MS Access Courses

Microsoft Access is a database management system (DBMS) that allows users to store, edit, and analyze data

Microsoft Access is a database management system (DBMS) from Microsoft that combines the relational Access Database Engine (ACE) with a graphical user interface and software-development tools.

MS Access Introduction – Course Outline

Duration: 2 Days

View details

Target Audience & Purpose

Access Introduction is for people new to databases, & for self-taught users to enhance their knowledge. It is a pre-requisite for the Intermediate & Advanced courses.

Objectives

By the end of this course participants should be able to:

  • Design and create a database
  • Create tables and set the primary key
  • Define the fields and properties for a table
  • Enter data and modify the layout of a table
  • Find data in tables
  • Create queries
  • Create table relationships
  • Design and create forms and reports
  • Print reports

MS Access Intermediate – Course Outline

Duration: One Day

View details

Target Audience & Purpose

Access Intermediate is for people who can already create simple databases, and want a Forms-driven database with basic automation.

Objectives

By the end of this course participants should be able to:

  • Export data from Access to other applications
  • Set table field properties
  • Design advanced queries and action queries
  • Use charts in Access
  • Create subforms and subreports
  • Use hyperlinks in Access
  • Create and use a switchboard

MS Access Advanced – Course Outline

Duration: 2 Days

View details

Target Audience & Purpose

Access Advanced is for skilled developers who wish to add high-end sophistication, automation and security.

Objectives

By the end of this course participants should be able to:

  • Design & Create a Relational Database
  • Set Table Relationships
  • Import and Export Records
  • Create Multi-Table, Parameter & Calculation Queries
  • Create Aggregate & Action Queries
  • Modify Forms
  • Create & Use Macros
  • Create simple VBA procedures

MS Access VBA – Course Outline

Duration: 2 Days

View details

Target Audience & Purpose

Access VBA is for highly skilled developers who wish to add high-end automation.

Objectives

By the end of this course participants should be able to:

  • Create and assign macros
  • Understand the advantages and disadvantages of using macros
  • Use forms and modules in the VBA editor
  • Create and work with subroutines and functions
  • Create and work with variables
  • Communicate with the user through input boxes and message boxes
  • Program decision structures using IF and CASE statements
  • Develop a variety of programming loops for repeating operations
  • Use the DoCmd object
  • Use ADO to handle working with data in your programs
  • Use the debugging features of VBA to locate and identify errors
  • Develop error-handling routines to prevent errors.