Access 2000 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, and add Web browser controls to forms
• Work with database utilities to optimize resources, secure data, and encrypt and decrypt databases

This course will help students to become proficient database application developers by using the features of Microsoft Access 2000 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 2000 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 • Planning an application

Automating forms Working with dialog boxes • Working with macro groups • Automating navigation across forms

Working with Switchboard and Splash Screen forms Working with Switchboard forms • Working with Splash Screen forms • Automating Splash Screen forms

Creating custom toolbars and menu bars Working with toolbars • Creating custom and shortcut menus

Working with VBA code Visual Basic for Applications programming elements • Working with modules • Creating procedures

Advanced VBA programming Using control structures • Handling events • Resolving errors • Displaying a Web site

Managing databases Working with database utilities to optimize resources • Securing data by database replication • Encrypting and decrypting databases

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