00 353 1 2790020sales@olas.ie Olas: Professional, Direct, Clever & Helpful

Microsoft Access Advanced

 

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.

Price: €375 per person

Dates

  • Book a place on this course and pay with your credit card.26 March 2020 , 1 Day
  • Book a place on this course and pay with your credit card.13 July 2020 , 1 Day
  • Book a place on this course and pay with your credit card.24 November 2020 , 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.

Course Outline
Click here to download course oultline

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

Contact Us

Drop us a line, include your contact details and we will get back to you as soon as possible.