Microsoft Office 2003

by Hunt,Marjorie S.

• ISBN13: 9780619188252
• ISBN10: 0619188251
• Edition: 1st
• Format: Spiral Bound
• Copyright: 2003-12-30
• Publisher: Cengage Learning

Summary

Updated version for Microsoft Office 2003 including the new features in Word, Excel, Access, and PowerPoint with additional challenging exercises and higher level tasks.

Table of Contents

Preface	iv
OFFICE 2003
Unit A: Getting Started with Microsoft Office 2003	1	(22)
Understanding Office 2003 Professional	2	(2)
Starting an Office Program	4	(2)
Using Menus, Toolbars, and the Task Pane	6	(2)
Saving, Printing, and Closing a File	8	(2)
Naming files
Using Help	10	(2)
Creating a New File with a Wizard	12	(2)
Exiting an Office Program	14	(2)
Concepts Review	16	(1)
Skills Review	17	(2)
Independent Challenges	19	(3)
Visual Workshop	22	(1)
WORD 2003
Unit B: Creating a Document	23	(24)
Creating a New Document from an Existing File	24	(2)
Entering Text In a Document	26	(2)
Using AutoCorrect
Editing Text	28	(2)
Using Click and Type
Copying and Pasting Text	30	(2)
Moving Text	32	(2)
Activating the Office Clipboard
Finding and Replacing Text	34	(2)
Using the Find command
Checking Spelling and Grammar	36	(2)
Using smart tags
Previewing and Printing a Document	38	(2)
Concepts Review	40	(1)
Skills Review	41	(2)
Independent Challenges	43	(3)
Visual Workshop	46	(1)
WORD 2003
Unit C: Enhancing a Document	47	(24)
Changing Font Type and Size	48	(2)
Changing Font Color, Style, and Effects	50	(2)
Changing Alignment and Line Spacing	52	(2)
Changing Margin Settings	54	(2)
Setting Tabs	56	(2)
Setting Indents	58	(2)
Adding Bulleted and Numbered Lists	60	(2)
Using AutoFormat
Applying and Modifying Styles	62	(2)
Concepts Review	64	(1)
Skills Review	65	(2)
Independent Challenges	67	(3)
Visual Workshop	70	(1)
WORD 2003
Unit D: Adding Special Elements to a Document	71	(24)
Creating a Table	72	(2)
Creating multiple columns
Inserting and Deleting Table Columns and Rows	74	(2)
Creating a table with the Draw Table button
Formatting a Table	76	(2)
Inserting WordArt	78	(2)
Adding Clip Art	80	(2)
Inserting pictures, sounds, and videos
Inserting a Footnote	82	(2)
Working with long documents
Inserting a Header or Footer	84	(2)
Adding Borders and Shading	86	(2)
Inserting manual page breaks
Concepts Review	88	(1)
Skills Review	89	(2)
Independent Challenges	91	(3)
Visual Workshop	94	(1)
EXCEL 2003
Unit E: Creating and Enhancing a Worksheet	95	(26)
Navigating a Workbook	96	(2)
Entering Numbers and Labels	98	(2)
Using data entry keys
Changing Column Width and Row Height	100	(2)
Using Formulas	102	(2)
Understanding absolute cell references
Editing a Worksheet	104	(2)
Changing Alignment and Number Format	106	(2)
Changing to number format
Changing Fonts and Adding Borders	108	(2)
Adding shading of cells
Saving a Worksheet as a Web Page	110	(2)
Previewing and Printing a Worksheet	112	(2)
Adding headers and footers
Concepts Review	114	(1)
Skills Review	115	(2)
Independent Challenges	117	(3)
Visual Workshop	120	(1)
EXCEL 2003
Unit F: Using Complex Formulas, Functions, and Lists	121	(24)
Creating Complex Formulas	122	(2)
Understanding Functions	124	(2)
Planning to use functions
Using the SUM Function	126	(2)
Mathematical functions
Using Date and Time Functions	128	(2)
Understanding how dates are calculated using serial values
Using Statistical Functions	130	(2)
Using Excel templates on the Web
Using Financial Functions	132	(2)
Sorting Rows in a List	134	(2)
Filtering List Data	136	(2)
Concepts Review	138	(1)
Skills Review	139	(2)
Independent Challenges	141	(3)
Visual Workshop	144	(1)
EXCEL 2003
Unit G: Creating a Chart	145	(24)
Understanding and Planning a Chart	146	(2)
Creating a Chart	148	(2)
Moving and Resizing a Chart and Chart Objects	150	(2)
Changing the Chart Type	152	(2)
Adding Axis Titles and Gridlines	154	(2)
Adding data labels to a chart
Changing Chart Fonts and Colors	156	(2)
Enhancing a Chart	158	(2)
Enhancing a chart: guidelines
Adding Headers and Footers and Printing a Chart	160	(2)
Adding custom headers and footers
Concepts Review	162	(1)
Skills Review	163	(2)
Independent Challenges	165	(3)
Visual Workshop	168	(1)
ACCESS 2003
Unit H: Creating a Database	169	(24)
Understanding Databases	170	(2)
Creating a Database and a Table	172	(2)
Choosing the best Access file format
Designing a Table	174	(2)
Modifying a Table	176	(2)
Working In Datasheet view
Creating a Data Entry Form	178	(2)
Entering Data into a Form	180	(2)
Adding and Editing Records	182	(2)
Printing a Database and Exiting Access	184	(2)
Concepts Review	186	(1)
Skills Review	187	(2)
Independent Challenges	189	(3)
Visual Workshop	192	(1)
ACCESS 2003
Unit I: Working with Forms and Data	193	(24)
Opening an Existing Database	194	(2)
Opening more than one database file at a time
Changing a Form's Layout	196	(2)
Understanding the parts of a form
Formatting Controls on a Form	198	(2)
Changing tab order
Adding a Graphic to a Form	200	(2)
Adding a bound image to a form
Filtering Records in a Table	202	(2)
Sorting Records in a Table	204	(2)
Creating Queries	206	(2)
Protecting a Database	208	(2)
Concepts Review	210	(1)
Skills Review	211	(2)
Independent Challenges	213	(3)
Visual Workshop	216	(1)
ACCESS 2003
Unit J: Creating Database Reports	217	(24)
Creating a Report	218	(2)
Resizing, Deleting, and Moving Controls	220	(2)
Formatting a Report	222	(2)
Printing a Report	224	(2)
Creating a Report from a Query	226	(2)
Adding Summary Information to a Report	228	(2)
Adding an Expression to a Report	230	(2)
Creating Mailing Labels	232	(2)
Modifying labels in Design view
Concepts Review	234	(1)
Skills Review	235	(2)
Independent Challenges	237	(3)
Visual Workshop	240	(1)
POWERPOINT 2003
Unit K: Creating a Presentation	241	(24)
Creating a Presentation from a Design Template	242	(2)
Creating a presentation using the AutoContent Wizard
Entering Text In the Slide Pane	244	(2)
Entering Text In the Outline Tab	246	(2)
Viewing a Presentation	248	(2)
Formatting Text	250	(2)
Adding Shapes	252	(2)
Adding Text Boxes	254	(2)
Working with stacked objects
Printing Handouts	256	(2)
Concepts Review	258	(1)
Skills Review	259	(1)
Independent Challenges	260	(4)
Visual Workshop	264	(1)
POWERPOINT 2003
Unit L: Polishing and Running a Presentation	265	(24)
Applying and Customizing Color Schemes	266	(2)
Adding Clip Art	268	(2)
Working with Images	270	(2)
Customizing a Slide Show	272	(2)
Packaging PowerPoint presentations on a CD
Setting Slide Timings and Transitions	274	(2)
Animating Slide Objects	276	(2)
Preparing for an offsite presentation
Creating Speaker Notes	278	(2)
Concepts Review	280	(1)
Skills Review	281	(3)
Independent Challenges	284	(4)
Visual Workshop	288	(1)
OFFICE 2003
Unit M: Integrating Office 2003 Programs	289	(24)
Embedding an Excel Chart in a PowerPoint Slide	290	(2)
Sending a PowerPoint Presentation to Word	292	(2)
Inserting Word text in a PowerPoint slide presentation
Inserting a Word File in a Word Document	294	(2)
Using drag and drop to insert an Access table into Word
Linking an Excel Worksheet to a Word Document	296	(2)
Updating a Linked Excel Worksheet	298	(2)
Unlinking files
Inserting Access Fields in a Word Form Letter	300	(2)
Merging Access Data and Word Text to Create a Form Letter	302	(2)
Using the Mail Merge toolbar
Saving an Office Document as a Web Page	304	(2)
Concepts Review	306	(1)
Skills Review	307	(2)
Independent Challenges	309	(3)
Visual Workshop	312	(1)
Glossary	313	(10)
Index	323