Creating a Table in Datasheet View
Some people prefer to create their table in Datasheet view. However, Access designed Datasheet view for data entry and viewing, not for table structure changes. I do not recommend creating the table this way, since you do not have access to as many controls as you do with Table Design view.
To create a table in Datasheet view, follow these steps:
Select Insert, Table.
Click Datasheet View and click OK. A blank table opens, as shown in Figure 8.5.
Figure 8.5. Creating a new table in Datasheet view gives you a quick, generic table.
How Do I Set the Field Names?
When you create a table in Datasheet view, the ...
Get Ten Minute Guide to Access 97 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.
