MS Access Level 2

/MS Access Level 2
MS Access Level 2 2019-08-07T16:07:25+00:00

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.

Best Training Institute in Dubai
View All
Soft Skills Courses
View All
PMP Project Management Professional Exam Prep Training Course Certification in Dubai
View All