 |
|
|
|
|
|
|
|
|
|
|
|
|
 |
|
|||||||||||
 |
 |
 |
 |
 |
 |
 |
 |
 |
 |
|
||
 |
 |
 |
|
|||||||||
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.
Students will learn how to build an application by designing and creating the database objects and a graphical user interface.
Prerequisites:
Access 2002 Advanced, or equivalent knowledge.
Unit 1 : Designing an application
Examining an application
Planning an application
Unit 2 : Automating forms
Working with dialog boxes
Working with macro groups
Automating navigation across forms
Unit 3 : Working with Switchboard and Splash Screen forms
Working with Switchboard forms
Working with Splash Screen forms
Automating Splash Screen forms
Unit 4 : Creating custom toolbars and menu bars
Working with toolbars
Creating custom and shortcut menus
Unit 5 : Working with VBA code
Discussing VBA programming elements
Working with modules
Creating procedures
Unit 6 : Advanced VBA programming
Using control structures
Handling events
Resolving errors
Displaying a Web site
Working with MDE files