Microsoft Access 2019 – Advanced

Nett Course Fee
$436

Please be advised that as of 1st January 2025, there will be changes to the course fees.

Nett Course Fee (effective 1st January 2025)
$545

Course Description

Participants will further build their knowledge on Access 2019 in the course of Microsoft Access 2019 – Advanced.

Participants will be able to perform complex queries, design forms and reports, import and export data, and handle database security effectively.

Course Objectives

In 2-day course, you will be able to:

Create control properties to validate and promote quality data entry into a database.
Organize a database for efficiency and performance, and to maintain data integrity by enforcing Table Referential Integrity
Create advanced queries such as multiple table query, work with Expression & Expression tables, summarizing group of records and use of IIF functions
Use advanced formatting and controls to improve form presentation. Learn to use subforms.
Use advanced formatting and calculated fields to improve reports.

Course Outline

Creating Relational Databases

Understanding Table Relationships
Creating Relationships Between Tables
Enforcing Referential Integrity
Printing and Deleting Relationships
Understanding Relationship Types

Working with Queries

Understanding Different Types of Queries
Creating a Multiple Table Query
Creating a Calculated Field
Working with Expressions and the Expression Builder
Using an IIf Function
Summarizing Groups of Records
Display Top or Bottom Values
Parameter Queries
Finding Duplicate Records
Finding Unmatched Records
Crosstab Queries
Delete Queries
Append Queries
Make-Table Queries
Update Queries

Working with Forms

Creating and Using a Form
Modifying a Form in Layout View
Form Design View Basics
Changing Tab Order
Working with Control Properties
Control Property Reference
Working with Form Properties
Form Property Reference
Changing a Control’s Data Source
Creating a Calculated Control
Changing a Control’s Default Value
Creating a Subform
Modifying and Working with Subforms

Working with Reports

Creating a Report
Working in Layout View
Working in Design View
Grouping and Sorting
Summarize Data using Totals
Understanding Report Sections

Working with Macros

Creating and Running a Macro
Editing a Macro
Working with Macro Groups
Assigning a Macro to an Event
Creating Conditional Expressions
Macro Action Reference

Additional Topics

Importing Information
Exporting Information
Linking Information from an External Source
Displaying Database Object Dependencies
Setting a Password in Access
Compacting and Repairing a Database

This 2-day course will equip participants with proficiency in Microsoft Access, encompassing database structure comprehension, table relationships, creation and modification of objects like tables, forms, reports, and queries, along with intermediate skills for managing data, ensuring integrity, task automation, and data analysis.

Course Duration:
2 Days (9.00am – 5.00pm)

View course details here