Exploring Microsoft Access 2003 Volume 1

by Grauer, Robert T.; Barber, Maryann

• ISBN13: 9780131434400
• ISBN10: 0131434403
• Format: Paperback
• Copyright: 2004-01-01
• Publisher: Prentice Hall

Summary

For Introductory Computer courses in Microsoft Office 2003 or courses in Computer Concepts with a lab component for Microsoft Office 2003 applications. Master the How and Why of Office 2003! Students master the "How and Why" of performing tasks in Office and gain a greater understanding of how to use the individual applications together to solve business problems.

Table of Contents

Preface	vii
MICROSOFT® OFFICE ACCESS 2003
Introduction to Access: What Is a Database?	1	(48)
Objectives	1	(1)
Case Study: Natalie's Cuppa Joe	1	(1)
The College Bookstore	2	(1)
Introduction to Microsoft Access	3	(4)
The Database Window	3	(1)
Tables	4	(1)
Forms, Queries, and Reports	5	(2)
Hands-On Exercise 1: Introduction to Access	7	(12)
Filters and Sorting	19	(2)
Hands-On Exercise 2: Filters and Sorting	21	(6)
Looking Ahead: A Relational Database	27	(2)
Hands-On Exercise 3: A Look Ahead	29	(7)
Summary	36	(1)
Key Terms	36	(1)
Multiple Choice	37	(2)
Practice with Access	39	(8)
Mini Cases	47	(2)
Tables and Forms: Design, Properties, Views, and Wizards	49	(54)
Objectives	49	(1)
Case Study: Kahakai Villas	49	(1)
A Student Database	50	(3)
Include the Necessary Data	51	(1)
Store Data in Its Smallest Parts	51	(1)
Avoid Calculated Fields	52	(1)
Creating a Table	53	(3)
Primary Key	53	(1)
Views	54	(1)
Properties	55	(1)
Hands-On Exercise 1: Creating a Table	56	(9)
Forms	65	(5)
Properties	66	(2)
AutoForms and the Form Wizard	68	(1)
Modifying a Form	68	(2)
Hands-On Exercise 2: Creating a Form	70	(8)
A More Sophisticated Form	78	(1)
Hands-On Exercise 3: A More Sophisticated Form	79	(9)
Summary	88	(1)
Key Terms	88	(1)
Multiple Choice	89	(2)
Practice with Access	91	(10)
Mini Cases	101	(2)
Information from the Database: Reports and Queries	103	(58)
Objectives	103	(1)
Case Study: Citizen of the World	103	(1)
Data Versus Information	104	(5)
Reports	104	(2)
Anatomy of a Report	106	(1)
The Report Wizard	106	(1)
Apply What You Know	106	(2)
Bound, Unbound, and Calculated Controls	108	(1)
Hands-On Exercise 1: The Report Wizard	109	(7)
Introduction to Queries	116	(5)
Query Design View	118	(1)
Selection Criteria	119	(2)
Hands-On Exercise 2: Creating a Select Query	121	(6)
Access Functions and Calculated Controls	127	(1)
Grouping Records	128	(2)
Hands-On Exercise 3: Grouping Records	130	(10)
Crosstab Queries	140	(1)
Action Queries	140	(1)
Hands-On Exercise 4: Crosstab and Action Queries	141	(8)
Summary	149	(1)
Key Terms	149	(1)
Multiple Choice	150	(2)
Practice with Access	152	(8)
Mini Cases	160	(1)
Proficiency: Relational Databases, Pivot Charts, and the Switchboard	161
Objectives	161	(1)
Case Study: Attorneys for Athletes	161	(1)
The Investment Database	162	(3)
Multiple-table Queries	163	(1)
Maintaining the Database	164	(1)
The Import Spreadsheet Wizard	165	(1)
Hands-On Exercise 1: Importing Data From Excel	166	(8)
Total Queries	174	(3)
Microsoft Graph	174	(3)
Pivot Tables and Pivot Charts	177	(2)
Hands-On Exercise 2: Total Queries, Charts, and Pivot Tables	179	(8)
The User Interface	187	(3)
The Switchboard Manager	189	(1)
Other Access Utilities	189	(1)
Hands-On Exercise 3: The Switchboard Manager	190	(7)
Summary	197	(1)
Key Terms	197	(1)
Multiple Choice	198	(2)
Practice with Access	200	(8)
Mini Cases	208
Getting Started with Microsoft® Windows® XP
Objectives	1	(1)
Case Study: Unforeseen Circumstances	1	(1)
Welcome to Windows XP	2	(1)
The Desktop	3	(3)
Moving and Sizing a Window	3	(3)
Anatomy of a Window	6	(3)
Pull-down Menus	7	(1)
Dialog Boxes	8	(1)
Help and Support Center	9	(1)
Hands-On Exercise 1: Welcome to Windows XP	10	(8)
Files and Folders	18	(2)
The Exploring Office Practice Files	20	(1)
Connecting to the Internet	20	(1)
Hands-On Exercise 2: Download the Practice Files	21	(8)
Windows Explorer	29	(3)
Personal Folders	29	(2)
Moving and Copying a File	31	(1)
Deleting a File	31	(1)
Backup	31	(1)
Hands-On Exercise 3: Windows Explorer	32	(9)
Increasing Productivity	41	(3)
The Control Panel	41	(1)
Shortcuts	42	(1)
The Search Companion	43	(1)
Hands-On Exercise 4: Increasing Productivity	44	(8)
Fun with Windows XP	52	(3)
Windows Media Player	52	(1)
Digital Photography	53	(1)
Windows Messenger	54	(1)
Hands-On Exercise 5: Fun with Windows XP	55	(9)
Summary	64	(1)
Key Terms	64	(1)
Multiple Choice	65	(2)
Practice with Windows XP	67	(5)
Mini Cases	72
Index	1