Course Name

Microsoft Access 2019: Intermediate – Level 2

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

Course Introduction

This course will expand your knowledge of relational database design and teach you to implement advanced features in tables, queries, forms, and reports.

Extending your knowledge of Access will result in a robust, functional database for your users.

Course Objectives

Upon successful completion of this course, you will be able to optimize of an Access database, including optimizing performance and normalizing data. You will be able to set up data validation, advanced queries, forms, and reports.

You will:

  • Provide input validation features to promote the entry of quality data into a database.
  • Organize a database for efficiency and performance, and to maintain data integrity.
  • Improve the usability of Access tables.
  • Create advanced queries to join and summarize data.
  • Use advanced formatting and controls to improve form presentation.
  • Use advanced formatting and calculated fields to improve reports.

Course Content

  • Module 1: Promoting Quality Data Input
    • Topic A: Restrict Data Input Through Field Validation
    • Topic B: Restrict Data Input Through Forms and Record Validation
  • Module 2: Improving Efficiency and Data Integrity
    • Topic A: Data Normalization
    • Topic B: Associate Unrelated Tables
    • Topic C: Enforce Referential Integrity
  • Module 3: Improving Table Usability
    • Topic A: Create Lookups Within a Table
    • Topic B: Work with Subdatasheets
  • Module 4: Creating Advanced Queries
    • Topic A: Create Query Joins
    • Topic B: Create Subqueries
    • Topic C: Summarize Data
  • Module 5: Improving Form Presentation
    • Topic A: Apply Conditional Formatting
    • Topic B: Create Tab Pages with Subforms and Other Controls
  • Module 6: Creating Advanced Reports
    • Topic A: Apply Advanced Formatting to a Report
    • Topic B: Add a Calculated Field to a Report
    • Topic C: Control Pagination and Print Quality
    • Topic D: Add a Chart to a Report

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

This course will expand your knowledge of relational database design and teach you to implement advanced features in tables, queries, forms, and reports.

Extending your knowledge of Access will result in a robust, functional database for your users.

Course Objectives

Upon successful completion of this course, you will be able to optimize of an Access database, including optimizing performance and normalizing data. You will be able to set up data validation, advanced queries, forms, and reports.

You will:

  • Provide input validation features to promote the entry of quality data into a database.
  • Organize a database for efficiency and performance, and to maintain data integrity.
  • Improve the usability of Access tables.
  • Create advanced queries to join and summarize data.
  • Use advanced formatting and controls to improve form presentation.
  • Use advanced formatting and calculated fields to improve reports.

Course Content

  • Module 1: Promoting Quality Data Input
    • Topic A: Restrict Data Input Through Field Validation
    • Topic B: Restrict Data Input Through Forms and Record Validation
  • Module 2: Improving Efficiency and Data Integrity
    • Topic A: Data Normalization
    • Topic B: Associate Unrelated Tables
    • Topic C: Enforce Referential Integrity
  • Module 3: Improving Table Usability
    • Topic A: Create Lookups Within a Table
    • Topic B: Work with Subdatasheets
  • Module 4: Creating Advanced Queries
    • Topic A: Create Query Joins
    • Topic B: Create Subqueries
    • Topic C: Summarize Data
  • Module 5: Improving Form Presentation
    • Topic A: Apply Conditional Formatting
    • Topic B: Create Tab Pages with Subforms and Other Controls
  • Module 6: Creating Advanced Reports
    • Topic A: Apply Advanced Formatting to a Report
    • Topic B: Add a Calculated Field to a Report
    • Topic C: Control Pagination and Print Quality
    • Topic D: Add a Chart to a Report

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