Microsoft Mous Office,9780619056735

Microsoft Mous Office

by
ISBN13: 9780619056735
ISBN10: 0619056738
Format: Paperback
Pub. Date: 2002-08-01
Publisher(s): Cengage Learning
List Price: $209.55

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 $138.22

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

Presents a highly visual approach to learning the necessary skills to pass the Microsoft Office User Specialist (MOUS) exam.

Table of Contents

Preface iv
Additional Resources vi
Getting Started with Word 2002 1(1)
Start and Exit Word
2(2)
Understand Toolbars
4(2)
Understand Task Panes
6(2)
Open and Close Documents
8(2)
Work with More Than One Open Document
10(2)
Navigate in the Document Window
12(2)
Understand Views
14(2)
Save the Files You Create
16(2)
Use Smart Tags
18(2)
Get Help
20(3)
Skill Set 1
23(42)
Insert, Modify, and Move Text and Symbols
24(18)
Apply and Modify Text Formats
42(4)
Correct Spelling and Grammar Usage
46(6)
Apply Font and Text Effects
52(6)
Enter and Format Date and Time
58(4)
Apply Character Styles
62(3)
Skill Set 2
65(26)
Modify Paragraph Formats
66(12)
Set and Modify Tabs
78(4)
Apply Bullet, Outline, and Numbering Format to Paragraphs
82(6)
Apply Paragraph Styles
88(3)
Skill Set 3
91(42)
Create and Modify a Header and Footer
92(4)
Apply and Modify Column Settings
96(8)
Modify Document Layout and Page Setup Options
104(8)
Create and Modify Tables
112(12)
Preview and Print Documents, Envelopes, and Labels
124(9)
Skill Set 4
133(10)
Manage Files and Folders for Documents
134(2)
Create Documents Using Templates
136(2)
Save Documents Using Different Names and File Formats
138(5)
Skill Set 5
143(16)
Insert Images and Graphics
144(4)
Create and Modify Diagrams and Charts
148(11)
Skill Set 6
159(10)
Compare and Merge Documents
160(2)
Insert, View, and Edit Comments
162(4)
Convert Documents into Web Pages
166(3)
Skill Set 7
169(10)
Control Pagination
170(6)
Sort Paragraphs in Lists and Tables
176(3)
Skill Set 8
179(38)
Create and Format Document Sections
180(6)
Create and Apply Character and Paragraph Styles
186(4)
Create and Update Document Indexes and Tables of Contents, Figures, and Authorities
190(8)
Create Cross-references
198(2)
Add and Revise Endnotes and Footnotes
200(2)
Create and Manage Master Documents and Subdocuments
202(4)
Move with in Documents
206(4)
Create and Modify Forms Using Various Form Controls
210(4)
Create Forms and Prepare Forms for Distribution
214(3)
Skill Set 9
217(10)
Use Excel Data in Tables
218(4)
Perform Calculations in Word Tables
222(5)
Skill Set 10
227(14)
Create, Modify, and Position Graphics
228(8)
Create and Modify Charts Using Data from Other Applications
236(2)
Align Text and Graphics
238(3)
Skill Set 11
241(14)
Create, Edit, and Run Macros
242(8)
Customize Menus and Toolbars
250(5)
Skill Set 12
255(36)
Track, Accept, and Reject Changes to Documents
256(6)
Merge Input from Several Reviewers
262(4)
Insert and Modify Hyperlinks to Other Documents and Web Pages
266(6)
Create and Edit Web Documents in Word
272(6)
Create Document Versions
278(2)
Protect Documents
280(2)
Define and Modify Default File Locations for Workgroup Templates
282(4)
Attach Digital Signatures to Documents
286(5)
Skill Set 13
291
Merge Letter with a Word, Excel, or Access Data Source
292(4)
Merge Labels with a Word, Excel, or Access Data Source
296(4)
Use Outlook Data as a Mail Merge Data Source
300
Getting Started with Excel 2002 1(1)
Start and Exit the Excel Program
2(2)
Explore the Excel Window
4(2)
Open and Close an Excel Workbook
6(2)
Navigate an Excel Workbook
8(2)
Explore Task Panes
10(2)
Copy Workbook Files
12(2)
Save Workbooks
14(2)
Preview and Print a Worksheet
16(2)
Get Help
18(3)
Skill Set 1
21(30)
Insert, Delete, and Move Cells
22(6)
Enter and Edit Cell Data Including Text, Numbers, and Formulas
28(12)
Check Spelling
40(2)
Find and Replace Cell Data and Formats
42(6)
Work with a Subset of Data by Filtering Lists
48(3)
Skill Set 2
51(14)
Manage Workbook Files and Folders
52(4)
Create Workbooks Using Templates
56(2)
Save Workbooks Using Different Names and File Formats
58(7)
Skill Set 3
65(34)
Apply and Modify Cell Formats
66(4)
Modify Row and Column Settings
70(14)
Apply Styles
84(2)
Use Automated Tools to Format Worksheets
86(2)
Modify Page Setup Options for Worksheets
88(6)
Preview and Print Worksheets and Workbooks
94(5)
Skill Set 4
99(16)
Insert and Delete Worksheets
100(4)
Modify Worksheet Names and Positions
104(6)
Use 3-D References
110(5)
Skill Set 5
115(22)
Create and Revise Formulas
116(10)
Use Statistical, Date and Time, Financial, and Logical Functions in Formulas
126(11)
Skill Set 6
137(22)
Create, Modify, Position, and Print Charts
138(16)
Create, Modify, and Position Graphics
154(5)
Skill Set 7
159(10)
Convert Worksheets into Web Pages
160(2)
Create Hyperlinks
162(4)
View and Edit Comments
166(3)
Skill Set 8
169(24)
Import Data to Excel
170(10)
Export Data from Excel
180(6)
Publish Worksheets and Workbooks to the Web
186(7)
Skill Set 9
193(16)
Create, Edit, and Apply Templates
194(6)
Create Workspaces
200(4)
Use Data Consolidation
204(5)
Skill Set 10
209(10)
Create and Apply Custom Number Formats
210(6)
Use Conditional Formats
216(3)
Skill Set 11
219(10)
Use Named Ranges in Formulas
220(6)
Use Lookup and Reference Functions
226(3)
Skill Set 12
229(16)
Customize Toolbars and Menus
230(4)
Create, Edit, and Run Macros
234(11)
Skill Set 13
245(12)
Audit Formulas
246(4)
Locate and Resolve Errors
250(2)
Identify Dependencies in Formulas
252(5)
Skill Set 14
257(24)
Use Subtotals with Lists and Ranges
258(6)
Define and Apply Filters
264(4)
Add Group and Outline Criteria to Ranges
268(2)
Use Data Validation
270(2)
Retrieve External Data and Create Queries
272(6)
Create Extensible Markup Language (XML) Web Queries
278(3)
Skill Set 15
281(20)
Create PivotTable Reports and PivotChart Reports
282(10)
Forecast Values with What-If Analysis
292(6)
Create and Display Scenarios
298(3)
Skill Set 16
301
Modify Passwords, Protections, and Properties
302(10)
Create a Shared Workbook
312(2)
Track, Accept, and Reject Changes to Workbooks
314(4)
Merge Workbooks
318
Getting Started with Access 2002 1(1)
Start Access and Open a Database
2(2)
Identify the Parts of the Database Window
4(2)
Understand Database Terminology
6(4)
Understand the Benefits of Using a Relational Database
10(2)
Manage Toolbars and Understand Views
12(2)
Use the Help System
14(2)
Close a Database and Exit Access
16(3)
Skill Set 1
19(12)
Create Access Databases
20(2)
Open Database Objects in Multiple Views
22(2)
Move Among Records
24(4)
Form at Datasheets
28(3)
Skill Set 2
31(12)
Create and Modify Tables
32(4)
Add a Pre-defined Input Mask to a Field
36(2)
Create Lookup Fields
38(2)
Modify Field Properties
40(3)
Skill Set 3
43(10)
Create and Modify Select Queries
44(4)
Add Calculated Fields to Select Queries
48(5)
Skill Set 4
53(10)
Create and Display Forms
54(4)
Modify Form Properties
58(5)
Skill Set 5
63(16)
Enter, Edit, and Delete Records
64(4)
Create Queries
68(2)
Sort Records
70(4)
Filter Records
74(5)
Skill Set 6
79(6)
Create One-To-Many Relationships
80(2)
Enforce Referential Integrity
82(3)
Skill Set 7
85(12)
Create and Format Reports
86(4)
Add Calculated Controls to Reports
90(4)
Preview and Print Reports
94(3)
Skill Set 8
97(14)
Import Data to Access
98(4)
Export Data from Access
102(4)
Create a Simple Data Access Page
106(5)
Skill Set 9
111(12)
Use Data Validation
112(2)
Link Tables
114(2)
Create Lookup Fields and Modify Lookup Field Properties
116(4)
Create and Modify Input Masks
120(3)
Skill Set 10
123(12)
Create a Form in Design View
124(2)
Create a Switchboard and Set Startup Options
126(6)
Add Subform Controls to Access Forms
132(3)
Skill Set 11
135(14)
Specify Multiple Query Criteria
136(4)
Create and Apply Advanced Filters
140(6)
Use Aggregate Functions in Queries
146(3)
Skill Set 12
149(10)
Create and Modify Reports
150(4)
Add Subreport Controls to Access Reports
154(2)
Sort and Group Data in Reports
156(3)
Skill Set 13
159(6)
Establish One-To-Many Relationships
160(2)
Establish Many-To-Many Relationships
162(3)
Skill Set 14
165(8)
Create and Modify a Data Access Page
166(2)
Save PivotTable and PivotChart Views to Data Access Pages
168(5)
Skill Set 15
173(16)
Import XML Documents into Access
174(2)
Export Access Data to XML Documents
176(2)
Encrypt and Decrypt Databases
178(2)
Compact and Repair Databases
180(2)
Assign Database Security
182(4)
Replicate a Database
186(3)
Skill Set 16
189
Create Access Modules
190(4)
Use the Database Splitter
194(2)
Create an MDE File
196
Getting Started with Outlook 2002 1(1)
Start Outlook
2(2)
Understand Outlook Folders and Items
4(2)
Use Toolbars, Menus, and Dialog Boxes
6(2)
Work with Items and Views
8(6)
Get Help
14(3)
Skill Set 1
17(24)
Display and Print Messages
18(6)
Compose and Send Messages
24(8)
Insert Signatures and Attachments
32(4)
Customize Views
36(5)
Skill Set 2
41(22)
Add Appointments, Meetings, and Events to the Calendar
42(8)
Apply Conditional Formats to the Outlook Calendar
50(2)
Respond to Meeting Requests
52(6)
Use Categories to Manage Appointments
58(2)
Print Calendars
60(3)
Skill Set 3
63(18)
Move Messages Between Folders
64(2)
Search for Messages
66(2)
Save Messages in Alternate File Formats
68(4)
Use Categories to Manage Messages
72(2)
Set Message Options
74(7)
Skill Set 4
81(16)
Create and Edit Contacts
82(4)
Organize and Sort Contacts
86(4)
Link Contacts to Activities and Journal Entries
90(7)
Skill Set 5
97
Create and Update Tasks
98(4)
Modify Task Organization and Task View
102(2)
Accept, Decline, or Delegate Tasks
104(6)
Create and Modify Notes
110(4)
Use Categories to Manage Tasks and Notes
114
Getting Started with PowerPoint 2002 1(1)
Start PowerPoint
2(2)
Understand PowerPoint Views
4(10)
Work with Objects
14(2)
Get Help
16(2)
Save Files
18(3)
Skill Set 1
21(18)
Create Presentations Manually and Using Automated Tools
22(6)
Add Slides to and Delete Slides from Presentations
28(4)
Modify Headers and Footers in the Slide Master
32(7)
Skill Set 2
39(16)
Import Text from Word
40(2)
Insert, Format, and Modify Text
42(13)
Skill Set 3
55(20)
Add Tables, Charts, Clip Art, and Bitmap Images to Slides
56(8)
Customize Slide Backgrounds
64(4)
Add Office Art Elements to Slides
68(4)
Apply Custom Formats to Tables
72(3)
Skill Set 4
75(38)
Apply Formats to Presentations
76(8)
Apply Animation Schemes
84(6)
Apply Slide Transitions
90(6)
Customize Slide Formats
96(2)
Customize Slide Templates
98(2)
Manage a Slide M aster
100(4)
Rehearse Timing
104(2)
Rearrange Slides
106(2)
Modify Slide Layout
108(2)
Add Links to a Presentation
110(3)
Skill Set 5
113(14)
Preview and Print Slides, Outlines, Handouts, and Speaker Notes
114(13)
Skill Set 6
127(16)
Import Excel Charts to Slides
128(4)
Add Sound and Video to Slides
132(4)
Insert Word Tables on Slides
136(4)
Export a Presentation as an Outline
140(3)
Skill Set 7
143(20)
Set Up Slide Shows
144(2)
Deliver Presentations
146(8)
Manage Files and Folders for Presentations
154(2)
Work with Embedded Fonts
156(2)
Publish Presentations to the Web
158(2)
Use Pack and Go
160(3)
Skill Set 8
163
Set Up a Review Cycle
164(2)
Review Presentation Comments
166(2)
Schedule and Deliver Presentation Broadcasts
168(2)
Publish Presentations to the Web
170
Word 2002 Core Projects Appendix 1(16)
Meeting Minutes for Mariposa Community Center
2(2)
Advertising Bulletin for Skis 'n Boards
4(2)
Newsletter for the Marine Educational Foundation
6(2)
Newsletter for the Marine Educational Foundation (continued)
8(2)
Memo for Lakeland Art Gallery
10(2)
Information Sheet for Classic Car Races
12(2)
Web Page for Allure Cosmetics
14(3)
Word 2002 Expert Projects Appendix 17(16)
Architectural Heritage Campaign Information
18(2)
TV Documentary Proposal
20(2)
Ohio Teen Choir Trip Information
22(2)
Flyer for Fascinating Rhythms Dance Studio
24(2)
Phoenix Concert Society Posters
26(2)
Short Story for Footloose Travel Magazine
28(2)
Film Location Form Letter
30(3)
Excel 2002 Core Projects Appendix 33(16)
Sales Projection for Alaska Adventures
34(2)
Invoice for Art Rentals to Movies
36(2)
Budget for Into Thin Air Balloon Tours
38(2)
Price Lists for Keeping the Beat Drum Shop
40(2)
Maui Resorts Time Share Vacation Options
42(2)
Sales Information for Fanfloratastic Flowers
44(2)
Sales Report for Splashdown Rafting
46(3)
Excel 2002 Expert Projects Appendix 49(20)
E-Commerce Conference Itinerary
50(2)
Expense Reports for Quito Imports
52(2)
Extreme Adventures Tours Sates
54(2)
Inventory Sheets for Vintage Records
56(2)
Payroll Register for Tapestries Bistro
58(2)
Purchase Orders for Saguaro Art Academy
60(2)
Guest Information for Glacier Cruises
62(2)
Analysis of Web Design 101 Class Grades
64(2)
Sales Projections for Big Sky Campgrounds
66(3)
Access 2002 Core Projects Appendix 69(18)
Contact Database for Step One Consulting
70(2)
Event Database for Great Prairies Jazz Festival
72(2)
Winners Database for Classic Car Races
74(2)
Photography Database for French Archeology Project
76(2)
Conference Database for E-Commerce Forum
78(2)
Properties Database for Powder Trails Realty
80(2)
Sales Database for Precious Pets
82(2)
Great Hiking Trails Database
84(3)
Access 2002 Expert Projects Appendix 87(18)
Database for Italia Vacations, Inc.
88(2)
Sales Database for Pioneer Antiques
90(2)
Product Database for Viva Arts
92(2)
Customer Database for Custom Mouse Pads
94(2)
Client Database for Fit 'n Fun Health Club
96(2)
Rentals Database for Classics Plus Video Club
98(2)
Database of Golden Golf Tours
100(2)
Product Database for Snaps Photo Supplies
102(3)
Outlook 2002 Core Projects Appendix 105(12)
E-mail Messages for Vision Productions
106(2)
Meeting Schedules for Pacific Imports
108(2)
Message Management for Career Corner
110(2)
Contact Management for Paradise Realty
112(2)
Tasks and Notes for Step One Consulting
114(3)
PowerPoint 2002 Comprehensive Projects Appendix 117(17)
Geranium Bistro Business Plan Presentation
118(2)
Tips for Home Security Presentation
120(2)
Orientation Presentation for Camp Dream Quest
122(2)
Great Cathedrals of Europe Tour Presentation
124(2)
``How to Draw People'' Instructional Presentation
126(2)
Sales Presentation for Road Smart Driving School
128(2)
Lecture Presentation for E-Commerce Marketing
130(2)
Rainforest Coalition Web Pages
132(2)
Word Glossary 134(4)
Excel Glossary 138(12)
Access Glossary 150(8)
Outlook Glossary 158(3)
PowerPoint Glossary 161(5)
Index 166

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.