FORMS: 

• Add buttons to forms to run macros
• Add drop-down look-up fields to forms
• Change Properties of fields
• Place Calculations in Headers and Footers
• Work with Layout View to design a form
• Add Controls to a form
• List Boxes
• Combo Boxes
• Option Groups

CALCULATIONS (EXPRESSIONS):

Learn different ways to calculate numbers and summarize data.

• Calculate Numbers in Tables & Queries
• Add Calculated Fields (Expressions) in Forms & Reports
• Summary Query or Table

QUERIES: 

Query multiple tables. Create Parameter Queries that ask for input from users. Include wildcards in Parameter Queries. Create different types of Action Queries: Append Queries (to add records from one table to another), Update Queries (to update a number of records based on a given criteria), Delete Queries (to delete a number of records that meet a given criteria), and Make Table Queries (to archive records before deleting them or to prepare to export records to Excel).

EXTERNAL DATA 

Import data from Excel, Outlook, or another Access database. Collect data from e-mail programs, create e-mail surveys, etc. Attach file(s) to Access, send XPS Attachments, save objects as web files, insert hyperlinks.

QUERIES:

• Multiple Tables  (with or without Joins)
• Parameters (basic parameters, multiple parameters, date ranges, wildcards, etc.)
• Find Duplicates Query (locate duplicate records)
• Find Unmatched Query (locate records in one table that have no matching record in another table)
• Append Query (add records from one table to another)
• Delete Query (delete records meeting one or more criteria)
• Update Query (update records based on one or more criteria)
• Cross-Tab Query
• Use Access Functions in Queries
• Add Queries in Forms, Reports, and Macros

REPORTS, PIVOT REPORTS, & PIVOT TABLES:

• Create Mailing Labels for a Word Mail Merge
• Create Pivot Tables
• Create Pivot Charts
• Save Forms as Reports