Basic Access Database

[fsupport1600]

I have very little experience with MS Access so I was wonder if someone could provide some help, even a sample database that I could get started with.

I work for an architectural firm nad we are working on a furniture package for a school.

I would like a way to run reports on the following data.

How many chairs, desks, projectors etc are needed for each room. The report would include the Room name and number and list the equipment information and quantity. Another report would list the total for the particular equipment for the entire school.

I am thinking of setting up two tables:

Table 1 = Room Information
Field1: Room Name
Field2: Room Number

Table 2 = Product Information
Field1: Product Number
Field2: Product Name
Field3: Model Number
Etc....

How would I setup the count aspect of the database? So if a product is needed for the particular room the person inputing the data can enter in a number value for that particular product.

Any help is apprecited.

 

[genomon]

A great place to start is with the sample Northwind database, or Open|New|Templates; both are included with Access. There is also "Getting Started" in Access help.

The three most dangerous things in the world are a programmer with a soldering iron, a hardware type with a program patch, and a user with an idea.

 

[BlueHorizon]

Check out Queries - this is where functions, like Count, are created. Also check out Lookup Tables, which lets the user select Product numbers from a drop-down list.

Good luck - also, there are several Access threads specifically for Access questions.

Best,


Best,
Blue Horizon