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

by Kinser, Amy; Moriarity, Brant; Kinser, Eric; Nightingale, Jennifer

• ISBN13: 9780135825976
• ISBN10: 0135825970
• Edition: 1st
• Format: Package
• Copyright: 2019-08-09
• 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 Microsoft ^® Access ^™ . Ideal for business courses.
This package includes MyLab IT.

Real-world problem-solving for business and beyond
Your Office: Microsoft Office 365, Access 2019 Comprehensive prepares students to apply both technical and soft skills in real business settings. Hands-¿on technical content together with realistic business cases help students use Microsoft Access as a decision-making tool for business areas such as finance and accounting, production and operations, and sales and marketing. Chapters are grouped by business units to align the text with AACSB requirements. Updated for Office 365, the 2019 edition includes 2019 MOS objectives and improved links between cases within the text and MyLab IT Grader projects.

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.

0135825970 / 9780135825976 Your Office: Microsoft Access 2019 Comprehensive, 1/e + MyLab IT w/ Pearson eText, 1/e
Package consists of:

• 0135391962 / 9780135391969 Your Office: Microsoft Office 365, Access 2019 Comprehensive, 1/e
• 0135440343 / 9780135440346 MyLab IT with Pearson eText -- Access Card -- for Your Office: Microsoft 2019 Comprehensive, 1/e

Author Biography

Amy S. Kinser, Esq., Series Editor, holds a BA degree in chemistry with a business minor from Indiana University, and a JD from the Maurer School of Law, also at Indiana University. After working as an environmental chemist, starting her own technology consulting company, and practicing intellectual property law, she has spent the past 15 years teaching technology at the Kelley School of Business in Bloomington, Indiana. Currently, she serves as Director of Computer Skills and senior lecturer at the Kelley School of Business at Indiana University. She loves spending time with her two sons, Aidan and J. Matthew, and her husband, J. Eric.

Brant P. Moriarity earned a BA degree in religious studies/philosophy and an MS degree in information systems at Indiana University. He is a senior lecturer at Indiana University’s Kelley School of Business, where he teaches topics such as data management and analysis, as well as the strategic use of information systems in business. He is also the founder of Beats Per Minute Technologies, LLC, bringing the benefits of business analytics and custom database application development to small businesses and nonprofit organizations.

J. Eric Kinser received his BS degree in biology from Indiana University and his MS in counseling and education from the Indiana School of Education. He has worked in the medical field and in higher education as a technology and decision support specialist. He is currently a senior lecturer in the Operations and Decision Technology Department at the Kelley School of Business at Indiana University. When he’s not teaching, he enjoys experimenting with new technologies, traveling, and hiking with his family.

Jennifer Paige Nightingale, associate professor at Slippery Rock University of Pennsylvania, has taught information systems management since 2000. Before joining Slippery Rock University, she spent 15 years in industry with a focus in management and training. Her research expertise is in instructional technology, using technology as a teaching tool, and the impact of instructional technologies on student learning. She has earned numerous teaching and research honors and awards, and holds an EdD in instructional technology and two MS degrees in information systems management and education from Duquesne University, as well as a BA degree from the University of Pittsburgh.

Table of Contents

COMMON FEATURES
1. Understanding the Common Features of Microsoft Office

ACCESS

ACCESS BUSINESS UNIT 1
1. The Four Main Database Objects
2. Tables, Keys, and Relationships
Access Business Unit 1 Capstone

ACCESS BUSINESS UNIT 2
3. Queries and Data Access
4. Using Forms and Reports in Access
Access Business Unit 2 Capstone

ACCESS BUSINESS UNIT 3
5. Advanced Tables
6. Pattern Matching and Functions in Queries
Access Business Unit 3 Capstone

ACCESS BUSINESS UNIT 4
7. Aggregated Calculations, Subquerying, and SQL
8. Action Queries and Advanced Relationships
Access Business Unit 4 Capstone

ACCESS BUSINESS UNIT 5
9. Advanced Form Settings and Form Types
10. Advanced Reports and Mailing Labels
Access Business Unit 5 Capstone

ACCESS BUSINESS UNIT 6
11. Develop Navigation Forms and the User Interface
12. Create a Refined User Experience with Macros
Access Business Unit 6 Capstone

ACCESS BUSINESS UNIT 7
13. Use VBA in Access
14. Implement Your Database
Access Business Unit 7 Capstone

Appendices
A. Access Appendix
B. Mac Appendix
C. MOS Core
D. MOS Expert