Switching Between Design and Datasheet Views

When working with tables, there are two views available: Design and Datasheet.

One easy way to switch between the views by clicking the down arrow next to the View button on the toolbar (it's the leftmost button). Then select the view you want from the drop-down list that appears.

Another way to switch between views is shown in the following steps:

  1. Open the View menu.

  2. Select Table Design or Datasheet, depending on which view you are currently in.

  3. If you're moving from Table Design to Datasheet view, you may be asked to save your work. If so, click Yes.

  4. If you're asked for a name for the table, type ...

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.