VTeach Training Partner
Your Training Partner
Follow Us:
Contact VTeach Training
Register for Training

Microsoft Access: Advanced

Course Dates:

Call for Dates

Course Specifications

Course length: 1.0 day(s)

Course Objective:

You will create complex Access databases by structuring existing data, writing advanced queries, working with macros, and performing database maintenance.

  • Restructure data into appropriate tables to ensure data dependency and minimize redundancy
  • Write advanced queries to analyze and summarize data
  • Create macros
  • Customize reports by using various Access features
  • Maintain your database using Access tools

Course Content

Lesson 1: Structuring Existing Data

  • Restructure the Data in a Table
  • Create a Junction Table
  • Improve the Table Structure

Lesson 2: Writing Advanced Queries

  • Create Subqueries
  • Create Unmatched and Duplicate Queries
  • Filter Records Using Criteria
  • Summarize Data Using a Crosstab Query
  • Create a PivotTable and a PivotChart

Lesson 3: 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

Lesson 4: Creating Effective Reports

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

Lesson 5: 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 

Newsletter Subscription

Connect with VTeach by subscribing to our mailing list