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.
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.