Access Chapter 04

Access Chapter 04 - MS Access Chapter 4 Chapter 4...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
MS Access Chapter 4 Carlotta Eaton Committed to Shaping the Next Generation of IT Experts. Chapter 4 Proficiency: Relational Databases, Pivot Charts, and the Switchboard Exploring Office 2003 - Grauer and Barber 2 Objectives z Import data from Excel into Access database z Create a one-to-many relationship z Create a report containing a relationships diagram z Use the Get External Data command z Create and modify a multiple-table select query z Create a totals query z Use Microsoft Graph to create a chart based on a table or query z Create and modify a switchboard z Compact and repair a database Exploring Office 2003 - Grauer and Barber 3 Case Study: Attorneys for Athletes z Students create a database that includes: z Three Tables: offices, attorneys, and athletes z Two one-to-many relationships z A switchboard Exploring Office 2003 - Grauer and Barber 4 Get External Data z Get External Data command z Export command z Import Spreadsheet Wizard z Import Text Wizard z Importing versus linking
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
MS Access Chapter 4 Carlotta Eaton Exploring Office 2003 - Grauer and Barber 5 Multiple-Table Queries z One-to-many relationship z Primary key z Foreign key z Referential integrity Exploring Office 2003 - Grauer and Barber
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 7

Access Chapter 04 - MS Access Chapter 4 Chapter 4...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online