Request full copy

Exploring Microsoft Office Access 2019 Comprehensive, 1st edition

Published by Pearson (March 15, 2019) © 2020

  • Mary Anne Poatsy
  • Jerri Williams Montgomery County Community College
  • Amy M. Rutledge Oakland University

eTextbook

per month

  • Anytime, anywhere learning with the Pearson+ app
  • Easy-to-use search, navigation and notebook
  • Simpler studying with flashcards
$149.32

  • Hardcover, paperback or looseleaf edition
  • Affordable rental option for select titles

MyLab

$119.99

  • Reach every student with personalized support
  • Customize courses with ease
  • Optimize learning with dynamic study tools

For courses covering introductory Microsoft® Access™.

Beyond point-and-click.

Exploring Microsoft Office Access 2019 Comprehensive moves students beyond rote tasks to a deeper comprehension of how, when, and why to apply Office skills. A market leader for over 20 years, the text helps students achieve high-level learning outcomes by engaging them in the way they learn best: through hands-on practice. A dozen exercises in each chapter range from multiple-choice questions to open-ended projects.

Revised to reflect Microsoft Office 365, the 2019 Edition is Mac compatible and adds new critical thinking assignments to help students build fundamental 21st-century skills.

Hallmark features of this title

Focus on outcomes

  • The text supports deeper understanding by design, with white pages highlighting theory-based content and yellow pages for hands-on exercises.
  • Objective mapping outlines clear objectives at the start of each chapter, identifies them by icons throughout, and assesses for mastery with chapter-ending reviews.

Active, flexible learning

  • Mid-Level Exercises include a Creative Case (for PowerPointâ„¢ and Wordâ„¢), an Analysis Case (for Excelâ„¢ and Accessâ„¢) and Discover Steps encouraging students to use Help or to problem-solve to accomplish a task.
  • Application Capstone Exercises test students on the entire contents of a single application.
  • Content for MOS exams is woven in seamlessly and easily identified via icons and a MOS Certification Guide.

New and updated features of this title

Case-based, hands-on learning

  • EXPANDED: The Running Case has been expanded to all applications. One exercise per chapter focuses on the New Castle County Technical Services case, offering a real-world project for reference throughout the semester.

Updated to Microsoft® Office 365® and Mac specifications

  • REVISED: This edition is written to Microsoft Office 365. Regular content updates keep the text current with Office 365, and an Office 365 content updates document is available as an instructor resource.
  • NEW: Now compatible with Mac, this edition includes Mac Tips, On a Mac boxes, and a Mac Student Reference Card to ensure Mac users can use the text as easily as a PC user.
  • NEW:A Mac Troubleshooting feature helps Mac users overcome obstacles while working in Office applications.

Varied assessment options and resources

  • EXPANDED: New assignments and resources have been added to enhance this edition.

Highlights of the DIGITAL UPDATE for MyLab IT (available for Summer 2020 classes)

Instructors, contact your sales rep to ensure you have the most recent version of the course.

  • Microsoft Office 365 updates are reflected in MyLab activities and in the associated eText. These updates reduce student confusion and ensure course materials remain current throughout the Office lifecycle.

Features of MyLab IT for the 1st Edition; published 2019

  • Book-specific 1:1 simulations let students practice in a realistic Office 365 environment using hi-fidelity HTML5 simulations that match the content in the Hands-On Exercises.
  • Book-specific 1:1 Grader projects let students complete end-of-chapter Capstone Exercises live in Office 365 and receive immediate feedback on their performance through various reports. A Grader in each chapter mirrors the Hands-On Exercise in each chapter.

OFFICE

Office 365 Common Features

ACCESS

  1. Introduction to Access
  2. Tables and Queries in Relational Databases
  3. Query Calculations and Expressions
  4. Basic Forms and Reports
  5. Data Validation and Data Analysis
  6. Action and Specialized Queries
  7. Advanced Forms and Reports
  8. Get Connected
  9. Fine-Tuning the Database
  10. Enhanced Database Techniques

APPLICATION CAPSTONE EXERCISE

Access Application Capstone Exercise

About our authors

Mary Anne Poatsy, Series Editor, Windows 10 Author, is a senior faculty member at Montgomery County Community College, teaching various computer applications and concepts courses in face-to-face and online environments. She holds a BA in psychology and education from Mount Holyoke College and an MBA in finance from Northwestern University's Kellogg Graduate School of Management.

Mary Anne has over 20 years of educational experience. She has taught at Montgomery County Community College and Muhlenberg College. She also engages in corporate training. Before teaching, she was Vice President at Shearson Lehman in the Municipal Bond Investment Banking Department.

Amy Rutledge, Access Author, is a special Instructor of MIS (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 BS in business administration, specializing in MIS, and a BA in French modern language and literature. She holds an MBA from Oakland University. She resides in Michigan with her husband, Dan, and daughters, Emma and Jane.

Jerri Williams, Access Author, is a senior instructor at Montgomery County Community College in Pennsylvania, and currently works as a technical editor and content developer in addition to her teaching responsibilities. Jerri worked as a live and virtual corporate trainer and developer in major pharmaceutical and other companies for many years prior to joining the Exploring Access 2013, 2016, and 2019 teams. She is interested in travel, history, cooking, theater, movies, and tending to her colonial farmhouse (a work in progress). Jerri is married to Gareth and is the mother of two daughters, Holly (an accountant/office manager, and mother of an adorable son, Meir) and Gwyneth (a corporate defense/employment attorney). Jerri and Gareth live outside of Philadelphia, and enjoy their home and garden, spending time with family and friends, watching the Philadelphia Eagles, and visiting the Jersey Shore any time of the year.

Need help? Get in touch

Pearson+

All in one place. Pearson+ offers instant access to eTextbooks, videos and study tools in one intuitive interface. Students choose how they learn best with enhanced search, audio and flashcards. The Pearson+ app lets them read where life takes them, no wi-fi needed. Students can access Pearson+ through a subscription or their MyLab or Mastering course.

MyLab

Customize your course to teach your way. MyLab® is a flexible platform merging world-class content with dynamic study tools. It takes a personalized approach designed to ignite each student's unique potential. And, with the freedom it affords to adapt your pedagogy, you can reinforce select concepts and guide students to real results.

Video
Play
Privacy and cookies
By watching, you agree Pearson can share your viewership data for marketing and analytics for one year, revocable upon changing cookie preferences. Disabling cookies may affect video functionality. More info...

Video transcript (PDF | 25KB) 

Empower your students, in class and beyond

Meet students where they are with MyLab®, and capture their attention in every lecture, activity, and assignment using immersive content, customized tools, and interactive learning experiences in your discipline.

Digital Learning NOW

Extend your professional development and meet your students where they are with free weekly Digital Learning NOW webinars. Attend live, watch on-demand, or listen at your leisure to expand your teaching strategies. Earn digital professional development badges for attending a live session.

Explore webinars