need help... what should I use?

[jowe]

I need to keep track of items for a rental service. I need to not only be
able to see the quantity of the items I have, but also be able to make
special notes on each item. What would be the best way of going about this?

 

[John W. Vinson]

I need to keep track of items for a rental service. I need to not only be
able to see the quantity of the items I have, but also be able to make
special notes on each item. What would be the best way of going about this?

Ummm...

create a database with a table with a quantity field and a notes field, or
perhaps a notes table related one to many to the items table (so you can
record multiple notes per item).

Context? What are you working with? How much experience do you have with
Access?

John W. Vinson [MVP]

 

[Wayne-I-M]

Hi Jowe

Rental database are notoriously difficult to design. You need - amongst
other things.

To be able to bring in new stock
To be able to get rid of old stock
To be able to adjust prices and give discounts
Some items may be in for repair and not available for rent
You need to be able see what items are available for rent
You need to be able to see where all the items on rent are
You need to be able to allow for theft

Some application have basic accounting facilities
You want to see which items are making a profit
What is the “total†cost of each item
What the rental cost should be for a new item
Etc
etc
etc
etc
The list goes on.

I may get shouted at for this in this forum "but" if you are running a
rental business do you really want to spend time learning how to construct
databases (I assume you don't know at the moment). And after you have
learned the basics do you really want to spend more time building this and
then maintaining it as your business changes.

There are times when it may be an idea to ask someone to do the work for you
- even if you could learn to do it yourself.

I don't know where you're based but if you look in the local yellow pages or
try Google r even post to this forum there will be many people who could
build your application, test it then take it to first fix for your ideas and
alter it all within a relatively short space of time.