Our trainings are available in-person or virtual online with live instructor via MS Teams

Microsoft Access Level 2 – Office 2016/Office 365

This training course will take your Microsoft Access skills to the next level and enroll now and receive step-by-step mentoring on mastering Microsoft Access at an intermediate level. You will learn how to work with more advanced Access features including: Lookup Fields, Parameter and Update Queries, Filter and Sort records, Combo Box and how to Keep Groups Together.

Microsoft Access Advance Level Training

2 Days

Microsoft Access

7 PDUs

Personal Development Unit

MS Access Level 2 – Advance

IMPLEMENTING ADVANCED FORM DESIGN

  • Add Controls to Forms
  • Create Subforms
  • Organize Information with Tab Pages
  • Enhance Navigation of Forms
  • Apply Conditional Formatting

USING DATA VALIDATION

  • Field and Record Validation
  • Form Validation

USING MACROS TO IMPROVE USER INTERFACE DESIGN

  • Create a Macro
  • Restrict Records Using a Condition
  • Validate Data Using a Macro
  • Automate Data Entry Using a Macro
  • Convert a Macro to VBA

USING ADVANCED DATABASE MANAGEMENT

  • Link Tables to External Data Sources
  • Manage a Database
  • Determine Object Dependency
  • Document a Database
  • Analyze the Performance of a Database

ADVANCED REPORTING

  • Organize Report Information
  • Format Reports
  • Include Control Formatting in a Report
  • Add a Calculated Field to a Report
  • Add a Subreport to an Existing Report

DISTRIBUTING AND SECURING A DATABASE

  • Splitting a Database for Multiple User Access
  • Implement Security
  • Set Passwords
  • Package a Database with a Digital Signature

MANAGING SWITCHBOARDS

  • Create a Database Switchboard
  • Modify a Database Switchboard
  • Set Startup Options

SHARING DATA ACROSS APPLICATIONS

  • Import Data into Access
  • Export Data to Text File Formats
  • Export Access Data to Excel
  • Create a Mail Merge

Workshop Wrap-Up

At the end of the course, students will have an opportunity to ask questions.