Mastering and Using Microsoft Access 2002 Comprehensive Course,9780619058142

Mastering and Using Microsoft Access 2002 Comprehensive Course

by
ISBN13: 9780619058142
ISBN10: 0619058145
Format: Paperback
Pub. Date: 2001-11-01
Publisher(s): Cengage Learning
List Price: $97.95

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

Buy from our Marketplace starting at $15.40

How Marketplace Works:

  • This item is offered by an independent seller and not shipped from our warehouse
  • Item details like edition and cover design may differ from our description; see seller's comments before ordering.
  • Sellers much confirm and ship within two business days; otherwise, the order will be cancelled and refunded.
  • Marketplace purchases cannot be returned to eCampus.com. Contact the seller directly for inquiries; if no response within two days, contact customer service.
  • Additional shipping costs apply to Marketplace purchases. Review shipping costs at checkout.

Summary

With over 50 years of combined experience as both academics and corporate trainers, Al Napier and Phil Judd have developed a proven approach to mastering and using application software. Through a realistic case approach, numerous business profiles, and coverage of MOUS certification objectives, learners gain the skills necessary to compete in today's ever-evolving business world.

Table of Contents

Napier & Judd v
Preface vi
Office Unit 1(1)
Getting Started with Microsoft Office XP
2(17)
What Is Microsoft Office XP?
3(1)
Hardware and Operating System Requirements
4(1)
Common Elements of Office Applications
4(4)
Starting Office Applications
8(4)
Getting Help in Office Applications
12(2)
Closing Office Applications
14(5)
Working with Menus, Toolbars, and Task Panes
19(18)
Working with Personalized Menus and Toolbars
20(5)
Viewing, Hiding, Docking, and Floating Toolbars
25(2)
Working with Task Panes
27(3)
Reviewing Smart Tags
30(7)
Introduction to the Internet and the World Wide Web
37
What Is the Internet?
38(1)
Connecting to the Internet
38(1)
Using Internet Explorer
39(3)
Using Directories and Search Engines
42
Access Unit 1(1)
Quick Start for Access
2(19)
Defining Access
3(1)
Opening the Access Application
3(1)
Identifying the Components of the Access Window
4(4)
Identifying Access Objects
8(7)
Exiting Access
15(6)
Planning a New Database
21(30)
Determining Appropriate Data Inputs and Outputs
22(2)
Creating and Saving a New Database
24(3)
Creating a Table Using the Table Wizard
27(2)
Creating a Table in Design View
29(7)
Modifying a Table in Design View
36(3)
Using the Input Mask Wizard
39(2)
Creating a Lookup Field
41(1)
Importing Data into a Table
42(9)
Entering and Editing Data into Tables
51(24)
Entering Records Using a Datasheet
52(1)
Navigating Through Records
53(1)
Modifying Records
54(3)
Deleting a Record from a Table
57(1)
Finding Records That Match Criteria
57(3)
Sorting Records in a Datasheet
60(2)
Filtering Records
62(3)
Printing a Table
65(1)
Adding Pictures to Records
66(9)
Establishing Relationships Between Tables
75(16)
Establishing Table Relationships
76(4)
Establishing Other One-to-Many Relationships
80(2)
Enforcing Referential Integrity
82(1)
Verifying Referential Integrity
83(8)
Creating and Modifying Basic Queries
91(22)
Creating a Multi-Table Select Query
92(1)
Specifying Query Criteria
93(6)
Modifying a Multi-Table Select Query
99(2)
Adding a Calculated Field to the Query
101(2)
Printing Query Results
103(10)
Creating and Modifying Forms
113(21)
Creating a Form with the Form Wizard and AutoForm
114(4)
Modifying a Form in Design View
118(6)
Creating a Calculated Control on a Form
124(1)
Entering and Modifying Records Using a Form
125(2)
Printing a Form
127(7)
Creating a Report
134(21)
Understanding Report Types
135(1)
Creating a Report with AutoReport
135(1)
Creating a Report with the Report Wizard
136(3)
Modifying a Report in Design View
139(6)
Previewing and Printing a Report
145(2)
Creating Labels with the Label Wizard
147(8)
Importing and Exporting Access Data
155
Integrating Access with Word Using Office Links
156(6)
Integrating Access with Excel
162(5)
Importing Access Data from Another Database
167(1)
Saving a Table, Query, Form, or Report as a Web Page
168(1)
Creating a Simple DAP
169
Building and Modifying Tables
2(18)
Defining Data Validation Rules
3(1)
Modifying Lookup Field Properties
4(2)
Modifying an Input Mask
6(3)
Defining Table Relationships
9(11)
Working with Advanced Filters and Queries
20(26)
Creating and Applying Advanced Filters
21(2)
Specifying Multiple Query Criteria
23(2)
Modifying Query Properties
25(1)
Using Aggregate Functions in a Query
26(3)
Creating a Parameter Query
29(2)
Creating an Action Query
31(7)
Creating a Crosstab Query
38(8)
Advanced Form Features
46(22)
Creating a Form in Design View
47(3)
Creating a Subform
50(5)
Creating a Switchboard Form
55(13)
Customizing Reports
68(29)
Creating a Custom Report in Design View
69(5)
Sorting and Grouping Data on a Report
74(9)
Adding a Subreport to an Existing Report
83(2)
Running a Grouped Report from a Parameter Query
85(12)
Using Access Tools
97(24)
Assigning Database Security
98(7)
Compacting and Repairing a Database
105(1)
Using the Database Splitter
106(2)
Using the Linked Table Manager
108(1)
Creating an MDE File
109(1)
Replicating a Database
110(1)
Creating an Access Module
111(10)
Integrating Access with the Internet
121
Viewing Web Sites and Sending E-mail Messages from a Database
122(3)
Working with XML Documents
125(3)
Creating and Previewing a Data Access Page
128(4)
Using PivotTable and PivotChart Views
132
Appendix 1(1)
A Working with Windows 2000
1(11)
a. Reviewing the Windows 2000 Desktop
2(2)
b. Accessing Your Computer System Resources
4(2)
c. Using Menu Commands and Toolbar Buttons
6(1)
d. Using the Start Menu
7(1)
e. Reviewing Dialog Box Options
7(1)
f. Using Windows 2000 Shortcuts
8(2)
g. Understanding the Recycle Bin
10(1)
h. Shutting Down Windows 2000
11(1)
B Formatting Tips for Business Documents
12(9)
a. Formatting Letters
13(2)
b. Inserting Mailing Notations
15(1)
c. Formatting Envelopes
15(2)
d. Formatting Interoffice Memorandums
17(1)
e. Formatting Formal Outlines
18(1)
f. Using Style Guides
18(1)
g. Using Proofreader's Marks
19(2)
C Using Office XP Speech Recognition
21
a. Training Your Speech Software
22(8)
b. Using Voice Commands
30(7)
c. Dictating, Editing, and Formatting by Voice
37(8)
d. Turning Microsoft Speech Recognition On and Off
45
Mous Grid 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.