Microsoft Access 2013 Plain & Simple

Chapter 4. Creating a desktop database

In this section:

• Creating a blank desktop database

• Creating a table in design view

• Working with data parts in layout view

• Creating a table by using application parts

• Adding a primary key

• Improving performance by indexing data

• Validate that data in a field is of the correct type

• Formatting a field

• Recording changes to text and rich text formatting

• Creating relationships by using the Lookup Wizard

• Viewing relationships

A desktop database uses tables to hold your data and is stored on your local computer or network. The data is displayed in rows (horizontal layout), with each row including a list of column or field names (vertical layout) like a worksheet. Using database tables differs from using several worksheets in a ...