Computer Training

Access - Intermediate

Course Prerequisites

  • Required: Solid understanding of all Access Introduction topics.

SECTION 1: Advanced File Tasks

Lesson 1.1: Using My Computer Within Access

  • Navigating With My Computer
  • Performing Basic Tasks With My Computer
  • Changing Views With My Computer
  • Using The My Places Toolbar
  • Practice Exercise

Lesson 1.2: Database Management

  • Repairing A Database
  • Compacting A Database
  • Backing Up Your Database
  • Editing Database Properties
  • Practice Exercise

Lesson 1.3: Saving Your Files

  • Using The Save As Dialog
  • Using Object Properties
  • Using Auto Recover
  • Practice Exercise

Lesson 1.4: Exporting Files

  • Exporting To Word
  • Exporting To Excel
  • Exporting To Older Versions Of Access
  • Exporting Vs. Save As
  • Practice Exercise

Lesson 1.5: Linking Files

  • Linking To An Excel Spreadsheet
  • Linking To Another Database
  • Creating A Hyperlink
  • Inserting An OLE Object
  • Practice Exercise

Section 1: Review Questions

back to top

SECTION 2: Working With Tables

Lesson 2.1: Customizing Tables

  • Understanding Field Properties
  • Adding A Primary Key To A Table
  • Indexing A Field
  • Inserting, Deleting And Moving Fields
  • Importing A Table From Another Source
  • Practice Exercise

Lesson 2.2: Formatting Tables

  • Formatting Text Fields
  • Adding Field Descriptions
  • Changing Field Data Types
  • Adding Captions
  • Practice Exercise

Lesson 2.3: Controlling Table Data Entry

  • Setting A Default Value
  • Setting A Required Value
  • Creating And Using Input Masks
  • Creating And Removing Table Relationships
  • Practice Exercise

Lesson 2.4: Managing Table Data Entry

  • How To Validate Data
  • Creating A Lookup Field
  • Modifying A Lookup Field
  • Creating A Value List
  • Modifying A Value List
  • Practice Exercise

Section 2: Review Questions

back to top

SECTION 3: Working With Forms

Lesson 3.1: Basic Form Controls

  • Adding A Control
  • Using The Control Wizard
  • Cutting, Copying, Pasting And Moving A Control
  • Formatting A Control
  • Practice Exercise

Lesson 3.2: Advanced Form Controls

  • Modifying A Control's Properties
  • Changing A Control's Data Source
  • Changing A Control's Default Value
  • Creating A Calculated Control
  • Using Form Properties
  • Practice Exercise

Lesson 3.3: Formatting A Form

  • Formatting Gridlines
  • Modifying The Font
  • Adding Images
  • Using AutoFormat
  • Practice Exercise

Section 3: Review Questions

back to top

SECTION 4: Reports

Lesson 4.1: Organizing Report Data

  • Adding And Removing Fields
  • Using Report Sections
  • Changing Section Properties
  • Grouping And Sorting In A Report
  • Changing Group Properties
  • Using Calculated Controls In A Report
  • Practice Exercise

Lesson 4.2: Formatting Reports

  • Formatting Gridlines
  • Modifying The Font
  • Adjusting The Layout Of Your Report
  • Using AutoFormat
  • Practice Exercise

Lesson 4.3: Common Report Tasks

  • Adding A Photo
  • Adjusting Page Properties
  • Adding Headers And Footers
  • Adding Page Numbers
  • Using The Label Wizard
  • Practice Exercise

Section 4: Review Questions

SECTION 5: Working With Queries

Lesson 5.1: Basic Queries

  • Review Of Queries
  • Creating A Query
  • Sorting A Query
  • Filtering A Query
  • Hiding Fields
  • Using And/Or Operators
  • Using IIF Functions
  • Practice Exercise

Lesson 5.2: Multiple Table Queries

  • Creating A Multiple Table Query
  • Creating A Calculated Field
  • Using The Expression Builder
  • Using Queries To Summarize
  • Using Make-Table Queries
  • Practice Exercise

Lesson 5.3: Management (Action) Queries

  • Append Queries
  • Delete Queries
  • Update Queries
  • Exporting Queries
  • Practice Exercise

Section 5: Review Questions

back to top