Microsoft Office Access Level 2

Module: Microsoft Office Access Level 2 (Intermediate)

Lesson 1: Controlling Data Entry
 Constrain data entry using field properties.
 Establish data entry formats for entering field values by using an
input mask.
 Create a list of permissible values for a field.

Lesson 2: Joining Tables
 Create query joins to retrieve data.
 Join two tables that have no common fields.
 Relate data within a table.

Lesson 3: Creating Flexible Queries
 Set the Select query properties.
 Retrieve records based on the criteria input by a user.
 Manipulate data in a table using Action queries.

Lesson 4: Improving Forms
 Restrict data entry in forms.
 Organize information using tab controls in forms.
 Add command buttons to forms.
 Create a subform.
 Display a summary of data in a form using PivotCharts and
 Change the display of data conditionally.

Lesson 5: Customizing Reports
 Organize report information.
 Format a report.
 Control report pagination.
 Add a calculated field to a report.
 Add a subreport to an existing report.
 Create a mailing label report.

Lesson 6: Sharing Data Across Applications
 Import data into Access.
 Export data to text file formats.
 Export Access data to Excel.
 Create a mail merge.