Course Outline

Microsoft Access 2003 - Level 3
Now the fun begins as you learn to architect relational databases in Access. No longer is a query just a query or a table just a table – they are transformed by the relationships you will create. You will learn to build queries based on other queries and define permanent relationships between tables to access a wide range of data. Define action queries and crosstab queries to make summary data easier to read. 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 8/16/2011
Return to Class Schedules             Computer Magic Training Home Page
Computer Magic Training • 4030 Moorpark Avenue • Suite 108 • San Jose, California 95117 • 408-261-2600