The objective of our Microsoft Access Advanced training course is for participants to acquire more advanced knowledge of Access, including relational database design, macros, VBA, database security and integration with other Microsoft Office applications.
Full Day Course Price: €375 per person
Click here to view the upcoming Virtual Live Training 1.5 hour session schedule.
To book onto a Virtual Live Training 1.5 hour session, or series of sessions, please click here.
This Microsoft Access Advanced training course is aimed at users who have a very good working knowledge of Access and wish to use high level database functions.
A very good working knowledge of Microsoft Access would be of great benefit. Ideally, participants should have attended the Access Introduction and/or Intermediate training programme prior to this course.
GOALS AND OBJECTIVES
Having completed this course, participants will have an advanced knowledge of Access, including relational database design, macros, VBA, database security and integration with other Microsoft Office applications.
Introduction and Overview
Explore the Ribbon
What is New in Access 2019
Discover the New Charts
Work with New Field Types
New Label Controls
Using the ‘Tell me what to do…’ Function
Advanced Database Design
Validating and Restricting Data
Relational Database Characteristics
Different Types of Relationship
Creating a One-to-Many Relationship
Adding Actions and Arguments
Creating Macro Groups
Attach Macro to Command Button
Customising Toolbars with Macros
Toolbars / Switchboard
Customising Toolbars using Macros
Creating a Switchboard
Modifying a Switchboard
The VB Window
Variables and Variable Scope
Object Properties, Methods and Events
Functions and Procedures
Conditional Logic and Looping Constructs
Importing, Linking and Exporting
Importing from another Access Database
Importing from a Spreadsheet
Automate Importing, Exporting or Linking
Export linked data source information to Excel
Database Management Tools
Compact and Repair Database
Compact on Close
Course Summary and Review
Recap of Topics Covered