This is the eBook of the printed book and may not include any media, website access codes, or print supplements that may come packaged with the bound book. 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