| Access 2000:
Application Development Course
specifications
Course number: 011 313
Software version number: 9.0
Course length: 1 day
Course description
Overview:
Students will learn how to develop an application and tie the objects together into
a cohesive system by using macros and Visual Basic for Applications code.
Prerequisites:
Access 2000: Introduction, Intermediate & Advanced, or equivalent
knowledge.
Delivery method:
Instructor-led, group-paced, classroom-delivery learning model with structured
hands-on activities.
Benefits:
Students will learn how to build an application by designing and creating the
database objects and a graphical user interface.
Target student:
Students enrolling in this course should understand table, query, form, report, and
macro design and function, as well as data normalization and table relationships.
What's next:
This is the last course in this series.
Access 2000:
Application Development
Performance-based objectives
Lesson objectives help students become comfortable with the course, and also provide a
means to evaluate learning. Upon successful completion of this course, students will be
able to:
- Identify components of and plan an application.
- Automate the application interface, automate dialog boxes, use Visual Basic for
Applications (VBA) code elements, and automate navigation across forms.
- Create Switchboard forms, and create and automate Splash Screen forms.
- Create macro groups, custom toolbars, menu bars, shortcut menus, and set the
startup properties for toolbars and menus.
- Use different VBA programming elements, work with modules, and create procedures
in modules.
- Use control and loop structures in VBA code, handle events by automating controls
on forms, trap and resolve errors in code, and add Web browser controls to forms.
- Work with database utilities to optimize resources, secure data, and encrypt and
decrypt databases.
|