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.