I'm a studentI'm an educator

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

Published by Pearson (September 18, 2020) © 2020

  • Amy S. Kinser Indiana University
  • Kristyn Jacobson
  • Eric Kinser Indiana University
  • Brant Moriarity
  • Jennifer Paige Nightingale
Products list
per month
-month term, pay monthly or pay
Buy nowOpens in a new tab
Instant access

eTextbook features

  • Instant access to eTextbook
  • Search, highlight, and notes
  • Create flashcards
Products list
$149.32

Price Reduced From: $186.65

Details

  • A print text
Products list
$119.99
Buy accessOpens in a new tab
14 day temporary access available

Access details

  • Pearson+ eTextbook with study tools
  • Instant access once purchased
  • Register with a Course ID, a link from your instructor or an LMS link (Blackboardâ„¢, Canvasâ„¢, Moodle or D2L®)

Features

  • Interactive digital learning experience
  • Help when and where you need it
  • Instant feedback on assignments
  • Apps and study tools

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

The 2019 Edition has been updated for Office 365 and offers visual features designed to help you navigate the text more efficiently. This edition covers 2019 MOS objectives and includes a MOS Certification Guide so those who seek certification can quickly locate the MOS objectives covered in each chapter.

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

This publication contains markup to enable structural navigation and compatibility with assistive technologies. Images in the publication are fully described. The publication supports text reflow, is screen-reader friendly, and contains no content hazards known to cause adverse physical reactions.

Need help? Get in touch