Course Name

Microsoft Access 2019: Advanced Features – Level 3

  • Duration: 1 Day(s)
  • Date: On Request
  • Price: R1, 643.00 (excl. VAT)
Call me back
Get Overview
Book now!

Course Introduction

You know many of the basic functions of Microsoft Office Access, and now you are ready to learn advanced Access features.

Knowledge of these features separate database professionals from the casual database users or occasional designers.

Course Objectives

Upon successful completion of this course, you will be able to manage the database, import and export data, use action queries to manage data, create complex forms and reports, create macros, and use tools to manage, distribute, and secure a database.

You will:

  • Use action, unmatched, and duplicate queries to manage data.
  • Create complex reports and forms.
  • Use macros to improve user interface design.
  • Use VBA to extend database capabilities.
  • Perform database management tasks such as backup, compacting, repairing, performance analysis and checking object dependencies.
  • Implement security strategies and distribute a database to multiple users.

Course Content

  • Module 1: Importing and Exporting Table Data
    • Topic A: Import and Link Data
    • Topic B: Export Data
    • Topic C: Create a Mail Merge
  • Module 2: Using Queries to Manage Data
    • Topic A: Create Action Queries
    • Topic B: Create Unmatched and Duplicate Queries
  • Module 3: Creating Complex Reports and Forms
    • Topic A: Create Subreports
    • Topic B: Create a Navigation Form
    • Topic C: Show Details in Subforms and Popup Forms
  • Module 4: Creating Access Macros
    • Topic A: Create a Standalone Macro to Automate Repetitive Tasks
    • Topic B: Create a Macro to Program a User Interface Component
    • Topic C: Restrict Records by Using a Condition
    • Topic D: Create a Data Macro
  • Module 5: Using VBA to Extend Database Capabilities
    • Topic A: Getting Started with VBA
    • Topic B: Using VBA with Form Controls
  • Module 6: Managing a Database
    • Topic A: Back Up a Database
    • Topic B: Manage Performance Issues
    • Topic C: Document a Database
  • Module 7: Distributing and Securing a Database
    • Topic A: Split a Database for Multiple-User Access
    • Topic B: Implement Security
    • Topic C: Convert an Access Database to an ACCDE File
    • Topic D: Package a Database with a Digital Signature

Course Associated Exam and Certification

  • Appendix A: Mapping Course Content to Access Expert (Office 365 and Office 2019): Exam MO-500
  • Appendix B: Microsoft® Office Access® 2019 Common Keyboard Shortcuts
L❤ ve this. Share it now!

Need additional information?

We are here to support your growth every step of the way

Please call me

Get in touch

Contact the Impactful team if you need any assistance.
Email: impactful@lrmg.co.za
Tel: +27 87 941 5764

Course Introduction

You know many of the basic functions of Microsoft Office Access, and now you are ready to learn advanced Access features.

Knowledge of these features separate database professionals from the casual database users or occasional designers.

Course Objectives

Upon successful completion of this course, you will be able to manage the database, import and export data, use action queries to manage data, create complex forms and reports, create macros, and use tools to manage, distribute, and secure a database.

You will:

  • Use action, unmatched, and duplicate queries to manage data.
  • Create complex reports and forms.
  • Use macros to improve user interface design.
  • Use VBA to extend database capabilities.
  • Perform database management tasks such as backup, compacting, repairing, performance analysis and checking object dependencies.
  • Implement security strategies and distribute a database to multiple users.

Course Content

  • Module 1: Importing and Exporting Table Data
    • Topic A: Import and Link Data
    • Topic B: Export Data
    • Topic C: Create a Mail Merge
  • Module 2: Using Queries to Manage Data
    • Topic A: Create Action Queries
    • Topic B: Create Unmatched and Duplicate Queries
  • Module 3: Creating Complex Reports and Forms
    • Topic A: Create Subreports
    • Topic B: Create a Navigation Form
    • Topic C: Show Details in Subforms and Popup Forms
  • Module 4: Creating Access Macros
    • Topic A: Create a Standalone Macro to Automate Repetitive Tasks
    • Topic B: Create a Macro to Program a User Interface Component
    • Topic C: Restrict Records by Using a Condition
    • Topic D: Create a Data Macro
  • Module 5: Using VBA to Extend Database Capabilities
    • Topic A: Getting Started with VBA
    • Topic B: Using VBA with Form Controls
  • Module 6: Managing a Database
    • Topic A: Back Up a Database
    • Topic B: Manage Performance Issues
    • Topic C: Document a Database
  • Module 7: Distributing and Securing a Database
    • Topic A: Split a Database for Multiple-User Access
    • Topic B: Implement Security
    • Topic C: Convert an Access Database to an ACCDE File
    • Topic D: Package a Database with a Digital Signature

Course Exam And Certification

  • Appendix A: Mapping Course Content to Access Expert (Office 365 and Office 2019): Exam MO-500
  • Appendix B: Microsoft® Office Access® 2019 Common Keyboard Shortcuts

Are you ready to start?

Sign Up
Download Overview

Certified global best practices in the new technologies…

Amazon Web Services Impactful Partner
PeopleCert Logo
Impactful is an Accredited Oracle University Partner
Impactful Partner Microsoft logo

Get ahead with your IT and Digital Talent development

Please complete the form with your information and one of our experts will get back to you soon.

Get in touch

Contact the Impactful team if you need any assistance.

Email: impactful@lrmg.co.za
Tel: +27 87 941 5764

About LRMG

Testing Elementor conditions

Testing Elementor conditions

Testing Elementor conditions

Testing Elementor conditions

CONTACT US