Tables

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