Exploring Microsoft Office Access 2016 Comprehensive : 9780134479453

Exploring Microsoft Office Access 2016 Comprehensive

Poatsy & Cameron
Published by
Pearson Higher Ed USA
Out of stock
Title type
Title type
This book offers full, comprehensive coverage of Microsoft Access.

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, anytime. 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.

Table of contents
  • Office 2016 Common Features 
  • Access Chapter 1 Introduction to Access
  • Chapter 2 T ables and Queries in Relational Databases
  • Chapter 3 Using Queries to Make Decisions
  • Chapter 4 Creating and Using Professional Forms and Reports
  • Chapter 5 Data Validation and Data Analysis
  • Chapter 6 Action and Specialized Queries
  • Chapter 7 Advanced Forms and Reports
  • Chapter 8 Get Connected
  • Chapter 9 Fine-Tuning the Database
  • Chapter 10 Using Macros and SQL in Access
  • Access Introductory Capstone Exercise (Chs. 1—4)
  • Access Comprehensive Capstone Exercise (Chs. 5—10)
  • Glossary
  • Index
  • Application
  • Capstone
  • Exercises
New to this edition

The Exploring series charts students beyond the “point and click,” helping them understand WHY they use Microsoft Office skills along with HOW they perform them. The latest edition provides an easy-to-follow map through each chapter to help students learn, study, and review efficiently and be successful in this class and beyond.

New to the Exploring Series:

  • Two-page chapter opener highlights the new outcomes, objectives, case study, and starting student data files
  • Outcomes now added for each chapter
  • Starting & Ending Data Files identified at the beginning of each chapter
  • New Hands-On Exercise Videos cover both the essential Why & How of each exercise, walking students through the click path and explaining the concepts throughout.
  • Application Capstone exercises are included in the book to allow instructors to test students on the en┬┐tire contents of a single application. These are available as a Homework Grader Project in MyITLab and now have an Assessment version as well.
  • Microsoft Office Specialist (MOS) Certification Guide for instructors and students to direct anyone interested in prepping for the MOS exam to the specific locations to find all content required for the test.


Also available with MyITLab

MyITLab® is an online homework, tutorial, and assessment program designed for Information Technology (IT) courses, to engage students and improve results. HTML5 Simulation exercises and Live-in-Application Grader projects come with the convenience of auto-grading and instant feedback, so students learn more quickly and effectively, and build the critical skills needed for college and career success. Digital badges allow students to showcase their Microsoft Office or Computer Concepts competencies, keeping them motivated and focused on their future careers.

  • MyITLab 2016 Grader Projects: Live-in-the-Application auto-graded projects are available for the Mid-Level Exercises and Capstone Exercises in the textbook.
  • Simulations for Office 2016 have been updated to match the pedagogical approach of the textbook projects, providing a direct, one-to-one learning experience.
  • Windows 10 Coverage includes topic-based simulation trainings for the Windows 10 skills covered in the textbook, helping students get up and running with the new operating system.
  • IT Innovation Station lets you stay current with Office and Windows updates, news, and trends, especially now that Microsoft Office is in the cloud. Monthly updates on the MyITLab Community site from Pearson’s product team and author-instructors offer tips on understanding the updates, using new capabilities, implementing new instructional techniques, and optimizing your Office usage.


Features & benefits


  • The How/Why approach helps students go from learning steps and performing tasks to gaining a true understanding of how to apply Microsoft Office skills.
    • White/Yellow Pages clearly distinguish the theory (white pages) from the skills covered in the Hands-On Exercises (yellow pages) so students always know what they are supposed to be doing.
    • Case Study presents a scenario for the chapter, creating a story that ties the Hands-On Exercises together.
    • Hands-On Exercise Videos–tied to each Hands-On Exercise–walk students through the steps of the exercise while weaving in conceptual information related to the Case Study and objectives.
  • The Outcomes focus keep both students and instructors aware of the higher-level learning goals and how those are achieved through discreet objectives and skills.
    • Outcomes are presented at the beginning of each chapter, identifying the learning goals that will be achieved in the material ahead.
    • Enhanced Objective Mapping give students a learning path for the chapter, from the objectives list in the beginning through the exercises at the end.
      • Objectives List: a simple list of key objectives covered in the chapter, with page numbers so students can skip to the objectives where they need the most help.
      • Step Icons appear in the white pages and reference the step numbers in the Hands-On Exercises, providing a correlation between the two so students can easily find conceptual help when they are working hands-on and need a refresher.
      • Quick Concepts Checks appear at the end of each white page section. These questions cover the essential concepts students will need to be successful in working the Hands-On Exercises. Page numbers are included for easy reference to help students locate the answers.
      • Chapter Objectives Review, near the end of the chapter, reviews all the important concepts throughout the chapter.
        • NEW! Chapter Objectives Review is redesigned in an easy-to-read bulleted format.
  • Microsoft Office Specialist (MOS) Certification Guide directs anyone interested in prepping for the MOS exam to the specific locations to find all content required for the test.
  • End-of-Chapter Exercises offer instructors several options for assessment, with 12—15 exercises ranging from multiple choice questions to open-ended projects: Multiple Choice, Key Terms Matching, Practice Exercises, Mid-Level Exercises, Beyond the Classroom Exercises, and Capstone Exercises.
    • NEW! Every chapter now includes a Key Terms Matching exercise, a Collaboration Case, and Soft Skills Case.
    • NEW! Key Terms Matching exercises require students to match key terms to their definitions. This requires students to work actively with important vocabulary and prove conceptual understanding.
    • Enhanced! Mid-Level Exercises
      • Creative Case (for PowerPoint and Word) allows students some flexibility and creativity, without being bound by a definitive solution.
      • Analysis Case (for Excel and Access) requires students to interpret the data they are using to answer an analytic question.
      • Discover Steps encourage students to use Help or to problem-solve to accomplish a task.
    • Application Capstone exercises allow instructors to test students on the entire contents of a single application.
  • New design with wide screen screenshots allows students to see the details in screenshots for better comprehension.

  •  New Access Running Case at the Mid-Level, carrying concepts and applications through each chapter.

Author biography

Mary Anne Poatsy, Series Editor

Mary Anne is a senior faculty member at Montgomery County Community College, teaching various computer application and concepts courses in face-to-face and online environments. She holds a B.A. in Psychology and Education from Mount Holyoke College and an M.B.A. in Finance from Northwestern University’s Kellogg Graduate School of Management. Mary Anne has more than 12 years of educational experience. She is currently adjunct faculty at Gwynedd-Mercy College and Montgomery County Community College. She has also taught at Bucks County Community College and Muhlenberg College, as well as conducted personal training. Before teaching, she was Vice President at Shearson Lehman in the Municipal Bond Investment Banking Department.

Eric Cameron

Eric Cameron is a tenured Associate Professor at Passaic County Community College, where he has taught in the Computer and Information Sciences department since 2001. He holds an M.S. in Computer Science and a B.S. degree in Computer Science with minors in Mathematics and Physics, both from Montclair State University. He currently co-chairs the College’s General Education committee and served as a member of the College’s Academic Assessment, College Writing, and Educational Technology committees at various points. Eric has also developed degrees in Graphic Design and Medical Informatics for the College. Eric previously worked as a software engineer both as a full-time employee and contractor, most recently for ITT/Exelis (now part of Harris Corporation). This is Eric’s fourth publication for Pearson, after authoring Web 2.0 and Windows 8 books in the Your Office series and co-authoring the Exploring Access 2013 text.


Jerri Williams

Jerri Williams is a Senior Instructor at Montgomery County Community College in Pennsylvania. Jerri also works as an independent corporate trainer, technical editor, and content developer. She is interested in travel, cooking, movies, and tending to her colonial farmhouse. Jerri is married, and is the mother of two daughters, Holly (an Accounting graduate and full-time mother to an adorable son, Meir) and Gwyneth (a corporate defense attorney). Jerri and Gareth live in the suburbs of Philadelphia. They enjoy their home and garden, and spending time with family and good friends.

Amy Rutledge

Amy Rutledge is a Special Instructor of Management Information Systems at Oakland University in Rochester, Michigan. She coordinates academic programs in Microsoft Office applications and introductory management information systems courses for the School of Business Administration. Before joining Oakland University as an instructor, Amy spent several years working for a music distribution company and automotive manufacturer in various corporate roles including IT project management. She holds a B.S. in Business Administration specializing in Management Information Systems, and a B.A. in French Modern Language and Literature. She holds an M.B.A from Oakland University. She resides in Michigan with her husband, Dan and daughters Emma and Jane.


Dr. Robert T. Grauer, Creator of the Exploring Series

Bob Grauer is Professor Emeritus in the Department of Computer Information Systems at the University of Miami, where he is a multiple winner of the Outstanding Teaching Award in the School of Business, most recently in 2009. He has written numerous COBOL texts and is the vision behind the Exploring Office series, with more than three million books in print. His work has been translated into three foreign languages and is used in all aspects of higher education at both national and international levels. Bob Grauer has consulted for several major corporations including IBM and American Express. He received his Ph.D. in Operations Research in 1972 from the Polytechnic Institute of Brooklyn.


Student supplements