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