GO! with Microsoft Office 365, Access 2019 Comprehensive book cover
GO! with Microsoft Office 365, Access 2019 Comprehensive book cover

GO! with Microsoft Office 365, Access 2019 Comprehensive

GO! with Microsoft Office 365, Access 2019 Comprehensive book cover

GO! with Microsoft Office 365, Access 2019 Comprehensive

$186.65

In stock
0 out of 5

$186.65

SKU: 09780135442043 Categories: ,
Title Range Discount
Trade Discount 5 + 25%
Add to wishlist

Description

New and updated features of this title

In-step with technology as it evolves

  • REVISED: Coverage of Microsoft Office 365, 2019 Edition keeps students current with up-to-date skills.
  • NEW: A combined Office Features and Windows chapter provides a concise overview of key features, reinforcing knowledge needed to complete projects.

Training for today’s workplace

  • EXPANDED: New critical thinking quizzes accompany Instructional A & B Grader Projects, requiring students to use problem-solving and analysis (soft skills employers look for) to demonstrate their understanding.
  • ENHANCED: Connections between business cases and instruction have been strengthened to reinforce the what, why, and how of skills application.
  • REVISED: All projects have been updated to provide meaningful hands-on experience.

Now live! SUMMER 2020 DIGITAL UPDATE for digital content
Microsoft Office 365 updates are reflected in the eText and associated MyLab for this title. To learn more, contact your Pearson representative.

For introductory courses in Microsoft® Access™.

Seamless digital instruction, practice, and assessment
For over 17 years, instructors have relied upon the GO! series to teach Microsoft Office successfully. The series uses a project-based approach that clusters learning objectives around projects, rather than software features, so students can practice solving real business problems. Gaskin uses easy-to-follow Microsoft Procedural Syntax so students always know where to go on the ribbon; she combines this with a Teachable Moment approach that offers learners tips and instructions at the precise moment they’re needed. Updated to Office 365, GO! with Microsoft® Office 365®, Access 2019 Comprehensive adds revised instructional projects and improved coverage of the what, why, and how of skills application.

Also available with MyLab IT
MyLab™ is the teaching and learning platform that empowers you to reach every student. By combining trusted author content with digital tools and a flexible platform, MyLab personalizes the learning experience and improves results for each student. MyLab IT 2019 delivers trusted content and resources through an expansive course materials library, including new easy-to-use Prebuilt Learning Modules that promote student success. Through an authentic learning experience, students become sharp critical thinkers and proficient in Microsoft Office, developing essential skills employers seek. Learn more about MyLab IT.

Hallmark features of this title

Built for the real world

  • Chapter projects, based on learning outcomes and objectives, teach workplace skills in the context of real-world tasks.
  • MOS objectives are noted by icons throughout. Detailed appendixes make them easy to find and review.

Project-based learning

  • Outcome-based, problem-solving, and critical thinking end-of-chapter projects help students reinforce and master skills.
  • GO! Collaborate with Google® projects provide practice applying skills to an environment popular in the workplace.

Strategic guidance throughout

  • Confusion-free, color-coded instructions lead step-by-step through projects, with screenshots of essential steps.
  • Learning is enhanced by visuals, like Office icons and boxes that highlight key concepts.

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

Now live! SUMMER 2020 DIGITAL UPDATE for digital content
Microsoft Office 365 updates are reflected in the eText and associated MyLab for this title. Instructors, to learn more, contact your Pearson representative.

For introductory courses in Microsoft® Access™.

Seamless digital instruction, practice, and assessment
For over 17 years, instructors have relied upon the GO! series to teach Microsoft Office successfully. The series uses a project-¿based approach that clusters learning objectives around projects, rather than software features, so students can practice solving real business problems. Gaskin uses easy-to-follow Microsoft Procedural Syntax so students always know where to go on the ribbon; she combines this with a Teachable Moment approach that offers learners tips and instructions at the precise moment they’re needed. Updated to Office 365, GO! with Microsoft® Office 365®, Access 2019 Comprehensive adds revised instructional projects and improved coverage of the what, why, and how of skills application.

Also available with MyLab IT
By combining trusted author content with digital tools and a flexible platform, MyLab personalizes the learning experience and improves results for each student. MyLab IT 2019 delivers trusted content and resources through an expansive course materials library, including new easy-to-use Prebuilt Learning Modules that promote student success. Through an authentic learning experience, students become sharp critical thinkers and proficient in Microsoft Office, developing essential skills employers seek.

Note: You are purchasing a standalone product; MyLab IT does not come packaged with this content. Students, if interested in purchasing this title with MyLab IT, ask your instructor to confirm the correct package ISBN and Course ID. Instructors, contact your Pearson representative for more information.

If you would like to purchase both the physical text and MyLab IT, search for:

0135768985 / 9780135768983 GO! with Microsoft Access 2019 Comprehensive, 1/e + MyLab IT w/ Pearson eText, 1/e
Package consists of:

  • 0135442044 / 9780135442043 GO! with Microsoft Office 365, Access 2019 Comprehensive, 1/e
  • 0135651263 / 9780135651261 MyLab IT with Pearson eText — Access Card — for GO! with Microsoft Office 365, 2019 Edition Introductory, 1/e

Details

  • A print text
  • Free shipping

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 professor and department chair in Business Technology at St. Charles Community College in Cottleville, Missouri. She holds a bachelor’s degree in marketing and a master’s degree in business education from the University of Missouri and has completed a certificate in online education. Nancy has authored textbooks on WordPerfect, Google, Microsoft Outlook, and Microsoft Access.

Additional information

Dimensions 1.20 × 8.00 × 10.80 in
Imprint

Format

ISBN-13

ISBN-10

Author

, , ,

BISAC

Subjects

higher education, information technology, business and economics, IT / MIS, Computer Applications, HIS000000