Follow us:

Courses

Microsoft Access: Advanced

woman working on a laptop
  • https://blackatlastraining.com/wp-content/uploads/2025/10/course-logo-access-2025-150x150.jpg

  • Microsoft Access: Advanced

    Microsoft Office

  • $495.00

Course Overview

You’ve covered many of the basic functions of Microsoft Office Access, and now you’re ready to learn advanced Access features such as database management, advanced form design, packaging a database, encrypting a database, preparing a database for multiple-user access, and more. Knowledge of these features separate database professionals from the casual database users or occasional designers. Today’s training, added to that which you’ve gained from the Microsoft Office Access Novice and Microsoft Office Access Intermediate courses, rounds out your Access education and provides you with marketable job skills.

Prerequisites

You should have basic knowledge of Windows including opening applications and opening files from File Explorer. You should have a working knowledge of all topics covered in Access Novice and Access Intermediate.

What You Will Learn

  • 01
    Implementing Advanced Form Design
  • Add Controls to Forms
  • Enhance Navigation and Organization of Forms
  • Apply Conditional Formatting
  • 02
    Sharing Data Across Applications
  • Import Data into Access
  • Export Access Data
  • Link Tables to External Data Sources
  • Create a Mail Merge
  • 03
    Using Macros to Improve User Interface Design
  • Create a Macro
  • Restrict Records by Using a Condition
  • Validate Data by Using a Macro
  • Automate Data Entry by Using a Macro
  • 04
    Using VBA
  • Getting Started with VBA
  • Enhance Access by Using VBA
  • 05
    Using Advanced Database Management
  • Manage a Database
  • Determine Object Dependency
  • Document a Database
  • 06
    Distributing and Securing a Database
  • Splitting a Database for Multiple-User Access
  • Implement Security
  • Convert an Access Database to an ACCDE File
  • Package a Database with a Digital Signature
  • 07
    Managing Switchboards
  • Create a Database Switchboard
  • Modify a Database Switchboard
  • Set Start-up Options

Included With The Course

  • Professional textbook (physical and digital)
  • Unused copy of any files referenced throughout the textbook.
  • Certificate of completion signed by the instructor.

Associated Certifications

Not applicable.

Frequently Asked Questions

We understand that you may have questions, and we’re here to help! Some of the most commonly asked questions about this course are covered below but if they don’t cover what you are looking for feel free to reach out to us through our contact page, and we’ll respond promptly to ensure you get the assistance you require. Your satisfaction is our priority, and we’re committed to making sure you have all the information necessary for a seamless experience.

There are a few different versions of OneNote out there. There is the online version that comes with Microsoft 365, the version that comes installed with Windows, and the Microsoft 365 desktop application. This course covers the Microsoft 365 desktop application but a lot of the features can be found in the others as well.

You can find additional information on the different versions of OneNote by clicking here.