Microsoft Access - Advanced

1 Day

Introduction

Designed for experienced users who wish to extend their knowledge further and for those who are responsible for maintaining databases for other users

Pre-requisites

Participants should have attended the introductory course or have been using the software for at least three months and have an understanding of tables, queries and reports before attending this course to fully benefit.

Benefits

Time efficient manipulation and creation of data to support business decisions.

Programme Objectives

Participants will be able to design a relational database, write complex queries and create advanced forms and reports.  In addition they will be able to develop more sophisticated database models for use in a multi-user environment.

Programme Content

• A Review of the Basics
• Indexes
• Hyperlinks
• Macros – Creating, Events, Grouping, Conditional
• Setting up Menu Systems
• Creating Custom Menus
• Creating Option Buttons, Combo and List Boxes
• Startup
• Switchboard Manager
• The Need for Security
• Activating Log On Procedure
• Setting up User/Group Accounts
• Determining who has access to the data and assigning permissions

 

Exact content will vary depending on version