• A table is a database that holds information. It's formed by fields of information into which you enter the records of the table. A field is a column from a table, consisting of one category of information.
  • Navigating tables and queries to establish relationships is the tricky part of Access. The Add Tables feature increases your productivity when you’re developing and viewing relationships and providing a better querying experience.
  • If you say database, you think of Microsoft Access. Read everything about it in our Microsoft Access category.
  • Get yourself up to speed with our latest Guides and tools for Microsoft Office.
Adding tables in Access

A table is a database that holds information. It’s formed by fields of information into which you enter the records of the table. A field is a column from a table, consisting of one category of information. A record is a collection of related fields that describe a single item, contained in a row from a certain table.

How can I use add Add Tables in Access? 

Navigating tables and queries to establish relationships is the tricky part of Access. The Add Tables feature increases your productivity when you’re developing and viewing relationships and providing a better querying experience.

How to open Add Tables 

1. Select Database Tools > Relationships.

2. The Add Tables pane should appear to the right of the screen. If it does not, right-click and select Show Tables, and it will appear.

how to use new Access

We can’t tell you how useful this new feature is. The whole database system in Access revolves around tables.

Field Data Types to add when you create tables in Access 2013 or later

  • AutoNumber: This should be the first field in a table because it assigns a unique numeric ID to all records from the table.
  • Short text: You can enter text or a combination of text and numbers of 255 characters maximum.
  • Long Text: Here, the maximum length is 65, 535 characters.
  • Number: Can contain only numbers for calculations. If you want to input phone numbers or zip codes, those should be set as text.
  • Date/Time: Contains a date or time code. Useful for Date/Time calculations.
  • Currency: It’s similar to the Number data type, but it uses fixed-point calculation, which is faster than the floating-point calculation used in Number fields.
  • Yes/No: Only stores logical data types like Yes/No, On/Off, True/False, and -1/0.
  • OLE Object (in desktop ver.): Connects to objects in Windows applications. For example, you can use it for ActiveX objects, pictures, calendars, and other types of files.
  • Hyperlink: That one is pretty obvious. You populate it with WWW links.
  • Attachment (in desktop ver.): You can attach images, or spreadsheets, for instance. This is for attaching many types of support types.
  • Image (only in the web app): Used to store picture data. Only used in web apps.
  • Calculated: The calculated field will contain a value that is derived by performing a function on other fields using an expression that you create. It’s a result field.
  • Lookup Wizard…: You can set up a lookup field, which will then contain values from another table, query, or values that you enter mannually.

Please drop us a line in the comments with your thought or questions.

Was this page helpful?
Thanks for letting us know!
Get the most from your tech with our daily tips
Tell us why!