Part time Access Advanced

Microsoft Access 2003 - Advanced Type of learning:
Instructor lead at DBIC

Duration:
1 day intensive

Times/dates:

Cost:

£185 (includes course materials, lunch and refreshments)
Corporate rates available please contact us for further information

Target Audience
Anyone wishing to investigate the more powerful and advanced features of Access 2003.

Pre-Course Requirements
Delegates should be proficient users of Access 2003, and should have experience of the topics covered in our Introductory and Intermediate courses, either from attending these courses or by knowledge gained from their own experience.

Benefits to the Employer
Staff will respond to your commitment to their career development and are likely to become more motivated to perform well and be dedicated to the business. Well-trained staff will be able to complete tasks more quickly and efficiently and productivity may go up.

Course Aims
This course allows the delegate to appreciate the full potential of Access 2003. By the end of the course, the user will be competent with the following skills:

Course Outline
Macros

- Single and Multiple Action Macros

- Grouping Macros

- Attach Macros to Controls

- Create Macros from Controls

- AutoExec Macro

- Update Fields and Dates Macros

- Print Record Macro

- Start Value Counter Macro

- Open a Form Macro

- Adjust Value Macro

Advanced Queries

- Append/Delete/Update Query

- Make-Table Query

- Crosstab Query

- Find Duplicate Records Query

- Find Unmatched Records Query

Formatting Forms

- Adding Backgrounds

- Insert Pictures and Charts

- Page Headers and Footers

- Conditional Formatting

- Insert Date and Time

- Tools and Operations

- Maximise and Restore Reports

- Number Report Pages

Database Utilities

- Compact a Database

- Repair a Database

- Linked Tables

- Backup and Restore a Database

- Database Splitter

- Switchboard Manager

- Add and Remove Passwords

Database Analysis

- Table Analyzer

- Performance Analyzer

- Documenter

Control Panel

- Main Control Panel

- Sub Control Panels

- Apply Macros

- Option Groups

This course outline is a guide. All our courses can be tailored to customer requirements.