Home :: Study Guides :: Microsoft Office 2003

Access 2003 Application Development, 2nd Edition Study Guide

1-4239-1350-7 © 2007 Publish date: March 6, 2006 122 pages

Course ID: access-2003-app-dev-2nd-sg

CBT Planet has computer training books designed for every level of Microsoft Access training including advanced topics such as Application Development. The Access 2003 Application Development study guide is a highly rated course (4.8/5.0 in overall quality by ProCert Labs) that is perfect for experienced Access users that wish to increase their database development proficiency.

You will learn advanced development skills including how to create complex queries, advanced forms and reports, macros, and data access pages using Microsoft Visual Basic for Applications.

The Access 2003 Application Development courseware doubles as both an advanced course as well as a reference book. You can use this course to supplement your existing Access classes or learn on your own by closely following each unit and participating in the included exercises.

This courseware lets you learn advanced Microsoft Access development techniques without having to spend time traveling to and from classes or taking time off of work. You can learn on your own time, using your own schedule, and study whenever you choose. The Access 2003 Application Development courseware is the perfect, portable solution for self-directed study and career-building. Whether you blaze through the course in a single day or take weeks to work through it is up to you and your individual goals.

Course Objectives

By following this course, you will understand applications and their components as well as be able to plan an application. You'll learn about creating and using grouped controls, tab controls, and sub-forms. Other topics include creating dialog boxes, macros for automating dialog boxes, using code elements from Visual Basic for Applications, and using command buttons to automate navigation between forms.

You will work with the Switchboard Manager to create, test, and modify Switchboard forms, create Splash Screen forms after modifying the form's properties, and set up Splash Screen forms so that they appear at startup of the database.

You also will learn how to use macro groups for showing or hiding toolbars, how to create your own custom toolbars, shortcut menus, and menu bars, and how to adjust startup properties for both menus and toolbars.

Course Contents

Unit 1 introduces application design

• Exploring applications
• Planning applications

Unit 2 covers advanced forms

• Working with grouped controls
• Fine-tuning the user interface
• Working with sub-forms
• Unit 3 discusses using form controls
• Using dialog boxes
• Using macro groups
• Automating form navigation

Unit 4 covers the Switchboard and splash screens

• Using Switchboards
• Using splash screens
• How to automate splash screens

Unit 5 discusses creating custom toolbars and menu bars

• Using toolbars
• How to create custom menu bars and shortcut menus