Microsoft Access - Advanced

Introduction

This one-day course is designed for experienced users of Access who now wish to exploit the advanced facilities of this software package to build more sophisticated applications. All courses are highly interactive and we encourage all delegates to join in, to enhance their own learning process.

Course Aims

To provide an understanding of the advanced functionality of Access for use in Database creation, development, modification and data security.

Course Objectives

• By the end of the course, delegates will be able to:
• Customise and secure databases
• Use database tools and utilities
• Automate a database with macros
• Write VBA code using the Wizard
• Pre-requisites
• We recommend that all those who attend are able to:
• Use Access at an intermediate level

Course Content

(If requested courses can be tailored to cover specific work requirements)

Performance and Database Design

• Setting up Indexes
• Creating and editing table relationships
• Importing and exporting database objects
• Creating Custom Toolbars

Using different join types

• Working with outer join
• Working with inner join
• Editing join types

Advanced Form Design

• Creating Calculated Fields
• Using the Expression Builder
• Understanding Form Events

Automating a Database

• Controlling the Start-up of a database
• Creating and running macros
• Setting conditions in macros
• Attaching macros to events

Database Utilities

• Security methods for a database
• Convert, compact & repair a database

Introduction to VBA

• Writing VBA code using the Wizard
• When to use VB instead of macros
• Converting macros to VB code

Back to previous page