| It means this book has been approved by the Microsoft Office Specialist program to be certified courseware for learning Microsoft Office 2003 and preparing for the certification exam. This book will prepare you fully for the certification exam at the specialist level for Microsoft Office Word, Microsoft Office Excel, Microsoft Office PowerPoint, Microsoft Office Access, and Microsoft Office Outlook. Each certification level has a set of objectives, which are organized into broader skill sets. Throughout this book, content that pertains to a Microsoft Office Specialist objective is identified with the Microsoft Office Specialist logo and objective number below the title of the topic:  Word 2003 Specialist Objectives | Objective | Skill | Page | | WW03S-1 | Creating Content | | WW03S-1-1 | Insert and edit text, symbols and special characters | 30, 94-96, 126 | WW03S-1-2 | Insert frequently used and pre-defined text | 92-93, 123 | WW03S-1-3 | Navigate to specific content | 32, 83, 86 | WW03S-1-4 | Insert, position and size graphics | 56, 58, 62, 64 | WW03S-1-5 | Create and modify diagrams and charts | 68-71 | WW03S-1-6 | Locate, select and insert supporting information | 44-45 | | WW03S-2 | Organizing Content | | WW03S-2-1 | Insert and modify tables | 128-129, 132, 134-139 | WW03S-2-2 | Create bulleted lists, numbered lists and outlines | 90, 116-117 | WW03S-2-3 | Insert and modify hyperlinks | 454-457 | | WW03S-3 | Formatting Content | | WW03S-3-1 | Format text | 100-105, 112-115 | WW03S-3-2 | Format paragraphs | 106-107, 109-111, 128-129 | WW03S-3-3 | Apply and format columns | 130-131 | WW03S-3-4 | Insert and modify content in headers and footers | 120-122 | WW03S-3-5 | Modify document layout and page setup | 88-89, 118 | | WW03S-4 | Collaborating | | WW03S-4-1 | Circulate documents for review | 468-469 | WW03S-4-2 | Compare and merge document versions | 43, 146 | WW03S-4-3 | Insert, view and edit comments | 41 | WW03S-4-4 | Track, accept and reject proposed changes | 42 | | WW03S-5 | Formatting and Managing Documents | | WW03S-5-1 | Create new documents using templates | 8, 124 | WW03S-5-2 | Review and modify document properties | 147 | WW03S-5-3 | Organize documents using file folders | 10-11 | WW03S-5-4 | Save data in appropriate formats for different uses | 12-13, 460 | WW03S-5-5 | Print documents, envelopes and labels | 98, 144 | WW03S-5-6 | Preview documents and Web pages | 97, 459 | WW03S-5-7 | Change and organize document views and windows | 81-85, 103, 119, 126 | | Excel 2003 Specialist Objectives | Objective | Skill | Page | | XL03S-1 | Creating Data and Content | | XL03S-1-1 | Enter and edit cell content | 154-159 | XL03S-1-2 | Navigate to specific cell content | 32, 153 | XL03S-1-3 | Locate, select and insert supporting data | 44-45 | XL03S-1-4 | Insert, position, and size graphics | 56, 58, 62-64 | | XL03S-2 | Analyzing Data | | XL03S-2-1 | Filter lists using AutoFilter | 198-199 | XL03S-2-2 | Sort lists | 198-199 | XL03S-2-3 | Insert and modify formulas | 174-175, 177, 179 | XL03S-2-4 | Use statistical, date and time, financial, and logical functions | 180-181 | XL03S-2-5 | Create, modify, and position diagrams and charts based on worksheet data | 56, 186-189 | | XL03S-3 | Formatting Data and Content | | XL03S-3-1 | Apply and modify cell formats | 202-203, 205, 207-208 | XL03S-3-2 | Apply and modify cell styles | 209 | XL03S-3-3 | Modify row and column formats | 162-164, 204 | XL03S-3-4 | Format worksheets | 170, 212 | | XL03S-4 | Collaborating | | XL03S-4-1 | Insert, view and edit comments | 41 | | XL03S-5 | Managing Workbooks | | XL03S-5-1 | Create new workbooks from templates | 8-9 | XL03S-5-2 | Insert, delete and move cells | 28-29, 160 | XL03S-5-3 | Create and modify hyperlinks | 454-457 | XL03S-5-4 | Organize worksheets | 166-168 | XL03S-5-5 | Preview data in other views | 213, 219, 459 | XL03S-5-6 | Customize Window layout | 16, 170-172 | XL03S-5-7 | Setup pages for printing | 213-215, 218 | XL03S-5-8 | Print data | 216-217, 220 | XL03S-5-9 | Organize workbooks using file folders | 10-11 | XL03S-5-10 | Save data in appropriate formats for different uses | 12-13, 460-461 | | PowerPoint 2003 Specialist Objectives | Objective | Skill | Page | | PP03S-1 | Creating Content | | PP03S-1-1 | Create new presentations from templates | 8, 222-224 | PP03S-1-2 | Insert and edit text-based content | 44-45, 230-231, 252, 500 | PP03S-1-3 | Insert tables, charts and diagrams | 68-71, 250 | PP03S-1-4 | Insert pictures, shapes and graphics | 60-64 | PP03S-1-5 | Insert objects | 251, 491-493 | | PP03S-2 | Formatting Content | | PP03S-2-1 | Format text-based content | 32, 104-105, 232 | PP03S-2-2 | Format pictures, shapes and graphics | 56, 58, 66, 242, 244-247 | PP03S-2-3 | Format slides | 224, 228, 233, 243 | PP03S-2-4 | Apply animation schemes | 258-261 | PP03S-2-5 | Apply slide transitions | 256-257 | PP03S-2-6 | Customize slide templates | 13 | PP03S-2-7 | Work with masters | 238-239, 269, 271 | | PP03S-3 | Collaborating | | PP03S-3-1 | Track, accept and reject changes in a presentation | 42 | PP03S-3-2 | Add, edit and delete comments in a presentation | 41 | PP03S-3-3 | Compare and merge presentations | 43 | | PP03S-4 | Managing and Delivering Presentations | | PP03S-4-1 | Organize a presentation | 226-228, 236-237, 246, 454-457 | PP03S-4-2 | Set up slide shows for delivery | 254-255, 264-265 | PP03S-4-3 | Rehearse timing | 262 | PP03S-4-4 | Deliver presentations | 267-268 | PP03S-4-5 | Prepare presentations for remote delivery | 274-276 | PP03S-4-6 | Save and publish presentations | 10-12, 274-275, 460, 464 | PP03S-4-7 | Print slides, outlines, handouts, and speaker notes | 272-273 | PP03S-4-8 | Export a presentation to another Microsoft Office program | 504 | | Access 2003 Specialist Objectives | Objective | Skill | Page | | AC03S-1 | Structuring Databases | | AC03S-1-1 | Create Access databases | 280-282 | AC03S-1-2 | Create and modify tables | 290-291, 295 | AC03S-1-3 | Define and create field types | 295-297, 299 | AC03S-1-4 | Modify field properties | 297-298 | AC03S-1-5 | Create and modify one-to-many relationships | 302-303 | AC03S-1-6 | Enforce referential integrity | 304 | AC03S-1-7 | Create and modify queries | 310-311, 314, 316-319 | AC03S-1-8 | Create forms | 324-325 | AC03S-1-9 | Add and modify form controls and properties | 328-329 | AC03S-1-10 | Create reports | 330-332 | AC03S-1-11 | Add and modify report controls properties | 334-335 | AC03S-1-12 | Create a data access page | 340-341 | | AC03S-2 | Entering Data | | AC03S-2-1 | Enter, edit and delete records | 292 | AC03S-2-2 | Find and move among records | 292-293 | AC03S-2-3 | Import data to Access | 294, 491 | | AC03S-3 | Organizing Data | | AC03S-3-1 | Create and modify calculated fields and aggregate functions | 315 | AC03S-3-2 | Modify form layout | 336-337, 339 | AC03S-3-3 | Modify report layout and page setup | 332-333, 338-339, 343 | AC03S-3-4 | Format datasheets | 342 | AC03S-3-5 | Sort records | 306 | AC03S-3-6 | Filter records | 307-308 | | AC03S-4 | Managing Databases | | AC03S-4-1 | Identify and modify object dependencies | 320 | AC03S-4-2 | View objects and object data in other views | 340-341, 344 | AC03S-4-3 | Print database objects and data | 344-345 | AC03S-4-4 | Export data from Access | 490-499, 502 | AC03S-4-5 | Back up a database | 321 | AC03S-4-6 | Compact and repair databases | 322 | | Outlook 2003 Specialist Objectives | Objective | Skill | Page | | OL03S-1 | Messaging | | OL03S-1-1 | Originate and respond to e-mail and instant messages | 358-359, 368-369, 384 | OL03S-1-2 | Attach files to items | 361, 386 | OL03S-1-3 | Create and modify a personal signature for messages | 363-364 | OL03S-1-4 | Modify e-mail message settings and delivery options | 360, 365, 367 | OL03S-1-5 | Create and edit contacts | 354, 382 | OL03S-1-6 | Accept, decline, and delegate tasks | 400 | | OL03S-2 | Scheduling | | OL03S-2-1 | Create and modify appointments, meetings, and events | 390-393 | OL03S-2-2 | Update, cancel, and respond to meeting requests | 394-395 | OL03S-2-3 | Customize Calendar settings | 389 | OL03S-2-4 | Create, modify, and assign tasks | 398, 400-401 | | OL03S-3 | Organizing | | OL03S-3-1 | Create and modify distribution lists | 357 | OL03S-3-2 | Link contacts to other items | 403 | OL03S-3-3 | Create and modify notes | 410 | OL03S-3-4 | Organize items | 356, 370-371, 374-375, 408-409 | OL03S-3-5 | Organize items using Folders | 372-375, 379 | OL03S-3-6 | Search for items | 370, 376-377 | OL03S-3-7 | Save items in different file formats | 12 | OL03S-3-8 | Assign items to categories | 407 | OL03S-3-9 | Preview and print items | 411-412 | | |
