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
Cost:

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

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.

 

Progression

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

Microsoft Courses

Intensive Training (Office 2010)

 

How to Apply

 

Employers

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

 


Printable Version

Click on icon to print this page

 


Contact details

Email: info@ictacademy.co.uk
Tel: 01302 554958
Address: ICT Academy, The Hub, Doncaster College, Chappell Drive, Doncaster, DN1 2RF

 
©2014 ICT Academy
All rights reserved.
ICT Academy, The Hub, Doncaster College, Chappell Drive, Doncaster, DN1 2RF

Email: info@ictacademy.co.uk
Tel: 01302 554958
Web: www.ictacademy.co.uk