Computer Training

Access - Advanced

Course Prerequisites

  • Required: Solid understanding of all Access Introduction & Intermediate topics.

SECTION 1: Customizing Access

Lesson 1.1: Customizing Menus And Toolbars

  • Customizing Menus
  • Creating Menus
  • Showing And Hiding Toolbars
  • Customizing Toolbars
  • Creating Toolbars
  • Practice Exercise

Lesson 1.2: Setting Access Options, Part 1

  • Setting General And View Options
  • Setting Keyboard And Editing Options
  • Setting Datasheet, Form, And Report Options
  • Setting Page And Tables/Queries Options
  • Setting Error Checking Options
  • Setting Advanced Options
  • Practice Exercise

Lesson 1.3: Setting Access Options, Part 2

  • Setting International Options
  • Setting Spelling Options
  • Setting AutoCorrect Options
  • Setting Start-Up Options
  • Setting Macro Security Options
  • Practice Exercise

Lesson 1.4: Creating Macros

  • Using The Macro Design Toolbar
  • Creating A Macro
  • Running A Macro
  • About Macro Groups
  • Practice Exercise

Lesson 1.5: Advanced Macro Uses

  • Editing A Macro With The Visual Basic Editor
  • Assigning A Macro To A Keystroke
  • Assigning A Macro To A Toolbar
  • Viewing And Printing Macro Definitions
  • Practice Exercise

Section 1: Review Questions

back to top

SECTION 2: Advanced Data Tools

Lesson 2.1: Switchboards

  • Using A Switchboard
  • Using The Switchboard Manager
  • Creating A Switchboard
  • Editing a Switchboard
  • Deleting A Switchboard
  • Practice Exercise

Lesson 2.2: Creating Data Access Pages

  • Using The Data Access Page Wizard
  • Using Design View To Create A Data Access Page
  • Using An Existing HTML Page
  • Practice Exercise

Lesson 2.3: Modifying Data Access Pages

  • Adding A Theme
  • Adding Text And Controls
  • Formatting Text And Controls
  • Aligning And Sizing Content
  • Adding Images
  • Practice Exercise

Lesson 2.4: Using Data Access Pages

  • Basics Of Using Data Access Pages
  • Viewing Data Entered Via a Data Access Page
  • Protecting Data
  • Practice Exercise

Section 2: Review Questions

back to top

SECTION 3: Advanced Queries

Lesson 3.1: Table Relationships

  • Normalizing Relationships
  • Establishing Referential Integrity
  • Using Cascade Delete and Cascade Update
  • Setting Fields For Indexing
  • Using The Index
  • Practice Exercise

Lesson 3.2: Using CrossTab Queries

  • Understanding CrossTab Queries
  • Creating A CrossTab Query With The Wizard
  • Creating A CrossTab Query Manually
  • Practice Exercise

Lesson 3.3: Using Parameter Queries

  • Setting Up Parameter Queries
  • Using a Parameter Query
  • Practice Exercise

Lesson 3.4: Advanced Reporting Features

  • Using AutoFormat
  • Aligning And Formatting Controls
  • Adding Pictures And Lines
  • Practice Exercise

Section 3: Review Questions

back to top

SECTION 4: PivotTables and PivotCharts

Lesson 4.1: Creating A Pivot Table

  • Creating a PivotTable Using the Wizard
  • Continuing Where the Wizard Left Off
  • More About Fields
  • Completing Your PivotTable
  • Practice Exercise

Lesson 4.2: Using AutoForm and Creating PivotCharts

  • Creating a PivotTable Using AutoForm
  • Creating a PivotChart Using AutoForm
  • About PivotChart Fields
  • Completing a PivotChart
  • Practice Exercise

Lesson 4.3: Using PivotTables and PivotCharts

  • Using a PivotTable
  • Using a PivotChart
  • Editing a PivotTable or a PivotChart
  • Common PivotChart Editing Commands
  • Turning a PivotTable Into a PivotChart and Vice-Versa
  • Practice Exercise

Section 4: Review Questions

back to top