did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

did-you-know? rent-now

Amazon no longer offers textbook rentals. We do!

We're the #1 textbook rental company. Let us show you why.

9780133412192

Exploring Microsoft Access 2013, Introductory

by ; ; ;
  • ISBN13:

    9780133412192

  • ISBN10:

    0133412199

  • Edition: 1st
  • Format: Package
  • Copyright: 2013-07-02
  • Publisher: Pearson

Note: Supplemental materials are not guaranteed with Rental or Used book purchases.

Purchase Benefits

  • Free Shipping Icon Free Shipping On Orders Over $35!
    Your order must be $35 or more to qualify for free economy shipping. Bulk sales, PO's, Marketplace items, eBooks and apparel do not qualify for this offer.
  • eCampus.com Logo Get Rewarded for Ordering Your Textbooks! Enroll Now
List Price: $106.65 Save up to $26.66
  • Buy Used
    $79.99
    Add to Cart Free Shipping Icon Free Shipping

    USUALLY SHIPS IN 2-4 BUSINESS DAYS

Supplemental Materials

What is included with this book?

Summary

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.

 

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
Index

Supplemental Materials

What is included with this book?

The New copy of this book will include any supplemental materials advertised. Please check the title of the book to determine if it should include any access cards, study guides, lab manuals, CDs, etc.

The Used, Rental and eBook copies of this book are not guaranteed to include any supplemental materials. Typically, only the book itself is included. This is true even if the title states it includes any access cards, study guides, lab manuals, CDs, etc.

Rewards Program