Microsoft Courses > Microsoft Access 2000 Level 4 Application Development Training Course

Access 2000: Introduction to Application Development is a hands-on instruction book that will guide you through the process of developing an application by using one or more Access 2000 databases.

Access 2000: Introduction to Application Development is for the delegate who is proficient in creating Access normalized tables and their relationships, multi-table queries, forms and subforms, reports, and macros, and who needs to draw on all these skills and add code to create an application. The prerequisite PTR courses for this course are:

Access 2000: Level 1

Access 2000: Level 2

Access 2000: Advanced

Topics covered on the 2 day Microsoft Access 2000 Level 4 Application Development course

Application Design Concepts

Planning an Application

Moving through 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

Customizing an Unbound Form to Behave like a Dialog Box

Documenting a Macro Group

Creating a Switchboard Form

Using the Switchboard Manager

Setting Database Startup Properties

Working with Command Bars: Toolbars and Menus

Using a Macro Group to Show and Hide a Toolbar

Creating a Custom Menu Bar and Shortcut Menu 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 by Using Visual Basic Code

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

Appendix A: APP.MDB Diagrams

Book Invoice Application

Access Application

Appendix B: Planning an Application

Planning an Application

Appendix C: Importing Spreadsheets, Databases, and Delimited Text Files

Importing and Linking Data from Spreadsheets

Importing and Linking Database Files

Importing Text Files

Appendix D: Securing Your Database Using the Access 2000 Security Wizard

A Summary of Using the Access 2000 Security Wizard

   (excl.VAT)