Microsoft Access 2007 - Level 3

Progressive Training & Development

Short course

In Southwark

Price on request

The best Access courses

See all

See all

Description

  • Type

    Short course

  • Location

    Southwark

  • Duration

    1 Day

This course covers advanced features of Access including Table Relationships, Advanced Forms, Pivoting data, and an introduction to SQL (Structured Query Language).

Facilities

Location

Start date

Southwark (London)
See map
202 Blackfriars Road, SE1 8NJ

Start date

On request

About this course

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.

Questions & Answers

Add your question

Our advisors and other users will be able to reply to you

Who would you like to address this question to?

Fill in your details to get a reply

We will only publish your name and question

Reviews

Subjects

  • Microsoft Access

Course programme

DESCRIPTION
This course covers advanced features of Access including Table Relationships, Advanced Forms, Pivoting data, and an introduction to SQL (Structured Query Language).

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.


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

See related categories

Microsoft Access 2007 - Level 3

Price on request

The best Access courses

See all

See all