Committed to Shaping the Next Generation of IT Experts.

1
Exploring Microsoft Access 2003
Chapter 4- Proficiency Robert Grauer and Maryann
Barber
Committed to Shaping the Next Generation of
IT Experts.
2
Agenda

• Import data
• Multiple-table select query
• Totals query
• Pivot table and chart
• User interface

3
External Data

• Get External Data command
• Export command

4
Multiple-Table Queries

• One-to-many relationship
• Primary key
• Foreign key
• Referential integrity

5
Total Query

• Summary functions
• Total row
• Group By
• Count function
• Sum function

6
Pivot Table and Pivot Chart

• Pivot table summary stats for the records
  according to parameters
• Pivot chart summary information in graphical form

7
The User Interface

• Switchboard
• Switchboard Manager
• Switchboard Items table

8
Points to Remember

• Import data
• Multiple-table select query
• Totals query
• Pivot table and chart
• User interface

9
Assignment

• Practice exercises 4 and 6