Course Code: 786

Access 2010 Level 2: Intermediate Topics

Class Dates:
1 Days
Class Time:
Office, Database


  • Course Overview
  • This course is designed for students who would like to learn intermediate-level operations of the Microsoft Office Access program. The level 2 course is for individuals whose job responsibilities include maintaining data integrity; handling complex queries, forms, and reports; and sharing data between Access and other application programs.

    In this course you will:
    • Modify the design and field properties of a table to streamline data entry and maintain data integrity.
    • Retrieve data from tables using joins.
    • Create flexible queries to display specified reports, allow user-determined query criteria, and modify data using queries.
    • Enhance the capabilities of a form.
    • Customized reports to organize the displayed information and produce specific print layouts.
    • Share Access data across other applications.


Course Details

  • Joining Tables
  • Create Query Joins
  • Join Tables with No Common Fields
  • Relate Data Within a Table
  • Creating Flexible Queries
  • Set the Select Query Properties
  • Retrieve Records Based on Input Criteria
  • Create Action Queries
  • Writing Advanced Queries
  • Create SubQueries
  • Create Unmatched and Duplicate Queries
  • Summarize Data Using a Crosstab Query
  • Create a PivotTable and a PivotChart
  • Structuring Existing Data
  • Restructure the Data in a Table
  • Create a Junction Table
  • Improve the Table Structure
  • Customize Reports
  • Organize Report Information
  • Format Reports
  • Control Report Pagination
  • Summarize Report Information
  • Add a Subreport to an Existing Report
  • Create a Mailing Label Report
  • Creating Effective Reports
  • Include a Chart in a Report
  • Print Data Columns
  • Cancel Printing of a Blank Report
  • Publish Reports as a PDF
  • Sharing Data Across Applications
  • Import Data into Access
  • Export Data to Text File Formats
  • Export Access Data to Excel
  • Create a Mail Merge
  • Maintaining an Access Database
  • Link Tables to External Data Sources
  • Manage a Database
  • Determine Object Dependency
  • Document a Database
  • Analyze the Performance of a Database