Exploring Microsoft Office Access 2019 Comprehensive

by Poatsy, Mary Anne; Williams, Jerri; Rutledge, Amy M.

• ISBN13: 9780135435816
• ISBN10: 0135435811
• Edition: 1st
• Format: Spiral Bound
• Copyright: 2019-03-15
• Publisher: Pearson

Summary

Now live! SUMMER 2020 DIGITAL UPDATE for digital content
Microsoft Office 365 updates are reflected in the eText and associated MyLab for this title. Instructors, to learn more, contact your Pearson representative.

For courses covering introductory Microsoft^® Access^™.

Beyond point-and-click
The Exploring Microsoft^® Office 365^® series 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 collection 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 adds new critical thinking assignments to help students build fundamental 21st-century skills.

Also available with MyLab IT
By combining trusted author content with digital tools and a flexible platform, MyLab personalizes the learning experience and improves results for each student. MyLab IT 2019 delivers trusted content and resources through an expansive course materials library, including new easy-to-use Prebuilt Learning Modules that promote student success. Through an authentic learning experience, students become sharp critical thinkers and proficient in Microsoft Office, developing essential skills employers seek.

Note: You are purchasing a standalone product; MyLab IT does not come packaged with this content. Students, if interested in purchasing this title with MyLab IT, ask your instructor to confirm the correct package ISBN and Course ID. Instructors, contact your Pearson representative for more information.

If you would like to purchase both the physical text and MyLab IT, search for:

0135825741 / 9780135825747 Exploring: Microsoft Access 2019 Comprehensive, 1/e + MyLab IT w/ Pearson eText, 1/e
Package consists of: 

• 0135402468 / 9780135402467 MyLab IT with Pearson eText -- Access Card -- for Exploring Microsoft Office 2019, 1/e
• 0135435811 / 9780135435816 Exploring Microsoft Office Access 2019 Comprehensive, 1/e

Author Biography

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.

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.

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.

Table of Contents

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