Course List >> Microsoft® Access® Application Development

MICROSOFT® ACCESS ® APPLICATION DEVELOPMENT

Description:
In this course you will learn how to: design an application, use advanced forms, work with form controls, dialog boxes and macro groups, work with switchboards and splash screens, work with toolbars and create custom toolbars and menu bars, use Visual Basic Editor, understand programming basics, uses control structures, work with ActiveX Date Objects, use VBA debugging tools & learn office integration skills between Office 2003 applications including Word, Access, and Excel.

Upon successful completion of this course, students will be able to:

• Design an application by planning the scope and components of an application and by using external data sources.
• Navigate from one form to another form in data-entry mode by using a command button, and make a command button invisible on the second form.
• Automate a form designed as a dialog box by using a macro group.
• Create and modify a Switchboard form by using the Switchboard Manager. Display the Switchboard form when the database opens by changing database Startup properties.
• Create and use custom toolbars and menus by using the Customize dialog box and setting properties.
• Create an unbound form to use as a splash screen on application startup by setting properties and writing Visual Basic for Applications code.
• Identify elements of Visual Basic for Application syntax and decide where to place code by working with a standard function, a Private module-level procedure, and Sub procedures attached to event properties.
• Secure an application by defining application-level and file-level security, by creating a workgroup information file, and by setting a database password
• (topics listed are for Access 2003; may vary slightly for Access 2007)

Prerequisite: Access® Level 3 or equivalent knowledge. Visual Basic programming knowledge is preferred.

Training Type: Instructor led, group-paced, classroom-delivery learning model with structured hands-on activities. Max # of students = 6.
**Available for Private or Group Sessions**

Cost: $320 (2 days)

Course Includes:

• Professional Textbook
• Take-home CD or downloadable materials with practice examples
• 1 month of email/phone support
• 1 year for a free re-take of the same course

Class Info: 1 day course | Time: 9:30am-approx 3pm (class times may vary). Several breaks are taken throughout the day. | Class size limited

How to register:Use our Course Information Request Form . We will contact you regarding scheduling and availability.