Microsoft Access Advanced

Time & Location

Contact us to Schedule Courses
Virtual Instructor Led Hands on Courses

About the Course

Microsoft Access advanced course focuses creating complex Access databases by structuring existing data, writing advanced queries, working with macros, and performing database maintenance.

COURSE CONTENT

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

• Filter Records Using Criteria

• Summarize Data using a Crosstab Query

• Create a Pivot Table and a Pivot Chart

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 a Report 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

Register
Price
Quantity
Total
  • 4 or more Course Participants
    $299
    +$38.87 HST
    $299
    +$38.87 HST
    0
    $0
  • 2 - 3 Course Participants
    $399
    +$51.87 HST
    $399
    +$51.87 HST
    0
    $0
  • Course Calendar Date Pricing
    $299
    +$38.87 HST
    $299
    +$38.87 HST
    0
    $0
  • 1 on 1 Training
    $499
    +$64.87 HST
    +$14.10 Service fee
    $499
    +$64.87 HST
    +$14.10 Service fee
    0
    $0
Total$0

Share This Event