Display a table in Design view and describe its features
Table Design view (Access)
You can look at every table created in Access in one of two views--Datasheet
view, where you see the data in rows and columns (covered in the previous module), and Design view. Design view does not show data,
it lists the properties of each field in the table. To display a table in Design view, use one of these methods:
Select the table in the database window and click the Design button on the database window toolbar.
Right-click the table in the database window and choose Design view from the shortcut menu.
Click the View button on the toolbar when the table is displayed in Datasheet view.
Remember the Projects table you created? Here it is in Datasheet view.
Let us have a look at the same table in Design view to see the difference.
Access Table in Design view
Access Table Design view
There is one field listed here for each column in the datasheet.
Each field has a data type. The most common are shown here--Text Date/Time, Currency, and AutoNumber.
You can add a description of the field here and this is useful if you do not use the database regularly or if you are creating it for someone else.
The key marks the primary key field in the table. Remember, the primary key field has a unique value for each record.
These properties allow you to further refine the field definition.
The next lesson will introduce you to the different data types.
