e-academy – IT training excellence in Cardiff, Newport, Bristol and South Wales

Course details
Fee £115
Days 1
Code AC073

There are currently no dates scheduled for this course.

However it can still be provided on a closed-company basis – or we may schedule it on demand. Please contact us for further information.

e-mail us
or call us on
0845 650 6500

Access 2007 Advanced

The Access 2007 Advanced training course is available at our Cardiff training centre in Wales, which is also within easy reach of Newport, Bristol and South WalesMicrosoft Certified Gold Partner for Learning Solutions

Overview

This course introduces students to the more advanced features in Access. Tasks include using charts, subforms, other form techniques, and ActiveX controls. Students will also learn how to work with indexes, replicate databases, and use Access and the Internet

Examination information

  • There is currently no examination associated with this course

Prerequisites

Before attending this course, students must have:

  • Attended the MS Access Introduction or a very good working knowledge of the subject

Course outline

Module 1: Using Charts

  • Creating a Chart
  • Adding a Chart to a Form or Report
  • Changing the Chart Type

Module 2: Using Subforms/Subreports

  • Creating a Subform/Subreport
  • Editing the Layout of a Subform
  • Displaying a Subform in Datasheet View

Module 3: Using Other Form Techniques

  • Adding a Command Button
  • Saving a Form as a Report
  • Creating a PivotTable or PivotChart View

Module 4: Using Pivot Tables and Pivot Charts

  • Creating a Pivot Table View
  • Creating a Pivot Chart View

Module 5: Working with Indexes

  • Creating a Single Field Index
  • Creating a Multiple Field Index
  • Creating a Multiple Field Primary Key

Module 6: Using Access and the Internet

  • Creating a Hyperlink Field
  • Inserting a Hyperlink Field
  • Creating a Data Access Page
  • Grouping and Sorting Data Access Pages
  • Creating a PivotTable in a Data Access Page

Module 7: Using Access Database Security

  • Encrypting a Database
  • Assigning a Database Password
  • Removing a Database Password

Module 8: Creating Macros

  • Creating a Macro
  • Assigning an Argument to an Action
  • Saving a Macro
  • Editing an Existing Macro
  • Creating a Macro using the Macro Builder

Module 9: Using Macros

  • Using Properties
  • Assigning a Macro to a Control
  • Creating a Command Button
  • Adding a Condition to a Macro

Module 10: Customising the Navigation Pane

  • Creating Custom Categories
  • Creating Custom Groups
  • Deleting Objects from the Group

Module 11: Collecting Data by Email

  • Using the Wizard
  • Setting collection by Email Options
  • Manually Processing Replies

Module 12: Exporting Data

  • Exporting Data to an Excel Workbook
  • Creating Excel Workbooks Office Links
  • Cresting Word Documents Office Links

Module 13: Using Switchboards

  • Creating a Switchboard Form
  • Adding a Command Button to a Switchboard
  • Setting Startup Options

Module 14: Creating Custom Toolbars

  • Creating a Custom Toolbar
  • Creating a Custom Menu Item
  • Creating a Shortcut Menu
  • Adding Buttons to a Custom Toolbar