Skip Ribbon Commands
Skip to main content

EK-084588 - Microsoft Office Access 2010 Intermediate, Level 2

Price:

Duration: 1 Day

Audience:

Level:

Technology:

Delivery Method:

Software Assurance Value:

Microsoft CPE:

Course Information

Course Description

​This course is for the individual whose job responsibilities include working with heavily related tables; creating advanced queries, forms, and reports; writing macros to automate common tasks; and performing general database maintenance. You will create complex Access databases by structuring existing data, writing advanced queries, working with macros, and performing database maintenance.

Course Objectives

​Upon successful completion of this course, students will be able to:

  • restructure data into appropriate tables to ensure data dependency and minimize redundancy.
  • write advanced queries to analyze and summarize data.
  • create and revise Access 2010 macros.
  • customize reports by using various Access 2010 features.
  • maintain their databases using Access 2010 tools.

Course Audience

​Anyone who is currently using Access 2010 and is working with more complex databases and performing higher-level tasks.

Course Outline

​Structuring Existing Data

  • Restructure the Data in a Table
  • Create a Junction Table
  • Improve the Table Structure
Writing Advanced Queries
  • Create SubQueries
  • Create Unmatched and Duplicate Queries
  • Group and Summarize Records Using Criteria
  • Summarize Data Using a Crosstab Query
  • Create a PivotTable and a PivotChart
Simplifying Tasks with Macros
  • Create a Macro
  • Attach a Macro
  • Restrict Records Using a Condition
  • Validate Data Using a Macro
  • Automate Data Entry Using a Macro
Creating Effective Reports
  • Include a Chart in a Report
  • Print Data in Columns
  • Cancel Printing of a Blank Report
  • Publish Reports as PDF
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

Course Prerequisites

​You should have taken Access 2010 Introduction or have the equivalent skills and knowledge.

Course Schedule
This course is not scheduled yet.