Access 2007 - Intermediate

Course Overview

This course builds on the skills and concepts taught in Access 2007: Introduction. Students will learn how to normalize data; work with Lookup fields and subdatasheets; create join queries; add objects to forms, print reports and labels; create charts; and use PivotTables and PivotCharts. Designated as Approved Courseware for the Microsoft Certified Application Specialist program, this course will help students prepare for the Access 2007 exam (77-605). For comprehensive certification training, students should complete Access 2007: Introduction, Intermediate, and Advanced.

Course Objectives

Relational Database Concept Overview, Table Design, Calculations, Multi-Table Queries, Action Queries, Parameter Queries, Calculations in Forms, Advanced Form Functions, Advanced Report Functions

Course Outline

1 - Introduction

  • Introduction

2 - Relational Database Concept Overview

  • Understanding Relationships
  • Enforcing Referential Integrity
  • Modifying and Deleting Relationships

3 - Table Design

  • Understanding Field Components
  • Accessing Field Properties
  • Using Text-Based Field Types
  • Using Numeric Field Types
  • Using Other Field Types
  • Setting Formats
  • Setting Input Masks
  • Adding Captions
  • Setting Default Values
  • Setting Validation Rules
  • Working with Required Property
  • Working with Indexed Property
  • Working with Unicode Compression Property

4 - Calculations

  • Performing Calculations with Queries
  • Concatenating Text
  • Calculating Totals in a Query

5 - Multi-Table Queries

  • Understanding Multi-Table Queries
  • Creating a Multi-Table Query
  • Grouping and Counting Totals
  • Referencing Calculated Fields in Another Query
  • Fixing WHERE Clause Errors
  • Calculating the Top Five Customers

6 - Action Queries

  • Understanding Action Queries
  • Using Make Table and Append Queries
  • Using Update Queries
  • Using Delete Queries

7 - Parameter Queries

  • Understanding Parameter Queries
  • Using a Simple Parameter Query
  • Using Parameter Queries with Wildcards
  • Finding Date Ranges
  • Creating Multi-Parm Queries

8 - Calculations in Forms

  • Understanding Forms
  • Understanding The Hidden Table
  • Resizing Controls
  • Performing Calculations with Bound Text Boxes
  • Setting Control Properties

9 - Advanced Form Functions

  • Creating a Combo Box
  • Creating a Calculated Control
  • Adding Label and Formatting Control

10 - Advanced Report Functions

  • Using the Report Wizard
  • Using a Calculated Control to Concatenate Text
  • Creating Other Calculated Controls
  • Making the Control Source a Parameter Query
  • Using Report Bands
  • Using the GroupSort Panel

11 - Conclusion

  • Course Recap

3 Hours, 21 Minutes

$39.99 Purchase this course for 12 months.
$99.00 Purchase this course and hundreds of others with our LearnNow On Demand 12-month subscription.