1.1.2 Create a database from a template
1.1.3 Create a database by using Import objects or data from other sources
1.1.4 Delete database objects
1.2 Manage Relationships and Keys
1.2.1 (Part 1) Create and modify relationships
1.2.1 (Part 2) Create and modify relationships
1.2.1 (Part 3) Create and modify relationships
1.2.1 (Part 4) Create and modify relationships
1.2.2 Set the primary key
1.2.3 Enforce referential integrity
1.2.4 Set foreign keys
1.2.5 View relationships
1.3 Navigate through a Database
1.3.1 Navigate specific records
1.3.2 Create and modify a navigation form
1.3.3 Set a form as the startup option
1.3.4 Display objects in the Navigation Pane
1.3.5 Change views of objects
1.4 Protect and Maintain Databases
1.4.1 and 2 Compact and Repair a Database
1.4.3 Back up a database
1.4.4 Split a database
1.4.5 Encrypt a database with a password
1.4.6 Recover data from backup
1.5 Print and Export Data
1.5.1 and 1.5.2 Print Datasheet Records and Reports
1.5.3 Save a database as a template
1.5.4 Export objects to alternative formats
Objective Domain 1 Exercises and Solutions
2.1 Create Tables
2.1.1 Create a table
2.1.2 Import data into tables
2.1.3 Create linked tables from external sources
2.1.4 Import tables from other databases
2.1.5 Create a table from a template with application parts
2.2 Manage Tables
2.2.1 Hide fields in tables
2.2.2 Add total rows
2.2.3 Add table descriptions
2.2.4 Rename tables
2.3 Manage Records in Tables
2.3.1, 2 and 3 Add, Update and Delete Records
2.3.4 Append records from external data
2.3.5 Find and replace data
2.3.6 Sort records
2.3.7 Filter records
2.4 Create and Modify Fields
2.4.1 Add fields to tables
2.4.2 Add validation rules to fields
2.4.3 Change Field Captions
2.4.4 and 2.4.5 Change Field Sizes and Data Types
2.4.6 and 2.4.7 Configure Auto Increment and Set Default Values
2.4.8 Using input masks
2.4.9 Delete fields
Objective Domain 2 Exercises and Solutions
Objective Domain 2 Exercise Solutions
Introduction to Section 3 - Access Queries
Introduction to Access Queries
3.1 Create a Query
3.1.1 Run a query
3.1.2 Create a crosstab query
3.1.3 Create a parameter query
3.1.4 (Part 1) Create an Update Query
3.1.4 (Part 2) Create a Make Table Query
3.1.4 (Part 3) Create an Append Query
3.1.4 (Part 4) Create a Delete Query
3.1.5 Create a multi-table query
3.1.6 Save a query
3.2 Modify a Query
3.2.1, 2, 3, 4, 5 and 6 Add, Remove, Hide, Sort and Format Query Fields
3.3 Create Calculated Fields and Grouping within Queries
3.3.1 Add calculated fields
3.3.2 and 3.3.4 Set filtering criteria and Using Comparison Operators
3.3.3 Group and summarize data
3.3.5 Group data by using arithmetic and logical operators
Objective Domain 3 Exercises and Solutions
4.1 Create a Form
Introduction to Forms
4.1.1 Create a form
4.1.2 Create a form from a template with application parts
4.1.3 Save a form
4.2 Configure Form Controls
4.2.1 and 2 (Part 1) Add and Move Form Controls
4.2.1 and 2 (Part 2) Add and Move Form Controls
4.2.1 and 2 (Part 3) Add and Move Form Controls (Layout Controls)
4.2.1 and 2 (Part 4) Add and Move Form Controls (Design Controls)
4.2.1 and 2 (Part 5) Add and Move Form Controls
4.2.3 and 4.2.4 Modify Data Sources and Remove Form Controls
4.2.6 Manage Labels
4.2.7 Add Sub-Forms
4.3 Format a Form
4.3.1 Modify Tab Order
4.3.2 and 4.3.3 Configure Print settings and Sort Records by Form Field
4.3.4 Apply a theme
Save
