Exploring Microsoft Access 2019 Comprehensive, 1/e + MyLab IT w/ Pearson eText

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

• ISBN13: 9780135825747
• ISBN10: 0135825741
• Edition: 1st
• Format: Package
• Copyright: 2019-07-27
• Publisher: Pearson

Summary

NOTE: Before purchasing, check with your instructor to ensure you select the correct ISBN. Several versions of the MyLab^™ and Mastering^™ platforms exist for each title, and registrations are not transferable. To register for and use MyLab or Mastering, you may also need a Course ID, which your instructor will provide.

Used books, rentals, and purchases made outside of Pearson
If purchasing or renting from companies other than Pearson, the access codes for the MyLab platform may not be included, may be incorrect, or may be previously redeemed. Check with the seller before completing your purchase.

DIGITAL UPDATE available now
Microsoft Office 365 updates will be reflected in the eText and associated MyLab activities, reducing student confusion and keeping course materials current throughout the Office lifecycle. For details, see the Product Announcements page in MyLab IT.

For courses covering introductory Microsoft ^® Access ^™ .
This package includes MyLab IT.

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.

Personalize learning 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.

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