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


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

Northgate

"Excellent. The right pace, the right style- great overall!"

Goldsmiths University of London

"I just wanted to let you know that I've managed to replicate the steps you showed me in FileMaker on my organisation's database and have managed to get my invoicing layouts to work perfectly. Thank you very much! I've also been able to use some of the other things you showed me to good effect too so the course has already helped enormously. Just thought you should know :-)"

Julian Support



 

 

© Transmedia . 277 Greenwich High Road London SE10 8NB  UK . 0208 269 4260
Designed by Transmedia's Web Team