New Perspectives on Microsoft Office Access 2003, Brief, CourseCard Edition

by ADAMSKI/FINNEGAN

• ISBN13: 9781418839079
• ISBN10: 1418839078
• Edition: Brief
• Format: Paperback
• Copyright: 2005-03-29
• Publisher: Cengage Learning

Summary

Part of the New Perspectives series, this text offers a case-based, problem-solving approach and innovative technology for meaningful learning of Microsoft Access 2003. A great case-based, problem-solving approach to learning Access, this text covers the basics such as creating queries, forms, and reports. Perfect for any introductory course or used in conjunction with our other Microsoft Office application books.

Table of Contents

Preface	iii
Office	1	(2)
Read This Before You Begin	2	(1)
Using Common Features of Microsoft Office 2003	3
Preparing Promotional Materials	3	(1)
Exploring Microsoft Office 2003	4	(1)
Integrating Office Programs	5	(1)
Starting Office Programs	5	(4)
Switching Between Open Programs and Files	8	(1)
Exploring Common Window Elements	9	(1)
Using the Window Sizing Buttons	9	(2)
Using Menus and Toolbars	11	(3)
Viewing Personalized Menus and Toolbars	11	(3)
Using Task Panes	14	(2)
Opening and Closing Task Panes	14	(1)
Navigating Among Task Panes	15	(1)
Using the Research Task Pane	16	(2)
Working with Files	18	(5)
Creating a File	19	(1)
Saving a File	19	(2)
Closing a File	21	(1)
Opening a File	22	(1)
Getting Help	23	(6)
Using ScreenTips	23	(1)
Using the Type a Question for Help Box	23	(2)
Using the Help Task Pane	25	(2)
Using Microsoft Office Online	27	(2)
Printing a File	29	(1)
Exiting Programs	30	(1)
Quick Check	31	(1)
Tutorial Summary	31	(1)
Key Terms	31	(1)
Review Assignments	31	(1)
SAM Assessment and Training	32	(1)
Quick Check Answers	32
Access	1	(1)
Read This Before You Begin	2	(1)
Introduction to Microsoft Access 2003	3	(32)
Viewing and Working with a Table Containing Employer Data	3	(1)
Session 1.1	4	(1)
Introduction to Database Concepts	4	(3)
Organizing Data	4	(1)
Databases and Relationships	5	(1)
Relational Database Management Systems	6	(1)
Opening an Existing Database	7	(3)
Exploring the Access and Database Windows	9	(1)
Opening an Access Table	10	(2)
Navigating an Access Datasheet	11	(1)
Printing a Datasheet	12	(1)
Saving a Database	12	(1)
Session 1.1 Quick Check	13	(1)
Session 1.2	13	(1)
Working with Queries	13	(5)
Opening an Existing Query	14	(1)
Creating, Sorting, and Navigating a Query	15	(3)
Creating and Navigating a Form	18	(2)
Creating, Previewing, and Navigating a Report	20	(4)
Printing Specific Pages of a Report	23	(1)
Managing a Database	24	(4)
Backing up and Restoring a Database	24	(1)
Compacting and Repairing a Database	25	(1)
Compacting a Database Automatically	26	(1)
Converting an Access 2000 Database	27	(1)
Session 1.2 Quick Check	28	(1)
Tutorial Summary	29	(1)
Key Terms	29	(1)
Review Assignments	29	(1)
Case Problems	30	(3)
Internet Assignments	33	(1)
SAM Assessment and Training	33	(1)
Lab Assignments	34	(1)
Quick Check Answers	34	(1)
Creating and Maintaining a Database	35	(46)
Creating the Northeast Database, and Creating, Modifying, and Updating the Position Table	35	(1)
Session 2.1	36	(1)
Guidelines for Designing Databases	36	(2)
Guidelines for Setting Field Properties	38	(3)
Naming Fields and Objects	38	(1)
Assigning Field Data Types	38	(1)
Setting Field Sizes	39	(1)
Setting Field Captions	40	(1)
Creating a New Database	41	(1)
Creating a Table	42	(11)
Defining Fields	43	(7)
Specifying the Primary Key	50	(2)
Saving the Table Structure	52	(1)
Session 2.1 Quick Check	53	(1)
Session 2.2	53	(1)
Adding Records to a Table	53	(3)
Modifying the Structure of an Access Table	56	(9)
Deleting a Field	57	(1)
Moving a Field	58	(1)
Adding a Field	59	(1)
Changing Field Properties	60	(1)
Updating Field Property Changes	61	(4)
Obtaining Data from Another Access Database	65	(3)
Copying Records from Another Access Database	65	(2)
Importing a Table from Another Access Database	67	(1)
Updating a Database	68	(3)
Deleting Records	68	(1)
Changing Records	69	(2)
Session 2.2 Quick Check	71	(1)
Tutorial Summary	71	(1)
Key Terms	72	(1)
Review Assignments	72	(2)
Case Problems	74	(5)
Internet Assignments	79	(1)
SAM Assessment and Training	80	(1)
Quick Check Answers	80	(1)
Querying a Database	81	(48)
Retrieving Information About Employers and Their Positions	81	(1)
Session 3.1	82	(1)
Introduction to Queries	82	(1)
Query Window	82	(2)
Creating and Running a Query	84	(3)
Updating Data Using a Query	87	(1)
Defining Table Relationships	87	(6)
One-to-Many Relationships	88	(1)
Referential Integrity	89	(1)
Defining a Relationship Between Two Tables	89	(4)
Creating a Multi-table Query	93	(2)
Sorting Data in a Query	95	(5)
Using a Toolbar Button to Sort Data	95	(1)
Sorting Multiple Fields in Design View	96	(4)
Filtering Data	100	(2)
Session 3.1 Quick Check	102	(1)
Session 3.2	102	(1)
Defining Record Selection Criteria for Queries	102	(5)
Specifying an Exact Match	103	(2)
Changing a Datasheet's Appearance	105	(1)
Using a Comparison Operator to Match a Range of Values	106	(1)
Defining Multiple Selection Criteria for Queries	107	(5)
The And Logical Operator	108	(1)
Using Multiple Undo and Redo	109	(2)
The Or Logical Operator	111	(1)
Performing Calculations	112	(9)
Creating a Calculated Field	113	(4)
Using Aggregate Functions	117	(2)
Using Record Group Calculations	119	(2)
Session 3.2 Quick Check	121	(1)
Tutorial Summary	121	(1)
Key Terms	121	(1)
Review Assignments	122	(1)
Case Problems	123	(4)
Internet Assignments	127	(1)
SAM Assessment and Training	128	(1)
Quick Check Answers	128	(1)
Creating Forms and Reports	129
Creating a Position Data Form, an Employer Positions Form, and an Employers and Positions Report	129	(1)
Session 4.1	130	(1)
Creating a Form Using the Form Wizard	130	(3)
Changing a Form's AutoFormat	133	(2)
Finding Data Using a Form	135	(3)
Previewing and Printing Selected Form Records	138	(1)
Maintaining Table Data Using a Form	139	(2)
Session 4.1 Quick Check	141	(1)
Session 4.2	142	(1)
Creating a Form with a Main Form and a Subform	142	(5)
Modifying a Form in Design View	145	(2)
Creating a Report Using the Report Wizard	147	(11)
Checking Errors in a Report	155	(3)
Inserting a Picture in a Report	158	(2)
Session 4.2 Quick Check	160	(1)
Tutorial Summary	161	(1)
Key Terms	161	(1)
Review Assignments	161	(2)
Case Problems	163	(5)
Internet Assignments	168	(1)
SAM Assessment and Training	168	(1)
Quick Check Answers	168
Glossary/Index	1	(6)
Task Reference	7