Microsoft Office 2003 : The Complete Reference,9780072229950

Microsoft Office 2003 : The Complete Reference

by
Edition: 2nd
ISBN13: 9780072229950
ISBN10: 0072229950
Format: Paperback
Pub. Date: 2003-09-25
Publisher(s): McGraw-Hill Osborne Media
  • Free Shipping Icon

    This Item Qualifies for Free Shipping!*

    *Excludes marketplace orders.

List Price: $41.99

Rent Book

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

New Book

We're Sorry
Sold Out

Used Book

We're Sorry
Sold Out

eBook

We're Sorry
Not Available

Buy from our Marketplace starting at $36.66

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

Office 2003: The Complete Reference is your one-stop resource to all of the major applications in Microsoft's latest Office Suite, which will be pre-loaded on new machines.

Author Biography

Jennifer Ackerman Kettell (Peoria, AZ) is the author of Dreamweaver 4: The Complete Reference and co-author with Molly Holzschlag of Special Edition Using Dreamweaver MX as well as a contributor to more than eight other books on web design and computer applications. She has provided documentation and training in Office applications for several large corporations. For more than 10 years, Jenn was an integral part of developing and managing several prominent online communities. In addition, she has designed Web sites for a wide range of professional, commercial and non-profit entities.

Table of Contents

Acknowledgments xxxv
Introduction xxxvii
Part 1 Common Office 2003 Elements
1 Getting to Know Office 2003
3(14)
The Office Suite of Programs
3(9)
Microsoft Word
4(2)
Microsoft Excel
6(1)
Microsoft PowerPoint
6(1)
Microsoft Outlook
7(1)
Microsoft Access
8(2)
Microsoft FrontPage
10(1)
Microsoft Publisher
11(1)
Collaborative Tools
12(1)
Installing Office 2003
12(3)
Getting Office Help
15(2)
2 Customizing the Office Environment
17(20)
Customizing Toolbars and Menus
17(6)
Displaying, Moving, and Customizing Toolbars
18(2)
Customizing Menus and Context Menus
20(1)
Controlling the Appearance of a Menu Item or Toolbar Button
21(1)
Customizing Keyboard Shortcuts in Word
21(2)
Setting Smart Tag Options
23(1)
AutoCorrect, Spell Checking, and Grammar Checking
24(10)
AutoCorrect
24(5)
Spell Checking
29(2)
Grammar Checking
31(3)
Improving Accessibility
34(1)
Using Office on Tablet PCs
34(1)
Configuring Options for Pen Input
35(1)
Using the Writing Tools
36(1)
3 Managing Files in Office
37(18)
Choosing Where to Store Your Files and Templates
37(2)
Coming to Grips with the My Documents Folder
37(1)
Changing the Working Folder for the Office Applications
38(1)
Changing the Templates Folders for Word, Excel, and PowerPoint
39(1)
Using Office over a Network
39(3)
Entering a Universal Naming Convention (UNC) Path
40(1)
Mapping a Network Drive to a Local Drive Letter
40(2)
Disconnecting a Network Drive
42(1)
Browsing with the My Network Places Folder
42(1)
Using Office over the Internet
42(1)
Creating Files
43(2)
Creating a New Default File
43(1)
Creating a File from the New Task Pane
43(2)
Creating a File from a Template in Windows Explorer
45(1)
Creating Your Own Templates
45(1)
Finding Files
45(5)
Performing a Basic File Search
46(1)
Performing an Advanced File Search
47(2)
Working with the Files You Find
49(1)
Using Office's Recovery Options Effectively
50(5)
Understanding What the Recovery Features Do
50(1)
Configuring the Backup and Recovery Options
51(1)
Using Microsoft Office Application Recovery to Close a Hung Application
51(1)
Recovering a Document
52(3)
4 Text Tools
55(22)
Entering Text
55(9)
Entering Text with the Keyboard
55(5)
Entering Text via Paste, and Drag and Drop
60(1)
Entering Text via Speech Recognition
61(1)
Entering Text via Scanning and OCR
62(2)
Formatting Text
64(3)
Cutting, Copying, and Pasting
67(3)
Understanding the Windows Clipboard and the Office Clipboard
67(1)
Using the Office Clipboard
68(1)
Configuring the Office Clipboard
69(1)
Using Paste Special and Smart Tags to Control Formatting on Pasted Items
69(1)
Selecting Text
70(2)
Selecting Text with the Mouse
71(1)
Selecting Text with the Keyboard
71(1)
Selecting Text with the Keyboard and Mouse
72(1)
Applying Paragraph Formatting
72(2)
Applying Alignment
72(1)
Applying Borders
73(1)
Using Find and Replace
74(3)
Finding Text
74(1)
Finding and Replacing Text
75(1)
Using Wildcard Characters in Searches
75(1)
Application-Specific Find and Replace Features
75(2)
5 Drawing and Graphics Tools
77(28)
How the Office Applications Handle Pictures
77(1)
Inserting Clip Art
78(4)
Working with Shapes, AutoShapes, and WordArt
82(11)
Starting a Drawing
82(1)
Adding Basic Shapes
83(1)
Adding AutoShapes
84(1)
Adding WordArt Objects to Your Drawings
84(2)
Adding Text to an AutoShape
86(1)
Resizing and Formatting Drawing Objects
87(2)
Positioning Drawing Objects
89(3)
Layering Drawing Objects
92(1)
Specifying Text-Wrapping Options
92(1)
Enhancing Your Documents with Text Boxes
92(1)
Adding Graphics to Your Documents
93(2)
Inserting (Embedding) a Picture
94(1)
Linking a Picture
94(1)
Using Insert and Link in Word and Outlook
95(1)
Cropping a Picture
95(1)
Importing Pictures from Scanners and Cameras
95(2)
Charts and Diagrams
97(8)
When to Use Microsoft Chart for Creating Charts
97(1)
Creating Basic Diagrams
98(2)
Creating Organization Charts
100(5)
Part II Word Processing
6 Word
105(20)
Word Task Pane
105(2)
Hiding the Task Pane
106(1)
Customizing Word Options
107(5)
View Options
107(1)
General Options
108(1)
Edit Options
109(1)
Print Options
110(1)
Save Options
111(1)
Track Changes
112(1)
Other Options
112(1)
Document Views
112(7)
Normal View
113(1)
Web Layout View
113(1)
Print Layout View
114(1)
Reading Layout View
114(2)
Outline View
116(1)
Splitting the Document Window
117(1)
Maximizing Screen Space
118(1)
Zoom
119(1)
Navigating in Word
119(3)
Keyboard Navigation
119(1)
Mouse Navigation
120(1)
Accessing the Document Map
120(1)
Using the Object Browser
121(1)
Printing Word Documents
122(3)
Using Print Preview
122(1)
Printing Thumbnails
122(3)
7 Editing Text
125(20)
Automatic Text Tools
125(6)
AutoCorrect
125(1)
AutoText
126(4)
Repeating Text
130(1)
Undo and Redo
131(1)
Text Formatting
131(4)
Changing Case
133(1)
Drop Caps
134(1)
Coloring and Highlighting Text
135(1)
Adding Special Characters
135(2)
Bullets and Numbering
137(8)
Automatic Bullets and Numbering
137(2)
Using the Bullets and Numbering Tools
139(1)
Customizing List Formats
140(1)
Multilevel Outline Lists
141(2)
Removing Bullets and Numbering
143(2)
8 Document Formatting
145(16)
Paragraph Formatting
145(4)
Alignment
145(1)
Line Spacing
146(2)
Paragraph Page Flow
148(1)
Indentation
149(4)
Tabs
150(2)
Using the Ruler
152(1)
Margins and Page Orientation
153(1)
Page and Section Breaks
154(3)
Section Breaks
155(2)
Headers and Footers
157(2)
Varying Headers and Footers
159(1)
Page Numbering
159(2)
9 Reusable Formatting with Styles and Templates
161(20)
AutoFormatting
161(3)
Paragraph and Character Styles
164(6)
Applying Styles
166(1)
Creating Styles
166(2)
Modifying Styles
168(1)
Using List and Table Styles
169(1)
Templates
170(5)
Modifying the Normal Template
171(1)
Attaching a Template
171(2)
Creating Your Own Templates
173(1)
Controlling Access to Styles
174(1)
The Style Gallery
175(1)
Themes
176(5)
Theme Assets and Liabilities
177(1)
Applying and Removing Themes
178(1)
Converting Themes into Templates
178(2)
Themes Across Applications
180(1)
10 Tables and Columns
181(16)
Tables
181(1)
Creating Tables
182(3)
Inserting Tables from the Menu
182(1)
Inserting Tables from the Toolbar
183(1)
Drawing Tables
183(1)
Converting Text to Tables
184(1)
Manipulating Tables
185(4)
Selecting Table Elements
186(1)
Inserting and Deleting Columns and Rows
186(1)
Adjusting Table Properties
186(2)
Merging and Splitting Cells
188(1)
Nesting Tables
189(1)
Splitting Tables
189(1)
Hiding Grid Lines
189(1)
Formatting Table Content
189(3)
Table Styles Using AutoFormat
189(1)
Changing Borders and Shading
190(1)
Rotating Text
190(1)
Repeating Headings
191(1)
Sorting Data
191(1)
Quick Math Calculations
192(1)
Columns
192(3)
Using Column Breaks
194(1)
Hyphenation
195(2)
11 Advanced Page Layout in Word
197(10)
Borders, Boxes, and Shading
198(3)
Borders
198(1)
Shading
199(1)
Horizontal Rules
200(1)
Page Fills and Backgrounds
201(3)
Page Backgrounds
201(3)
Watermarks
204(1)
Text Boxes
204(3)
Overflowing Text Boxes
205(2)
12 Automating Information with Fields
207(14)
Field Basics
207(6)
Field Switches
208(3)
Inserting Fields
211(1)
Toggling Field Codes
212(1)
Updating Field Content
213(1)
Common Fields
213(2)
Page Numbering
213(1)
Date and Time
213(1)
Document Properties
214(1)
AutoText Fields
215(1)
Creating Forms
215(6)
Adding Form Fields
216(2)
Web Forms
218(1)
Protecting Your Form
218(3)
13 Managing Long Documents
221(16)
Outlining
221(3)
Creating an Outline
221(1)
Changing Outline Level Styles
222(1)
Rearranging and Viewing the Outline
223(1)
Using Bookmarks in Long Documents
224(1)
Creating a Master Document
225(3)
Working with Subdocuments
226(1)
Page Numbering Across Documents
227(1)
Generating a Table of Contents
228(2)
Creating an Index
230(4)
Preparing Index Entries
230(1)
Generating the Index
231(1)
Other Types of Tables and Indexes
232(2)
Cross-References
234(1)
Formatting References
235(1)
Adding Footnotes
235(2)
14 Mail Merge, Labels, and Envelopes
237(14)
Using the Letter Wizard
237(1)
Mail Merges
238(6)
Creating a Database
241(2)
Filtering and Sorting a Database
243(1)
Generating Envelopes
244(2)
E-Postage
246(1)
Creating Labels
246(5)
Part III Spreadsheets
15 Excel
251(26)
Using and Hiding the Task Pane
251(1)
Hiding the Getting Started Task Pane
252(1)
Customizing Excel Options
252(5)
View Options
253(1)
Calculation Options
254(1)
Edit Options
255(1)
General Options
255(1)
Transition Options
256(1)
Save Options
256(1)
Loading and Unloading Add-Ins
256(1)
Using Worksheets and Workbooks
257(1)
Understanding the Excel Screen
258(1)
Navigating in Workbooks and Selecting Objects
258(6)
Navigating in Worksheets
258(2)
Selecting Cells and Ranges of Cells
260(3)
Selecting Worksheets in a Workbook
263(1)
Entering Data in Your Worksheets
264(4)
Entering Data Manually
264(1)
Entering Data by Using Drag and Drop
265(1)
Entering Data with Paste, Paste Options, and Paste Special
265(2)
Linking Data Across Worksheets or Across Workbooks
267(1)
Improving Your View with Hiding, Splits, Extra Windows, Zooming, and Freezing
268(1)
Hiding a Window
268(1)
Splitting the Window
268(1)
Using Extra Windows
269(1)
Zooming In and Out
269(1)
Using Freezing to Keep Some Rows and Columns Visible
269(1)
Converting from Other Formats
269(1)
Printing Worksheets
270(7)
Instant Printing with the Default Settings
270(1)
Using Print Preview
270(1)
Setting the Print Area
271(1)
Setting Page Breaks
272(1)
Modifying Print Settings
273(4)
16 Formatting Worksheets and Restricting Data
277(28)
Adding, Deleting, and Manipulating Worksheets
277(2)
Adding, Deleting, Hiding, and Redisplaying Worksheets
277(1)
Moving and Copying Worksheets
278(1)
Renaming a Worksheet
279(1)
Changing the Formatting on New Default Worksheets and Workbooks
279(1)
Formatting Cells and Ranges
279(14)
Applying Number Formatting
280(1)
Understanding Excel's Number Formats
281(6)
Applying Visual Formatting
287(1)
Formatting Rows and Columns
288(1)
Conditional Formatting
289(1)
AutoFormat
290(1)
Using Styles in Excel
291(2)
Restricting Data and Protecting Workbooks
293(7)
Checking Data Entry for Invalid Entries
293(3)
Protecting Cells, a Worksheet, or Workbook
296(1)
Protecting a Worksheet
297(1)
Allowing Users to Edit Ranges in a Protected Worksheet
297(2)
Protecting a Workbook with Passwords
299(1)
Using AutoFill
300(2)
Creating Custom AutoFill Lists
301(1)
Find and Replace
302(3)
17 Calculating with Formulas and Functions
305(26)
Understanding What Formulas and Functions Are
305(7)
Components of a Formula
305(3)
How Excel Handles Numbers
308(1)
Referring to Cells and Ranges in Your Formulas
308(1)
Referring to Other Worksheets in Your Formulas
308(1)
Example of Entering a Formula
309(1)
Using Range Names and Labels in Formulas
309(2)
Using Absolute, Relative, and Mixed References
311(1)
Displaying Formulas
311(1)
Hiding Your Formulas from Other Users
312(1)
Troubleshooting Formulas
312(3)
Understanding and Fixing Basic Errors
312(1)
Fixing Formatting, Operator Precedence, and Range-Change Errors
312(2)
Understanding Formula AutoCorrect
314(1)
Configuring Error-Checking Options
314(1)
Checking for Errors Manually
315(1)
Entering Functions
315(4)
Components of a Function
316(1)
Entering a Function
316(1)
Using the Insert Function Dialog Box
317(1)
Nesting One Function Inside Another Function
318(1)
Editing a Function
319(1)
Monitoring Calculations with the Watch Window
319(1)
Working with Array Formulas
319(1)
Goal Seeking
320(1)
Using the Solver
321(2)
Examples of Functions in Action
323(8)
Database Functions
323(1)
Date and Time Functions
323(1)
Financial Functions
324(1)
Logical Functions
325(1)
Information Functions
326(1)
Lookup and Reference Functions
327(1)
Mathematical and Trigonometric Functions
327(1)
Statistical Functions
328(1)
Text Functions
329(2)
18 Viewing and Manipulating Data with Charts and PivotTables
331(26)
Working with Charts
331(13)
Components of an Excel Chart
331(1)
Using the Chart Wizard
332(3)
Choosing the Right Type of Chart for Your Data
335(1)
Creating a Chart Instantly Using the Keyboard
336(1)
Editing Charts
336(4)
Formatting Charts
340(2)
Copying Formatting from One Chart to Another
342(1)
Unlinking a Chart from Its Data Source
342(1)
Printing Your Charts
343(1)
Creating Custom Chart Types
343(1)
Working with PivotTables
344(8)
What Is a PivotTable?
345(1)
Running the PivotTable and PivotChart Wizard
346(2)
Creating Your PivotTable
348(2)
Changing the PivotTable
350(1)
Using the PivotTable Toolbar
351(1)
Formatting a PivotTable
351(1)
Changing a Field to a Different Function
352(1)
Choosing PivotTable Options
352(1)
Working with PivotCharts
352(1)
Creating a Conventional Chart from PivotTable Data
353(4)
19 Creating Excel Databases
357(20)
Creating a Database
357(2)
Entering Data in Your Database
359(2)
Entering Data by Using Standard Techniques
359(1)
Entering and Editing Data with Data Entry Forms
359(2)
Sorting
361(2)
Preparing to Sort Your Database
361(1)
Performing a Quick Sort
361(1)
Performing a Multifield Sort
362(1)
Sorting by a Custom Sort Order
362(1)
Finding and Replacing Data in Databases
363(1)
Filtering
363(4)
Performing Quick Filtering with AutoFilter
363(2)
Creating Custom Filters Manually
365(2)
Linking to an External Database
367(6)
Linking to a Database with the Query Wizard
367(4)
Customizing a Query with MS Query
371(2)
Performing Web Queries
373(4)
Part IV Presentations
20 PowerPoint
377(12)
Exploring the PowerPoint Interface
377(5)
Menus in PowerPoint
377(2)
PowerPoint's Toolbars
379(2)
Outline/Slides Pane
381(1)
Work Area
381(1)
Starting a Presentation
382(4)
Using Blank Presentation
382(1)
From Design Template
382(2)
AutoContent Wizard
384(2)
Browsing a Presentation
386(1)
Saving a Presentation
387(2)
21 Creating and Editing Slides
389(18)
Working with Slides
389(2)
Add a Slide
389(1)
Remove a Slide
390(1)
Reorganize Slides
390(1)
Editing Slides
391(1)
Changing Text
391(1)
Changing Design
391(1)
Changing Layout
392(1)
Formatting Text
392(2)
Formatting Paragraphs
394(1)
Formatting Bullets and Numbering
395(2)
Adjusting a Placeholder Box
397(1)
Managing Placeholder Layout
398(1)
Checking Spelling and AutoCorrect Options
399(1)
Inserting a Table
399(2)
Entering Data
400(1)
Formatting Tables
400(1)
Insert Microsoft Word Table
401(1)
Inserting a Chart
401(2)
Creating a PowerPoint Chart
402(1)
Use a Microsoft Excel Chart
403(1)
Inserting an Organization Chart
403(1)
Inserting a Text Box
404(1)
Inserting an Object
405(1)
Inserting a Hyperlink
405(2)
22 Adding Graphics, Multimedia, and Special Effects to Slides
407(22)
Insert Clip Art and Photos
407(7)
Insert Clip Art
407(2)
Edit a Clip Art Image
409(3)
Insert a Photo
412(1)
Create a Photo Album
412(2)
Using Draw Tools
414(8)
Modify Shapes
414(2)
Modify Orientation
416(1)
Adjust an AutoShape
417(1)
Make a Shape 3-D
417(1)
Change a Shape's Fill Color
418(1)
Change an AutoShape
419(1)
Edit Line Properties
419(1)
Copy and Paste Shapes
420(1)
Align a Shape
420(1)
Manage Stack Order
420(2)
Create Shapes
422(5)
Draw Basic Shapes
422(1)
Draw an Arc and Other Standard Shapes
423(1)
Group Shapes
423(1)
Insert Text on Shapes
424(1)
Use Connectors
424(1)
Create a Flowchart
425(1)
Configure Action Buttons
426(1)
Inserting Multimedia Content
427(2)
23 Showing Your PowerPoint Presentations
429(14)
Transitions and Animation
429(3)
Setting Up Transitions
429(2)
Using Animation
431(1)
Getting Ready for Your Presentation
432(4)
Rehearsing Your Presentation
433(1)
Using Hidden Slides
433(1)
Using a Pen/Highlighter
434(1)
Set Up Show Options
435(1)
Printing Speaker Notes and Audience Handouts
436(7)
Add a Header and Footer
436(1)
Configure Print Settings
437(1)
Use Print Preview
437(2)
Print a Presentation
439(4)
Part V Schedule and Contact Management
24 Outlook
443(10)
A First Look at Outlook
443(3)
Mail
443(2)
Calendar
445(1)
Contacts
445(1)
Tasks
446(1)
Using Outlook's Toolbars
446(2)
Using Categories
448(1)
Data File Management
448(2)
Importing and Exporting Data
450(1)
Archiving Data
451(2)
25 Outlook E-mail
453(14)
Setting Up a Mail Account
453(1)
Sending and Receiving E-mail
454(6)
Reading E-mail
455(1)
Composing and Responding to E-mail
456(1)
Managing Attachments
457(3)
Configuring E-mail Options
460(4)
Standard E-mail Options
460(1)
Using a Signature
461(1)
Using Stationery
461(1)
Managing Automatic Send /Receive
462(1)
Flagging Messages
463(1)
Managing Mail
464(3)
Using Personal Folders
464(1)
Managing Junk E-mail
465(2)
26 Outlook Calendar and Task Lists
467(12)
Outlook Calendar
467(7)
Configuring Appointments
468(3)
Configuring Meetings
471(2)
Scheduling an Event
473(1)
Working with Reminders
473(1)
Calendar Management
473(1)
Using Tasks
474(5)
Creating a Task
474(2)
Assigning a Task
476(3)
27 Managing Contacts and Taking Notes
479(8)
Outlook Contacts
479(5)
Creating a Contact
479(3)
Viewing Contacts
482(1)
Editing Contact Information
482(1)
Working with Contacts
483(1)
Taking Notes
484(3)
Creating a Note
484(1)
Viewing Notes
485(1)
Changing a Note's Color
485(1)
Changing Note Preferences
485(2)
28 Scheduling and Planning with Others
487(8)
Sharing Your Calendar
487(2)
Accessing a Shared Calendar
487(1)
Hiding Personal Calendar Data
488(1)
Working with Free /Busy Times
488(1)
Working with Scheduled Meetings and Appointments
489(6)
Rescheduling a Shared Appointment or Meeting
490(1)
Changing Meeting Attendees
491(1)
Send an E-mail to the Meeting or Appointment Organizer
491(1)
Delete a Meeting or Appointment
491(4)
Part VI Databases
29 Databases in Access
495(18)
Access Components
495(2)
The Database Engine
495(2)
Databases and Projects
497(1)
Creating a Database
497(2)
Building a Blank Database
497(1)
Using a Template Wizard
497(2)
Choosing a File Format
499(1)
Converting a Database
499(1)
Creating a Project
499(1)
Upsizing a Database
500(1)
Running the Upsizing Wizard
501(1)
Importing and Exporting Data
501(3)
Importing Data
502(1)
Linking Data
503(1)
Exporting Data
503(1)
Database Objects
504(2)
Tables
504(1)
Queries
504(1)
Forms
505(1)
Reports
505(1)
Data Access Pages
505(1)
Macros
505(1)
Modules
506(1)
The Database Window
506(2)
Creating Objects
507(1)
Editing in Design View
507(1)
Customizing Access
508(5)
View Tab
509(1)
General Tab
509(1)
Edit/Find Tab
510(1)
DatasheetTab
510(1)
Forms/Reports Tab
510(1)
Pages Tab
510(1)
Advanced Tab
510(1)
Tables/Queries Tab
511(2)
30 Defining and Developing Tables
513(18)
Creating Tables
514(3)
Using the Table Wizard
514(2)
Table Design View
516(1)
Entering Fields
517(2)
Choosing Data Types
518(1)
Setting Field Properties
519(7)
Primary Keys
519(1)
Indexes
520(1)
Input Masks
520(2)
Format Properties
522(3)
Default Values
525(1)
Validation Rules
526(1)
Data Normalization
526(5)
Non-Normalized Example
527(1)
Normalized Example
528(1)
Table Relationships
528(3)
31 Creating Queries
531(20)
Query Types
531(9)
Select Queries
531(3)
Crosstab Queries
534(1)
Parameter Queries
535(1)
Action Queries
536(4)
Query Wizards
540(5)
Simple Query Wizard
541(1)
Crosstab Query Wizard
542(1)
Find Duplicates Query Wizard
543(1)
Find Unmatched Query Wizard
544(1)
Working in Query Design View
545(2)
Choosing Tables
545(1)
Choosing Fields
545(1)
Defining Query Criteria
546(1)
Performing Calculations
547(1)
SQL Queries
547(4)
Using SQL as a Record Source
547(2)
SQL-Specific Queries
549(2)
32 Forms and Reports
551(16)
Forms
551(10)
Anatomy of a Form
552(1)
Creating Forms
552(5)
Customizing Forms
557(2)
Linked Forms and Subforms
559(2)
Reports
561(6)
Report Layout
561(2)
Creating Reports
563(2)
Grouping and Sorting Records
565(2)
33 Building a Database Application
567(14)
Using a Database Application Wizard
567(2)
Templates Home Page
568(1)
Building Applications from Scratch
569(1)
Switchboards
569(3)
The Switchboard Manager
570(2)
Customizing the User Interface
572(4)
Adding Custom Menus and Toolbars
572(1)
Setting Startup Options
572(1)
Locking a Database
573(3)
Making an MDE File
576(1)
Making Data Available
576(5)
Linking to External Data
576(1)
Replicating a Database
577(4)
Part VII Web and Print Layout
34 Designing Pages and Sites in FrontPage
581(46)
Creating a New FrontPage Site
581(7)
Choosing a Design Template
583(1)
Deciding on a Structure for Your Site
583(1)
Importing an Existing Web Site
584(3)
Saving Your Web Site
587(1)
Getting Around in FrontPage
588(4)
Working with Pages in FrontPage
592(28)
Creating New Pages
593(1)
Applying a Theme to a Site
594(2)
Working with Text
596(2)
Formatting a Background
598(3)
Using Background Sounds
601(1)
Assigning Page Titles
602(1)
Using Photos and Clip Art
602(7)
Working with the Drawing Toolbar
609(2)
Inserting Web Components
611(5)
Inserting Tables
616(3)
Creating Hyperlinks
619(1)
Creating a New Theme
620(7)
Configuring Theme Colors
621(2)
Working with Custom Font Styles
623(2)
Creating Theme Graphics
625(2)
35 Advanced Management Features and Web Site Publishing
627(32)
Working with HTML in FrontPage
627(5)
Code and Split-Pane View
628(1)
Working with Tags
628(1)
Controlling Color Coding
629(1)
Finding and Replacing Text and Finding Line Numbers
629(1)
Using Custom HTML
629(1)
Working with Reveal Tags
630(1)
Managing HTML Preferences
630(2)
Working with Forms and Form Input
632(13)
Creating Forms
633(1)
Working with Form Templates
634(1)
Exploring Form Elements
635(4)
Confirmation Page
639(1)
Using the Form Page Wizard
639(3)
Gathering Form Input
642(3)
Managing Browser Compatibility
645(2)
Publishing Sites and Pages
647(5)
Choosing a Web Provider
648(2)
Publishing Your Site
650(1)
Updating Your Site
651(1)
Using Reports to Manage Your Web Site
652(7)
Site Summary
652(2)
Detailed Reports
654(3)
Setting Reports View Options
657(2)
36 Creating Publications in Publisher
659(14)
Creating Publications with Templates
659(2)
Creating Custom Publications
661(12)
Setting Up Publication Pages
661(4)
Working with Content
665(8)
37 Publishing Documents in Publisher
673(8)
Printing on Your Home or Office Printer
673(1)
Working with Professional Printers
673(4)
Color Printing
674(1)
Registration Settings
675(1)
Fonts
676(1)
Using Pack and Go
676(1)
Publishing to the Web
677(4)
Web Publishing and Photos
677(4)
Part VIII Integration and Collaboration
38 Using Office Applications Together
681(32)
Using the Clipboard
681(1)
Embedding and Linking Objects
682(6)
Understanding the Differences Between Embedding and Linking
682(1)
Choosing When to Embed and When to Link
683(1)
Verifying Whether an Object Is Linked or Embedded
684(1)
Embedding or Linking an Object
684(2)
Editing an Embedded Object
686(1)
Editing a Linked Object
687(1)
Editing, Updating, and Breaking Links
688(1)
Using Office's XML Capabilities
688(25)
What You're Likely to Do with XML Files
689(1)
Working with XML Documents in Word
689(2)
Creating XML Documents in Word
691(10)
Working with XML Files in Excel
701(2)
Creating XML Files in Excel
703(10)
39 Using Office on the Web
713(12)
HTML and Round Tripping
713(1)
Understanding the File Formats Available
714(1)
Single File Web Page Format
714(1)
Web Page Format
714(1)
Web Page, Filtered Format
714(1)
Publishing Documents on the Web
715(1)
Using Hyperlinks in Office Documents
715(1)
Choosing Web Options
716(3)
General Tab Options
716(1)
Browsers Tab Options
717(1)
Files Tab Options
718(1)
Pictures Tab Options
718(1)
Encoding Tab Options
718(1)
Fonts Tab Options
718(1)
Saving a File as a Web Page
719(6)
Using Web Page Preview to Check How Your File Looks
719(1)
Setting the Page Title
719(1)
Saving a Word Document as a Web Page
719(2)
Saving an Excel Worksheet or Workbook as a Web Page
721(1)
Saving a PowerPoint Presentation as a Web Page
722(2)
Saving an Access Data Access Page as a Web Page
724(1)
40 Collaboration Using Office Tools and SharePoint Team Services
725(30)
Review Tools
725(11)
Tracking Changes in Word Documents
725(5)
Tracking Changes in Excel Workbooks
730(3)
Comparing and Merging Documents in Word
733(2)
Comparing and Merging Changes in PowerPoint
735(1)
Securing Documents
736(2)
Securing Documents with Passwords
737(1)
Specifying an Encryption Type for a Document
737(1)
Removing Personal Information from Document Properties
738(1)
Working with Comments
738(3)
How Comments Work
738(1)
Using Comments in Word
739(1)
Using Comments in Excel
739(1)
Using Comments in PowerPoint
740(1)
Sending Documents in E-mail
741(6)
Sending a Document for Review
741(1)
Receiving and Returning a Document Sent for Review
742(1)
Sending and Receiving a Document as an Attachment
743(1)
Sending and Receiving a Word Document or Excel Worksheet in a Message
743(1)
Routing a Word Document or Excel Workbook Among a Group of People
744(2)
Receiving a Routed Document or Workbook
746(1)
Using SharePoint Team Services
747(8)
Anatomy of a SharePoint Site
747(1)
Understanding Permissions on SharePoint Sites
748(1)
Accessing a SharePoint Site
748(1)
Managing Documents Within SharePoint
748(2)
Synchronizing Documents with SharePoint Sites
750(5)
Part IX Macros and Visual Basic for Applications
41 Creating and Using Office Macros
755(16)
Understanding Macros
755(1)
Understanding Office's Macro Virus-Protection Features
756(4)
Understanding and Setting Security Levels
756(3)
Digital Signatures
759(1)
Recording Macros
760(2)
Testing and Running Your Macros
762(3)
Running a Macro from the Macros Dialog Box
763(1)
Running a Macro from an Interface Item
763(2)
Storing Your Macros
765(2)
Storing Your Macros in Word
766(1)
Storing Your Macros in Excel
766(1)
Storing Your Macros in PowerPoint
767(1)
Storing Your Macros in Access
767(1)
Storing Your Macros in Outlook
767(1)
Recording the Sample Macros
767(4)
Recording the Sample Macro in Word
767(1)
Recording the Sample Macro in Excel
768(3)
42 Using Visual Basic for Applications with Office
771(18)
Understanding VBA
771(2)
Understanding Objects, Properties, and Methods
772(1)
VBA Projects and Their Components
773(1)
Modules
773(1)
Userforms
773(1)
Classes
773(1)
Procedures, Subprocedures, Macros, and Functions
773(1)
Using the Visual Basic Editor
774(7)
Launching the Visual Basic Editor
774(1)
Getting Acquainted with the Visual Basic Editor
774(3)
Returning to the Host Application
777(1)
Using the Visual Basic Editor's Features for Creating Code
777(4)
Running Code
781(3)
Design Mode, Run Mode, and Break Mode
781(1)
Running a Macro from the Visual Basic Editor
781(1)
Interrupting Code When It's Running
781(1)
Stepping into a Procedure
782(1)
Setting a Line of Code to Be the Next Statement
782(1)
Executing Code in the Immediate Window
782(1)
Following the Value of Expressions as Code Runs
783(1)
Managing Your Macros, Modules, Userforms, and Classes
784(1)
Creating a Module, Userform, or Class
784(1)
Copying or Moving a Macro
784(1)
Renaming a Macro or Module
784(1)
Deleting a Macro or Module
784(1)
Copying and Moving Modules, Userforms, or Classes
785(1)
Exporting and Importing Modules, Userforms, and Classes
785(1)
Examining the Recorded Macros
785(4)
Examining and Editing the Word Macro
785(3)
Examining the Excel Macro
788(1)
43 Putting VBA and Macros to Work
789(28)
Working with Variables
789(3)
VBA's 12 Types of Variables
789(1)
Declaring and Using a Variable
789(3)
Recommendations for Declaring Variables Effectively
792(1)
Making Decisions with If and Select Case
792(2)
If Statements
792(1)
Select Case Structures
793(1)
Using Message Boxes and Input Boxes
794(3)
Input Boxes
796(1)
Using Loops to Repeat Actions
797(3)
Creating the IsAlphanumeric Function
798(2)
Calling One Procedure from Another Procedure
800(2)
Adding a Reference to Another Project or Application
800(1)
Accessing Another Application
801(1)
Using the Call Stack Window to Track Procedure Calls
802(1)
Creating Dialog Boxes
802(10)
Creating the Userform
803(1)
Adding the Frames
804(1)
Adding the Option Buttons
805(1)
Adding the Check Boxes
805(1)
Creating the Initialize Subprocedure for the Userform
806(1)
Adding the Label and Text Box
807(1)
Adding the Command Buttons
808(4)
Calling the Userform from the Macro
812(1)
Distributing a VBA Project
812(17)
Signing Your VBA Project
812(1)
Locking Your VBA Project
813(4)
Part X Appendixes
A Keyboard Shortcuts
817(12)
B XML: The Underpinnings of Office 2003
829(8)
What Is XML?
829(1)
What Is XML For?
830(1)
What Benefits Does XML Offer?
830(1)
How XML Is Implemented in Office
831(1)
XML Terms and Components
832(5)
XML Files
832(1)
XML Schemas and DTDs
833(1)
Namespaces
833(1)
Elements
834(1)
Attributes
835(1)
Comments
835(2)
Index 837

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.