did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

We're the #1 textbook rental company. Let us show you why.

9780619206727

New Perspectives on Microsoft Office Access 2003

by
  • ISBN13:

    9780619206727

  • ISBN10:

    0619206721

  • Format: Paperback
  • Copyright: 2003-12-22
  • Publisher: Cengage Learning
  • View Upgraded Edition
  • Purchase Benefits
  • Free Shipping Icon Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • eCampus.com Logo Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $133.95

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.

Table of Contents

Preface v
File Management
1(2)
Read This Before You Begin
2(1)
Managing Your Files
3
Creating and Working with Files and Folders in Windows XP
3(1)
Organizing Files and Folders
4(3)
Understanding the Need for Organizing Files and Folders
5(1)
Developing Strategies for Organizing Files and Folders
6(1)
Planning Your Organization
7(1)
Exploring Files and Folders
7(5)
Using Windows Explorer
9(1)
Navigating to Your Data Files
10(2)
Working with Folders and Files
12(6)
Creating Folders
12(2)
Moving and Copying Files and Folders
14(2)
Naming and Renaming Files
16(1)
Deleting Files and Folders
17(1)
Working with Compressed Files
18(2)
Quick Check
20(1)
Tutorial Summary
21(1)
Key Terms
21(1)
Review Assignments
21(1)
Case Problems
22(2)
SAM Assessment and Training
24(1)
Lab Assignments
24(1)
Quick Check Answers
24
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 Screen Tips
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 Level I Tutorials
1(168)
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(3)
Adding Records to a Table
56(1)
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(40)
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(1)
Access Level II Tutorials
169(272)
Read This Before You Begin
170(1)
Enhancing a Table's Design and Creating Advanced Queries
171(50)
Making the Jobs Database Easier to Use
171(1)
Session 5.1
172(1)
Creating a Lookup Wizard Field
172(6)
Displaying Related Records in a Subdatasheet
178(1)
Using the Input Mask Wizard
179(4)
Identifying Object Dependencies
183(2)
Defining Data Validation Rules
185(3)
Defining Field Validation Rules
185(1)
Defining Table Validation Rules
186(2)
Session 5.1 Quick Check
188(1)
Session 5.2
188(1)
Using a Pattern Match in a Query
188(3)
Using a List-of-Values Match in a Query
191(1)
Using the Not Operator in a Query
192(1)
Using Both the And and Or Operators in the Same Query
193(1)
Creating a Parameter Query
194(4)
Session 5.2 Quick Check
198(1)
Session 5.3
198(1)
Creating a Crosstab Query
198(5)
Creating a Find Duplicates Query
203(1)
Creating a Find Unmatched Query
204(2)
Creating a Top Values Query
206(3)
Session 5.3 Quick Check
209(1)
Tutorial Summary
209(1)
Key Terms
210(1)
Review Assignments
210(2)
Case Problems
212(7)
Internet Assignments
219(1)
SAM Assessment and Training
219(1)
Quick Check Answers
220(1)
Creating Custom Forms
221(66)
Creating a Multi-page Form
221(1)
Session 6.1
222(1)
Planning a Custom Form
222(3)
Designing a Custom Form
222(1)
Removing the Lookup Feature
223(2)
Printing Database Relationships and Using the Documenter
225(3)
Creating a Custom Form
228(5)
The Form Window in Design View
228(4)
Adding Fields to a Form
232(1)
Selecting and Moving Controls
233(2)
Changing a Label's Caption
235(2)
Session 6.1 Quick Check
237(1)
Session 6.2
238(1)
Resizing Controls
238(2)
Using From Headers and Form Footers
240(5)
Adding a Label to a Form
241(2)
Adding a Picture to a Form
243(2)
Changing the Background Color of a Form Control
245(1)
Creating a Multi-page Form Using Tab Controls
246(5)
Changing a Control to Another Control Type
251(1)
Adding Combo Boxes to a Form
252(3)
Session 6.2 Quick Check
255(1)
Session 6.3
256(1)
Adding a Subform to a Form
256(3)
Displaying a Subform's Calculated Control in the Main Form
259(5)
Adding a Calculated Control to a Subform's Form Footer Section
260(1)
Adding a Calculated Control to a Main Form
261(3)
Changing the Tab Order in a Form
264(2)
Using a Filter with a Form
266(9)
Using Simple Filters
267(1)
Using Filter By Form
268(3)
Saving a Filter as a Query
271(1)
Applying a Filter Saved as a Query
272(1)
Applying an Advanced Filter in a Form
273(2)
Session 6.3 Quick Check
275(1)
Tutorial Summary
275(1)
Key Terms
276(1)
Review Assignments
276(2)
Case Problems
278(7)
Internet Assignments
285(1)
SAM Assessment and Training
285(1)
Quick Check Answers
285(2)
Creating Custom Reports
287(82)
Creating a Potential Income Report
287(1)
Session 7.1
288(1)
Customizing an Existing Report
288(6)
Report Window in Design View
289(2)
Resizing and Moving Controls
291(3)
Hiding Duplicate Values in a Report
294(1)
Calculating Grand Totals
295(3)
Session 7.1 Quick Check
298(1)
Session 7.2
298(1)
Designing a Custom Report
298(2)
Reviewing and Modifying Queries for a Custom Report
300(3)
Assigning a Conditional Value to a Calculated Field
303(2)
Creating a Custom Report
305(2)
Sorting and Grouping Data in a Report
307(2)
Adding Fields to a Report
309(2)
Working with Controls
311(3)
Session 7.2 Quick Check
314(1)
Session 7.3
315(1)
Adding a Subreport Using Control Wizards
315(1)
Modifying a Subreport
316(4)
Adding Lines to a Report
320(2)
Calculating Group Totals
322(3)
Defining Conditional Formatting Rules
325(3)
Using Domain Aggregate Functions
328(4)
Session 7.3 Quick Check
332(1)
Session 7.4
332(1)
Adding the Date to a Report
332(2)
Adding Page Numbers to a Report
334(2)
Adding a Title to a Report
336(6)
Adding a Summary Subreport
342(3)
Creating Mailing Labels
345(7)
Session 7.4 Quick Check
352(1)
Tutorial Summary
352(1)
Key Terms
352(1)
Review Assignments
352(2)
Case Problems
354(12)
Internet Assignments
366(1)
SAM Assessment and Training
366(1)
Quick Check Answers
366(3)
Integrating Access with the Web and with Other Programs
369(72)
Creating Web-Enabled and Integrated Information for the Jobs Database
369(1)
Session 8.1
370(1)
Using the Web
370(1)
Exporting an Access Query to an HTML Document
370(3)
Viewing an HTML Document Using Internet Explorer
373(2)
Creating a Data Access Page for an Access Table
375(3)
Updating Data in a Data Access Page Using Internet Explorer
378(2)
Using a Data Access Page to Sort and Filter Records
380(1)
Creating a Custom Data Access Page
381(11)
Creating a Blank Data Access Page in Design View
381(1)
Adding Fields to a Data Access Page
382(4)
Deleting, Moving, and Resizing Controls in a Data Access Page
386(1)
Resizing a Section and Applying a Special Effect
387(2)
Selecting a Theme
389(1)
Saving and Viewing a Data Access Page
390(2)
Session 8.1 Quick Check
392(1)
Session 8.2
392(1)
Creating and Using a Pivot Table in a Data Access Page
392(12)
Adding a Pivot Table to a Data Access Page
394(1)
Adding Fields to a Pivot Table
395(3)
Using a Pivot Table in Page View
398(3)
Adding a Total Field to a Pivot Table
401(3)
Creating and Using a PivotChart in a Data Access page
404(10)
Session 8.2 Quick Check
414(1)
Session 8.3
414(1)
Using XML
414(6)
Importing an XML File as an Access Table
414(3)
Exporting an Access Table as an XML File
417(3)
Exporting an Access Query as an Excel Worksheet
420(3)
Saving the Worksheet and Exiting Excel
422(1)
Creating Hyperlinks to Other Office XP Documents
423(5)
Creating a Hyperlink Field in a Table
423(1)
Entering Hyperlink Field Values
424(3)
Using a Hyperlink
427(1)
Session 8.3 Quick Check
428(1)
Tutorial Summary
428(1)
Key Terms
428(1)
Review Assignments
429(1)
Case Problems
430(9)
Internet Assignments
439(1)
SAM Assessment and Training
439(1)
Quick Check Answers
439(2)
Access Level III Tutorials
441
Read This Before You Begin
442(1)
Using Action Queries and Defining Table Relationships
443(46)
Enhancing User Interaction with the Overseas Database
443(1)
Session 9.1
444(1)
Action Queries
444(13)
Creating a Make-Table Query
444(4)
Creating an Append Query
448(3)
Creating a Delete Query
451(2)
Creating an Update Query
453(4)
Session 9.1 Quick Check
457(1)
Session 9.2
457(1)
Relationships Between Database Tables
457(4)
Many-to-Many Relationships
458(2)
One-to-One Relationships
460(1)
Defining M:N and 1:1 Relationships Between Tables
461(3)
Using Indexes for Table Fields
464(2)
Viewing Existing Indexes
466(3)
Creating an Index
468(1)
Joining Tables
469(9)
Inner and Outer Joins
469(3)
Self-Joins
472(3)
Creating a Self-Join
475(3)
Session 9.2 Quick Check
478(1)
Tutorial Summary
479(1)
Key Terms
479(1)
Review Assignments
479(2)
Case Problems
481(6)
Internet Assignments
487(1)
SAM Assessment and Training
487(1)
Quick Check Answers
488(1)
Automating Tasks with Macros
489(64)
Creating a User Interface for the Overseas Database
489(1)
Session 10.1
490(1)
Implementing a Graphical User Interface
490(2)
Switchboards
490(2)
Dialog Boxes
492(1)
Introduction to Macros
492(1)
Running a Macro
493(2)
Adding Actions to a Macro
495(3)
Single Stepping a Macro
498(1)
Creating a Macro
499(5)
Adding Actions by Dragging
500(4)
Session 10.1 Quick Check
504(1)
Session 10.2
504(1)
Using a Command Button with an Attached Macro
504(3)
Events
505(2)
Macro Groups
507(2)
Adding a Macro to a Macro Group
509(2)
Adding a Command Button to a Form
511(1)
Attaching a Macro to a Command Button
512(1)
Creating the Queries Dialog Box Form
513(2)
Adding a List Box to a Form
515(2)
Using SQL
517(4)
Viewing an SQL Statement for a Query
518(2)
Using an SQL Statement for a List Box
520(1)
Adding Command Buttons to a Form
521(4)
Modifying Form Properties
525(1)
Testing the Queries DialogBox Form
526(1)
Session 10.2 Quick Check
527(1)
Session 10.3
527(1)
Reviewing the Overseas Database Switchboard Requirements
527(1)
Creating the Macro Group for the Switchboard
528(4)
Creating a Switchboard
532(8)
Adding Command Buttons to a Switchboard Page
534(2)
Moving Command Buttons in a Switchboard Page
536(1)
Adding Command Buttons to a Second Switchboard Page
537(1)
Viewing and Testing a Switchboard
538(2)
Modifying a Switchboard
540(2)
Session 10.3 Quick Check
542(1)
Tutorial Summary
543(1)
Key Terms
543(1)
Review Assignments
543(2)
Case Problems
545(6)
Internet Assignments
551(1)
SAM Assessment and Training
551(1)
Quick Check Answers
551(2)
Using and Writing Visual Basic for Applications Code
553(46)
Creating VBA Code for the Overseas Database User Interface
553(1)
Session 11.1
554(1)
Introduction to Visual Basic for Applications
554(4)
Events
554(2)
Procedures
556(1)
Modules
556(2)
Using Help and the Sample Northwind Database
558(1)
Using an Existing Procedure
558(6)
Displaying an Event Procedure
559(3)
Modifying an Event Procedure
562(2)
Creating Functions in a Standard Module
564(4)
Creating a Function
565(2)
Saving a Module
567(1)
Testing a Procedure in the Immediate Window
568(1)
Session 11.1 Quick Check
569(1)
Session 11.2
570(1)
Creating an Event Procedure
570(5)
Designing an Event Procedure
571(1)
Adding an Event Procedure
572(2)
Compiling Modules
574(1)
Testing an Event Procedure
574(1)
Adding a Second Procedure to a Class Module
575(6)
Designing the Field Validation Procedure
575(3)
Adding a Second Event Procedure
578(3)
Session 11.2 Quick Check
581(1)
Session 11.3
581(1)
Changing the Case of a Field Value
581(2)
Hiding and Changing Display Color
583(3)
Creating the Procedures for the QueriesDialogBox Form
586(5)
Coding the Load Event Procedure for the QueriesDialogBox Form
586(2)
Coding the PreviewQuery and DisplayQuery Procedures for the QuereisDialogBox Form
588(3)
Session 11.3 Quick Check
591(1)
Tutorial Summary
591(1)
Key Terms
591(1)
Review Assignments
592(1)
Case Problems
593(4)
Internet Assignments
597(1)
SAM Assessment and Training
597(1)
Quick Check Answers
598(1)
Managing and Securing a Database
599
Managing and Securing the Overseas Database
599(1)
Session 12.1
600(1)
Analyzing Database Performance with the Performance Analyzer
600(3)
Linking Tables and Using the Linked Table Manager
603(4)
Creating a Replica of a Database
607(3)
Synchronizing the Replica and the Design Master
610(3)
Session 12.1 Quick Check
613(1)
Session 12.2
613(1)
Using the Database Splitter
613(4)
Setting the Database Startup Options
617(2)
Securing an Access Database
619(5)
Encrypting a Database
620(1)
Setting and Unsetting a Database Password
621(3)
Establishing User-Level Security
624(8)
Using the User-Level Security Wizard
625(6)
Testing User-Level Security
631(1)
Saving a database as an MDE File
632(1)
Session 12.2 Quick Check
632(1)
Tutorial Summary
633(1)
Key Terms
633(1)
Review Assignments
633(1)
Case Problems
634(4)
Internet Assignments
638(1)
SAM Assessment and Training
638(1)
Quick Check Answers
638
Additional Case 1 Enhancing an Investment Club Database
1(6)
Additional Case 2 Tracking Parking Permits and Violations
7(6)
Additional Case 3 Internship Program for Pontiac College
13
Appendix Relational Databases and Database Design
1(1)
Tables
2(1)
Keys
3(2)
Relationships
5(4)
One-to-One
6(1)
One-to-Many
6(1)
Many-to-Many
7(1)
Entity Subtype
8(1)
Entity-Relationship Diagrams
9(2)
Integrity Constraints
11(1)
Dependencies and Determinants
11(3)
Anomalies
14(1)
Normalization
15(6)
First Normal Form
15(2)
Second Normal Form
17(2)
Third Normal Form
19(2)
Natural, Artificial, and Surrogate Keys
21(4)
Microsoft Access Naming Conventions
25(3)
Summary
28(1)
Key Terms
28(1)
Review Questions
28
Glossary/Index 1(17)
Task Reference 18(5)
Microsoft Office Specialist Certification Grid 23

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program