Intermediate Microsoft Access

Duration: 1 Day

Objectives

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.

Pre-requisites

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


"I thought the course and the location were perfect."

MOD

"Very thorough course and enthusiastic trainer who was very helpful and responsive to individual needs."

NVIDIA

"The course was perfect. Great course, great trainer!"

Northgate



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