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 |