- Shopping Bag ( 0 items )
Other sellers (Other Format)
-
All (10) from $78.39
-
New (9) from $78.39
-
Used (1) from $88.66
More About This Textbook
Overview
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.
Product Details
Related Subjects
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