Using the Book s CD | MicrosoftR Office AccessT 2007 Step by Step

Using the Book's CD

The companion CD included with this book contains the practice files you'll use as you work through the book's exercises, as well as other electronic resources that will help you learn how to use Microsoft Office Access 2007.

What's on the CD?

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

Chapter	Files
Chapter 1: Exploring Access 2007	01_Working.accdb
	03_Opening.accdb
	04_Tables.accdb
	05_Queries.accdb
	06_Forms.accdb
	07_Reports.accdb
	09_Print.accdb
Chapter 2: Creating a Database	03_TableTemplate.accdb
	04_Manipulating.accdb
Chapter 3: Populating a Database	01_ImportAccess.accdb
	01_Products.accdb
	02_Customers.xlsx
	02_ImportExcel.accdb
	05_Employees.txt
	05_ImportText.accdb
	06_ImportXML.accdb
	06_OrderDetails.xml
	06_OrderDetails.xsd
	06_Orders.xml
	07_ImportHTML.accdb
	07_NewCust.html
	09_ImportDbase.accdb
	09_Ship.dbf
Chapter 4: Sharing and Reusing Information	01_ExportAccess.accdb
	01_Exported.accdb
	02_ExportExcel.accdb
	04_ExportWord.accdb
	05_ExportText.accdb
	06_ExportXML.accdb
	07_ExportHTML.accdb
	08_CopyOffice.accdb
Chapter 5: Simplifying Data Entry by Using Forms	01_CreateFormTool.accdb
	02_RefineProperties.accdb
	03_RefineLayout.accdb
	04_AddControls.accdb
	04_CustomersFormLogo.jpg
	05_VBA.accdb
	05_AftUpdate.txt
	06_CreateWizard.accdb
	07_AddSubform.accdb
Chapter 6: 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 7: 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 8: Working with Reports	01_Wizard.accdb
	02_ModifyDesign.accdb
	03_Manually.accdb
	04_ModifyContent.accdb
	05_AddSubreport.accdb
	06_Printing.accdb
Chapter 9: Making Your Database Easy to Use	01_Switchboard.accdb
	02_CustomCategory.accdb
	03_Features.accdb
Chapter 10: Securing and Sharing Information	01_Password.accdb
	02_Prevent.accdb
	03_Distribute.accdb

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 Access 2007, including the following:

Microsoft Office Access 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 Access 2007 software. You should purchase and install that program before using this book.

Minimum System Requirements

2007 Microsoft Office System

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 OneNote 2007
Microsoft Office Outlook 2007
Microsoft Office Outlook 2007 with Business Contact Manager
Microsoft Office PowerPoint 2007
Microsoft Office Publisher 2007
Microsoft Office Word 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 800x600 screen resolution; 1024x768 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:

Access 2007, Excel 2007, and Outlook 2007
Access to a printer
52 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 drive 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_Access2007), 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.

Adding the Practice File Folder to the Trusted Locations List

The databases provided as practice files for this book contain macros. You can enable the macros in all the practice databases by adding the practice file folder to the list of Trusted Locations for Access 2007.

Follow these steps:

1.	Click the Microsoft Office Button, and then click Access Options.
2.	On the Trust Center page of the Access Options dialog box, click Trust Center Settings.
3.	On the Trusted Locations page of the Trust Center dialog box, click Add new location.
4.	In the Microsoft Office Trusted Location dialog box, click Browse.
5.	In the Browse dialog box, browse to your Documents\MSP\SBS_Access2007 folder, and then click OK.
6.	In the Microsoft Office Trusted Location dialog box, select the Subfolders of this location are also trusted check box, and then click OK in each of the open dialog boxes.

If you prefer to not do this, you can enable macros in an individual database by clicking Options in the Security Warning area that appears at the top of the content pane. In the Microsoft Office Security Options dialog box, selecting the Enable This Content option, and then clicking OK.

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_Access2007. 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 03_Opening database. This practice file is located in the Chapter01 subfolder under SBS_Access2007.

BE SURE TO start your computer, but don't start Access before starting this exercise.

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

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

Start

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

You can browse to the practice files from an Access 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_Access2007, and then double-click the specified chapter folder.

Removing and Uninstalling the Practice Files

After you finish working through this book, delete the practice messages, appointments, contacts, and other Outlook items you created while working through the exercises, and then uninstall the practice files that were installed from the companion CD. Follow these steps:

1.	On the Windows taskbar, click the Start button, and then click Control Panel. Start
2.	In Control Panel, under Programs, click the Uninstall a program task.
3.	In the Programs and Features window, click Microsoft Office Access 2007 Step by Step, and then on the toolbar at the top of the window, click the Uninstall button.
4.	If the Programs and Features message box asking you to confirm the deletion appears, click Yes.