How to Open a Table in Design View in Microsoft Access

See Microsoft Access: Tips and Tricks for similar articles.

While Datasheet view lets you work directly with the data in tables, Design view takes you behind the scenes to work with the table structure. In Design view you have much finer control over how the fields in your data are defined and validated. You can open a closed table in Design view with just a few clicks.

This feature works the same in all modern versions of Microsoft Access: 2010, 2013, and 2016.

  1. Locate the table in the Navigation Pane and right-click on it. Right-Click on Table
  2. From the shortcut menu, select Design View. The table object opens as a tab on the work surface. Select Design View

If a table is already open in Datasheet view, you can switch to Design view by clicking the View icon in the toolbar. Switch to Design View

Related Articles

  1. How to Create a Form with the Form Wizard in Microsoft Access
  2. How to Create a Report with the Report Wizard in Microsoft Access
  3. How to Add a Header and Footer to a Form in Microsoft Access
  4. How to Add a Header and Footer to a Report in Microsoft Access
  5. How to Open a Table in Design View in Microsoft Access (this article)
  6. How to Rename a Table in Microsoft Access
  7. How to Move a Field in the Query Grid in Microsoft Access
  8. How to Create a Navigation Form in Microsoft Access
  9. How to Add a Logo to a Form Header in Microsoft Access
  10. How to Add a Title to a Form Header in Microsoft Access
  11. How to Set the Navigation Form as the Default Form in Microsoft Access
  12. How to Run a Macro from a Navigation Button in Microsoft Access
  13. How to Add a Title to a Report Header in Microsoft Access
  14. How to Add a Logo to a Report Header in Microsoft Access