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

WU EDGE - Western Union Business Solutions


Our Testimonials

During the Advanced Excel class, the trainer helped me to clarify my doubts especially the VLookup.
- Clarinda

A very engaging course that I really enjoyed. The tutor was very cheerful and helpful.
- Manisha

Good experience and thanks to the Trainer for her kind patient in teaching our company.
- Belle

Why choose us?

Hands-on Training Method
ACTA and Microsoft Certified Trainers
Small class size
Complete Course Material
Free One-Time Refresher
Affordable Price
Certification of Completion
Central Location

Our Training Location

10 Anson Road
#31-12 International Plaza
Singapore 079903
(Tanjong Pagar MRT Station)

Call: +65 6673 4479

Email: admin@vteach.com.sg

Privacy Policy