1. Managing the Access Environment 1.1. Create and manage a database Compact and Repair a Database, Pg 341 Security: Encrypt with a Password, Pg 335   2. Building Tables 2.1. Create Tables Tables: Getting Started   2.2. Create and Modify Fields Tables: Modify Data Types, Pg 35 Tables: Hide/Unhide Fields, Pg 55 Tables: Freeze or Unfreeze Fields, Pg 57 2.4. Set Relationships Table Relationships: Use Keys to create Relationships, Pg 76 Table Relationships: Edit Relationships, Pg 77   2.5. Import Data from a Single Data File. Import Data and Append to a Table, Pg 281 Import Data as a Linked Table, Pg 322 3. Building Forms 3.3. Apply Form Arrange options. Table Arrange: Use the Table Functions, Pg 99 Table Arrange: Insert Row, Pg 101 Table Arrange: Move Table Fields, Pg 102 Table Arrange: Merge Cell, Pg 103 Table Arrange: Split Cells, Pg 104 Table Arrange: Cell Margins, Pg 105 Table Arrange: Cell Padding, Pg 106 Table Arrange: Anchor Controls, Pg 107 Table Arrange: Reposition Controls, Pg 108   4. Creating and Managing Queries 4.1. Construct Queries Query: Create a Crosstab Query, Pg 248 Query: Create an Append Query, Pg 282 Query: Create a Make Table Query, Pg 302   4.2. Manage Source Tables and Relationships Query: Remove a Table, Pg 162   4.3. Manipulate Fields Query Design: Calculate Totals, Pg 165 Query Design: Use the Totals Row, Pg 166 Query Design: Use Group By, Pg 165 Query Design: Create Calculated Fields, Pg 167 Query Design: Perform Calculations, Pg 166 Microsoft Access 2010 Study Guide              Microsoft Office Specialist (MOS): Exam 77-885 for Access 2010