Access 2002 Application Development

This content has been designed for a one day classroom course. On course completion, 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, add Web browser controls to forms, and work with MDE files

This course will help students to become proficient database application developers by using the features of Microsoft Access 2002 and Visual Basic for Applications.

Target audience

Students should have familiarity with personal computers and the use of the keyboard and mouse. They should have completed introduction, intermediate and advanced courses in Access 2002 or have equivalent practical experience. Specifically, students should be familiar with creating complex queries, creating advanced forms and reports, creating and using macros and creating and using data access pages.

Course content

Planning an application Examining an application • Examining the components of an application • Identifying the objectives of an application • Resolving design issues in an application • Planning application objects

Automating forms Working with dialog boxes • Examining the properties of a dialog box • Examining the properties of controls on a dialog box • Working with macro groups • Examining a macro group • Creating a macro group • Attaching a macro group to command buttons • Automating navigation across forms • Discussing VBA • Examining the VBE window • Examining a command button code • Programming a button on a form to open another form • Disabling and enabling command buttons

Working with Switchboard and Splash Screen forms Working with Switchboard forms • Creating a Switchboard form by using the Switchboard Manager • Testing Switchboard objects • Modifying a Switchboard form • Working with Splash Screen forms • Observing a Splash Screen form • Creating a Splash Screen form • Setting label properties • Setting the properties of a Splash Screen form • Automating Splash Screen forms • Displaying the Splash Screen form on database startup • Displaying the Splash Screen form for a specified time • Opening a Switchboard form automatically after the Splash Screen form

Creating custom toolbars and menu bars Working with toolbars • Creating a macro group to show or hide a toolbar • Replacing the built-in toolbar with a custom toolbar • Adding buttons to a custom toolbar • Creating custom and shortcut menus • Examining a custom menu bar • Creating a custom menu bar • Adding commands to a custom menu bar • Creating a custom shortcut menu • Setting startup properties for toolbars, menus, and Access Special Keys

Working with VBA code Discussing VBA programming elements • Discussing data types • Using variables and constants • Working with modules • Examining the Code window • Examining a VBA code • Creating procedures • Creating a Sub procedure in a standard module • Calling a Sub procedure • Creating a Function procedure in a standard module • Calling a Function procedure

Advanced VBA programming Using control structures • Using the IF…Then statement • Using the IF…Then…Else statement • Using the IF…Then…ElseIf statement • Using the For…Next loop • Using the Do While… loop • Handling events • Assigning event handling code to a text box • Assigning event handling code to a combo box • Assigning event handling code to coordinate events across two forms • Assigning the OnUndo event procedure for a form • Assigning the Unload event procedure for a form • Resolving errors • Adding error-handling code • Testing an error-handling code • Displaying a Web site • Adding a Web browser control to a form • Displaying a Web site on the form • Working with MDE files • Creating an MDE file

About Courseware Company :: Instructor-led training courseware :: Self-study solutions :: Buy online today