How to Change Views in a Microsoft Access Table

You can view your Microsoft Access tables in two different views - Datasheet view and Design view. Your choice will hinge upon what you want to do.

Difficulty: Moderately Easy

Instructions

Things You'll Need:

• Microsoft Access

1. Open your database file in Microsoft Access.

2. Use the F11 key to open the Database window.

3. Click on the Table tab. The table that opens is probably in Datasheet view. From this view, you can add, delete, copy, paste or sort data.

4. To change to Design view, click on the table to select it, then open the View menu and select Design. From this view, you can work with the structure of the table: Add and delete fields, rearrange field columns and so on.

Tips & Warnings

• If you've generated a form for inputting data, you'll also be able to switch to Form view from Datasheet view.
• Alternatively, click the View button located on the top left corner of the toolbar to switch views.