GO! Microsoft 365: Access 2019, 1st edition

  • Shelley Gaskin, 
  • Nancy Graviett, 
  • Alicia Vargas, 
  • Debra Geoghan

Choose the option that's right for you

$9.99 / mo

4-month term, pay monthly or pay $39.96

Enjoy these features

  • Up to 2 devices
  • Exclusive offers

$14.99 / mo

4-month term, pay monthly or pay $59.96

Enjoy these features

  • Up to 2 devices
  • Exclusive offers

Learn more, spend less

  • Study smarter, not harder

    Save time with study tools in your eTextbook

  • Watch and learn

    Videos & animations bring concepts to life

  • Listen on the go

    Learn how you like with full eTextbook audio

  • Learn anytime, anywhere

    Get the app to access your eTextbook whenever you need it

  • Make it your own

    Your notes. Your highlights. Your eTextbook


GO! with Microsoft® Office 365®, Accesss 2019, Comprehensive uses a project-­based approach to teach the basic-to-advanced features and functions of Microsoft Access.

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

ISBN-13: 9780136874591

Subject: Microsoft Office Applications

Category: GO! with Microsoft Office 365, Access 2019 Comprehensive

Table of contents


Chapter 1: Microsoft Office Common Features and Windows 10 Features and File Management

  1. Explore Microsoft Office
  2. Create a Folder for File Storage
  3. Download and Extract Zipped Files and Enter, Edit, and Check the Spelling of Text in an Office Program
  4. Perform Office Commands and Apply Office Formatting
  5. Finalize an Office Document
  6. Use the Office Help Features
  7. Explore Windows 10
  8. Prepare to Work with Folders and Files
  9. Use File Explorer to Extract Zipped Files and to Display Locations, Folders, and Files
  10. Start Programs and Open Data Files
  11. Create, Rename, and Copy Files and Folders


Chapter 1: Getting Started with Microsoft Access 2019

  1. Identify Good Database Design
  2. Create a Table and Define Fields in a Blank Desktop Database
  3. Change the Structure of Tables and Add a Second Table
  4. Create a Query, Form, and Report
  5. Close a Database and Close Access
  6. Use a Template to Create a Database
  7. Organize Objects in the Navigation Pane
  8. Create a New Table in a Database Created with a Template
  9. View a Report

Chapter 2: Sort and Query a Database

  1. Open and Save an Existing Database
  2. Create Table Relationships
  3. Sort Records in a Table
  4. Create a Query in Design View
  5. Create a New Query From an Existing Query
  6. Sort Query Results
  7. Specify Criteria in a Query
  8. Specify Numeric Criteria in a Query
  9. Use Compound Criteria in a Query
  10. Create a Query Based on More Than One Table
  11. Use Wildcards in a Query
  12. Create Calculated Fields in a Query
  13. Calculate Statistics and Group Data in a Query
  14. Create a Crosstab Query
  15. Create a Parameter Query

Chapter 3: Forms, Filters, and Reports

  1. Create and Use a Form to Add and Delete Records
  2. Filter Records
  3. Create a Form by Using the Form Wizard
  4. Modify a Form in Layout View and in Design View
  5. Create a Report by Using the Report Tool and Modify the Report in Layout View
  6. Create a Report by Using the Report Wizard
  7. Modify the Design of a Report
  8. Keep Grouped Data Together in a Printed Report

Chapter 4: Enhancing Tables

  1. Manage Existing Tables
  2. Modify Existing Tables
  3. Change Data Types
  4. Attach Files to Records
  5. Create a Table in Design View
  6. Create a Lookup Field
  7. Set Field Properties
  8. Create Data Validation Rules and Validation Text

Chapter 5: Enhancing Queries

  1. Create Calculated Fields in a Query
  2. Use Aggregate Functions in a Query
  3. Create a Crosstab Query
  4. Find Duplicate and Unmatched Records
  5. Create a Parameter Query
  6. Create a Make Table Query
  7. Create an Append Query
  8. Create a Delete Query
  9. Create an Update Query
  10. Modify the Join Type

Chapter 6: Customizing Forms and Reports Microsoft Access 2019

  1. Create a Form in Design View
  2. Change and Add Controls
  3. Format a Form
  4. Make a Form User Friendly
  5. Create a Report Based on a Query Using a Wizard
  6. Create a Report in Design View
  7. Add Controls to a Report
  8. Group, Sort, and Total Records in Design View

Chapter 7: Creating Advanced Forms and Reports

  1. Create a Split Form
  2. Create a Form and a Subform
  3. Create a Multi-Page Form
  4. Create and Modify a Subreport
  5. Create a Report Based on a Parameter Query
  6. Create an Alphabetic Index

Chapter 8: Creating Macros

  1. Create a Standalone Macro with One Action
  2. Add Multiple Actions to a Standalone Macro
  3. Create an Embedded Macro
  4. Print Macro Details
  5. Create a Macro Group
  6. Associate a Macro with an Event
  7. Create a Data Macro

Chapter 9: Integrating Access with Other Applications

  1. Import Data from a Word Table
  2. Import Data from an Excel Workbook
  3. Insert an Excel Chart into a Report
  4. Import from and Link to Another Access Database
  5. Export Data to Word
  6. Use Mail Merge to Integrate Access and Word
  7. Export Data to Excel
  8. Export Data to an HTML File and an XML File

Chapter 10: Administering Databases and Writing SQL Statements

  1. Create a Navigation Form
  2. Use Microsoft Access Analysis Tools
  3. Modify Access Views and Behaviors
  4. Use the Database Splitter
  5. Encrypt and Decrypt Databases
  6. Create a Locked Database (ACCDE File)
  7. Modify a Query in SQL View
  8. Create a Query in SQL View
  9. Create a Union Query Using SQL
  10. Create Calculated Fields and SQL Aggregate Functions

Your questions answered

Choose from one eTextbook or over 1,500 eTextbooks and study tools, all in one place, for one low monthly subscription. A Single plan includes the use of 1 eTextbook title and study tools. A Multi plan gives you access to more than 1,500 eTextbook titles and study tools. Plus, with the app, put textbooks in your pocket and learn wherever.

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.

A Pearson eTextbook is an easy-to-use digital version of the book. You can add notes and highlights, plus learn on the go with the Pearson+ mobile app. Listen on the go with the audiobook feature, available for most titles.

When you choose a plan, you're signing up for a 4-month 'term'. You can opt to make a one-time payment for the initial 4-month term or pay monthly. If you opt for monthly payments, we will charge your payment method each month until your 4-month term has ended. You can turn on auto-renew in My account at any time to continue your subscription before your 4-month term has ended.

When you purchase a Pearson+ subscription, it will last 4 months. Before your initial 4-month term ends, you can extend your subscription by turning auto-renew on in My account.

If you turn auto-renew on, we’ll automatically renew your subscription and charge you every month until you turn off auto-renew. If you made a one-time payment for your initial 4-month term, you’ll now pay monthly.

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 10 titles from your library on each of your authorized smartphone and tablet 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.