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

Course details
Fee £115
Days 1
Code AC3

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 Advanced

The Access 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

  • This course helps prepare delegates for the ECDL Module 5 - Databases examination and the Microsoft Office Specialist Access Expert examination

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 ActiveX Controls

  • Working with ActiveX Controls
  • Registering an ActiveX Control
  • Adding an ActiveX Control

Module 5 - Working with Indexes

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

Module 6 - Replicating Databases

  • Replicating a Database
  • Synchronizing Database Replicas
  • Resolving Replication Conflicts

Module 7 - 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 8 - Using Access Database Security

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

Module 9 - 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 10 - Using Macros

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

Module 11 - Using Switchboards

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

Module 12 - Creating Custom Toolbars

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

Module 13 - Exporting Data to Excel and Word

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