Intermediate Microsoft Access

Duration: 1 Day


This intensive hands-on one-day training course has been designed to provide delegates with a solid understanding of intermediate and more advanced Access tools and concepts in order to increase their knowledge and productivity.


Delegates should have a good working knowledge and understanding of the concepts covered in the Introduction courses.

Course includes

A comprehensive set of reference notes covering course topics, follow-up telephone support and, for training on Transmedia premises, lunch and refreshments.

Course outline

Exporting Data

  • Exporting Data to an Excel Workbook
  • Saving Export Setup
  • Dragging and Dropping Data into Excel
  • Creating Word Mail Merge Documents

Using Advanced Database Features

  • Importing Data
  • Linking Data to an Access Table
  • Using the Linked Table Manager
  • Exporting Data
  • Converting Files
  • Printing a Relationship Document
  • Compacting a Database
  • Using Name AutoCorrect
  • Backing Up a Database

Using Subforms/Subreports

  • Working with Subforms/Subreports
  • Creating a Subform/Subreport
  • Editing the Layout of a Subform
  • Displaying a Subform in Datasheet View
  • Displaying a Subform/Subreports Total

Using Controls and Layouts

  • Switching Views
  • Using Controls
  • Using Control, Stacked and Tubular Layouts
  • Moving and Removing a Control from a Layout
  • Viewing the Properties of an Object
  • Changing a Control Property
  • Manipulating Controls

Using Other Form Techniques

  • Creating a Split Form
  • Converting an Existing Form to a Split Form
  • Editing a Split Form
  • Adding a Command Button
  • Saving a Form as a Report

Using Charts

  • Creating a Chart and Adding it to a Form or Report
  • Activating Microsoft Graph to Edit
  • Changing the Chart Type and Title
  • Formatting the Chart Title and Adding Data Labels to a Chart

Using PivotTables and PivotCharts

  • Creating a PivotTable View
  • Creating a PivotChart View
  • Using Other Form Techniques

Creating Macros

  • Working with Macros
  • Opening the Macro Tools Window
  • Creating a Macro
  • Displaying Macro Design Arguments
  • Assigning an Argument to an Action
  • Saving a Macro
  • Using Single Step Mode for Testing
  • Running a Macro
  • Editing an Existing Macro

Using Macros

  • Using Properties
  • Creating Embedded Macros
  • Assigning a Macro to a Control and Creating a Command Button
  • Adding a Condition to a Macro
  • Creating a Group Macro
  • Creating an Autoexec Macro

Collecting Data by E-mail

  • Data Collection and using the Collect Data By E-mail Messages Wizard
  • Setting Data Collection by E-mail Options
  • Manually Processing Replies

Customising the Navigation Pane

  • Creating Custom Categories
  • Creating Custom Groups
  • Adding Database Objects to a Group
  • Showing/Hiding the Unassigned Objects Group
  • Deleting Objects from a Group

This course is available as a private or customised course. Contact us for further information and to customise this course to your exact requirements:

Phone us: 0208 269 4260Book Now

Related Courses

"Very enjoyable, well-paced tuition, tailored and relevant to my workplace demands."


"Our needs and expectations were surpassed."

FSL Aerospace

"First class - The trainer was extremely knowledgeable and answered all our questions."


© Transmedia . 85 Tottenham Court Road, London, W1T 4TQ  UK . 0208 269 4260       Privacy Policy