ICT Academy banner

Microsoft Access 2010 - Advanced

Type of learning: Instructor lead at DBIC
Duration: 1 day intensive
Times/dates: Click here for available dates

Contact us for costs

Target Audience

Anyone wishing to investigate the more powerful and advanced features of Access 2007 or 2010.


Pre-Course Requirements

Delegates should be proficient users of Access 2010, 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 2010. By the end of the course, the user will be competent with the following skills:


Course Outline


- 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.



Explore the benefits of using other Office applications including Excel, Word, PowerPoint, or Project.

Microsoft Courses

Intensive Training (Office 2010)


How to Apply



Government funding available for local businesses through Train to Gain Enhancement Fund.


Contact details

Email: info@ictacademy.co.uk
Tel: (+44) 01302 554955 (DBIC)
Address: Autodesk Training Centre, ICT Academy, Doncaster Business Innovation Centre, Ten Pound Walk, DN4 5QA

©2015 ICT Academy
All rights reserved.
ICT Academy, Doncaster Business Innovation Centre, Ten Pound Walk, Doncaster, DN4 5QA

Email: info@ictacademy.co.uk
Tel: (+44) 01302 554955 (DBIC)
Tel: (+44) 01302 558517 (The Hub)