Home | Training Classes | Consulting | Hosted Solutions | FAQ | Contact     

 

Home

Training Classes

  > Word

  > Excel

  > Access 

  > PowerPoint

  > Visio 

  > MS Project

  > Crystal Reports 

  > ACT!

  > Other Classes 

Consulting

Hosted Solutions

FAQ

Contact

 

 

 

ACT! Consultants

High Trust for ACT

 

 

 

Access 2007: Level 3 - Syllabus  
Advanced Data Management
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

Advanced Form Tasks
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

Pivoting Data
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