MS Access 2002 / 2003 Intermediate Course Outline

COURSE INFORMATION

Duration: One Day: 9am - 4:30pm
Price: $390
Book: Enquire or make a course booking

TARGET AUDIENCE & PURPOSE

This Intermediate Access Course is for people who can already create simple databases, and want a Forms-driven database with basic automation.

OBJECTIVES

By the end of this course participants should be able to:

  • Export data from Access to other applications
  • Set table field properties
  • Design advanced queries and action queries
  • Use charts in Access
  • Create subforms and subreports
  • Use hyperlinks in Access
  • Create and use a switchboard

PREREQUISITES

Participants should be competent users of Access and should already be able to:

  • Create a database
  • Define the fields and properties for a table
  • Create simple calculation and select queries
  • Link tables using queries
  • Create table relationships
  • Create forms and modify the appearance of forms
  • Perform calculations in forms
  • Create and modify reports

COURSE CONTENT

Exporting Data to Excel & Word
Exporting Data to an Excel Workbook, Dragging & Dropping Data into Excel,
Creating Excel Workbooks – Office Links,
Creating Word Documents – Office Links

Using Advanced Database Features
Printing a Relationship Document, Linking Data to an Access Table, Importing Data, Setting a Database Password, Compacting a Database, Backing Up a Database, Using Advanced Database Features

Using Subforms/Subreports
Working with Subforms / Subreports, Creating a Subform/Subreport, Editing the Layout of a Subform, Displaying a Subform in Datasheet View, Adding a Subform Header / Footer, Displaying a Subform Total

Using Switchboards
Opening & Using a Switchboard, Creating a Switchboard Form, Adding a Command Button to a Switchboard, Setting Startup Option

Using Other Form Techniques
Viewing the Properties of an Object, Changing a Control Property, Adding a Logic Control, Adding a Command Button, Saving a Form as a Report, Creating a Form Letter		 Using ActiveX Controls
Working with ActiveX Controls, Registering an ActiveX Control, Adding an ActiveX Control, Attaching an ActiveX Control,
Using ActiveX Controls

Using Charts
Creating a Chart, Adding a Chart to a Form or Report, Activating Microsoft Graph to Edit, Changing the Chart Type, Changing the Chart Title, Formatting the Chart Title, Adding Data Labels to a Chart

Creating Macros (Time Permitting)
Working with Macros, Opening the Macro Design Window, Creating a Macro, Assigning an Argument to an Action, Saving a Macro, Using Single Step Mode for Testing, Running a Macro, Editing an Existing Macro, Running a Macro using the Tools Menu, Creating a Macro using the Macro Builder

Using Macros (Time Permitting)
Using Properties, Assigning a Macro to a Control, Creating a Command Button, Adding a Condition to a Macro, Creating a Group Macro, Creating an Autoexec Macro

 

Access 02 / 03 Inter.

Course Inclusions