Microsoft Access 2003 VBA

Course Overview

This course builds on existing knowledge to provide advanced skills in Microsoft Access 2003. You will be introduced to the advanced features of the Access application and also the VBA programming language. You will also be introduced to advanced topics that deal with local database management. You will learn remote database management, how to exchange data with XML and other type applications, and how to automate your business processes by using VBA code.

Audience

This course is designed for experienced users of Microsoft Access 2003 who want to understand advanced features and apply them to their work. The course is designed for individuals who have a thorough understanding of the basic and advanced user features of the Access program, and are interested in learning introductory level administrator skill sets. The course is also for individuals who may be working in a web-based environment and may need to adapt Access applications to the environment

Skills Gained

Delegates will learn how to;

• Develop a data access page
• Develop a data access page, a PivotTable, and a PivotChart
• Import XML data and export Access data
• Use VBA to automate a business process
• Create and modify a database switchboard, and set and modify your startup options
• Distribute a database and add security features to it

Prerequisites

You will only achieve the course objectives if you have:

• Attended the Advanced Microsoft Access 2003 or have equivalent experience of Microsoft Access 2003