Prentice Hall Test Prep Series: Microsoft Access 2002 MOUS Core Level / Edition 1

Paperback (Print)
Used and New from Other Sellers
Used and New from Other Sellers
from $1.99
Usually ships in 1-2 business days
(Save 95%)
Other sellers (Paperback)
  • All (7) from $1.99   
  • New (3) from $74.50   
  • Used (4) from $1.99   
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any coupons and promotions
Seller since 2015

Feedback rating:



New — never opened or used in original packaging.

Like New — packaging may have been opened. A "Like New" item is suitable to give as a gift.

Very Good — may have minor signs of wear on packaging but item works perfectly and has no damage.

Good — item is in good condition but packaging may have signs of shelf wear/aging or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Acceptable — item is in working order but may show signs of wear such as scratches or torn packaging. All specific defects should be noted in the Comments section associated with each item.

Used — An item that has been opened and may show signs of wear. All specific defects should be noted in the Comments section associated with each item.

Refurbished — A used item that has been renewed or updated and verified to be in proper working condition. Not necessarily completed by the original manufacturer.

Brand New Item.

Ships from: Chatham, NJ

Usually ships in 1-2 business days

  • Canadian
  • International
  • Standard, 48 States
  • Standard (AK, HI)
  • Express, 48 States
  • Express (AK, HI)
Seller since 2015

Feedback rating:


Condition: New
Brand new.

Ships from: acton, MA

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Seller since 2008

Feedback rating:


Condition: New

Ships from: Chicago, IL

Usually ships in 1-2 business days

  • Standard, 48 States
  • Standard (AK, HI)
Page 1 of 1
Showing All
Sort by


This book focuses on preparing the user to pass the associated Microsoft Office User Specialist (MOUS) certification exam. Its step-by-step tutorials show how to complete the required procedures in a clear, concise, and direct manner. The tutorials are organized to match the order of the skill sets and skills being measured as published on Microsoft's MOUS website. Skill sets include creating and using databases; creating and modifying tables, queries, and forms; viewing and organizing information; defining relationships; producing reports; and integrating with other applications. For MOUS Certification.
Read More Show Less

Editorial Reviews

From The Critics
Step-by-step tutorials, chapter exercises, screen shots, and notes on common problems help prepare students for the Core level of the Microsoft Office User Specialist (MOUS) certification exam. Other learning features include chapter summaries, key terms, challenge exercises, and notes on different ways to perform the same task. Tutorials are organized to match the order of the skill sets and skills being measured as published on Microsoft's MOUS Web site. Winters teaches computer science at Manatee Community College. Manchester is a database designer. Annotation c. Book News, Inc., Portland, OR
Read More Show Less

Product Details

  • ISBN-13: 9780130497864
  • Publisher: Prentice Hall
  • Publication date: 8/2/2002
  • Series: Prentice Hall Test Prep Series
  • Edition description: New Edition
  • Edition number: 1
  • Pages: 300
  • Product dimensions: 8.50 (w) x 11.00 (h) x 0.52 (d)

Table of Contents

About Access 2002 1
Open Access and Explore the Access Workspace 2
Use Access Help 5
A Brief Overview of Database Design 12
Ch. 1 Core Skill Set I: Creating and Using Databases 15
Skill 1.1 Create Access Databases 17
Skill 1.2 Open Database Objects in Multiple Views 32
Skill 1.3 Move Among Records 44
Skill 1.4 Format Datasheets 48
Ch. 2 Core Skill Set 2: Creating and Modifying Tables 57
Skill 2.1 Create and Modify Tables 58
Skill 2.2 Add a Predefined Input Mask to a Field 72
Skill 2.3 Create Lookup Fields 77
Skill 2.4 Modify Field Properties 82
Ch. 3 Core Skill Set 3: Creating and Modifying Queries 95
Skill 3.1 Create and Modify Select Queries 97
Skill 3.2 Add Calculated Fields to Select Queries 108
Ch. 4 Core Skill Set 4: Creating and Modifying Forms 115
Skill 4.1 Create and Display Forms 117
Skill 4.2 Modify Form Properties 127
Ch. 5 Core Skill Set 5: Viewing and Organizing Information 157
Skill 5.1 Enter, Edit, and Delete Records 158
Skill 5.2 Create Queries 170
Skill 5.3 Sort Records 177
Skill 5.4 Filter Records 187
Ch. 6 Core Skill Set 6: Defining Relationships 201
Skill 6.1 Create One-to-Many Relationships 203
Skill 6.2 Enforce Referential Integrity 214
Ch. 7 Core Skill Set 7: Producing Reports 223
Skill 7.1 Create and Format Reports 225
Skill 7.2 Add Calculated Controls to Reports 238
Skill 7.3 Preview and Print Reports 248
Ch. 8 Core Skill Set 8: Integrating with Other Applications 257
Skill 8.1 Import Data to Access 258
Skill 8.2 Export Data from Access 268
Skill 8.3 Create a Simple Data Access Page 273
Glossary 289
Index 293
Read More Show Less



Prentice Hall Test Prep Series courseware is anchored in the practical and professional needs of all types of students. The MOUS titles within this series focus on preparing students to sit for the associated Core, Comprehensive, or Expert MOUS exam. Coverage of concepts and how-to steps make each text suitable for general introductory computer courses as well.

The chapters in each MOUS Prep text exactly match the skill sets—and skills being measured within each skill set—published for the associated MOUS exam. As such, it consists of skills that are built around a series of numbered, step-by-step procedures that are clear, concise, and easy to review. The end-of-chapter exercises have likewise been carefully crafted to reinforce skills and to extend what you've learned into areas beyond the explicit scope of the specific skills. Following, you'll find out more about the rationale behind each book element and how to use each to your maximum benefit.

Key Features

  • Step-by-Step Tutorials. Each skill includes numbered, bold step-by-step instructions that show you how to perform the procedures in a clear, concise, and direct manner. These hands-on tutorials let you "learn by doing." A short paragraph may appear after a step to clarify the results of that step. To review the skill, you can easily scan the bold numbered steps. Accompanying data files eliminate unnecessary typing.
  • Illustrations. Multiple illustrations add visual appeal and reinforce learning in each skill set. Each time a new button is introduced, its icon displays in the margin. Screen shots display after key steps for you to checkagainst the results on your monitor. These figures, with ample callouts, make it easy to check your progress.
  • Notes. Skills include three types of notes: If you have problems, Alternate Ways, and In Depth. These notes describe common problems, explain different methods for performing tasks, and provide extra tips and special hints (details provided in "How to Use This Book"). You may safely ignore these for the moment to focus on the main task at hand, or you may pause to learn and appreciate the additional information.
  • Summary. A summary precedes the end-of-chapter exercises. The summary provides a brief recap of tasks learned in the skill set.
  • End-of-Chapter Exercises. Check out the extensive end-of-chapter exercises—at least one for each skill presented in the skill set. You'll find two levels of reinforcement: Skill Drill and Challenge (detail provided in "How to Use This Book"). Generally, each exercise is independent of other exercises, so you can complete your choices in any order. Accompanying data files eliminate unnecessary typing.

How to Use This Book

Each MOUS Prep book is organized by chapters-one chapter per core or expert skill set. A skill set consists of numbered skill areas that are related to that topic. Each skill within a numbered skill area presents a specific task or closely related set of tasks in a manageable chunk that is easy to assimilate and retain.

Each element in a MOUS Prep book is designed to maximize your learning experience. Following is a list of the MOUS Prep skill set elements and a description of how each element can help you:

  • Skill Set Objectives. Starting with an objective gives you short-term, attainable goals. Using skill set objectives that closely match the titles of the step-by-step tutorials breaks down the possibly overwhelming prospect of learning several new features of an Office XP application into small, attainable, bite-sized tasks. Look over the objectives on the opening page of a chapter before you begin, and review them after completing the chapter to identify the main goals for each MOUS skill set.
  • Key Terms. Each key term is defined during its first use within the text, and is shown in bold italic within that explanation. Definitions of key terms are also included in the Glossary.
  • Skill Set Overview. This opening section explains the concepts and features that you will learn in the skill set.
  • If You Have Problems... These short troubleshooting notes appear between hands-on steps. They help you anticipate or solve common problems quickly and effectively. Even if you do not encounter the problem at this time, make a mental note of it so that you know where to look when you (or others) have difficulty.
  • Alternate Way. These notes explain a different way to perform a task. Relatively short notes display between hands-on steps or in the margin next to the associated hands-on step. Longer notes display immediately after the associated set of hands-on steps.
  • In Depth. Many skills include "in Depth" comments. These notes provide extra tips and special hints, and they follow the related set of hands-on steps.
  • Periodic Cross-Reference to Related Exercises. MOUS skill sets include from two to ten numbered skill areas. Therefore, some of the chapters in a text are quite long. After each numbered skill area, you find a cross reference to any Skill Drill and/or Challenge exercises) relating to that numbered skill area. For immediate reinforcement, work through one or more of the related exercises. Otherwise, you can continue to the next skill area.
  • Skill Drill Exercises. Skill Drill exercises reinforce skills presented in the chapter. Each skill reinforced is the same, or nearly the same, as a skill presented within a skill set. Each exercise includes a brief narrative introduction, followed by detailed instructions in a step-by-step format.
  • Challenge Exercises. Challenge exercises expand on or are somewhat related to skills presented in the chapter. Each exercise provides a brief narrative introduction, followed by instructions in a numbered-step format that are not as detailed as those in the Skill Drill section.

Typeface Conventions Used in This Book

Prentice Hall Test Prep uses the following conventions to make it easier for you to understand the material.

  • Key terms appear in italic and bold the first time they are defined in a skill set.
  • Monospace type appears frequently and looks like this. It is used to indicate text that you are instructed to key in.
  • Italic text indicates (1) text that appears onscreen as warnings, confirmations, or general information; (2) the name of a file to be used in a skill or exercise; and (3) text from a dialog box that is referenced within a sentence, when that sentence might appear awkward if the dialog box text were not set off.
  • Hotkeys are indicated by underline. Hotkeys are the underlined letters in menus, toolbars, and dialog boxes that activate commands and options, and are a quick way to choose frequently used commands and options. Hotkeys look like this: File, Save.

Student Resources—Companion Website

The Web site that accompanies this book is the tool that empowers you to get the most out of this text (see Figure I. I ). It provides access to all the data files for you to use as you work through the step-by-step tutorials, and the Skill Drill and Challenge exercises provided at the end of each skill set.

Accessing Student Data Files on the Companion Website
Data files are provided for each chapter. The filenames correspond to the filenames called for in this book. The files are named in the following manner: The first character indicates the book series (M=MOUS); the second character denotes the application (W=Word, E=Excel, and so forth); and the third character indicates the level (C=Core or Comprehensive and E=Expert). The last four digits indicate the skill set number and the file number within the skill set. For example, the complete name for the first file in Chapter 3 (Core Skill Set 3) in the MOUS Word book is MWCS301. The complete name for the third file in Chapter 14 (Expert Skill Set 7) in the MOUS Excel book is MEE-S703.

For the Instructor

Instructor's Resource CD-ROM
The Instructor's Resource CD-ROM that is available contains:

  • Instructor's Manual in Word and PDF
  • Solutions to all exercises from the book and Website
  • PowerPoint lectures
  • A Windows-based test manager and the associated test bank in Word format with offer 1500 new questions

Companion Website
For both students and instructors, the Companion Website includes ancillary material to accompany the Prentice Hall Test Prep Series. Instructors will find the data and solution files, PowerPoint slides, and Instructor's Manuals for each application.

Prentice Hall has also formed close alliances with each of the leading online platform providers: WebCT, Blackboard, and our own Pearson CourseCompass.

CourseCompass is a dynamic, interactive online course-management tool powered exclusively for Pearson Education by Blackboard. This exciting product enables you to teach market-leading Pearson Education content in an easy-to-use, customizable format.

Prentice Hall's abundant online content, combined with Blackboard's popular tools and interface, result in robust Web-based courses that are easy to implement, manage, and use—taking your courses to new heights in student interaction and learning.

Course-management tools within WebCT include page tracking, progress tracking, class and student management, gradebook, communication, calendar, reporting tools, and more. GOLD LEVEL CUSTOMER SUPPORT, available exclusively to adopters of Prentice Hall courses, is provided free-of-charge upon adoption and provides you with priority assistance, training discounts, and dedicated technical support.

Train & Assess IT
Prentice Hall offers Performance Based Training and Assessment in one product: Train & Assess IT The training component offers computer-based training that a student can use to preview, learn, and review Microsoft Office applications and computer literacy skills. Web- or CD-ROM delivered, the training component offers interactive, multimedia, computer-based training to augment classroom learning. Built-in prescriptive testing suggests a study path based not only on student test results but also on the specific textbook chosen for the course.

The assessment component offers computer-based testing that shares the same user interface and is used to evaluate a student's knowledge about specific topics in Word, Excel, Access, PowerPoint, Windows, Outlook, and the Internet. It does this in a task-oriented environment to demonstrate proficiency as well as comprehension of the topics by the students.

Read More Show Less

Customer Reviews

Be the first to write a review
( 0 )
Rating Distribution

5 Star


4 Star


3 Star


2 Star


1 Star


Your Rating:

Your Name: Create a Pen Name or

Barnes & Review Rules

Our reader reviews allow you to share your comments on titles you liked, or didn't, with others. By submitting an online review, you are representing to Barnes & that all information contained in your review is original and accurate in all respects, and that the submission of such content by you and the posting of such content by Barnes & does not and will not violate the rights of any third party. Please follow the rules below to help ensure that your review can be posted.

Reviews by Our Customers Under the Age of 13

We highly value and respect everyone's opinion concerning the titles we offer. However, we cannot allow persons under the age of 13 to have accounts at or to post customer reviews. Please see our Terms of Use for more details.

What to exclude from your review:

Please do not write about reviews, commentary, or information posted on the product page. If you see any errors in the information on the product page, please send us an email.

Reviews should not contain any of the following:

  • - HTML tags, profanity, obscenities, vulgarities, or comments that defame anyone
  • - Time-sensitive information such as tour dates, signings, lectures, etc.
  • - Single-word reviews. Other people will read your review to discover why you liked or didn't like the title. Be descriptive.
  • - Comments focusing on the author or that may ruin the ending for others
  • - Phone numbers, addresses, URLs
  • - Pricing and availability information or alternative ordering information
  • - Advertisements or commercial solicitation


  • - By submitting a review, you grant to Barnes & and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Terms of Use.
  • - Barnes & reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & also reserves the right to remove any review at any time without notice.
  • - See Terms of Use for other conditions and disclaimers.
Search for Products You'd Like to Recommend

Recommend other products that relate to your review. Just search for them below and share!

Create a Pen Name

Your Pen Name is your unique identity on It will appear on the reviews you write and other website activities. Your Pen Name cannot be edited, changed or deleted once submitted.

Your Pen Name can be any combination of alphanumeric characters (plus - and _), and must be at least two characters long.

Continue Anonymously

    If you find inappropriate content, please report it to Barnes & Noble
    Why is this product inappropriate?
    Comments (optional)