Access 2010 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 2010 has provided you with a solid foundation in the basic and intermediate skills for working in Microsoft Office Access 2010. 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.

Advanced Data Management

1.1: Referential Integrity
• Using the Relationships View and Tab
• Types of Relationships
• Establishing Referential Integrity
• Enforcing Referential Integrity
• Testing Referential Integrity
1.2: Table Relationships
• About Join Lines
• Normalizing Tables
• Using Cascade Delete and Cascade Update
• Setting Fields for Indexing
• Using the Index
Lesson 1.3: Switchboards
• Using a Switchboard vs. Using the Navigation Pane and Tab
• Using the Switchboard Manager
• Creating a Switchboard
• Editing a Switchboard
• Deleting a Switchboard
Lesson 1.4: Modal Dialog Boxes
• Creating a Modal Dialog Box
• Adding Controls
• Setting Properties
• Formatting your Dialog Box

Advanced Form Tasks

2.1: 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
2.2: Advanced Form Tasks
• Limiting User Access to a Form
• Creating Check Boxes and Command Buttons
• Creating Event Procedures
• Customizing Error Messages
2.3: Exporting Your Form
• Sending a Form via E-Mail
• Managing Replies
• Exporting your Form to XML
2.4: 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

3.1: Creating a PivotTable
• About PivotTables
• Creating a PivotTable
• More about PivotTable Fields
• Completing your PivotTable
3.2: Creating a PivotChart
• About PivotCharts
• Creating a PivotChart
• More about PivotChart Fields
• Completing Your PivotChart
3.3: 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

4.1: Access and Windows
• Recovering Access
• Starting Access on Windows Boot
• Using Office Diagnostics
• Checking for Updates
4.2: Using the Access Viewer
• What is the Access Viewer?
• Downloading the Viewer
• Using the Viewer
4.3: An Introduction to SQL
• What is SQL?
• Parts of an SQL Statement
• SQL Keywords
• Adding Where Clauses
Access 2010Microsoft Access