Tables and Table Design

Everything in Microsoft Access has several Views. Each object (Table, Form, or Report) has a View that displays the object as a User would see it. For Tables, this is the Datasheet View. For Forms, it is the Form View, and for Reports, it is Print Preview.

 

In the first lesson, we created a simple customer table in Datasheet View. We used the Table Tools to add Fields to the Table. So far, so good. All objects in Access also have a Design View. The Design View is how a programmer sees the objects. For Tables, Design View lets the programmer define what data will be saved in a Table and how the information will be formatted.

 

Microsoft Access 2010: Example of a Table