Your Office: Microsoft Office 365, Excel 2019 Comprehensive

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

  • Amy S. Kinser, 
  • Kristyn A. Jacobson, 
  • Eric Kinser, 
  • Brant Moriarity, 
  • Jennifer Paige Nightingale

Choose the option that's right for you

Single

$9.99 / mo

4-month minimum term for $39.96

  • Access this eText title
  • Up to 2 devices

Multi

$14.99 / mo

4-month minimum term for $59.96

  • Access over 1,500 titles
  • Up to 2 devices
  • Discounted tutor access

Learn more, spend less

  • Icon

    Study smarter, not harder

    Save time with study tools in your eText

  • Icon

    Watch and learn

    Videos & animations bring concepts to life

  • Icon

    Listen on the go

    Learn how you like with full eText audio

  • Icon

    Learn anytime, anywhere

    Get the app to access your eText whenever you need it

  • Icon

    Make it your own

    Your notes. Your highlights. Your eText

Overview

Your Office: Microsoft® Office 365®, 2019 Comprehensive combines technical content with business cases to help you use Access and Excel as decision-making tools at work.

Published by Pearson (September 18th 2020) - Copyright © 2020

ISBN-13: 9780136874829

Subject: Information Technology

Category: Microsoft Office Applications

Table of contents

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
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

Your questions answered

Introducing Pearson+. Reimagined learning, designed for you. Choose from one eText or over 1,500 eTexts and study tools, all in one place, for one low monthly subscription. A new way to buy books that fits your budget. Make the most of your study time with offline access, enhanced search, notes and flashcards — to get organized, get the work done quicker and get results. Plus, with the app, put textbooks in your pocket and learn wherever. It's time to upgrade the textbook and simplify learning, so you can have time to live too.

Pearson eText is an easy-to-use digital textbook available from Pearson+. Make it your own by adding notes and highlights. Download the Pearson+ mobile app to learn on the go, even offline. Listen on the go with our new audiobook feature, available for most titles.

When you choose a plan, you're signing up for a 4-month term. We will charge your payment method each month until your 4-month term has ended. After that, we'll automatically renew your subscription and charge you on a month-to-month basis unless you turn off auto-renewal in My account.

When you purchase a Pearson+ subscription, it will last a minimum of 4 months, and then automatically renew each month thereafter unless you turn off auto-renew in My account.

If you want to stop your subscription at the end of your 4-month term, simply turn off auto-renew from My account. To avoid the next payment charge, make sure you turn auto renewal off 1 day before the auto renewal date.

You can subscribe again after auto-renew has been turned off by purchasing another Pearson+ subscription.

We use your credit card to renew your subscription automatically. To make sure your learning is uninterrupted, please check your card details before your first monthly payment.

With a Multi Pearson+ subscription plan, you can download up to 5 titles on the Pearson+ app from My list on each of your authorized devices every month.

When you're using your Multi Pearson+ subscription plan in a browser, you can select and read from as many titles as you like.