Microsoft Access 2003 VBA
Four days,
Instructor-led
Introduction
Elements of this
syllabus are subject to change
This four-day instructor-led course begins with the programming life cycle,
the Visual Basic Editor environment, and essential programming concepts.
Each day, students will move through object-oriented programming concepts,
learn to retrieve and update data with ADO, use VBA to create reports
programmatically, export Access data to various Web formats, and migrate an
existing Access database to an Access project that uses SQL Server®.
Students will also learn advanced topics such as working with external DLLs,
handling security, creating transactions, and creating custom code
libraries. Students will also learn how to distribute their applications by
studying two case studies - a project tracking application and a customer
service application.
Audience
This course is designed for Access users and programmers who have created
databases that include tables, forms, and possibly macros. No prior
experience with VBA is required.
At Course Completion
After completing this
course, students will be able to:
-
Object-oriented
programming techniques using VBA
-
How to use
built-in objects and create your own
-
How to use ActiveX
Data Objects (ADO) to retrieve and update data
-
Methods for
creating reports and Web content from the database
-
Techniques for
integrating with Office applications
-
How to build SQL
Server solutions with Access projects
Prerequisites
Students taking this
course should be familiar with personal computers and the use of a keyboard
and mouse. Furthermore, this course assumes that students have completed
the following courses or have equivalent experience:
-
Operation
understanding of Microsoft Windows XP
-
Understanding of
Microsoft Access 2003
Course Materials
The student kit includes a comprehensive and award-winning textbook and
other necessary materials for this class.
Course Outline
Chapter 1:
Introduction to Access 2003 VBA
Chapter 2: The
Basics of Writing and Testing VBA Code
Chapter 3:
Programming Applications Using Objects
Chapter 4: Creating
Your Own Objects
Chapter 5:
Interacting with Data Using ADO and SQL
Chapter 6: Building
Interactive Forms
Chapter 7:
Importing, Linking, and Exporting Using External Data Sources
Chapter 8: Creating
Reports and Web-Enabled Output
Chapter 9: Building
SQL Server Applications with Access Projects
Chapter 10:
Advanced Access Programming
Chapter 11:
Finishing the Application
Chapter 12: Case
Study 1 – Project Tracking Application
Chapter 13: Case
Study 2 – Customer Service Application
|
