Access 2000 VBA Programming

Course Description
Course Outline

Overview

Students will learn how to develop an application and tie the objects together into a cohesive system by using macros and Visual Basic for Applications code.

Prerequisites

Access 2000 Advanced, or equivalent knowledge.

Benefits

Students will learn how to build an application by designing and creating the database objects and a graphical user interface.

Target student

Students should already understand table, query, form, report, and macro design and function, as well as data normalization and table relationships.

We offer a range of VBA training courses

Application design concepts
Planning an application Examining a completed application Developing a distributed application design
Adding command buttons to guide user navigation
Using one form for two purposes to add or edit records
Automating a dialog-box form with a macro group
Creating a macro group Customising an unbound form as a dialog box Documenting a macro group
Creating a Switchboard form
Using the Switchboard Manager Setting database startup properties
Working with custom toolbars and menus
Using a macro group to show and hide a toolbar Creating a custom menu bar for a form Startup properties for toolbars and menu bars
Creating a Splash Screen form
Creating a form as a splash screen Automating the Splash Screen form Modifying startup properties to display a Splash Screen form Documenting the application
Using Visual Basic procedures
Creating a public function Adding general procedures in a Form module Creating Event Procedures Viewing a live web site on a Form
Adding security to an application
Security overview Steps to securing a database by using user-level security Documenting database security Securing a database with a database password Distributing the secured application

Publisher:	Microsoft
Version:	2000
Length:	2 days
Course-ID:	076403x

	Printer Friendly Version
	Download Outline As PDF

Related Courses

Excellent course, most topics were useful and the others were interesting and will be good to know about even if they don't affect my job personally

- IRI