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
PivotTables.
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.