Access 2010 Advanced

Request more details:

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.
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