Access 2010 Advanced

 

Course Length

Full day

 

Prerequisites

Access 2010 Intermediate or equivalent experience

 

Course Description

This course is for the individual whose job responsibilities include the need to create complex Access databases by structuring existing data, writing advanced queries, enhancing reports, working with macros, and performing database maintenance.

 

Course Topics

Structure Existing Data

  • Restructure the data in a table

  • Create a junction table

  • Improve the table structure

Write 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

Simplify 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

Create Effective Reports

  • Include a chart in a report

  • Print data in columns

  • Cancel printing of a blank report

  • Publish reports as PDF

Maintain an Access Database

  • Link tables to external data sources

  • Manage a database

  • Determine object dependency

  • Document a database

  • Analyze the performance of a database
     

What Participants Receive

Each participant receives a guide containing step-by-step instructions and practice exercises.

 

 

[Home   |   Services   |   Courses   |   Instructors  |  References  |  Contact Us]