Contact us for costs
Anyone wishing to investigate the more powerful and advanced features of Access 2007 or 2010.
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.
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.
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:
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.
Explore the benefits of using other Office applications including Excel, Word, PowerPoint, or Project.
Microsoft Office Specialist
(MOS 2010)
MOS - Excel
MOS - Word
MOS - PowerPoint
MOS Outlook
MOS Access
Intensive Training (Office 2010)
Government funding available for local businesses through Train to Gain Enhancement Fund.
Click on icon to print this page
Email: info@ictacademy.co.ukTel: 01302 554958Address: ICT Academy, DBIC, Doncaster, DN4 5QA