Relational Database, Pivot Charts, and Switchboard

1
Chapter 4

• Relational Database, Pivot Charts, and Switchboard

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 5 and 6