In this course, 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.
Upon successful completion of this course, students will be able 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.
Course Objective: You will be introduced to the advanced features of the Access application and also the VBA programming language.
Target Student: Access Level 4 is for students who have a thorough understanding of the basic and advanced user features of Access, Access 2000, Access XP or Access 2003 program, and are interested in learning introductory level administrator skillsets. The course is also for the student that may be working in a web-based environment and may need to adapt Access applications to the environment. It is also designed for students pursuing the Microsoft MOS Expert Level Certification for Access 2003.
Certification: This course is one of a series of Knowledge Transfer courses that addresses Microsoft Office Specialist (Office Specialist) skill sets. The Office Specialist program is for individuals who use Microsofts business desktop software and who seek recognition for their expertise with specific Microsoft products. Certification candidates must pass one or more proficiency exams in order to earn Office Specialist certification. To learn more about the Microsoft Office Specialist Program visit our certifications section.