Product Cover Image

Exploring: Microsoft Access 2013, Introductory, CourseSmart eTextbook

By Mary Anne Poatsy, Cynthia Krebs, Eric Cameron, Robert T. Grauer

Published by Prentice Hall

Published Date: Aug 22, 2013

Description

For use in the Office Applications course

 

Move students beyond the point and click

 

The goal of the Exploring series has been to move students beyond the point and click, helping them understand the why and how behind each skill. The Exploring series also enables students to extend the learning beyond the classroom–a lot of learning takes place outside of the classroom, and the Exploring series provides learning tools that students can access anytime, anywhere.

 

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 every one needs to know.

 

Teaching and Learning Experience

This program will provide a better teaching and learning experience–for you and your students. Here’s how:


  • Personalize Learning: MyITLab delivers proven results in helping students succeed, provides engaging experiences that personalize learning, and comes from a trusted partner with educational expertise and a deep commitment to helping students and instructors achieve their goals.
  • Move Beyond the Point and Click: Students can move beyond the basics of the software at a faster pace, without sacrificing coverage of fundamental skills.
  • Extend Learning Beyond the Classroom: A lot of learning takes place outside of the classroom, and the Exploring series provides learning tools that students can access anytime, anywhere.

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

Purchase Info ?

With CourseSmart eTextbooks and eResources, you save up to 60% off the price of new print textbooks, and can switch between studying online or offline to suit your needs.

Once you have purchased your eTextbooks and added them to your CourseSmart bookshelf, you can access them anytime, anywhere.

Buy Access

Exploring: Microsoft Access 2013, Introductory, CourseSmart eTextbook
Format: Safari Book

$36.99 | ISBN-13: 978-0-13-335011-1