Description

Book Synopsis

About our authors

Shelley Gaskin (series editor) is a professor in the Business and Computer Technology Division at Pasadena City College in Pasadena, California. She holds a bachelor's degree in Business Administration from Robert Morris College (Pennsylvania), a master's degree in Business from Northern Illinois University, and a doctorate in Adult and Community Education from Ball State University (Indiana). Before joining Pasadena City College, she spent 12 years in the computer industry, where she was a systems analyst, sales representative, and director of Customer Education with Unisys Corporation. She also worked for Ernst & Young on the development of large systems applications for their clients. She has written and developed training materials for custom systems applications in both the public and private sector and has also written and edited numerous computer application textbooks.

Nancy ?Graviett (Access author) is a pro

Table of Contents
MICROSOFT OFFICE 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
ACCESS 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

GO with Microsoft Office 365 Access 2019

Product form

£166.34

Includes FREE delivery

Order before 4pm today for delivery by Mon 26 Jan 2026.

A Spiral bound by Shelley Gaskin, Nancy Graviett, Alicia Vargas

Out of stock


    View other formats and editions of GO with Microsoft Office 365 Access 2019 by Shelley Gaskin

    Publisher: Pearson Education (US)
    Publication Date: 18/03/2019
    ISBN13: 9780135442043, 978-0135442043
    ISBN10: 0135442044
    Also in:
    Computing Database software

    Description

    Book Synopsis

    About our authors

    Shelley Gaskin (series editor) is a professor in the Business and Computer Technology Division at Pasadena City College in Pasadena, California. She holds a bachelor's degree in Business Administration from Robert Morris College (Pennsylvania), a master's degree in Business from Northern Illinois University, and a doctorate in Adult and Community Education from Ball State University (Indiana). Before joining Pasadena City College, she spent 12 years in the computer industry, where she was a systems analyst, sales representative, and director of Customer Education with Unisys Corporation. She also worked for Ernst & Young on the development of large systems applications for their clients. She has written and developed training materials for custom systems applications in both the public and private sector and has also written and edited numerous computer application textbooks.

    Nancy ?Graviett (Access author) is a pro

    Table of Contents
    MICROSOFT OFFICE 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
    ACCESS 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

    Recently viewed products

    © 2026 Book Curl

      • American Express
      • Apple Pay
      • Diners Club
      • Discover
      • Google Pay
      • Maestro
      • Mastercard
      • PayPal
      • Shop Pay
      • Union Pay
      • Visa

      Login

      Forgot your password?

      Don't have an account yet?
      Create account