Home

About the Courseware

Copyright: 2017

Authors: Nita Rutkosky, Pierce College Puyallup; Denise Seguin, Fanshawe College; Jan Davidson, Lambton College; Audrey Roggenkamp, Pierce College Puyallup; and Ian Rutkosky, Pierce College Puyallup

With this courseware, students build mastery skills in Access 2016. Students receive step-by-step instructions in creating, formatting and maintaining databases to report and analyze information. A three-level instructional approach moves students from initial modeling of skills to guided application in projects-based exercises to independent problem solving in realistic workplaces.

Order today
View table of contents

Table of Contents

Getting Started in Office 2016.

Level 1

Unit 1. Creating Tables and Queries
1. Managing and Creating Tables
2. Creating Relationships between Tables
3. Performing Queries
4. Creating and Modifying Tables in Design View
Unit 1 Performance Assessment

Unit 2. Creating Forms and Reports
5. Creating Forms
6. Creating Reports and Mailing Labels
7. Modifying, Filtering, and Viewing Data
8. Importing and Exporting Data
Unit 2 Performance Assessment

Level 2

Level 2 Unit 1. Advanced Tables, Relationships, Queries, and Forms
1. Designing the Structure of Tables
2. Designing and Building Relationships and Lookup Fields
3. Advanced Query Techniques
4. Creating and Using Custom Forms
Unit 1. Performance Assessment

Unit 2. Advanced Reports, Access Tools, and Customizing Access.
5. Creating and Using Custom Reports
6. Using Access Tools and Managing Objects
7. Automating, Customizing, and Securing Access
8. Integrating Access Data
Unit 2. Performance Assessment

Courseware Features

After successfully completing a course using this textbook and digital courseware, students will be able to:

  • Create database tables to organize business or personal records.
  • Modify and manage tables to ensure that data is accurate and up to date.
  • Perform queries to assist with decision making.
  • Plan, research, create, revise, and publish database information to meet specific communication needs.
  • Given a workplace scenario requiring the reporting and analysis of data, assess the information requirements and then prepare the materials that achieve the goal efficiently and effectively.

Upon completing the text, students can expect to be proficient in using Access to organize, analyze, and present information.

SNAP 2016

SNAP is a web-based training and assessment platform that accelerates student success in Microsoft® Office. Students get real-world experience working directly in the Microsoft® software and instructors get a suite of powerful tools at their fingertips. Through real-time analytics, instructors get instant performance insight on their students' work, and students can identify their challenges to define their own individual learning paths to success.

Preview SNAP
SNAP features

Precheck quizzes test students' knowledge of chapter content before they study the material. Students can use the results to help focus their study on the skills they need to learn.

Tutorials guide students through the steps for the skills and then allow them to practice on their own. These interactive tutorials include simple instructions and optional help.

Preview images show how students' file should look when they have completed each chapter, skill, review exercise, or assessment.

Recheck quizzes at the end of each chapter enable students to recheck their understanding of the chapter content.

The Workbook ebook provides study resources (such as presentations with audio support, study notes, and tips and hints), review exercises, and assessments to help reinforce students' understanding of the concepts, features, and skills covered in the textbook.