Microsoft Access 2013 Inside Out

Chapter 10. Designing tables in a desktop database

Creating a new desktop database

Creating your first simple table by entering data

Creating a table using Application Parts

Creating a table using Data Type Parts

Creating a table in Design view

Defining fields

Defining a primary key

Defining a table validation rule

Understanding other table properties

Defining relationships

Adding indexes

Setting table design options

Database limitations

DEFINING tables in a Microsoft Access 2013 desktop database (.accdb file) is very easy. This chapter shows you how it’s done. You’ll learn how to:

• Create a new desktop database application using a database template.

• Create a new empty database for your own custom application.

• Create a simple table by entering data directly in ...