Access Advanced 2000/XP/2003

Duration 1 day

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

Pre-requisites
Delegates 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

Course Aims

By the end of this course delegates 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

Course 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

Qualifications
for team leaders
and first line
managers

ILM Endorsement refers to bespoke programmes that have some form of assessment and are approved as ILM Endorsed Awards. Call or contact Adapt to discuss your specific requirements

Looking for a bespoke programme which has been approved by ILM but doesn’t have an assessment process? Choose Adapt to design a programme for an ILM Development Award

What they said about ...

ILM Level 3 Award in First Line Management

Jane is an excellent trainer and explained everything very clearly, excellent course with content well explained

The trainer answered all my questions superbly, very comprehensive on the detail of the course

Very knowledgeable and helpful and understanding and re explaining

Very good course which has taught me how to talk and deal with my team

Kept interesting and fresh throughout. Easy to stay attentive