This course is not currently offered by Global Knowledge. Information here is provided for reference only.

In this course, students will learn to use charts and cover topics such as sub forms or subreports, form techniques, PivotTables and PivotCharts, indexes, and hyperlinks. Students will also investigate applying database security, creating macros, customizing the navigation pane, collecting data by e-mail, and exporting data.

For this course, training is performed on student's equipment. We provide the software and data files for the training.

What You'll Learn

• Use Charts
• Use Subforms/Subreports
• Use Other Form Techniques
• Use PivotTables and PivotCharts
• Work with Indexes
• Use Access and the Internet
• Use Access Database Security
• Create Macros
• Use Macros
• Customize the Navigation Pane
• Collect Data By E-mail
• Export Data

Who Needs to Attend

Business users who have taken Access 2007 - Level 2 (Course 6614) or have equivalent knowledge

Prerequisites

Access 2007 - Level 2 (Course 6614) or equivalent knowledge

Follow-On Courses

There are no follow-ons for this course.

Course Outline

1. Using Charts

• Working with Charts
• Adding a Chart to a Form or Report
• Using Microsoft Graph to Edit
• Changing the Chart Type
• Changing the Chart Title
• Formatting the Chart Title
• Adding Data Labels to a Chart

2. Using Subforms/Subreports

• Working with Subforms/Subreports
• Creating a Subform/Subreport
• Editing the Layout of a Subform
• Displaying a Subform in Datasheet View
• Displaying a Subform/Subreport Total

3. Using Other Form Techniques

• Creating a Split Form
• Converting an Existing Form to a Split Form
• Editing a Split Form
• Adding a Command Button
• Saving a Form as a Report

4. Using PivotTables and PivotCharts

• Creating a PivotTable View
• Creating a PivotChart View

5. Working with Indexes

• Viewing Indexes
• Creating a Single Field Index
• Creating a Multiple Field Index
• Deleting an Index
• Creating a Multiple Field Primary Key

6. Using Access and the Internet

• Working with Hyperlinks
• Creating a Hyperlink Field
• Inserting a Hyperlink Field
• Editing a Hyperlink Field
• Deleting a Hyperlink Field

7. Using Access Database Security

• Encrypting a Database with a Password
• Opening and Decrypting a Database
• Removing a Database Password

8. Creating Macros

• Working with Macros
• Opening the Macro Tools Window
• Creating a Macro
• Assigning an Argument to an Action
• Displaying Macro Design Arguments
• Saving a Macro
• Using Single Step Mode for Testing
• Running a Macro
• Editing an Existing Macro

9. Using Macros

• Using Properties
• Creating Embedded Macros
• Assigning a Macro to a Control
• Creating a Command Button
• Adding a Condition to a Macro
• Creating a Group Macro
• Creating an Autoexec Macro

10. Customizing the Navigation Pane

• Creating Custom Categories
• Creating Custom Groups
• Adding Database Objects to a Group
• Showing/Hiding the Unassigned Objects Group
• Deleting Objects from a Group

11. Collecting Data By E-mail

• Understanding When to Use Data Collection
• Using the Collect Data By E-mail Messages Wizard
• Setting Data Collection by E-mail Options
• Manually Processing Replies

12. Exporting Data

• Exporting Data to an Excel Workbook
• Saving Export Setup
• Dragging and Dropping Data into Excel
• Creating Word Mail Merge Documents