Access 2000
Application development

Topic-Level Outline

Days: 1

Prerequisites: Access 2000: Basic, Intermediate, and Advanced

Unit 1 : Designing an application

Topic A: 0 Examining an application

A-1: Examining the components of an application

Topic B: 0 Planning an application

B-1: Identifying the objectives of an application

B-2: Resolving design issues in an application

B-3: Planning application objects

Unit 2 : Automating forms

Topic A: 0 Working with dialog boxes

A-1: Examining the properties of a dialog box

A-2: Examining the properties of controls on a dialog box

Topic B: 0 Working with macro groups

B-1: Examining a macro group

B-2: Creating a macro group

B-3: Attaching a macro group to command buttons

Topic C: 0 Automating navigation across forms

C-1: Discussing VBA

C-2: Examining the VBE window

C-3: Examining a command button code

C-4: Programming a button on a form to open another form

C-5: Disabling and enabling command buttons

Unit 3 : Working with Switchboard and Splash Screen forms

Topic A: 0 Working with Switchboard forms

A-1: Creating a Switchboard form by using the Switchboard Manager

A-2: Testing Switchboard objects

A-3: Modifying a Switchboard form

Topic B: 0 Working with Splash Screen forms

B-1: Observing a Splash Screen form

B-2: Creating a Splash Screen form

B-3: Setting label properties

B-4: Setting the properties of a Splash Screen form

Topic C: 0 Automating Splash Screen forms

C-1: Displaying the Splash Screen form on database startup

C-2: Displaying the Splash Screen form for a specified time

C-3: Opening a Switchboard form automatically after the Splash Screen form

Unit 4 : Creating custom toolbars and menu bars

Topic A: 0 Working with toolbars

A-1: Creating a macro group to show or hide a toolbar

A-2: Replacing the built-in toolbar with a custom toolbar

A-3: Adding buttons to a custom toolbar

Topic B: 0 Creating custom and shortcut menus

B-1: Examining a custom menu bar

B-2: Creating a custom menu bar

B-3: Adding commands to a custom menu bar

B-4: Creating a custom shortcut menu

B-5: Setting startup properties for toolbars, menus, and Access Special Keys

Unit 5 : Working with VBA code

Topic A: 0 Visual Basic for Applications programming elements

A-1: Discussing data types

A-2: Using variables and constants

Topic B: 0 Working with modules

B-1: Examining the Code window

B-2: Examining a VBA code

Topic C: 0 Creating procedures

C-1: Creating a Sub procedure in a standard module

C-2: Calling a Sub procedure

C-3: Creating a Function procedure in a standard module

C-4: Calling a Function procedure

Unit 6 : Advanced VBA programming

Topic A: 0 Using control structures

A-1: Using the IF…Then statement

A-2: Using the IF…Then…Else statement

A-3: Using the IF…Then…ElseIf statement

A-4: Using the For…Next loop

A-5: Using the Do While… loop

Topic B: 0 Handling events

B-1: Assigning event handling code to a text box

B-2: Assigning event handling code to a combo box

B-3: Assigning event handling code to coordinate events across two forms

B-4: Assigning the Unload event procedure for a form

Topic C: 0 Resolving errors

C-1: Adding error-handling code

C-2: Testing an error-handling code

Topic D: 0 Displaying a Web site

D-1: Adding a Web browser control to a form

D-2: Displaying a Web site on the form

Unit 7 : Managing databases

Topic A: 0 Working with database utilities to optimize resources

A-1: Converting the database to a prior version

A-2: Analyzing performance

A-3: Splitting a database

A-4: Compacting and repairing a database

Topic B: 0 Securing data by database replication

B-1: Replicating a database

B-2: Synchronizing replicated databases

Topic C: 0 Encrypting and decrypting databases

C-1: Encrypting a database

C-2: Decrypting a database