RMD Training - Hull

 

RMD Business Access 2007 Advanced Syllabus

 

This course is designed for delegates who have strong experience of using Microsoft Access 2007 and want to learn the advanced features to allow them to work even more efficiently.

 

If the course syllabus does not entirely match your requirements, please contact us as we are able to customise it to your needs.

 

This course has a duration of 1 day.

 

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

     

    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

     

    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

     

     

    •