Access 2007 - Intermediate

3 Hours, 21 Minutes
Delivery Method
LearnNow On Demand

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.


Purchase This On Demand Title or a LearnNow On Demand subscription

Access 2007 - Intermediate
  Buy Now $39.99 Purchase this course for 12 months.
  Buy Now $99.95 Purchase this course and hundreds of others with our LearnNow On Demand 12-month subscription.

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


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