Microsoft Access 2003 VBA

About this class

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.

Who will the lesson benefit?

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

What delegates will learn

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

What prerequisites are required

You will only achieve the course objectives if you have:

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