Advanced Microsoft Access 2010 Training

This 3 day Advanced Access 2010 training class is for people who intend to design databases at an advanced level and/or improve existing Access databases.


  • Learn to streamline data entry and maintain data integrity.
  • Learn to join tables to retrieve data from unrelated tables.
  • Learn to create flexible queries to display specified records, allow for user-determined query criteria, and modify data using queries
  • Learn to write advanced queries to analyze and summarize data.
  • Learn to improve forms.
  • Learn to customize reports to organize the displayed information and produce specific print layouts.
  • Understand how to maintain databases using Microsoft Office Access 2010 tools.
  • Learn to share data between Access and other applications.
  • Learn to restructure data into appropriate tables to ensure data dependency and minimize redundancy.
  • Learn to create and revise Microsoft Office Access 2010 macros.


  1. Controlling Data Entry
    1. Constrain Data Entry Using Field Properties
    2. Establish Data Entry Formats for Entering Field Values
    3. Create a List of Values for a Field
  2. Joining Tables
    1. Create Query Joins
    2. Join Tables with No Common Fields
    3. Relate Data within a Table
  3. Creating Flexible Queries
    1. Set the Select Query Properties
    2. Retrieve Records Based on Input Criteria
    3. Create Action Queries
  4. Improving Forms
    1. Restrict Data Entry in Forms
    2. Organize Information with Tab Pages
    3. Add a Command Button to a Form
    4. Create a Subform
    5. Display a Summary of Data in a Form
    6. Change the Display of Data Conditionally
  5. Customizing Reports
    1. Organize Report Information
    2. Format Reports
    3. Control Report Pagination
    4. Summarize Report Information
    5. Add a Subreport to an Existing Report
    6. Create a Mailing Label Report
  6. Sharing Data Across Applications
    1. Import Data into Access
    2. Export Data to Text File Formats
    3. Export Access Data to Excel
    4. Create a Mail Merge
  7. Structuring Existing Data
    1. Restructure the Data in a Table
    2. Create a Junction Table
    3. Improve the Table Structure
  8. Writing Advanced Queries
    1. Create SubQueries
    2. Create Unmatched and Duplicate Queries
    3. Group and Summarize Records Using Criteria
    4. Summarize Data Using a Crosstab Query
    5. Create a PivotTable and a PivotChart
  9. Simplifying Tasks with Macros
    1. Create a Macro
    2. Attach a Macro
    3. Restrict Records Using a Condition
    4. Validate Data Using a Macro
    5. Automate Data Entry Using a Macro
  10. Creating Effective Reports
    1. Include a Chart in a Report
    2. Print Data in Columns
    3. Cancel Printing of a Blank Report
    4. Publish Reports as PDF
  11. Maintaining an Access Database
    1. Link Tables to External Data Sources
    2. Manage a Database
    3. Determine Object Dependency
    4. Document a Database
    5. Analyze the Performance of a Database

To Hire an AMS Microsoft Access 2010 Subject Matter Expert and Instructor who also teaches this class, call us today at 800-798-3901!

Leave a Reply