1 / 9

Mastering Access: Relational Databases & Visualizations

Learn to import, query, & visualize data in Access. Explore relationships, totals, pivot tables, & switchboards in this comprehensive guide. Practice assignments included.

sritzman
Download Presentation

Mastering Access: Relational Databases & Visualizations

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