Access 2000 Day 3

Course Length: One Day

Content

Using Charts

Creating a Chart

Adding a Chart to a Form or Report

Activating Microsoft Graph to Edit

Changing the Chart Type

Changing the Chart Title

Formatting the Chart Title

Adding Data Labels to a Chart

Using Charts

Using Subforms/Subreports

Working with Subforms/Subreports

Creating a Subform/Subreport

Editing the Layout of a Subform

Displaying a Subform in Datasheet View

Adding a Subform Header/Footer

Displaying a Subform Total

Using Subforms/Subreports

Using Other Form Techniques

Viewing the Properties of an Object

Changing a Control Property

Adding a Logic Control

Adding a Command Button

Saving a Form as a Report

Creating a Form Letter

Using Other Form Techniques

Using ActiveX Controls

Working with ActiveX Controls

Registering an ActiveX Control

Adding an ActiveX Control

Attaching an ActiveX Control

Using ActiveX Controls

Working with Indexes

Viewing Indexes

Creating a Single Field Index

Creating a Multiple Field Index

Deleting an Index

Creating a Multiple Field Primary Key

Working with Indexes

Replicating Databases

Replicating a Database

Synchronizing Database Replicas

Resolving Replication Conflicts

Replicating Databases

Using Access and the Internet

Working with Hyperlinks

Creating a Hyperlink Field

Inserting a Hyperlink Field

Editing a Hyperlink Field

Deleting a Hyperlink Field

Hiding/Displaying the Web Toolbar

Creating a Data Access Page

Grouping and Sorting Data Access Pages

Using Access and the Internet

Creating Macros

Working with Macros

Opening the Macro Design Window

Creating a Macro

Assigning an Argument to an Action

Saving a Macro

Using Single Step Mode for Testing

Running a Macro

Editing an Existing Macro

Running a Macro using the Tools Menu

Creating a Macro using the Macro Builder

Creating Macros

Using Macros

Using Properties

Assigning a Macro to a Control

Creating a Command Button

Adding a Condition to a Macro

Creating a Group Macro

Creating an Autoexec Macro

Using Macros

Using Switchboards

Opening and Using a Switchboard

Creating a Switchboard Form

Adding a Command Button to a Switchboard

Setting Startup Options

Using Switchboards

Creating Custom Toolbars

Creating a Custom Toolbar

Adding a Built-in Menu Item

Creating a Custom Menu Item

Adding a Command to a Menu Item

Adding Custom Commands

Docking a Floating Toolbar

Linking a Toolbar to a Report

Adding a Separator Bar

Creating a Shortcut Menu

Linking a Custom Shortcut Menu

Adding Buttons to a Custom Toolbar

Changing a Button Image

Deleting a Custom Toolbar

Creating Custom Toolbars

Exporting Data to Excel and Word

Exporting Data to an Excel Workbook

Dragging and Dropping Data into Excel

Creating Excel Workbooks - Office Links

Creating Word Documents - Office Links

Exporting Data to Excel and Word

Return to Table of Contents