Course Name

Microsoft Access 2016: Advanced Features – Level 3

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

Course Introduction

Knowledge of advanced Access features separate database professionals from the casual database users or occasional designers. This course rounds out your Access education and provides you with marketable job skills.

Course Objectives

At the end of this course, you will be able to use advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access.

You will:

  • Customize a form layout to improve usability and efficiency of data entry.
  • Share data across applications.
  • Use macros to improve user interface design.
  • Use VBA to enhance tasks.
  • Organize data into appropriate tables to ensure data dependency and minimize redundancy.
  • Lock down and prepare a database for distribution to multiple users.
  • Create and modify a database switchboard and set the start-up options.

Course Content

  • Module 1: Implementing Advanced Form Design
    • Topic A: Add Controls to Forms
    • Topic B: Enhance Navigation and Organization of Forms
    • Topic C: Apply Conditional Formatting
  • Module 2: Sharing Data Across Applications
    • Topic A: Import Data into Access
    • Topic B: Export Access Data
    • Topic C: Link Tables to External Data Sources
    • Topic D: Create a Mail Merge
  • Module 3: Using Macros to Improve User Interface Design
    • Topic A: Create a Macro
    • Topic B: Restrict Records by Using a Condition
    • Topic C: Validate Data by Using a Macro
    • Topic D: Automate Data Entry by Using a Macro
  • Module 4: Using VBA
    • Topic A: Getting Started with VBA
    • Topic B: Enhance Access by Using VBA
  • Module 5: Using Advanced Database Management
    • Topic A: Manage a Database
    • Topic B: Determine Object Dependency
    • Topic C: Document a Database
  • Module 6: Distributing and Securing a Database
    • Topic A: Splitting 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
  • Module 7: Managing Switchboards
    • Topic A: Create a Database Switchboard
    • Topic B: Modify a Database Switchboard
    • Topic C: Set Start-up Options

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

Knowledge of advanced Access features separate database professionals from the casual database users or occasional designers. This course rounds out your Access education and provides you with marketable job skills.

Course Objectives

At the end of this course, you will be able to use advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access.

You will:

  • Customize a form layout to improve usability and efficiency of data entry.
  • Share data across applications.
  • Use macros to improve user interface design.
  • Use VBA to enhance tasks.
  • Organize data into appropriate tables to ensure data dependency and minimize redundancy.
  • Lock down and prepare a database for distribution to multiple users.
  • Create and modify a database switchboard and set the start-up options.

Course Content

  • Module 1: Implementing Advanced Form Design
    • Topic A: Add Controls to Forms
    • Topic B: Enhance Navigation and Organization of Forms
    • Topic C: Apply Conditional Formatting
  • Module 2: Sharing Data Across Applications
    • Topic A: Import Data into Access
    • Topic B: Export Access Data
    • Topic C: Link Tables to External Data Sources
    • Topic D: Create a Mail Merge
  • Module 3: Using Macros to Improve User Interface Design
    • Topic A: Create a Macro
    • Topic B: Restrict Records by Using a Condition
    • Topic C: Validate Data by Using a Macro
    • Topic D: Automate Data Entry by Using a Macro
  • Module 4: Using VBA
    • Topic A: Getting Started with VBA
    • Topic B: Enhance Access by Using VBA
  • Module 5: Using Advanced Database Management
    • Topic A: Manage a Database
    • Topic B: Determine Object Dependency
    • Topic C: Document a Database
  • Module 6: Distributing and Securing a Database
    • Topic A: Splitting 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
  • Module 7: Managing Switchboards
    • Topic A: Create a Database Switchboard
    • Topic B: Modify a Database Switchboard
    • Topic C: Set Start-up Options

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