About This Training Course

Objectives of this Access Advanced 2010 (2 day course) Training Course are to give experienced users the ability to develop customised menu-driven Access applications using the advanced features of this powerful database management program.

Subjects Covered

This Access Advanced 2010 (2 day course) Training Course will cover the following subjects:

REVIEW OF INTERMEDIATE CONCEPTS
• Overview of topics covered during Intermediate
• Access course

ACCESS-EXCEL INTERACTION
• Import/Export data to Excel

WORKING WITH MACROS
• Create macros
• Saving macros
• Automating Access processes by running macros
• Using macros on Forms

CONTROLLING MACRO PROCEDURES
• Add actions to macros
• Set arguments for macros
• Using Msgbox and Input box tools

ADVANCED FORM FEATURES
• Setting Tab Order
• Using bound Combo Boxes
• Creating Calculated controls
• Setting default values
• Using Macros on Forms

CREATING NAVIGATION WITHIN ACCESS
• Create Switchboards As a user interface tool
• Create Custom Menus & Toolbars
• Set Start Up Options

SECURITY SETTINGS
• Set password access
• Hiding/Unhiding Access objects
• Encode/Decode Database file
• Create a Multi-user environment

SPLIT A DATABASE
• The database splitter wizard
• Working with a Split Database

Training Course Outcomes

At the end of this Access Advanced 2010 (2 day course) Training Course, participants will be able to create customised, menu-driven applications using the advanced features of Microsoft Access.

Prerequisites

Completion of the Access Intermediate course, or equivalent knowledge is required.

Other Information

Put MICROSOFT on your resume!

ATI-Mirage is an Authorised Testing Centre for Microsoft Office Applications - enabling YOU to gain Microsoft Office Specialist certification, a globally recognised credential which PROVES the skills you have gained in desktop computing and helps you to achieve higher productivity and efficiency than your peers!

If you need more information contact Startnextweek.com.au on 1300 728 102