Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

4 main components of Access =Table, Query, Form, Report

Access 101

4 main components of Access =Table, Query, Form, Report

by  DougP  Posted    (Edited  )
A Table is where the data is stored. Such as Names
Tables contain Fields. First Name, Last Name, Address, City, St, Zip are examples of fields for a customer table.
Always start with a table.

Next you can create a "Form" to key data into your table.
You can key data directly in the table but a form offers more flexibility. You can automate some of the data entry using a form. You can add buttons to do a whole host of things like print reports and add new records.

You can then create a "Query". A query answers questions about your data.
After you have Customers in your table and you want to find all of the Smiths. This is easily done with a query.

Next you want to print a Report of all the Smiths.
use your query as a record source for your Report.

You could print from the Table or Query but a report lets you add things like Date printed and a Company logo and a lot more.

So those are the 4 main components in Access.
Table = Where Raw data is stored.
Form = A place to key in data and Open reports.
Query = Ask questions about your data.
Report = Create a paper document that is professional looking.
Register to rate this FAQ  : BAD 1 2 3 4 5 6 7 8 9 10 GOOD
Please Note: 1 is Bad, 10 is Good :-)

Part and Inventory Search

Back
Top