Chapter 21. Changing Table Design

Switch between Datasheet and Design Views

You can view a table in Datasheet view or Design view. Each view allows you to perform different tasks, and Access allows you to quickly switch between the two views.

Datasheet view displays all of the records in a table. You can enter, edit, and review records in this view. Working in this view is covered in Chapter 20.

Design view displays the structure of a table. You can use this view when you want to make changes to the structure, layout, and design of the table.

You can change the data type and field property settings in this view. The data type determines the type of information that you can enter in a field, such as text, numbers, or dates. Specifying a data type helps ...

Get Master Visually®: Microsoft® Office 2007 now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.