|
|
Access 2003: VBA |
Course Outline
Duration:
1 Day
Prerequisites: Access 2003: Introduction, Access 2003: Intermediate, and Access 2003: Advanced or equivalent
experience
Description: This course is designed for experienced Access users who want to learn
ActiveX data objects, control structures, and the basics of VBA programming. The
manual is designed for quick scanning in the classroom, and filled with
interactive exercises.
Who should take this course?
Microsoft Access 2003: VBA Programming is for students
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 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.
Objectives
- Work with objects, use Object Browser, identify
collection objects, and use the Controls collection.
- Manipulate data by declaring variables, combine
data by using expressions, get user input, create Sub and Function
procedures, and call one procedure from another.
- Use decision structures and use loop structures.
- Identify ActiveX Data Objects (ADO) architecture
and collections, connect to a database, work with a Recordset,
and create a parameter query.