Course Outline

Microsoft Access 2003 - Level 3
Create relationships and learn join types. Design totals and cross tab queries. Create update, append, delete and make table queries. Learn advanced queries that compare criteria between tables. Create outer join, multiple join, no join queries. 6 hours
Setting up Relationships 
  • Multiple source queries 
  • What are relationships? 
  • Referential integrity 
  • Cascading updates and deletes 
  • Join types 

Totals Queries 

  • What are statistical calculations? 
  • Using statistical calculations while grouping 
  • Excluding rows before grouping 
  • Excluding results of grouping 
  • Top values 
  • Creating expressions while grouping 
  • Displaying the detail data of a totals query 

Crosstab Queries 

  • What is a crosstab query? 
  • Column or row heading with expression 
  • Multiple row headings 
  • Adding row totals 
  • Excluding rows before crosstabbing 
  • Fixed column headings 
  • Sorting and criteria in expressions 
Action Queries 
  • Update query 
  • Append query 
  • Make table query 
  • Delete query 

Advanced Queries 

  • Using grouped totals queries as a source 
  • Criteria compared to fields 
  • Multiple join 
  • No join or cross product 

PivotTables / PivotCharts (optional)

  • Creating a PivotTable / PivotChart
  • Elements of a PivotTable / PivotChart
  • Modifying a PivotTable / PivotChart
  • Grouping and Sorting PivotTable fields
  • Customizing the Layout
Prerequisites:  Access Level 2 or equivalent experience.
Revised 7/7/08
Return to Class Schedules             Computer Magic Training Home Page
Computer Magic Training • 4030 Moorpark Avenue • Suite 108 • San Jose, California 95117 • 408-261-2600