Access Advanced

Days 1    Code AC132

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

Fee £195

WebAccess Advanced