Learn Access 2002 Comprehensive,9780130097231

Learn Access 2002 Comprehensive

by ; ;
Edition: 1st
ISBN13: 9780130097231
ISBN10: 0130097233
Format: Paperback
Pub. Date: 2003-01-01
Publisher(s): Pearson College Div
Availability: This title is currently not available.
  • Free Shipping Icon

    This Item Qualifies for Free Shipping!*

    *Excludes marketplace orders.

List Price: $69.30

Rent Textbook

Select for Price
Add to Cart
There was a problem. Please try again later.

New Textbook

We're Sorry
Sold Out

Used Textbook

We're Sorry
Sold Out

eTextbook

We're Sorry
Not Available

Summary

For courses in Microsoft Office Professional 2002 and Access 2002. This text is highly-visual and skills-based, delivering the steps in a screen-by-screen format. Learn.edu methodology gives quick framework for success in Office XP and the series is certified to the core level of Microsoft XP.

Table of Contents

Using Common Elements in Office 1(1)
Explain It
1(2)
Introduction
1(1)
Visual Summary
2(1)
Do It
3(19)
Starting and Exiting an Office Application
3(3)
Opening and Saving an Existing Document with a New Name
6(3)
Using the Taskbar to Work in Multiple Windows
9(2)
Using Menus and Toolbars
11(5)
Printing a Document Using the Toolbar Button and the Menu
16(2)
Using the Office Assistant to Get Help
18(4)
Use It
22
Comprehension
22
Getting Started with Access
1(26)
Explain It
1(2)
Introduction
1(1)
Visual Summary
2(1)
Do It
3(16)
Copying, Renaming, and Opening a Database File
3(3)
Examining and Printing a Database Table
6(6)
Using a Form to Enter Data and Print a Record
12(3)
Previewing and Printing a Report
15(3)
Compacting and Closing a Database
18(1)
Use It
19(8)
Comprehension
19(2)
Reinforcement
21(2)
Challenge
23(2)
On Your Own
25(2)
Creating a Customized Database
27(44)
Explain It
27(2)
Introduction
27(1)
Visual Summary
28(1)
Do It
29(33)
Task 1 Creating a New Database and Creating Tables in Design View
30(5)
Creating a Table Using a Wizard
35(3)
Adding and Deleting Records in a Table
38(4)
Creating a Form Using the Form Wizard
42(4)
Modifying a Form Design
46(4)
Changing the Tab Order
50(3)
Creating a Report Using the Report Wizard
53(4)
Modifying and Printing a Report
57(5)
Use It
62(9)
Comprehension
62(2)
Reinforcement
64(3)
Challenge
67(2)
On Your Own
69(2)
Modifying the Structure of an Existing Database
71(42)
Explain It
71(2)
Introduction
71(1)
Visual Summary
72(1)
Do It
73(31)
Adding, Deleting, and Modifying Fields
73(5)
Adding Hyperlink Field Types and Data
78(3)
Adding Input Masks
81(6)
Setting Field Properties
87(5)
Creating a Lookup List in a Table
92(4)
Displaying Related Records in a Subdatasheet
96(3)
Creating Relationships Between Tables and Enforcing Referential Integrity
99(5)
Use It
104(9)
Comprehension
104(2)
Reinforcement
106(2)
Challenge
108(3)
On Your Own
111(2)
Retrieving Information From Your Database
113(42)
Explain It
113(3)
Introduction
113(1)
Visual Summary
114(2)
Do It
116(31)
Finding Records
116(4)
Sorting and Indexing Records
120(2)
Using Filter by Selection to Display Data
122(2)
Using Filter by Form to Display Data
124(4)
Creating Select Queries to Display Data
128(5)
Creating Compound Queries and Using Comparison Operators
133(7)
Creating a Query Based on Two Tables
140(4)
Creating Calculated Values in a Query
144(3)
Use It
147(8)
Comprehension
147(2)
Reinforcement
149(2)
Challenge
151(2)
On Your Own
153(2)
Integrating Access with Other Applications
155(38)
Explain It
155(3)
Introduction
155(1)
Visual Summary
156(2)
Do It
158(25)
Importing Data from Excel
158(4)
Importing Data from Word
162(4)
Creating a Query to Merge with Word
166(3)
Merging Data with Word
169(6)
Analyzing Data with Excel
175(2)
Converting a Database to a Different Version
177(3)
Linking to Other Databases
180(3)
Use It
183(10)
Comprehension
183(2)
Reinforcement
185(3)
Challenge
188(3)
On Your Own
191(2)
Becoming Proficient with Forms
193(44)
Explain It
193(2)
Introduction
193(1)
Visual Summary
194(1)
Do It
195(32)
Creating and Modifying a Columnar Form
195(5)
Adding a List Box to a Form
200(4)
Creating a Form Based on a Query
204(4)
Adding a Combo Box to a Form
208(5)
Adding a Calculated Control to a Form
213(3)
Creating a Form with a SubForm
216(6)
Publishing a Form as a Web Page
222(5)
Use It
227(10)
Comprehension
227(2)
Reinforcement
229(3)
Challenge
232(3)
On Your Own
235(2)
Becoming Proficient with Reports
237(38)
Explain It
237(3)
Introduction
237(1)
Visual Summary
238(2)
Do It
240(26)
Creating a Report Based on More than One Table
240(4)
Modifying a Report
244(6)
Creating a Grouped Summary Report
250(4)
Working with Report Samples
254(3)
Creating a Calculation in a Report
257(6)
Creating a Mailing Label Report
263(3)
Use It
266(9)
Comprehension
266(2)
Reinforcement
268(3)
Challenge
271(3)
On Your Own
274(1)
Becoming Proficient with Queries
275(30)
Explain It
275(3)
Introduction
275(1)
Visual Summary
276(2)
Do It
278(20)
Creating a Query Using the Query Wizard
278(3)
Summarizing Data in a Query
281(5)
Creating a Query that Archives Records
286(2)
Using a Query to Delete Records
288(2)
Creating a Query to Append Records
290(2)
Creating Parameter Queries
292(2)
Creating a Simple Crosstab Query
294(4)
Use It
298(7)
Comprehension
298(2)
Reinforcement
300(2)
Challenge
302(2)
On Your Own
304(1)
Modifying Table Properties and Joining Tables
305(32)
Explain It
305(2)
Introduction
305(1)
Visual Summary
306(1)
Do It
307(21)
Setting Data Validation Properties
308(3)
Creating and Modifying Lookup Field Properties
311(4)
Adding Custom Input Masks
315(3)
Using the Linked Table Manager
318(4)
Creating Relationships Between Tables
322(6)
Use It
328(9)
Comprehension
328(2)
Reinforcement
330(2)
Challenge
332(3)
On Your Own
335(2)
Working with Complex Query Designs
337(28)
Explain It
337(2)
Introduction
337(1)
Visual Summary
338(1)
Do It
339(18)
Creating and Applying Advanced Filters
339(4)
Creating Queries with Multiple Criteria
343(4)
Designing Parameter Queries
347(3)
Creating an Update Query to Change Data
350(4)
Using Summary Queries
354(3)
Use It
357(8)
Comprehension
357(2)
Reinforcement
359(2)
Challenge
361(2)
On Your Own
363(2)
Creating and Modifying Customer Forms and Reports
365(38)
Explain It
365(2)
Introduction
365(1)
Visual Summary
366(1)
Do It
367(28)
Creating a Form in Design View
367(3)
Adding a Subform to a Form
370(5)
Creating a Report in Design View
375(3)
Modifying a Report in Design View
378(5)
Adding Subreport Controls to a Report
383(4)
Adding PivotTable Views
387(4)
Adding PivotChart Views
391(4)
Use It
395(8)
Comprehension
395(2)
Reinforcement
397(3)
Challenge
400(2)
On Your Own
402(1)
Working with Macros and Modules
403(28)
Explain It
403(2)
Introduction
403(1)
Visual Summary
404(1)
Do It
405(17)
Creating a Macro and Attaching It to a Command Button
405(3)
Creating a Command Button
408(4)
Adding a Command Button to a Form Using the Wizard
412(4)
Modifying a VBA Module
416(2)
Attaching a Module to a Command Button
418(4)
Use It
422(9)
Comprehension
422(2)
Reinforcement
424(2)
Challenge
426(3)
On Your Own
429(2)
Collaborating with Access
431(24)
Explain It
431(2)
Introduction
431(1)
Visual Summary
432(1)
Do It
433(14)
Creating and Modifying a Data Access Page
433(5)
Saving PivotTable Views to a Data Access Page
438(2)
Saving PivotChart Views to a Data Access Page
440(3)
Exporting Access Data to XML Documents
443(2)
Importing XML Documents into Access
445(2)
Use It
447(8)
Comprehension
447(2)
Reinforcement
449(3)
Challenge
452(2)
On Your Own
454(1)
Protecting Your Database While Sharing It with Others
455
Explain It
455(2)
Introduction
455(1)
Visual Summary
456(1)
Do It
457(17)
Splitting a Database
457(4)
Setting Passwords for Databases
461(3)
Encrypting and Decrypting Databases
464(3)
Creating a Switchboard
467(4)
Setting Startup Options
471(3)
Use It
474
Comprehension
474(2)
Reinforcement
476(2)
Challenge
478(2)
On Your Own
480
Glossary 1(1)
Index 1

An electronic version of this book is available through VitalSource.

This book is viewable on PC, Mac, iPhone, iPad, iPod Touch, and most smartphones.

By purchasing, you will be able to view this book online, as well as download it, for the chosen number of days.

Digital License

You are licensing a digital product for a set duration. Durations are set forth in the product description, with "Lifetime" typically meaning five (5) years of online access and permanent download to a supported device. All licenses are non-transferable.

More details can be found here.

A downloadable version of this book is available through the eCampus Reader or compatible Adobe readers.

Applications are available on iOS, Android, PC, Mac, and Windows Mobile platforms.

Please view the compatibility matrix prior to purchase.