Access Advanced

Days 1    Code AC132   Fee £195

This course introduces students to the more advanced features in Access.

Course Details

This course introduces students to the more advanced features in Access. Tasks include using charts, sub-forms, other form and Report techniques. Students will also learn how to work with indexes, create macros and customise the Access navigation pane. Finally student will learn how to create a switchboard in order the database users can navigate around the different forms, tables and reports.

Prerequisites

Students should have the following prerequisite knowledge prior to attending this course:

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

Examination

  • There is currently no examination associated with this course

Course Outline

Lesson 1: Using Charts

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

Lesson 2: Using Subforms/Subreports

  • Creating a Subform/Subreport
  • Editing the Layout of a Subform
  • Displaying a Subform in Datasheet View
  • Creating Navigation Forms
  • Creating a Tab Hierarchy

Lesson 3: Working with Indexes

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

Lesson 4: Using Access and the Internet

  • Creating a Hyperlink Field
  • Inserting a Hyperlink Field

Lesson 5: Using Access Database Security

  • Encrypting/Decrypting a Database
  • Assigning a Database Password
  • Removing a Database Password

Lesson 6: 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

Lesson 7: Using Macros

  • Creating Embeded Macros
  • Assigning a Macro to a Control
  • Creating a Command Button
  • If Then Else Statements
  • Using Macros in a Table
  • Creating and Using Submacros

Lesson 8: Customising the Navigation Pane

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

Lesson 9: Exporting Data

  • Exporting Data to an Excel Workbook
  • Saving Export Steps
  • Dragging and Dropping

Lesson 10: Using Switchboards

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

Request a Call Back

WebAccess Advanced