Microsoft Access Level 2

Microsoft Access Level 2

Course Summary

Summary: This course has been designed to enable the delegate to :

• Maximise the use of Database querying facilities to interrogate data
• Customise forms and reports to include user-defined options
• Enable the design and use of Macros for efficient Database operation
• Utilise database protection facilities.
• This session will also serve as a refresher in the Intermediate level access uses.

The course contents are intended as a guideline only, however as this is a workshop based session it will depend on the requirements of the group as a whole;

Duration: 1 Day

Group: Microsoft

Contents

Forms & Reports -

• Using expressions
• Creating mailing labels in a report
• Grouping /sorting data in a report
• Lists, Combo Boxes & Filtering

Macros

• Grouping Macros
• Conditional Macros
• Assigning Macros to shortcut Keys
• Creating an application

Queries

• Multiple tables and relationships
• Creating auto lookup queries
• Parameter Queries

Object linking and embedding

• Drag and drop database objects
• Adding bound and unbound objects

Graphs

• Using the Chart Wizard
• Editing and enhancing Charts
• Importing and linking Data

Protecting Data

• Data Validation
• Setting passwords
• Setting Database security
• Using the Security Wizard

Prerequisites

Attendance on Access Introduction

Course: Microsoft Access Introduction

Suggested Next Steps

None

Scheduled Dates and Fees

Start Dates Fee Notes

Tuesday 17 June 2008 £145 (ex VAT)
Tuesday 16 September 2008 £145 (ex VAT)
Tuesday 09 December 2008 £145 (ex VAT)