acc_01 - Exploring Office 2003 - Grauer and Barber 1...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon

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

View Full DocumentRight Arrow Icon

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

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

Unformatted text preview: Exploring Office 2003 - Grauer and Barber 1 Committed to Shaping the Next Generation of IT Experts. Chapter 1- Introduction to Access: What is a Database? Robert Grauer and Maryann Barber Modified by A. Clark (USA) Exploring Microsoft Access 2003 Exploring Office 2003 - Grauer and Barber 2 Objectives Define field, record, table, and database Describe the objects in Access database Add, edit, and delete records in a table Use existing forms and reports Exploring Office 2003 - Grauer and Barber 3 Objectives (continued) Explain importance of data validation Apply filter by form or selection Sort a table on one or more fields Identify one-to-many relationships Exploring Office 2003 - Grauer and Barber 4 Example of Poor Data Storage Employer ID Employer Name Address Phone Position ID Position Title 10122 BeanTown Tours 105 State Street, Boston, MA 02109 617-451-1970 2045 Tour Guide 10125 Boston Harbor Excursions 75 Atlantic Avenue, Boston, MA 021110 617-235-1800 2082 Reservationist 10126 DaySide Inn & Country Club 354 Oceanside Drive, Brewster, MA 02631 508-283-5775 2040 Waiter/Waitress 10190 The Briar Rose Inn 105 Queen Street, Charlottetown PE CIA8R4 (902) 636-1595 2053 Host/Hostess 10191 Windsor Alpine Tours 14 Longmeadow Road, Laconia, NH 03246 603-266-9233 2078 Ski Patrol 10198 Trudel Spa & Resort 40 Rue Rivard, North Hatley, QC J0B 2CO 8198427783 2066 Lifeguard 10126 Baside Inn & Country Club 354 Oceanside Drive, Brewster, MA 02631 508-283-5775 2073 Pro Shop Clerk 10191 Windsor Alpine Tours 14 Longmeadow Road, Laconia, NH 03246 603-266-9233 2079 Day Care Worker 10126 Bayside Inn & Club 354 Oceanside Drive, Brewster, MA 02631 508-283-5775 2111 Kitchen Help Exploring Office 2003 - Grauer and Barber 5 Example of Poor Data Storage Employer ID Employer Name Address Phone Position ID Position Title 10122 BeanTown Tours 105 State Street, Boston, MA 02109 617-451-1970 2045 Tour Guide 10125 Boston Harbor Excursions 75 Atlantic Avenue, Boston, MA 021110 617-235-1800 2082 Reservationist 10126 DaySide Inn & Country Club 354 Oceanside Drive, Brewster, MA 02631 508-283-5775 2040 Waiter/Waitress 10190 The Briar Rose Inn 105 Queen Street, Charlottetown PE CIA8R4 (902) 636-1595 2053 Host/Hostess 10191 Windsor Alpine Tours 14 Longmeadow Road,...
View Full 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 / 32

acc_01 - Exploring Office 2003 - Grauer and Barber 1...

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