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