Your Office: Microsoft Office 365, Access 2019 Comprehensive, 1st edition

Published by Pearson (February 26, 2019) © 2020

  • Amy S. Kinser Indiana University
  • Brant Moriarity
  • Kristyn Jacobson
  • Eric Kinser Indiana University
  • Jennifer Paige Nightingale

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
  • Free shipping on looseleafs and traditional textbooks

MyLab

$119.99

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

For courses covering Microsoft® Access™. Ideal for business courses.

Real-world problem-solving for business and beyond

Your Office: Microsoft Office 365, Access 2019 Comprehensive preps students to apply technical and soft skills in real business settings. Hands-on technical content and realistic cases help students use 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.

The 2019 Edition has been updated for Office 365 and includes 2019 MOS objectives.

Hallmark features of this title

Case-based learning

  • Students complete a chapter-by-chapter Global Business Scenario aided by blue boxes outlining case steps and challenged by Consider This critical-thinking questions and discussion topics.
  • Chapter-ending Practice, Problem Solve and Perform Cases reinforce learning, as do Capstone cases.

Real-world focus

  • Advice boxes simulate a manager's best-practice advice and graduates share experience in Real-world Success features; and icons identify where specific business areas or soft skills are represented.
  • Office 365 coverage includes data type and Query by Form (Access).

Study Aids

  • The MOS Certification Guide reflects 2019 objectives and locates them in the text.
  • Chapter objectives are tested and reviewed by Concept Checks and Visual Summaries.

New and updated features of this title

  • UPDATED: Detailed information on the updated ribbon helps students navigate Office 365 effectively.
  • NEW: A more accessible design helps learners use the text more efficiently.

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

  • Supplementary videos expand on the recurring Global Business Scenario that appears in each chapter, while Real-world Interview videos support the Real-world Success feature in the text, and Soft Skills videos coach students on key employability skills.
  • The 1:1 link between MyLab IT Grader projects and in-text cases is strengthened by a Grader Heads Up feature which highlights differences between them.
  • Closely aligned with Prepare and Problem Solve cases in the text, book-specific 1:1 Grader projects let students work live in Office applications, while Autograded critical thinking modules include an Application Capstone that can lead to an Office application badge, and a quiz that can earn a critical thinking badge.
  • Badges let students showcase high-demand Microsoft Office skills to potential employers. Students can share their badges through social media and online portfolios.
  • Regular content updates keep you and your students current with Office 365.

COMMON FEATURES

  1. Understanding the Common Features of Microsoft Office

ACCESS BUSINESS UNIT 1

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

ACCESS BUSINESS UNIT 2

  1. Queries and Data Access
  2. Using Forms and Reports in Access
    • Access Business Unit 2 Capstone

ACCESS BUSINESS UNIT 3

  1. Advanced Tables
  2. Pattern Matching and Functions in Queries
    • Access Business Unit 3 Capstone

ACCESS BUSINESS UNIT 4

  1. Aggregated Calculations, Subquerying, and SQL
  2. Action Queries and Advanced Relationships
    • Access Business Unit 4 Capstone

ACCESS BUSINESS UNIT 5

  1. Advanced Form Settings and Form Types
  2. Advanced Reports and Mailing Labels
    • Access Business Unit 5 Capstone

ACCESS BUSINESS UNIT 6

  1. Develop Navigation Forms and the User Interface
  2. Create a Refined User Experience with Macros
    • Access Business Unit 6 Capstone

ACCESS BUSINESS UNIT 7

  1. Use VBA in Access
  2. Implement Your Database
    • Access Business Unit 7 Capstone

Appendices

  1. Access Appendix
  2. Mac Appendix
  3. MOS Core
  4. MOS Expert

About our authors

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.

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 by deleting your cookies.

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.