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.
Other People Are Reading
Instructions
-
-
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.
-
1
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.
More Like This
Comments
-
same here - I want to view multiple tables at the same time.
-
I thought this was going to tell me how to change the view of the table. When I open multiple tables, they have tabs up top and I can't view more than one table at a time. I used to be able to set them one above the other or side by side. I can't seem to find the option to allow me to do that again.
