acc_04 - Exploring Microsoft Access 2003 Chapter 4-...

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

View Full Document Right Arrow Icon
Exploring Office 2003 - Grauer and Barber 1 Committed to Shaping the Next Generation of IT Experts. Chapter 4- Proficiency: Relational Databases, Pivot Charts, and the Switchboard Robert Grauer and Maryann Barber Modified by A. Clark (USA) Exploring Microsoft Access 2003
Background image of page 1

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

View Full DocumentRight Arrow Icon
Exploring Office 2003 - Grauer and Barber 2 Objectives Import data from Excel into Access database Create a one-to-many relationship Create a report containing a relationships diagram Use the Get External Data command Create and modify a multiple-table select query
Background image of page 2
Exploring Office 2003 - Grauer and Barber 3 Objectives (continued) Create a totals query Compact and repair a database
Background image of page 3

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

View Full DocumentRight Arrow Icon
Exploring Office 2003 - Grauer and Barber 4 Get External Data Get External Data command Export command Import Spreadsheet Wizard Import Text Wizard Importing versus linking
Background image of page 4
Exploring Office 2003 - Grauer and Barber 5 Multiple-Table Queries One-to-many relationship Primary key Foreign key Referential integrity
Background image of page 5

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

View Full DocumentRight Arrow Icon
Image of page 6
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 02/10/2012 for the course CIS 250 taught by Professor Wright during the Summer '09 term at S. Alabama.

Page1 / 16

acc_04 - Exploring Microsoft Access 2003 Chapter 4-...

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

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