Create a table

Click the New button and double-click the method you wish to use to create a table.

Access New Table button

The most common table creation methods (shown in boldface) are detailed below.

Access New Table dialog box

  • Datasheet view:  Enter preliminary or sample data, after which Access analyzes the data and selects appropriate field types.
  • Design view:  Design a table from scratch.
  • Table Wizard:  Use a Table Wizard that assists you in selecting appropriate fields.
  • Import table:  Import a table from another database or application.
  • Link table:  Link to an external database such as an Excel workbook or mainframe.
Hide comments


  • Allowed HTML tags: <em> <strong> <blockquote> <br> <p>

Plain text

  • No HTML tags allowed.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Lines and paragraphs break automatically.