By using our website you agree to our use of cookies.

Access 2010 Level 3

1 Day Course
Hands On
Code DAC10L3

This course has been retired. Please view currently available User Microsoft Office Training Courses.

Modules

Collapse all

Structuring Existing Data (3 topics)

  • Analyse Tables
  • Create a Junction Table
  • Improve the Table Structure

Writing Advanced Queries (5 topics)

  • 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 (5 topics)

  • 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 (4 topics)

  • Include a Chart in a Report
  • Print Data in Columns
  • Cancel Printing of a Blank Report
  • Publish Reports as PDF

Maintaining an Access Database (5 topics)

  • Link Tables to External Data Sources
  • Manage a Database
  • Determine Object Dependency
  • Document a Database
  • Analyze the Performance of a Database

Prerequisites

Delegates should have attended the Access 2010 Level 1 and Level 2 courses or have equivalent knowledge.

Additional Learning

The courses below may help you meet the knowledge level required to take this course.

User Microsoft Office Training Courses

Course PDF

Print

Sections