database design

am setting up database for public storage unit - owner stores vehicles and
equip, wants to access info by tenant, VIN, Make & Model, etc. Any
suggestions? totally new to access, but have worked with databases in the
past. HELP!!

On Wed, 20 Oct 2004 10:57:03 -0700, "db"
wrote:

am setting up database for public storage unit - owner stores vehicles and
equip, wants to access info by tenant, VIN, Make & Model, etc. Any
suggestions? totally new to access, but have worked with databases in the
past. HELP!!

Take a look at the links at

http://support.microsoft.com/kb/289533

There are many other good resources available;
http://www.mvps.org/access is another good place to start.

You'll need to start first by identifying the Entities - real-life
things, people, and events - of importance to your database. In this
case I'd say these would include Units, Vehicles, Tenants, and Rentals
(the latter being the event wherein a Tenant rents a Unit). Each of
these will get its own Table.

Once you have the tables constructed, and relationships defined (i.e.
each Tenant will have one or more Rentals, each Unit will have one or
more Rentals, etc.), you can start building Forms for data entry and
onscreen viewing, and Reports for printing (e.g. printing monthly
bills or a list of what equipment is stored in each unit).

If you have specific problems don't hesitate to come back with
questions!

John W. Vinson[MVP]
Join the online Access Chats
Tuesday 11am EDT - Thursday 3:30pm EDT
http://community.compuserve.com/msdevapps