Microsoft Access – Level 3
Course Outline

DURATION 1 Day
PREREQUISITES Must have attended Access Level 1-2, or be confident with what tables, queries, forms and reports are, as well as create each object manually.
DESCRIPTION This course covers advanced features of Access including Table Relationships, Advanced Forms, Pivoting data, and an introduction to SQL (Structured Query Language).
COURSE DATES Special: Four Days of MS Office training for the price of Three!

Click here to request an alternate date
Or call us on 020 313 73958 from 8:00 to 22:00 Monday to Sunday.
Evening Wed, 29-Feb-12 and Thu, 1-Mar-12 18:30 - 21:30 £200.00 +VAT
Weekday Thu, 8-Mar-12 09:30 - 16:30 £180.00 +VAT
Weekend Sat, 31-Mar-12 10:00 - 16:30 £200.00 +VAT
Weekday Wed, 11-Apr-12 09:30 - 16:30 £200.00 +VAT
Evening Mon, 30-Apr-12 and Tue, 1-May-12 18:30 - 21:30 £200.00 +VAT
Weekday Thu, 3-May-12 09:30 - 16:30 £200.00 +VAT
Evening Wed, 30-May-12 and Thu, 31-May-12 18:30 - 21:30 £200.00 +VAT
Weekday Tue, 5-Jun-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 30-Jun-12 10:00 - 16:30 £200.00 +VAT
Weekday Wed, 4-Jul-12 09:30 - 16:30 £200.00 +VAT
Evening Mon, 30-Jul-12 and Tue, 31-Jul-12 18:30 - 21:30 £200.00 +VAT
Weekday Fri, 3-Aug-12 09:30 - 16:30 £200.00 +VAT
Evening Wed, 29-Aug-12 and Thu, 30-Aug-12 18:30 - 21:30 £200.00 +VAT
Weekday Thu, 13-Sep-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 29-Sep-12 10:00 - 16:30 £200.00 +VAT
Weekday Wed, 3-Oct-12 09:30 - 16:30 £200.00 +VAT
Evening Mon, 29-Oct-12 and Tue, 30-Oct-12 18:30 - 21:30 £200.00 +VAT
Weekend Sat, 3-Nov-12 10:00 - 16:30 £200.00 +VAT
Weekday Mon, 5-Nov-12 09:30 - 16:30 £200.00 +VAT
Weekday Wed, 5-Dec-12 09:30 - 16:30 £200.00 +VAT
Weekend Sat, 29-Dec-12 10:00 - 16:30 £200.00 +VAT
Any One-to-One Tuition
Any Date - Fully Customisable		 09:30 - 16:30 £375.00 +VAT

Alternatively, use our BOOKINGS FORM for an alternative payment method, or for multiple dates/courses.

 

 

 

ADVANCED DATA MANAGEMENT

  • Referential Integrity

    • Using the Relationships View and Tab

    • 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 Tab

    • Using the Switchboard Manager

    • Creating a Switchboard

    • Editing a Switchboard

    • Deleting a Switchboard

      •  

  • Modal Dialog Boxes

    • Creating a Modal Dialog Box

    • Adding Controls

    • Setting Properties

    • Formatting your Dialog 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

  • 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

 

 


Home | Contact | Terms and Conditions