Because a correct design is essential to achieving your goals in working with a database, investing the time required to learn the principles of good design makes sense.

Opening a table in Design view gives you a detailed look at the table's structure. For example, you can find the data type setting for each field, find any input masks, or see if the table uses any lookup …

This article explains how to create a table, add fields to a table, set a table's primary key, and how to set field and table properties. Before you create tables and add fields, make sure you understand the …

When you create a table with Table Design, you can be more deliberate about designing your database, set field types, create a lookup list, and create a foreign key to pair with your primary key.

Before you create tables in Access, consider your requirements and determine all the tables that you might need. For an introduction to planning and designing a database, see Database design basics.

Learn how to save Access table relationships schema and other design information about your database in an offline format.

In Access desktop databases you can set design options for table, form, report, and query designs from this centralized Access Options location.

To create a form from a table or query in your database, in the Navigation Pane, click the table or query that contains the data for your form, and on the Create tab, click Form.

When you create a table with Table Design, you can be more deliberate about designing your database, set field types, create a lookup list, and create a foreign key to pair with your primary key.

When you design a database, you divide your database information into many subject-based tables to minimize data redundancy. You then give Access a way to bring the data back together by placing …