Microsoft Access 2003 VBA

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

Visual Basic Editor Objects • Object Browser • Collections

Programming Basics Data • Scope

Control Structures Decision structures • Loop Structures

ActiveX Data Objects Getting started with ActiveX Data Objects  • Working with ActiveX Data Objects

VBA debugging tools Errors in code • Debugging techniques • Handling run-time errors

Office Integration Automating Office 2003 • Working with Word from Access • Working with Excel from Access

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