Access 2007 Advanced

This course has been superseded

We suggest the following instead:
Access 365 - Part 2

Course Description

Your training in and use of Microsoft® Office Access™ 2007 has provided you with a solid foundation in the basic and intermediate skills for working in Microsoft® Office Access™ 2007. You have worked with the various Access objects, such as tables, queries, forms, and reports. In this course, you will extend your knowledge into some of the more specialized and advanced capabilities of Access by structuring existing data, writing advanced queries, working with macros, enhancing forms and reports, and maintaining a database.
1 Day
Contact us for pricing
 

Prerequisites

To ensure the successful completion of the Advanced course, the completion of the Intermediate course or equivalent knowledge is recommended.

Referential Integrity

Using the Relationships View and Ribbon
Types of Relationships
Establishing Referential Integrity
Enforcing Referential Integrity
Testing Referential Integrity

Table Relationships

About Join Lines
Normalizing Tables
Using Cascade Delete and Cascade Update
Setting Fields for Indexing
Using the Index

Switchboards

Using a Switchboard vs. Using the Navigation Pane and Ribbon
Using the Switchboard Manager
Creating a Switchboard
Editing a Switchboard
Deleting a Switchboard

Modal Dialogue Boxes

Creating a Modal Dialogue Box
Adding Controls
Setting Properties
Formatting your Dialogue Box

Using Subforms

Creating a Subform
Modifying a Subform
Working with a Subform
Synchronizing Subform Data with a Main Form
Displaying a Subform within a Main Form

Advanced Form Tasks

Limiting User Access to a Form
Creating Check Boxes and Command Buttons
Creating Event Procedures
Customizing Error Messages

Exporting Your Form

Sending a Form via E-Mail
Managing Replies
Exporting your Form to XML

Using Outlook and SharePoint with Access

Creating an RSS Feed for Outlook
Importing Contacts from Outlook
Importing Contacts from a SharePoint Server
Moving your Database to a SharePoint Server
Publishing to a Web Server

Creating a PivotTable

About PivotTables
Creating a PivotTable
More about PivotTable Fields
Completing your PivotTable

Creating a PivotChart

About PivotCharts
Creating a PivotChart
More about PivotChart Fields
Completing Your PivotChart

Using PivotTables and PivotCharts

Using a PivotTable
Using a PivotChart
Editing a PivotTable or a PivotChart
Common PivotTable and PivotChart Editing Commands
Creating a PivotTable and PivotChart from the Same Object

Access and Windows

Recovering Access
Starting Access on Windows Boot
Using Office Diagnostics
Checking for Updates

Using the Access Viewer

What is the Access Viewer?
Downloading the Viewer
Using the Viewer

An Introduction to SQL

What is SQL?
Parts of an SQL Statement
SQL Keywords
Adding Where Clauses
Microsoft Access