Course Search:
Request more details:


Print Page

Access 2007 Advanced

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.
  • Cost: Price on application
  • Duration: 1 Day
  • This course is not available as part of our public schedule but can be provided on a customised client specific basis.
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


Dublin: 01 6627700 - Cork: 021 4319010 - Limerick: 061 311982

© Professional Training Solutions Limited 1996-2012
CRO No. 252390 - Unit 22, Westland Square, Pearse Street, Dublin 2, Ireland.