List of Figures

Chapter 1: A First Look at the Microsoft Office System

Figure 1-1: The most common way to start an Office System application begins with the Start menu.

Figure 1-2: Choose the New Office Document command at the top of the All Programs menu when you want to begin a new document in the Office System.

Figure 1-3: Office searches online to display results related to the topic you enter.

Figure 1-4: Press F1 to display Help choices that take you to Office Online.

Figure 1-5: The Templates Home page offers dozens of document templates for download.

Figure 1-6: Detect And Repair can be your answer when an Office program is behaving strangely.

Chapter 2: Working with Programs and Files

Figure 2-1: The Windows taskbar is where the action begins in the Office System.

Figure 2-2: You can use the Windows Task Manager when you want to check the status of your programs or switch to a different one.

Figure 2-3: You can resize multiple windows so that you can see the necessary data for the work youre doing.

Figure 2-4: The Open Office Document dialog box lists all the Office files in the current folder and shows their program icons.

Figure 2-5: You save files using the Save As dialog box.

Chapter 3: Creating and Viewing Documents

Figure 3-1: In the New Document task pane, you choose the type of document you want to create.

Figure 3-2: The Templates dialog box shows you all the types of documents you can create.

Figure 3-3: The new Reading Layout pane is designed to give you flexibility and clarity for viewing documents.

Figure 3-4: The Shared Document task pane provides a number of tabs that give you different types of information about the shared file.

Figure 3-5: The Research task pane makes it possible for you to find what you need without interrupting your work.

Chapter 4: Using the Editing Tools in Microsoft Office Word 2003

Figure 4-1: Click a red- underlined word or phrase in your document to display the short-cut menu.

Figure 4-2: AutoCorrect checks for a number of errors automatically, but you can always add your own.

Figure 4-3: You can control the smart tags you want to use in your documents.

Figure 4-4: The Find And Replace dialog box enables you to make changes quickly throughout your document.

Figure 4-5: Word takes care of the spelling and grammar check in the same procedure.

Figure 4-6: The Thesaurus gives you the option of choosing the dictionary you want to use and inserting, copying, or looking up selected words.

Figure 4-7: Tracking enables you to see what has been done to a document during the editing process.

Figure 4-8: You can change the color and style of your changes, as well as the way in which changes appear, in the Track Changes dialog box.

Figure 4-9: Now you can use the speech features to insert a voice comment directly into a document.

Chapter 5: Formatting in Microsoft Word

Figure 5-1: You can have Word do a quick AutoFormat based on the document style you select.

Figure 5-2: Word includes themes that coordinate the heading, text, link, and list styles used in your documents.

Figure 5-3: You can use the Paragraph dialog box to change spacing.

Figure 5-4: You can use the Tabs dialog box to set tabs at specific points in your document and add leaders .

Figure 5-5: You can change the style of bullets and numbers Word uses in the lists you create.

Figure 5-6: You can use the Insert Table tool to create a simple table quickly.

Figure 5-7: In the Table AutoFormat dialog box, you can choose the table style you want and add your own enhancements, if necessary.

Figure 5-8: You can easily create multiple columns in your Word documents.

Figure 5-9: Youll use the Styles And Formatting task pane to work with styles in your document.

Chapter 6: Special Tasks in Microsoft Office Word 2003

Figure 6-1: Add clip art by selecting it from the Clip Art task pane.

Figure 6-2: Word includes six types of diagrams you can create on the fly.

Figure 6-3: You add hyperlinks for text and images in your Word documents using the Insert Hyperlink dialog box.

Figure 6-4: You can select and add a schema to your current document in the XML Schema tab of the Templates And Add-Ins dialog box.

Figure 6-5: The task pane displays the tree structure of the current XML document and enables you to click and add tags while you work.

Figure 6-6: Words indexing feature is a bit more complex than ordinary tasks, but worth the effort to learn.

Figure 6-7: You can record a macro to automate tasks you find yourself performing over and over and over.

Chapter 7: Creating and Saving a Spreadsheet

Figure 7-1: The Excel window provides the workspace for your worksheets and data lists.

Figure 7-2: You can use the AutoFill button to fill data in a sequential series.

Figure 7-3: The Insert Function dialog box gives you three ways to find the function you need.

Figure 7-4: When you choose Shared Workspace from the Tools menu, you create a Web site team members can access to edit, discuss, and collaborate on your project.

Figure 7-5: The various tabs in the Shared Workspace task pane give you information about the project youre working on.

Figure 7-6: Preparing an XML file in Excel 2003 is literally as simple as drag-and-drop.

Chapter 8: Editing, Formatting, and Printing Spreadsheets

Figure 8-1: Paste Options enable you to preserve the format of the cells you paste.

Figure 8-2: AutoFormat gives you a number of fast formats to apply to selected data.

Figure 8-3: You can control all kinds of formatting tasks in the Format Cells dialog box.

Figure 8-4: Make your changes for text font, style, size , and color on the Font tab of the Format Cells dialog box.

Chapter 9: Charting Spreadsheet Data

Figure 9-1: The most common chart types share these traditional chart elements.

Figure 9-2: Click the Chart Wizard tool to start the process.

Figure 9-3: You can easily change the perspective of your chart by changing rows to columns in the Chart Source Data window.

Figure 9-4: The chart displayed by Columns.

Chapter 10: Creating a PresentationFrom Start to Finish

Figure 10-1: The Getting Started task pane gives you quick access to Microsoft Online when you launch PowerPoint.

Figure 10-2: You use the Page Setup dialog box to tell PowerPoint how to gauge the size of the slides you want to create.

Figure 10-3: The Slide Design task pane displays all the professional designs you can use for your own presentation.

Figure 10-4: The AutoContent Wizard suggests topics, content, charts , and more for specific types of presentations.

Figure 10-5: The Slide Layout task pane presents you with different slide choices for the one you add.

Figure 10-6: Enter chart data and labels in the datasheet.

Figure 10-7: You can rearrange your slides easily in Slide Sorter view.

Figure 10-8: The navigation controls are easy to use, and give you options while you are presenting.

Figure 10-9: The presentation displayed as a Web page.

Chapter 11: Animating and Timing Your Presentation

Figure 11-1: Slide Sorter view enables you to fine-tune your almost-done presentation.

Figure 11-2: You make some basic choices for the way your presentation will operate in the Set Up Show dialog box.

Figure 11-3: A list of animation schemes appears in the task pane. Click one to see its effectthe selected slide shows the result.

Figure 11-4: When you want to control the appearance of individual objects on a slide, use the Custom Animation task pane.

Figure 11-5: Choose the slide transition you want from the displayed list and watch the selected slide to see the effect.

Figure 11-6: Speaker Notes enable you to add presentation suggestions and comments for others who might be giving your presentation.

Chapter 12: Enhancing Your Presentations

Figure 12-1: You can choose the clip you want to add by clicking it in the Insert Clip Art task pane.

Figure 12-2: Use the Record Sound dialog box to capture customized sound elements for your presentation.

Figure 12-3: Choose the CD track you want to play, and then click OK.

Figure 12-4: The Record Narration box provides everything you need for setting up and recording narrations .

Chapter 13: E-Mailing with Microsoft Office Outlook 2003

Figure 13-1: Outlooks new design makes it easy to move among views and enter and organize information.

Figure 13-2: When you start Instant Messaging, you are asked for your .NET Passport user name and password.

Figure 13-3: Trading text is only one part of what you can do with Instant Messaging.

Figure 13-4: You control the status displayed to others within Windows Messenger.

Figure 13-5: The received message appears in the Preview pane.

Figure 13-6: Now you can respond to meeting invitations with a single click.

Figure 13-7: You can send a shared attachment to others when you are working on a collaborative document.

Chapter 14: Organizing with Microsoft Office Outlook 2003

Figure 14-1: You can choose to view your messages in many different ways.

Figure 14-2: Enter a name and choose a location for the new folder.

Figure 14-3: You can create e-mail rules to have Outlook take action whenever certain e-mail messages are received.

Figure 14-4: The New Item Alerts dialog box lists the new alerts related to the rule you created.

Figure 14-5: Choose the flag type you want to assign to the selected message.

Figure 14-6: You indicate which messages you want to search for in the New Search Folder dialog box.

Figure 14-7: When you mark a message as not junk, the sender is added to the Trusted Sender List.

Figure 14-8: The AutoArchive feature files away or deletes old e-mail messages according to your instructions.

Figure 14-9: The Contacts window displays all contacts in the Preview Pane and shows the different view options in the Current View panel on the left.

Figure 14-10: Simply fill in all the information you have for the contact, and click Save and Close.

Figure 14-11: The Journal helps you track how much time you spend on individual pieces in a project.

Figure 14-12: Create a new task by clicking New on the Outlook toolbar when the Tasks window is displayed.

Figure 14-13: Outlook lets you know how many days you have before the task is due. Pressure, pressure.

Chapter 15: Scheduling with Microsoft Office Outlook 2003

Figure 15-1: You view, organize, add, and modify appointments in the Calendar window.

Figure 15-2: You fill in additional scheduling details in the Appointment window.

Figure 15-3: You can set up an appointment to repeat daily, weekly, monthly, or yearly.

Figure 15-4: The Reminder window pops up when its almost time for a task or appointment youve scheduled.

Figure 15-5: After you select attendees using the Add Others button, they appear in the All Attendees list.

Figure 15-6: If your company uses SharePoint Team Services, you can create a shared meeting space on the Web where team members can gather, share information, and meet.

Figure 15-7: The side-by-side calendar view displays multiple calendars in a columnar format.

Figure 15-8: You can hold online meetings in Outlook using NetMeeting or another online conferencing service.

Chapter 16: Getting Started with Databases

Figure 16-1: The Access window includes the tools and menus for creating, working with, and building relationships among data tables.

Figure 16-2: The Main Switchboard includes choices for the main Access tasks youre likely to perform.

Figure 16-3: The new database file is created and displayed as a data table in your Access work area.

Figure 16-4: The Table Wizard prompts you to choose the fields you want to include in the new table.

Figure 16-5: The Table Wizard creates the table and displays it in Datasheet view, with your field names as column headings and the first row selected, ready to receive the data you enter.

Figure 16-6: You add data in a simple form the Table Wizard creates for you.

Figure 16-7: Click Options in the Import XML dialog box to make further choices about the XML data you import.

Figure 16-8: When you import data from another Access database, you have the option of importing the tools you created in that database as well.

Figure 16-9: The Form Wizard walks you through the process of creating a data entry form for your data table.

Chapter 17: Working with Your Data

Figure 17-1: You can search for specific data items using the Find And Replace dialog box.

Figure 17-2: When you choose Filter By Form, you use a blank form or datasheet row to choose the data by which you want to filter your records.

Figure 17-3: You can import data from all SharePoint lists by using the Import wizard.

Figure 17-4: The Simple Query Wizard walks you through the process of creating your first query.

Figure 17-5: To modify a query, display it in Design View and change your selections.

Figure 17-6: Use Show Table to choose the tables you want to use to set up relationships.

Figure 17-7: The Relationships window shows the tables among which youll establish relationships.

Figure 17-9: The new Back Up Database option enables you to easily create a backup copy of important files.

Chapter 18: Preparing and Printing Reports in Microsoft Office Access 2003

Figure 18-1: The Report Wizard leads you through the steps of generating a report based on the selected database.

Figure 18-2: You can change the print margins for your report using the Page Setup dialog box.

Chapter 19: FrontPage 2003 Basics

Figure 19-1: The FrontPage 2003 window has the familiar Office menu and toolbars , but includes special features related to Web work.

Figure 19-2: To create a Web site the fast and easy way, use a Web site template.

Figure 19-3: After FrontPage creates the site, the pages and folders appear in Folder view in the Web Site window.

Figure 19-4: You can use one of FrontPages new Web packages to create a specialized data- driven site.

Figure 19-5: Tasks view gives you a list of items to accomplish on your way to a finished Web site.

Figure 19-6: Double-click a task to change its status and assignment.

Figure 19-7: You can choose a theme to give your Web site a coordinated look and feel.

Figure 19-8: The Navigation window shows you how the pages in your Web site are linked.

Figure 19-9: The links between pages (and between sites) are the sticky fibers that make this online world a Web.

Chapter 20: Microsoft Office FrontPage 2003 Special Tasks

Figure 20-1: A layout table provides a framework to house the content of your Web page.

Figure 20-2: When you add a frame page to your site, you must tell FrontPage which content to display where.

Figure 20-3: When you click Set Initial Page, FrontPage displays the Insert Hyperlink dialog box, so that you can choose the page you want to use in that frame.

Figure 20-4: Modify your horizontal lines by right-clicking them and choosing Horizontal Line Properties.

Figure 20-5: Use the Font dialog box to add a rollover effect to a hyperlink, to make the link stand out when the visitor points to it.

Figure 20-6: You can click the Code tab to take a look at the HTML source code for your Web page whenever you like.

Figure 20-7: Split view enables you to see both Code and Design view on-screen at the same time.

Figure 20-8: The Quick Tag Selector gives you an easy way to work with HTML tags in Code view.

Chapter 21: Publishing Your Pages

Figure 21-1: You can display Reports to see information about your site and list the elements that still need work.

Figure 21-2: You can optimize your HTML code in FrontPage 2003 to ensure that it appears as quickly as possible.

Figure 21-3: Choose the server type youre publishing to in the Remote Web Site Properties dialog box.

Figure 21-4: FrontPage will request your user name and password, so that a connection with the server can be established.

Figure 21-5: Click Publish Web Site to copy the Web site files from your local system to the Web.

Appendix A: Installing the Microsoft Office System

Figure A-1: Use the Change or Remove Programs feature to change your Office installation.

Figure A-2: You can repair installation problems while youre still working with Change or Remove Programs.

Appendix D: The Microsoft Office System: The Big Picture

Figure D-1: The new Office System UI has a more sophisticated look that follows Windows XP themes.

Figure D-2: You can customize Outlooks new interface to rearrange the column format, if you choose.

Figure D-3: You can get Help from both your local system and from the wider resources available on Microsoft Office Online.

Figure D-4: The Templates area of Microsoft Office Online is a jackpot of templates for any kind of document you need to create.

Figure D-5: The Research task pane extends your research options, by scouring the online resources you select.

Figure D-6: Office OneNote helps you capture good ideas wherever they occur, and use them seamlessly in your Office applications.

Figure D-7: Users can create a Meeting Workspace when they are setting up a meeting in Outlook.

Figure D-8: The Office Picture Manager is a new tool with the Office System that enables you to edit your pictures.

Figure D-9: Office Document Imaging includes a number of enhancements, such as the annotations feature to support ink capability throughout the Office System.