Tables - Microsoft Support

Support

Sign in

Sign in with Microsoft

Sign in or create an account.

Hello,

Select a different account.

You have multiple accounts

Choose the account you want to sign in with.

Tables

Creating tables Data Types Relationships

Introduction to tables

Create a table and add fields

Guidelines for naming fields, controls, and objects

Set the field size

Combine fields using the Calculated data type

Add data macros in a desktop database

Control data entry formats with input masks

Restrict data input by using a validation rule

Add or change a table’s primary key

Create and use an index to improve performance

Data types for Access desktop databases

Introduction to data types and field properties

I get a message about data type mismatch

Document and print your database design

Guide to table relationships

Create, edit or delete a relationship

Normalize your data using the Table Analyzer

Email

Need more help?

Want more options?

Discover Community

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Microsoft 365 subscription benefits

Microsoft 365 training

Microsoft security

Accessibility center

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Ask the Microsoft Community

Microsoft Tech Community

Windows Insiders

Microsoft 365 Insiders