Course Name

Microsoft Access 2016: 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

Virtually everyone is affected in some way by the need to manage data.

A relational database application such as Microsoft Office Access 2016 can help your organization collect and manage large amounts of data. Access is a versatile tool.

You can use it as a personal data management tool or you can use it as a construction set to develop applications for an entire department or organization.

Course Objectives

In this course, you will use Access 2016 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

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
    • Topic A: Orientation to Microsoft Access
    • Topic B: Create a Simple Access Database
    • Topic C: Get Help and Configure Options in Microsoft Access
  • Module 2: Working with Table Data
    • Topic A: Modify Table Data
    • Topic B: Sort and Filter Records
  • Module 3: Querying a Database
    • Topic A: Create Basic Queries
    • Topic B: Sort and Filter Data in a Query
    • Topic C: Perform Calculations in a Query
  • Module 4: Using Forms
    • Topic A: Create Basic Access Forms
    • Topic B: Work with Data on Access Forms
  • Module 5: Generating Reports
    • Topic A: Create a Report
    • Topic B: Add Controls to a Report
    • Topic C: Enhance the Appearance of a Report
    • Topic D: Prepare a Report for Print
    • Topic E: Organize Report Information
    • Topic F: Format Reports

Course Associated Exam and Certification

  • Appendix A: Microsoft Office Access 2016 Exam 77-730
  • Appendix B: Microsoft Access 2016 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

Virtually everyone is affected in some way by the need to manage data.

A relational database application such as Microsoft Office Access 2016 can help your organization collect and manage large amounts of data. Access is a versatile tool.

You can use it as a personal data management tool or you can use it as a construction set to develop applications for an entire department or organization.

Course Objectives

In this course, you will use Access 2016 to manage your data, including creating a new database; constructing tables; designing forms and reports; and creating queries to join, filter, and sort data.

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
    • Topic A: Orientation to Microsoft Access
    • Topic B: Create a Simple Access Database
    • Topic C: Get Help and Configure Options in Microsoft Access
  • Module 2: Working with Table Data
    • Topic A: Modify Table Data
    • Topic B: Sort and Filter Records
  • Module 3: Querying a Database
    • Topic A: Create Basic Queries
    • Topic B: Sort and Filter Data in a Query
    • Topic C: Perform Calculations in a Query
  • Module 4: Using Forms
    • Topic A: Create Basic Access Forms
    • Topic B: Work with Data on Access Forms
  • Module 5: Generating Reports
    • Topic A: Create a Report
    • Topic B: Add Controls to a Report
    • Topic C: Enhance the Appearance of a Report
    • Topic D: Prepare a Report for Print
    • Topic E: Organize Report Information
    • Topic F: Format Reports

Course Exam And Certification

  • Appendix A: Microsoft Office Access 2016 Exam 77-730
  • Appendix B: Microsoft Access 2016 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