Microsoft Access Level 2 ACC-02

role of tables and relationships between tables in an Access database. Completion of the following course or equivalent knowledge and skills is recommended: Microsoft Access Level 1 Importing Data from an Access Database Importing Data from Excel Creating table relationships

1. Module 2

   • Review of Access Level 1
   • Building a Query Using a Wizard
   • Building a Query in Design View
   • Working with Join Types in Queries
   • Querying a Database
   • Using a Single Criterion to Limit Results
   • Using Multiple Criteria to Limit Results
   • Using Keywords in Queries
   • Using Wildcards in Criteria
   • Building a Parameter Query

2. Module 3Calculations and Groups in Queries

   • Adding Calculated Fields to Queries
   • Adding Groups and Totals to Queries

3. Module 4Creating Action Queries

   • Updating Records with an Update Query
   • Copying Records with an A ppend Query
   • Deleting Records with an Action Query
   • Using a Make-Table Query

4. Module 5Writing Advanced Queries

   • Creating a Subquery
   • Union Queries
   • Queries That Find Duplicate Records in a Table
   • Queries That Find Unmatched Records between Tables
   • Crosstab Queries
   • Using Autolookup Queries

5. Module 6Advanced Form Design

   • Using the Form Header to Search for Data
   • Setting up Tab Forms
   • Creating a Dialog Form
   • Setting Dialog Form Properties

6. Module 7Generating Reports

   • Creating Basic Reports
   • Creating a Report Using the Report Wizard
   • Creating a report from scratch
   • Making basic report enhancements
   • Printing a Report

7. Module 8Customizing Reports

   • Adding a Group to an Existing Report
   • Adding a Custom Calculation to a Report

8. Module 9Enhancing Reports

   • Controlling page breaks and page layouts
   • Including a chart in a report
   • Using customized groups and layouts in reports
   • Saving the report as a PDF file
   • Adding line numbers to a report

9. Module 10Exporting Data

   • Exporting a Query to Excel
   • Exporting a Report to Excel
   • Exporting a Report to Word