Description
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: €400 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.
Dates
- Dates available on request, please call for details – 1 Day
TARGET AUDIENCE
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.
PREREQUISITES
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
Objectives
Programme 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
Developing Applications
Naming Conventions
Input Masks
Validating and Restricting Data
Indexes
Relational Databases
Relational Databases
Database Capabilities
Relational Database Characteristics
Different Types of Relationship
Creating a One-to-Many Relationship
Primary Keys
Referential Integrity
Macros
Create Macros
Adding Actions and Arguments
Creating Macro Groups
Attach Macro to Command Button
Customising Toolbars with Macros
Toolbars / Switchboard
Creating Toolbars
Customising Toolbars using Macros
Creating a Switchboard
Modifying a Switchboard
Start-Up Options
VBA
The VB Window
Module Types
Variables and Variable Scope
Object Properties, Methods and Events
Functions and Procedures
Conditional Logic and Looping Constructs
Importing, Linking and Exporting
Importing Data
Linking Data
Importing from another Access Database
Importing from a Spreadsheet
Exporting Data
Automate Importing, Exporting or Linking
Start-Up Options
Export linked data source information to Excel
Database Management Tools
Compact and Repair Database
Compact on Close
Table Analyzer
Course Summary and Review
Recap of Topics Covered
Question Time