Prentice Hall Test Prep Series: Microsoft Access 2002 MOUS Expert Level / Edition 2

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 97%)
Other sellers (Paperback)
  • All (9) from $1.99   
  • New (1) from $113.87   
  • Used (8) from $1.99   
Sort by
Page 1 of 1
Showing All
Note: Marketplace items are not eligible for any coupons and promotions
Seller since 2008

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.


Ships from: Naperville, 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; integrating with other applications; producing reports; defining relationships; operating Access on the web; using Access tools; and creating database applications. For MOUS Certification.
Read More Show Less

Product Details

  • ISBN-13: 9780130497857
  • Publisher: Pearson
  • Publication date: 9/25/2002
  • Series: Prentice Hall Test Prep Series
  • Edition description: 2ND
  • Edition number: 2
  • Pages: 560
  • Product dimensions: 8.58 (w) x 10.86 (h) x 0.88 (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
Ch. 9 Expert Skill Set 1: Creating and Modifying Tables 289
Skill 1.1 Use Data Validation 290
Skill 1.2 Link Tables 294
Skill 1.3 Create Lookup Fields and Modify Lookup Field Properties 297
Skill 1.4 Create and Modify Input Masks 301
Ch. 10 Expert Skill Set 2: Creating and Modifying Forms 311
Skill 2.1 Create a form in Design view 313
Skill 2.2 Create a Switchboard and Set Startup Options 322
Skill 2.3 Add Subform Controls to Access Forms 333
Ch. 11 Expert Skill Set 3: Refining Queries 345
Skill 3.1 Specify Multiple Query Criteria 346
Skill 3.2 Create and Apply Advanced Filters 351
Skill 3.3 Create and Run Parameter Queries 354
Skill 3.4 Create and Run Action Queries 356
Skill 3.5 Use Aggregate Functions in Queries 362
Ch. 12 Expert Skill Set 4: Producing Reports 375
Skill 4.1 Create and Modify Reports 376
Skill 4.2 Add Subreport Controls to Access Reports 389
Skill 4.3 Sort and Group Data in Reports 393
Ch. 13 Expert Skill Set 5: Defining Relationships 409
Skill 5.1 Establish One-to-Many Relationships 410
Skill 5.2 Establish Many-to-Many Relationships 415
Ch. 14 Expert Skill Set 6: Operating Access on the Web 423
Skill 6.1 Create and Modify a Data Access Page 424
Skill 6.2 Save PivotTable and PivotChart Views to Data Access Pages 433
Ch. 15 Expert Skill Set 7: Using Access Tools 451
Skill 7.1 Import XML Documents into Access 452
Skill 7.2 Export Access Data to XML Documents 454
Skill 7.3 Encrypt and Decrypt Databases 457
Skill 7.4 Compact and Repair Databases 459
Skill 7.5 Assign Database Security 462
Skill 7.6 Replicate a Database 476
Ch. 16 Expert Skill Set 8: Creating Database Applications 485
Skill 8.1 Create Access Modules 486
Skill 8.2 Use the Database Splitter 494
Skill 8.3 Create an MDE File 498
Glossary 505
Index 511
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
Sort by: Showing 1 Customer Reviews
  • Anonymous

    Posted February 2, 2004

    There is no MOUS Expert Level exam for Access

    I am sure the book is excellent but the title is misleading. The only MOUS Access Certification available is the Core Cert.

    Was this review helpful? Yes  No   Report this review
Sort by: Showing 1 Customer Reviews

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