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

Microsoft Access Advanced

 

Description

To acquire more advanced knowledge of Access, including relational database design, macros, VBA, database security and integration with other MS Office applications.

Price €300 per person

Dates

  • Book a place on this course and pay with your credit card.27 July 2017 , 1 Day
  • Book a place on this course and pay with your credit card.14 September 2017 , 1 Day
  • Book a place on this course and pay with your credit card.22 November 2017 , 1 Day

TARGET AUDIENCE

Aimed at users who have a good working knowledge of Microsoft Access and who would like to reach an advanced level.

PREREQUISITES

None

GOALS AND OBJECTIVES

Course Outline
Click here to download course oultline

Introduction and Overview
Objectives
Programme Overview
Explore the Ribbon

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
Startup 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
Startup Options
Export linked data source information to Excel

Database Management Tools
Compact and Repair Database
Compact on Close
Table Analyzer

Using the ‘Tell me what to do…’ function

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.