Exploring: Microsoft Access 2013, Introductory / Edition 1

Other Format (Print)
Rent from BN.com
(Save 67%)
Est. Return Date: 07/03/2015
Buy New
Buy New from BN.com
Buy Used
Buy Used from BN.com
(Save 29%)
Item is in good condition but packaging may have signs of shelf wear/aging or torn packaging.
Condition: Used – Good details
Used and New from Other Sellers
Used and New from Other Sellers
from $52.18
Usually ships in 1-2 business days
(Save 46%)
Other sellers (Other Format)
  • All (12) from $52.18   
  • New (7) from $90.12   
  • Used (5) from $52.18   


This book covers introductory Access.

Move students beyond the point-and-click.

The goal of the Exploring series is to move students beyond the point and click, to understanding the why and how behind each skill. And, because so much learning takes place outside of the classroom, this series provides learning tools that students can access anywhere, any time.

Students go to college now with a different set of skills than they did years ago. With this in mind, the Exploring series seeks to move students beyond the basics of the software at a faster pace, without sacrificing coverage of the fundamental skills that everyone needs to know.

NOTE: Before purchasing, check with your instructor to ensure you select the correct ISBN. Several versions of Pearson's MyLab & Mastering products exist for each title, and registrations are not transferable. To register for and use Pearson's MyLab & Mastering products, you may also need a Course ID, which your instructor will provide.

Used books, rentals, and purchases made outside of Pearson

If purchasing or renting from companies other than Pearson, the access codes for Pearson's MyLab & Mastering products may not be included, may be incorrect, or may be previously redeemed. Check with the seller before completing your purchase.

Read More Show Less

Product Details

  • ISBN-13: 9780133412192
  • Publisher: Prentice Hall
  • Publication date: 7/22/2013
  • Series: Exploring Series
  • Edition description: Comprehens
  • Edition number: 1
  • Pages: 352
  • Sales rank: 433,469
  • Product dimensions: 8.90 (w) x 10.80 (h) x 0.60 (d)

Table of Contents

Microsoft Office 2013

Chapter One Office Fundamentals and File Management: Taking the First Step 1

Objectives¿¿¿¿¿¿¿¿ 1

Case Study: Spotted Begonia Art Gallery 1

Windows 8 Startup 2

Logging In with Your Microsoft Account 2

Identifying the Start Screen Components 3

Interacting with the Start Screen 4

Accessing the Desktop 4

Hands-On Exercise 1:

Windows 8 Startup 6

Files and Folders¿¿¿¿¿¿¿¿ 10

Using File Explorer 10

Working with Folders and Files 13

Selecting, Copying, and Moving Multiple Files and Folders 15

Hands-On Exercise 2:

Files and Folders 17

Microsoft Office Software 22

Identifying Common Interface Components 22

Getting Office Help 28

Hands-On Exercise 3:

Microsoft Office Software 31

The Backstage View Tasks¿¿¿¿¿¿¿¿ 36

Opening a File 36

Printing a File 38

Closing a File and Application 39

Hands-On Exercise 4:

The Backstage View Tasks 41

Home Tab Tasks¿¿¿¿¿¿¿¿ 45

Selecting and Editing Text 45

Using the Clipboard Group Commands 49

Using the Editing Group Commands 52

Hands-On Exercise 5:

Home Tab Tasks 55

Insert Tab Tasks¿¿¿¿¿¿¿¿ 60

Inserting Objects 60

Review Tab Tasks¿¿¿¿¿¿¿¿ 62

Reviewing a File 62

Page Layout Tab Tasks¿¿¿¿¿¿¿¿ 65

Using the Page Setup Dialog Box 66

Hands-On Exercise 6:

Insert Tab Tasks, Page Layout Tab Tasks, and

Review Tab Tasks 68

Chapter Objectives Review¿¿¿¿¿¿¿¿ 72

Key Terms Matching¿¿¿¿¿¿¿¿ 73

Multiple Choice 74

Practice Exercises¿¿¿¿¿¿¿¿ 75

Mid-Level Exercises¿¿¿¿¿¿¿¿ 79

Beyond the Classroom¿¿¿¿¿¿¿¿ 81

Capstone Exercise 82


Microsoft Office Access 2013

Chapter One Introduction to Access: Finding Your Way Through an Access Database 83

Objectives¿¿¿¿¿¿¿¿ 83

Case Study: Managing a Business in the Global

Economy 83

Databases Are Everywhere! 84

Understanding Database Fundamentals 84

Using an Existing Database 91

Hands-On Exercise 1:

Databases Are Everywhere! 95

Sorts and Filters¿¿¿¿¿¿¿¿ 102

Sorting Table Data on One or Multiple Fields 102

Creating, Modifying, and Removing Filters 103

Hands-On Exercise 2:

Sorts and Filters 106

Access Versus Excel, and Relational Databases¿¿¿¿¿¿¿¿ 111

Knowing When to Use Access or Excel to Manage Data 111

Understanding Relational Power 112

Hands-On Exercise 3:

Access Versus Excel, and Relational Databases 115

Access Database Creation¿¿¿¿¿¿¿¿ 119

Creating a Database 119

Hands-On Exercise 4:

Access Database Creation 123

Chapter Objectives Review¿¿¿¿¿¿¿¿ 127

Key Terms Matching¿¿¿¿¿¿¿¿ 128

Multiple Choice 129

Practice Exercises¿¿¿¿¿¿¿¿ 130

Mid-Level Exercises¿¿¿¿¿¿¿¿ 135

Beyond the Classroom¿¿¿¿¿¿¿¿ 139

Capstone Exercise 140


Chapter Two Tables and Queries in Relational Databases: Designing

Databases and Extracting Data 141

Objectives¿¿¿¿¿¿¿¿ 141

Case Study: Bank Audit 141

Table Design, Creation, and Modification¿¿¿¿¿¿¿¿ 142

Designing a Table 142

Creating and Modifying Tables 146

Hands-On Exercise 1:

Table Design, Creation, and Modification 152

Multiple-Table Databases¿¿¿¿¿¿¿¿ 157

Sharing Data 157

Establishing Table Relationships 160

Hands-On Exercise 2:

Multiple-Table Databases 165

Single-Table Queries¿¿¿¿¿¿¿¿ 171

Creating a Single-Table Query 171

Specifying Query Criteria for Different Data Types 173

Understanding Query Sort Order 177

Running, Copying, and Modifying a Query 177

Using the Query Wizard 178

Hands-On Exercise 3:

Single-Table Queries 181

Multitable Queries¿¿¿¿¿¿¿¿ 184

Creating a Multitable Query 184

Modifying a Multitable Query 185

Hands-On Exercise 4:

Multitable Queries 189

Chapter Objectives Review¿¿¿¿¿¿¿¿ 193

Key Terms Matching¿¿¿¿¿¿¿¿ 195

Multiple Choice 196

Practice Exercises¿¿¿¿¿¿¿¿ 197

Mid-Level Exercises¿¿¿¿¿¿¿¿ 202

Beyond the Classroom¿¿¿¿¿¿¿¿ 206

Capstone Exercise 208


Chapter Three Customize, Analyze, and Summarize Query Data: Creating and Using Queries to Make Decisions 211

Objectives¿¿¿¿¿¿¿¿ 211

Case Study: Housing Slump Means Opportunity

For College Students¿¿¿¿¿¿¿¿ 211

Calculations and Expressions¿¿¿¿¿¿¿¿ 212

Creating a Calculated Field in a Query 212

Formatting and Saving Calculated Results 215

Hands-On Exercise 1:

Calculations and Expressions 218

The Expression Builder and Functions¿¿¿¿¿¿¿¿ 223

Creating Expressions with the Expression Builder 223

Using Built-In Functions in Access 225

Hands-On Exercise 2:

The Expression Builder and Functions 228

Aggregate Functions¿¿¿¿¿¿¿¿ 233

Adding Aggregate Functions to Datasheets 233

Creating Queries with Aggregate Functions 234

Hands-On Exercise 3:

Aggregate Functions 240

Chapter Objectives Review¿¿¿¿¿¿¿¿ 243

Key Terms Matching¿¿¿¿¿¿¿¿ 244

Multiple Choice 245

Practice Exercises¿¿¿¿¿¿¿¿ 246

Mid-Level Exercises¿¿¿¿¿¿¿¿ 249

Beyond the Classroom¿¿¿¿¿¿¿¿ 253

Capstone Exercise 255


Chapter Four Creating and Using Professional Forms and Reports:

Moving Beyond Tables and Queries 257

Objectives¿¿¿¿¿¿¿¿ 257

Case Study: Coffee Shop Starts New Business¿¿¿¿¿¿¿¿ 257

Form Basics¿¿¿¿¿¿¿¿ 258

Creating Forms Using Form Tools 258

Using Form Views 265

Working with a Form Layout Control 268

Sorting Records in a Form 270

Hands-On Exercise 1:

Form Basics 272

Report Basics¿¿¿¿¿¿¿¿ 278

Creating Reports Using Report Tools 278

Using Report Views 285

Modifying a Report 287

Sorting Records in a Report 290

Hands-On Exercise 2:

Report Basics 292

Chapter Objectives Review¿¿¿¿¿¿¿¿ 296

Key Terms Matching¿¿¿¿¿¿¿¿ 298

Multiple Choice 299

Practice Exercises¿¿¿¿¿¿¿¿ 300

Mid-Level Exercises¿¿¿¿¿¿¿¿ 303

Beyond the Classroom¿¿¿¿¿¿¿¿ 306

Capstone Exercise 307

Application Capstone Exercise
Access 309

Glossary 313

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 & Noble.com 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 & Noble.com 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 & Noble.com 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 BN.com 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 & Noble.com and its sublicensees the royalty-free, perpetual, irrevocable right and license to use the review in accordance with the Barnes & Noble.com Terms of Use.
  • - Barnes & Noble.com reserves the right not to post any review -- particularly those that do not follow the terms and conditions of these Rules. Barnes & Noble.com 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 BN.com. 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)