Microsoft Access 2003 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 2003 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 2003 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

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

Advanced forms Using grouped controls • Creating and using grouped controls • Adding an option group control to a form • Modifying the option group control • Checking errors in forms • Refining the user interface • Adding a tab control to a form • Preventing modifications • Creating a Startup form • Discussing a Switchboard form • Creating subforms • Examining and using a subform • Creating a subform

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

Switchboards and splash screens Working with Switchboards • Using the Switchboard Manager • Testing Switchboard objects • Modifying a Switchboard • Working with splash screens • Observing a splash screen • Creating a Splash Screen form • Setting the properties of a Splash Screen form • Automating splash screens • Displaying the splash screen on database startup • Displaying the splash screen for a specified amount of time • Opening a Switchboard form automatically

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 menu bars and shortcut menus

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