Course summary: Design and build tables for a database (Access basics, part 1)

Concepts & terms

A relational database divides data into tables, each with one subject—just customer names in one table, just phone numbers in another.

Each table captures all the data needed for each subject, and each field (column) hold the smallest possible unit of data.

Each table has a primary key, a value that makes each record (row) unique.

Data usually has a parent-child relationship; a single name can be related to multiple orders. Parent tables have primary keys, child tables have foreign keys—values from the primary key shared as needed to link records in the child table to records in the parent table. Keys are linked by a relationship.

Create a new database

Start Access, select the type of database you want (desktop or App, blank or a template), enter a name, browse for a location, select Create.

Build tables

  1. Select Create > Table or Create > Table Design.

  2. Set data type, enter field names, set a primary key, and save the table.

Lookup list

When adding a field to a table, select Lookup & Relationship> I will type the values I want, and follow the wizard.

Calculated field

When adding a field to a table, select Calculated Field, then an option such as Text. Use the Expression Builder to create your expression.

See also

Expand your Office skills
Explore training
Get new features first
Join Office Insiders

Was this information helpful?

Thank you for your feedback!

Thank you for your feedback! It sounds like it might be helpful to connect you to one of our Office support agents.