Access Objects: Tables
What is a
database? All databases begin with the Tables. Data entry
forms, queries, and reports just use the information in the Tables.
Table
Views: Design and Datasheet
The
Datasheet View looks like an Excel spreadsheet. The Header Row
at the top of the Datasheet has filters that you can use to Sort,
Select and Find if you wish. The Design View lets you create
the Table by adding Fields and defining what kind of data these
Fields will store. The Fields can be Text, Numbers, Date/Time,
Yes/No.
Table
Options: Unique Information
Each Table
has a unique collection of data. For example, tblCustomers has
customer names and addresses...it does not include any information
about movies. tblMovieTitles lists products... no
customer phone numbers.
Keep
going...
Microsoft Access 2010: Sample Database Table