Your Office: Microsoft Access 2013, Comprehensive

ALERT: Before you purchase, check with your instructor or review your course syllabus to ensure that you select the correct ISBN. Several versions of Pearson's MyLab & Mastering products exist for each title, including customized versions for individual schools, and registrations are not transferable. In addition, you may need a CourseID, provided by your instructor, to register for and use Pearson's MyLab & Mastering products.

Packages

Access codes for Pearson's MyLab & Mastering products may not be included when purchasing or renting from companies other than Pearson; check with the seller before completing your purchase.

Used or rental books

If you rent or purchase a used book with an access code, the access code may have been redeemed previously and you may have to purchase a new access code.

Access codes

Access codes that are purchased from sellers other than Pearson carry a higher risk of being either the wrong ISBN or a previously redeemed code. Check with the seller prior to purchase.

  --

For use in the Office Applications course or individuals who would like to master Microsoft Access 2013

Make Microsoft Office, Your Office

The Your Office series teaches readers the way Microsoft Office works in the real world, not just in a classroom.

With Your Office, readers will learn to use Office to make decisions and solve problems in a business context. Your Office bridges the gap between skill and application, and empowers students to master Office 2013 as a tool to solve problems and make decisions.

• Modular Structure Promotes Concept Retention: Provides a strong foundation for readers to practice in each workshop and then synthesize the objectives covered over two workshops–effectively challenging students to really retain what they learned as opposed to learning, and then forgetting soon after.
• Case Progression Promotes Concept Mastery: Readers progress from learning the skills in each Office Application to using the applications as tools to make business decisions.
• Realistic Series Scenario Provides Business Context: Readers gain a solid understanding of how an organization works as they see how individuals in all facets of a business interact with tools like Microsoft Office and use information to make decisions.
• Engaging Features Help Students Make Microsoft Office Their Own: Videos, Visual Summaries, and Real-World Advice boxes are among the features that help readers master Office to make decisions and solve problems in a business context.

The Your Office series prepares you to use both technical and soft skills in the real world. Our modern approach weaves the technical content into realistic business scenarios and focuses on using Office as a decision-making tool. Students learn best by doing, so you will be active from page 1. There is plenty of guidance at first, but the case exercises will ask more from you as the book progresses. Innovative features help you progress from a basic understanding to mastery of each application, empowering you to perform with confidence in Windows 8, Word, Excel, Access, and PowerPoint, even on mobile devices. No matter what career path you're on, the Your Office series will give you the foundation to succeed.

Make Microsoft Office, Your Office

The Your Office series prepares you to use both technical and soft skills in the real world. Our modern approach weaves the technical content into realistic business scenarios and focuses on using Office as a decision-making tool. Students learn best by doing, so you will be active from page 1. There is plenty of guidance at first, but the case exercises will ask more from you as the book progresses. Innovative features help you progress from a basic understanding to mastery of each application, empowering you to perform with confidence in Windows 8, Word, Excel, Access, and PowerPoint, even on mobile devices. No matter what career path you’re on, the Your Office series will give you the foundation to succeed.

013378195X / 9780133781953  Technology in Action, Introductory, Your Office: Microsoft Access, Your Office: Microsoft Excel, Comprehensive 2013, 10/e

Package consists of:   

0133141020 / 9780133141023 Technology in Action, Introductory

0133143031 / 9780133143034 Your Office: Microsoft Access 2013, Comprehensive

0133143228 / 9780133143225 Your Office: Microsoft Excel 2013, Comprehensive

0133815609 / 9780133815603 MyITLab without Pearson eText -- Access Card -- for Your Office with Technology In Action (Replacement Card) 

Contents

Common Features

Common Features WORKSHOP 1: The Common Features of Microsoft Office

PREPARE CASE: Painted Paradise Resort and Spa Employee Training Preparation

Working with the Office Interface

Understand Office Applications and Accounts

Start Office Programs and Manipulate Windows

Use the Office Ribbon, Contextual Tools, and Other Menus

Manipulating Files and Finding Help in Office

Manage Files in Office

Get Help

Understanding the Cloud and Touch Integration

Use Windows SkyDrive

Use Touch Mode, Gestures, and Reading Mode

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

Perform in Your Life

Access Module 1-Understanding and Using a Relational Database

Access WORKSHOP 1: The Four Main Database Objects

PREPARE CASE: Red Bluff Golf Club Putts for Paws Charity Tournament

Understanding Database Basics and Tables

Understand what Access Is

Maneuvering in the Navigation Pane

Understand what a Table Is

Manually Navigate a Database

Understanding Queries, Forms, and Reports

Understand what a Query Is

Understand what a Form Is

Understand what a Report Is

Backing Up Your Database

Compact and Repair a Database

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

Access WORKSHOP 2: Tables, Keys, and Relationships

PREPARE CASE: Red Bluff Golf Club Putts for Paws Charity Tournament Database

Inserting Data into a Database

Importing Data from Other Sources

Manual Data Entry

Understanding Tables and Keys

Creating a Table in Design View

Understand Masks and Formatting

Understanding and Designating Keys

Understanding Relational Databases

Understanding Basic Principles of Normalization

Understanding Relationships

Create a One-to-Many Relationship

Create a Many-to-Many Relationship

Understanding Referential Integrity

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

Access Module 1 Capstone

More Practice

More Practice Case 1

Problem Solve

Problem Solve Case 1

Problem Solve Case 2

Perform

Perform in Your Life

Perform in Your Career

Perform in Your Group

How Others Perform

Access Module 2-Accessing, Maintaining, and Presenting Information

Access WORKSHOP 3: Queries and Data Access

PREPARE CASE: Turquoise Oasis Spa Data Management

Work With Datasheets

Find and Replace Records in the Datasheet

Modify Datasheet Appearance

Queries

Run Other Query Wizards

Create Queries in Design View

Sort Query Results

Define Selection Criteria for Queries

Create Aggregate Functions

Create Calculated Fields

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

Access WORKSHOP 4: Access Information from an Access Database

PREPARE CASE: Turquoise Oasis Spa's New Database

Creating Customized Forms

Navigate in datasheets and forms

Update Table Records Using Forms

Create a Form Using the Form Wizard

Modify a Form’s Design

Creating Customized Reports

Create a Report Using the Report Wizard

Use and Customize Access Themes

Modify a Report’s Design

Save a Report as a PDF File

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

Access Module 2 Capstone

More Practice

More Practice Case 1

Problem Solve

Problem Solve Case 1

Problem Solve Case 2

Perform

Perform in Your Life

Perform in Your Career

Perform in Your Group

How Others Perform

Access Module 3-Ensuring Consistent Data and Advanced Querying

Access WORKSHOP 5: Advanced Tables

PREPARE CASE: The Red Bluff Golf Club: Modifying Database Tables

Controlling the Way Data Is Entered: Advanced Field Options

Understand Input Masks

Use Custom Formatting

Define Data Validation Rules

Work with Captions

Create Indexes

Use the Required Data Property

Define Default Values

Advanced Data Types

Create Lookup Fields

Use the Calculated Data Type

Use the Yes/No Data Type

Use AutoNumbers and Determining Preferences for Natural Keys

Use the Attachments, Hyperlinks, and OLE Objects Data Types

Filtering Data

Create Filters

Using the Table Analyzer Wizard

Normalize a Table

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

Access WORKSHOP 6: Pattern Matching and Functions in Queries

PREPARE CASE: The Red Bluff Golf Club: Creating Queries

Working with Advanced Criteria and Calculations

Wildcard Characters in String Comparisons

Find Records with the “Most” or “Least” Values

Make a Parameter Query Ask for Input

Concatenate Strings Using the & Operator

Use Advanced Query Operators

Using Advanced Functions in Queries

The IIf Function

The IsNull Function

Date Functions

The Round Function

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

Access Module 3 Capstone

More Practice

More Practice Case 1

Problem Solve

Problem Solve Case 1

Problem Solve Case 2

Perform

Perform in Your Life

Perform in Your Career

Perform in Your Group

How Others Perform

Access Module 4-Leveraging Queries for Business Information and Intelligence

Access WORKSHOP 7: Aggregated Calculations, Subquerying, and SQL

PREPARE CASE: The Turquoise Oasis Spa Database: Querying with Advanced Calculations

Understanding the Group By Aggregate Function in Aggregated Calculations

The Group By Clause

Summarize Data

Summarize Duplicate Data

Understanding the Where Aggregate Function in Aggregated Calculations

Where Aggregate Function

Business Calculations Using Subquerying

Subqueries

Percentage of Sales Revenue

Percentage of Sales Volume

Physical Volume

Percentage of Physical Volume

Understanding Structured Query Language

SQL Statements

SELECT Statement Basics

Create a Basic SQL Query

The WHERE Clause

The ORDER BY Clause

The HAVING Clause with AS and GROUP BY

The INNER JOIN and OUTER JOIN Clauses

The Union Query

The SQL Subquery

Creating a Crosstab Query

Crosstab Query Wizard

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

Access WORKSHOP 8: Action Queries and Advanced Relationships

PREPARE CASE: The Turquoise Oasis Spa: Understanding Action Queries

Understanding Action Queries

Create a New Table Using a Make Table Query

Append Data to a Table

Edit and Delete Data

Create, Test, and Run Delete Queries

Advanced Relationships Using Multiple Tables

Inner Joins

Outer Joins

Use the Find Unmatched Query Wizard

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

Access Module 4 Capstone

More Practice

More Practice Case 1

Problem Solve

Problem Solve Case 1

Problem Solve Case 2

Perform

Perform in Your Life

Perform in Your Career

Perform in Your Group

How Others Perform

Access Module 5-Producing Professional Forms and Reports

Access WORKSHOP 9: Advanced Form Settings and Form Types

PREPARE CASE: Enhancing Data Entry at the Red Bluff Golf Club

Working with Form Properties

Define Bound and Unbound Forms

Modify the Form Property Sheet

Using Advanced Form Modification

Modify the Form Header

Modify the Form in Design View

Creating Advanced Forms

Create Specialized Forms

Create a Multipage Form Using Tab Controls

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

Access WORKSHOP 10: Advanced Reports and Mailing Labels

PREPARE CASE: Enhancing Database Reports at the Red Bluff Golf Club

Creating Customized Reports

Use the Summary Options in Report Wizard

Modify the Report in Design View

Selecting and Modifying Controls in Design View

Change Report Properties

Add and Remove Fields from a Report

Use the Group, Sort, and Total Pane

Add Labels and Shapes to a Report

Modify Calculated Fields in a Report

Creating Parameter Reports

Create a Parameter Report

Use Conditional Formatting in a Report

Creating Mailing Labels

Create Mailing Labels

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

Access Module 5 Capstone

More Practice

More Practice Case 1

Problem Solve

Problem Solve Case 1

Problem Solve Case 2

Perform

Perform in Your Life

Perform in Your Career

Perform in Your Group

How Others Perform

Access Module 6-Building a Refined User Interface and Experience

Access WORKSHOP 11: Develop Navigation Forms and the User Interface

PREPARE CASE: Turquoise Oasis Spa Database

Creating Navigation Forms

View a Navigation Form

Create a Navigation Form

Modify a Navigation Form

Refining the User Interface

Create a Main Menu

Add Command Buttons to the Navigation Form

Set Start-Up Display Options

Test the Application

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

Access WORKSHOP 12: Create a Refined User Experience with Macros

PREPARE CASE: The Turquoise Oasis Spa Database: Automating Tasks and Increasing Functionality

Understanding the Purpose of Macros

Modify Database Settings for Protection from Macro Viruses

Understand the Macro Designer

Understand How to Test and Troubleshoot Macros

Increase Efficiency and Usability of a Database by Automating Tasks

Improve Database Design and Function by Automating Manual Processes

Reduce Processing Time by Combining Routine Tasks

Create Macro Groups

Create Macros That Run When the Database Opens

The Benefits of Embedded Macros

Increase Functionality of Forms and Reports

Implement Complex Business Rules with Data Macros

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

Access Module 6 Capstone

More Practice

More Practice Case 1

Problem Solve

Problem Solve Case 1

Problem Solve Case 2

Perform

Perform in Your Life

Perform in Your Career

Perform in Your Group

How Others Perform

Access Module 7-Implementing and Automating a Database with VBA

Access WORKSHOP 13: Use VBA In Access

PREPARE CASE: The Red Bluff Golf Course & Pro Shop Putts for Paws Charity Database

Introducing VBA Basics

Understand the Functionality of VBA in Access

Convert an Existing Macro to VBA

Edit and Structure VBA Procedures

Create and Use Loops in VBA

Adding VBA to an Access Database

Create VBA Procedures

Use Comments to Document VBA Procedures

Debug the VBA in a Database and Add Error Handling

Compiling and Securing Your VBA

Compile VBA Modules

Secure VBA in a Database

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

Access WORKSHOP 14: Implement Your Database

PREPARE CASE: The Red Bluff Golf Course & Pro Shop Putts for Paws Charity Database

Implementing a Database

Shared and Exclusive Modes

Prepare a Database for a Single User

Compatibility Between Versions of Access

Prepare a Database for Multiple Users

Encryption and Passwords

Setting the User’s Experience

Control Startup Options

Methods of Implementation

Concept Check

Key Terms

Visual Summary

Practice

Practice Case 1

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

Access Module 7 Capstone

More Practice

More Practice Case 1

Problem Solve

Problem Solve Case 1

Problem Solve Case 2

Perform

Perform in Your Life

Perform in Your Career

Perform in Your Group

How Others Perform

Appendix A: Efficient Interaction with a Touchscreen

PREPARE CASE: Painted Paradise Resort and Spa Works with Touch Features

Interacting with a Windows 8 Tablet PC

Understand Variations in Tablets

Understand Methods for Interacting with a Tablet PC

Using the Touch-Screen Interface

Use Flick, Touch, and Bezel Gestures

Use Office 2013 Touch Gestures

Use Other Touch Features

Concept Check

Key Terms

Appendix B: Normalize a Database for Effective Design

PREPARE CASE: The Terra Cotta Brew Coffee Shop Designing a Normalized Database

Normalizing a Database

Types of Anomalies

The First Normal Form

The Second Normal Form

The Third Normal Form

Join Tables Together in Relationships with Referential Integrity

Understanding an Entity Relationship Diagram

Concept Check

Key Terms

Visual Summary

Problem Solve

Problem Solve Case 1

Perform

Perform in Your Career

How Others Perform