Using the Books CD

Using the Book’s CD

CD Content

The companion CD included with this book contains practice files you can use as you work through the book’s exercises. By using practice files, you won’t waste time creating samples and typing large amounts of data. Instead, you can jump right in and concentrate on learning how to use the programs.

What’s on the CD?

The following table lists the practice files supplied on the book’s CD.

Open table as spreadsheet

Chapter	Folder\File
Chapter 1: Exploring Word 2007	02_Opening.docx 03_Viewing1.docx 03_Viewing2.docx 05_Printing.docs
Chapter 2: Editing and Proofreading Documents	01_Changes.docx 02_SavedText.docx 03_FindingWord.docx 04_Outline.docx 05_FindingText.docx 06_Spelling.docx 07_Finalizing.docx
Chapter 3: Changing the Look of Text	01_QuickFormatting.docx 02_Characters.docx 03_Paragraphs.docx 04_Lists.docx
Chapter 4: Presenting Information in Columns and Tables	01_Columns.docx 02_TabularList.docx 03_Table.docx 05_Calculations.docx 05_LoanData.xlsx 06_Loan.xlsx 06_Memo.docx 06_TableAsLayout.docx
Chapter 5: Setting Up a Workbook	Creating\Exception Summary.xlsx Creating\Route Volume.xlsx
Chapter 6: Working with Data and Data Tables	Data and Data Tables\Series.xlsx Data and Data Tables\2007Q1ShipmentsByCategory.xlsx Data and Data Tables\Average Deliveries.xlsx Data and Data Tables\Service Levels.xlsx Data and Data Tables\Driver Sort Times.xlsx
Chapter 7: Performing Calculations on Data	Formulas\VehicleMiles.xlsx Formulas\ITExpenses.xlsx Formulas\PackagingCosts.xlsx Formulas\ConveyerBid.xlsx
Chapter 8: Changing Document Appearance	Appearance\VehicleMileSummary.xlsx Appearance\HourlyExceptions.xlsx Appearance\HourlyTracking.xlsx Appearance\ExecutiveSearch.xlsx Appearance\Dashboard.xlsx Appearance\CallCenter.xlsx
Chapter 9: Creating a Database	03_TableTemplate.accdb 04_Manipulating.accdb
Chapter 10: Simplifying Data Entry by Using Forms	01_CreateFormTool.accdb 02_RefneProperties.accdb 03_RefieLayout.accdb 04_AddControls.accdb 04_CustomersFormLogo.jpg 05_VBA.accdb 05_AftUpdate.txt 06_CreateWizard.accdb 07_AddSubform.accdb
Chapter 11: Locating specific Information	01_SortTable.accdb 02_FilterTable.accdb 03_FilterForm.accdb 04_MultipleCriteria.accdb 05_QueryDesign.accdb 06_QueryWizard.accdb 07_Calculate.accdb
Chapter 12: Keeping Your Information Accurate	01_FieldTest.accdb 02_Size.accdb 03_Accurate.accdb 04_Validate.accdb 05_SimpleLookup.accdb 06_MulticolumnLookup.accdb 07_Update.accdb 08_Delete.accdb 09_Prevent.accdb
Chapter 13: Starting a New Presentation	01_Creating.pptx 03_Converting.docx 04_Reusing1.pptx 04_Reusing2.pptx
Chapter 14: Working with Slide Text	02_Editing.pptx 03_TextBoxes.pptx 04_Correcting.pptx 05_Spelling.pptx 06_Finding.pptx 07_Changing.pptx
Chapter 15: Adjusting the Layout, Order, and Look of Slides	01_Layout.pptx 02_Rearranging.pptx 03_Theme1.pptx 03_Theme2.pptx 04_ColorScheme.pptx 05_OtherColors.pptx 06_Background.pptx
Chapter 16: Delivering a Presentation Electronically	01_Adapting.pptx 02_Rehearsing.pptx 03_NotesHandouts.pptx 03_YinYang.png 04_Travel.pptx 05_Showing.pptx
Chapter 18: Sending E-Mail Messages	03_Attaching.docx 03_Attaching.pptx

In addition to the practice files, the CD contains some exciting resources that will really enhance your ability to get the most out of using this book and Office System 2007, including the following:

• Microsoft Office System 2007 Step by Step in eBook format

• Microsoft Computer Dictionary, 5th ed. eBook

• First Look 2007 Microsoft Office System (Katherine Murray, 2006)

• Sample chapter and poster from Look Both Ways: Help Protect Your Family on the Internet (Linda Criddle, 2007)

Important 

The companion CD for this book does not contain the Office System 2007 software. You should purchase and install that program before using this book.

Minimum System Requirements

The 2007 Microsoft Office system includes the following programs:

• Microsoft Office Access 2007

• Microsoft Office Communicator 2007

• Microsoft Office Excel 2007

• Microsoft Office Groove 2007

• Microsoft Office InfoPath 2007

• Microsoft Office Outlook 2007

• Microsoft Office Outlook 2007 with Business Contact Manager

• Microsoft Office Publisher 2007

• Microsoft Office Word 2007

• Microsoft Office PowerPoint 2007

No single edition of the 2007 Office system installs all of the above programs. Specialty programs available separately include Microsoft Office Project 2007, Microsoft Office SharePoint Designer 2007, and Microsoft Office Visio 2007.

To install and run these programs, your computer needs to meet the following minimum requirements:

• 500 megahertz (MHz) processor

• 256 megabytes (MB) RAM

• CD or DVD drive

• 2 gigabytes (GB) available hard disk space; a portion of this disk space will be freed if you select the option to delete the installation files

  Tip 

  Hard disk requirements will vary depending on configuration; custom installation choices might require more or less hard disk space.

• Monitor with 800×600 screen resolution; 1024×768 or higher recommended

• Keyboard and mouse or compatible pointing device

• Internet connection, 128 kilobits per second (Kbps) or greater, for download and activation of products, accessing Microsoft Office Online and online Help topics, and any other Internet-dependent processes

• Windows Vista or later, Microsoft Windows XP with Service Pack 2 (SP2), or Microsoft Windows Server 2003 or later

• Windows Internet Explorer 7 or Microsoft Internet Explorer 6 with service packs The 2007 Microsoft Office suites, including Office Basic 2007, Office Home & Student 2007, Office Standard 2007, Office Small Business 2007, Office Professional 2007, Office Ultimate 2007, Office Professional Plus 2007, and Office Enterprise 2007, all have similar requirements.

Step-by-Step Exercises

In addition to the hardware, software, and connections required to run the 2007 Microsoft Office system, you will need the following to successfully complete the exercises in this book:

• PowerPoint 2007, Word 2007, Excel 2007, and Outlook 2007

• Access to a printer

• 10 MB of available hard disk space for the practice files

Installing the Practice Files

You need to install the practice files in the correct location on your hard disk before you can use them in the exercises. Follow these steps:

1. Remove the companion CD from the envelope at the back of the book, and insert it into the CD drive of your computer.

The Step By Step Companion CD License Terms appear. Follow the on-screen directions. To use the practice files, you must accept the terms of the license agreement. After you accept the license agreement, a menu screen appears.

Important 

If the menu screen does not appear, click the Start button and then click Computer. Display the Folders list in the Navigation pane, click the icon for your CD drive, and then in the right pane, double-click the StartCD executable file.

2. Click Install Practice Files.

3. Click Next on the first screen, and then click Next to accept the terms of the license agreement on the next screen.

4. If you want to install the practice files to a location other than the default folder (Documents\MSP\SBS_Office2007), click the Change button, select the new drive and path, and then click OK.

Important 

If you install the practice files to a location other than the default, you will need to substitute that path within the exercises.

5. Click Next on the Choose Destination Location screen, and then click Install on the Ready to Install the Program screen to install the selected practice files.

6. After the practice files have been installed, click Finish.

7. Close the Step by Step Companion CD window, remove the companion CD from the CD drive, and return it to the envelope at the back of the book.

Using the Practice Files

When you install the practice files from the companion CD that accompanies this book, the files are stored on your hard disk in chapter-specific subfolders under Documents\MSP\SBS_Office2007. Each exercise is preceded by a paragraph that lists the files needed for that exercise and explains any preparations needed before you start working through the exercise. Here are examples:

Use the 02_Worksheets presentation and the 02_Costs workbook. These practice files are located in the Chapter14 subfolder under SBS_PowerPoint2007.

Be Sure To start PowerPoint before beginning this exercise.

Open the 02_Editing and 03_TextBoxes presentation files.

You can browse to the practice files in Windows Explorer by following these steps:

1. On the Windows taskbar, click the Start button, and then click Documents.

2. In your Documents folder, double-click MSP, double-click SBS_Office2007, and then double-click a specific chapter folder.

You can browse to the practice files from a PowerPoint 2007 dialog box by following these steps:

1. On the Favorite Links pane in the dialog box, click Documents.

2. In your Documents folder, double-click MSP, double-click SBS_Office2007, and then double-click the specified chapter folder.

Removing and Uninstalling the Practice Files

You can free up hard disk space by uninstalling the practice files that were installed from the companion CD. The uninstall process deletes any files that you created in the Documents\MSP\SBS_Office2007 chapter-specific folders while working through the exercises. Follow these steps:

1. On the Windows taskbar, click the Start button, and then click Control Panel.

2. In Control Panel, under Programs, click the Uninstall a program task.

3. If the Programs and Features message box asking you to confirm the deletion appears, click Yes.

See Also If you need additional help installing or uninstalling the practice files, see the “Getting Help” section later in this book.

Important 

Microsoft Product Support Services does not provide support for this book or its companion CD.