Access 97 - Day 3

Required Background

Users who have attended our levels 1 and 2 or have equivalent knowledge.

Course Lessons

Using Charts

Creating a chart, adding a chart to a report and data labels to a chart, activating Microsoft Graph to edit, changing the chart type and title, formatting the chart title, editing the chart datasheet

Using Subforms

Working with and creating subforms, editing the layout of a subform, displaying in Datasheet view, adding a form header/footer, displaying a subform total

Using Other Form Techniques

Viewing the properties of an object, changing a control property, adding a logic control and a command button, saving a form as a report, creating a form letter

Using ActiveX Controls

Working with and registering ActiveX controls, adding and attaching an ActiveX control

Working with Indexes

Viewing and deleting indexes, creating a single and multiple field indexes, creating a multiple key field

Replicating Databases

Replicating a database, synchronizing database replicas, resolving replication conflicts

Using Access and the Internet

Working with hyperlinks; creating, inserting, editing, and deleting a hyperlink field; hiding and displaying the Web toolbar; using the Publish to the Web Wizard

 

Creating Macros

Working with macros; creating, running, and saving a macro; opening the macro design window; assigning an argument to an action; using single step mode for testing; editing an existing macro; running a macro - Tools menu

Using Macros

Using properties and the Command Button Wizard; assigning a macro to a control; creating a command button, a group macro, and an Autoexec macro; adding a condition to a macro

Using Switchboards

Opening and using a switchboard, creating a switchboard form, adding a button to a switchboard, setting startup options

Creating Custom Toolbars

Creating a custom toolbar, a custom menu item, and a shortcut menu; adding a built-in menu item, a command to a menu item, custom commands, a separator bar, and buttons to a toolbar; docking a floating toolbar; linking a shortcut menu and a toolbar to a report; changing a button image

 Return to Table of Contents