55280-A: Advanced Microsoft Access 2019 Certification

Advanced Microsoft Access 2019 (55280-A) Certification Training Course Overview

Enroll for 2-day Advanced Access 2019 certification training course from Koenig Solutions accredited by Microsoft. This course is intend to design databases at an advanced level and/or want to improve existing Access 2019 or Access 365 databases.

Target Audience:

This course is intended for students who have basic skills with Microsoft Access 2019 who want to learn advanced-level skills or students who want to learn the topics covered in this course in the 2019 interface.

Learning Objectives:

After completing this course, you will be able to:

  • Understand database relationships.
  • Work with table relationships.
  • Work with queries at an advanced level.
  • Work with forms at an advanced level.
  • Work with reports at an advanced level.
  • Work with macros.
  • Complete the desktop application with the navigation form.

 

55280-A: Advanced Microsoft Access 2019 Certification (Duration : 16 Hours) Download Course Contents

Live Virtual Classroom Fee For Both Group Training & 1-on-1 Training On Request
Group Training Date On Request
1-on-1 Training (GTR)
4 Hours
8 Hours
Week Days
Week End

Start Time : At any time

12 AM
12 PM

GTR=Guaranteed to Run
Classroom Training (Available: London, Dubai, India, Sydney, Vancouver)
Duration : On Request
Fee : On Request
On Request
Special Solutions for Corporate Clients! Click here Hire Our Trainers! Click here

Course Modules

Module 1: Relationships
  • Review
  • Referential Integrity
  • Relationships
  • A Few Words about Naming Conventions
  • Installing and Configuring Windows 7
Module 2: Queries
  • Query Design View
  • Review of Select Queries
  • Review of Select Queries with Criteria
  • Logical Operators
  • Parameter Queries
  • Action Queries
  • Queries Exercises
Module 3: Table Functions
  • Importing Data
  • Linking Tables from External Sources
  • Import Tables from Other Databases
  • Tables from Templates and Application Parts
  • Table Functions Exercises
Module 4: Forms
  • Design View
  • Formatting
  • Tab Order
  • Create Forms with Application Parts
  • Creating a Subform
  • Alter a Form
  • Creating Forms
Module 5: Reports
  • Design View
  • Report Sections
  • Arranging Fields on a Report
  • Resizing the Detail Section
  • Grouping and Sorting
  • Setting Properties on a Report
  • Special Report Fields
  • Controls
  • Subreports
  • Application Parts
  • Deleting a Report
  • Formatting a Report
  • Creating Reports
Module 6: Macros
  • Macro Basics
  • Running a Macro
  • Creating Simple Macros
Module 7: Completing the Desktop Application
  • The Navigation Form
  • Running Macros from a Navigation Form
  • Setting the Navigation Form as the Default Form
  • Splitting the Database
  • Distributing the Front-end Database
  • Database Maintenance
  • Creating a Navigation Form
Download Course Contents

Request More Information

Course Prerequisites
  • Introductory-level knowledge and skills working with Microsoft Access.