Course Name

Microsoft Access 2019: Essentials – Level 1

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

Course Introduction

Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data.

A relational database application such as Microsoft Office Access can help you and your organization with this task. This course is the first part of a three-course series that covers the skills needed to perform database design and development in Access.

Course Objectives

Upon successful completion of this course, you will be able to design and construct an Access database as well as understand basic relational database design and be able to create simple tables, queries, forms, and reports.

You will:

  • Navigate within the Microsoft Access environment and create a simple database.
  • Organize and manage data stored within Access tables.
  • Use queries to join, sort, and filter data from different tables.
  • Use forms to make it easier to view, access, and input data.
  • Create and format custom reports.

Course Content

  • Module 1: Getting Started with Access 2019
    • Topic A: Launch Access and Open a Database
    • Topic B: Use Tables to Store Data
    • Topic C: Use Queries to Combine, Find, Filter, and Sort Data
    • Topic D: Use Forms to View, Add, and Update Data
    • Topic E: Use Reports to Present Data
    • Topic F: Get Help and Configure Options in Microsoft Access
  • Module 2: Creating Tables
    • Topic A: Plan an Access Database
    • Topic B: Start a New Access Database
    • Topic C: Create a New Table
    • Topic D: Establish Table Relationships
  • Module 3: Creating Queries
    • Topic A: Create Basic Queries
    • Topic B: Perform Calculations in a Query
    • Topic C: Sort and Filter Data in a Query
  • Module 4: Creating Forms
    • Topic A: Start a New Form
    • Topic B: Enhance a Form
  • Module 5: Creating Reports
    • Topic A: Start a New Report
    • Topic B: Enhance Report Layout

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

Data is everywhere. Most job roles today involve some form of data management. Virtually everyone is affected in some way by the need to manage data.

A relational database application such as Microsoft Office Access can help you and your organization with this task. This course is the first part of a three-course series that covers the skills needed to perform database design and development in Access.

Course Objectives

Upon successful completion of this course, you will be able to design and construct an Access database as well as understand basic relational database design and be able to create simple tables, queries, forms, and reports.

You will:

  • Navigate within the Microsoft Access environment and create a simple database.
  • Organize and manage data stored within Access tables.
  • Use queries to join, sort, and filter data from different tables.
  • Use forms to make it easier to view, access, and input data.
  • Create and format custom reports.

Course Content

  • Module 1: Getting Started with Access 2019
    • Topic A: Launch Access and Open a Database
    • Topic B: Use Tables to Store Data
    • Topic C: Use Queries to Combine, Find, Filter, and Sort Data
    • Topic D: Use Forms to View, Add, and Update Data
    • Topic E: Use Reports to Present Data
    • Topic F: Get Help and Configure Options in Microsoft Access
  • Module 2: Creating Tables
    • Topic A: Plan an Access Database
    • Topic B: Start a New Access Database
    • Topic C: Create a New Table
    • Topic D: Establish Table Relationships
  • Module 3: Creating Queries
    • Topic A: Create Basic Queries
    • Topic B: Perform Calculations in a Query
    • Topic C: Sort and Filter Data in a Query
  • Module 4: Creating Forms
    • Topic A: Start a New Form
    • Topic B: Enhance a Form
  • Module 5: Creating Reports
    • Topic A: Start a New Report
    • Topic B: Enhance Report Layout

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