MOS 2010 Study Guide for Microsoft® Word Expert, Excel® Expert, Access®, and SharePoint® Exams

Chapter 2. Building Tables

The skills tested in this section of the Microsoft Office Specialist exam for Microsoft Access 2010 relate to building tables. Specifically, the following objectives are associated with this set of skills:

2.1 Create Tables in Design View

2.2 Create and Modify Fields

2.3 Sort and Filter Records

2.4 Set Relationships

2.5 Import Data from a Single Data File

2.1 Create Tables in Design View

When you create a blank database, Microsoft Access 2010 inserts a table (named Table1 by default) and displays that table in Datasheet view. Datasheet view resembles a worksheet in Microsoft Excel by presenting a grid of cells in columns and rows. Each column represents a field, and each row represents a record in the table. Access also ...