1 / 9

Chapter 4

Chapter 4. Relational Database, Pivot Charts, and Switchboard. Agenda. Import data Multiple-table select query Totals query Pivot table and chart User interface. External Data. Get External Data command Export command. Multiple-Table Queries. One-to-many relationship Primary key

sritzman
Télécharger la présentation

Chapter 4

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  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

More Related