Personalize learning with MyLab By combining trusted author content with digital tools and a flexible platform, MyLab™ personalizes the learning experience and improves results for each student. You are purchasing an access card only. Before purchasing, check with your instructor to confirm the correct ISBN. Several versions of the MyLab™ and Mastering™ platforms exist for each title, and registrations are not transferable. To register for and use MyLab or Mastering, you may also need a Course ID, which your instructor will provide. If purchasing or renting from companies other than Pearson, the access codes for the MyLab platform may not be included, may be incorrect, or may be previously redeemed. Check with the seller before completing your purchase.

Table of Contents:
MICROSOFT OFFICE Chapter 1: Microsoft Office Common Features and Windows 10 Features and File Management Explore Microsoft Office Create a Folder for File Storage Download and Extract Zipped Files and Enter, Edit, and Check the Spelling of Text in an Office Program Perform Office Commands and Apply Office Formatting Finalize an Office Document Use the Office Help Features Explore Windows 10 Prepare to Work with Folders and Files Use File Explorer to Extract Zipped Files and to Display Locations, Folders, and Files Start Programs and Open Data Files Create, Rename, and Copy Files and Folders WORD Introducing Microsoft Word 2019 Chapter 1: Creating Documents with Microsoft Word Create a New Document and Insert Text Insert and Format Graphics Insert and Modify Text Boxes and Shapes Preview and Print a Document Change Document and Paragraph Layout Create and Modify Lists Set and Modify Tab Stops Insert a SmartArt Graphic and an Icon Chapter 2: Creating Cover Letters and Using Tables to Create Resumes Create a Table for a Resume Format a Table Present a Word Document Online Create a Letterhead for a Cover Letter Create a Cover Letter and Correct and Reorganize Text Use the Word Editor to Check Your Documents Print an Envelope, Change Style Sets, Create a Word Template and Use Learning Tools Chapter 3: Creating Research Papers, Newsletters, and Merged Mailing Labels Create a Research Paper Insert Footnotes in a Research Paper Create Citations and a Bibliography in a Research Paper Use Read Mode and PDF Reflow Format a Multiple-Column Newsletter Use Special Character and Paragraph Formatting Create Mailing Labels Using Mail Merge EXCEL Introducing Microsoft Excel 2019 Chapter 1: Creating a Worksheet and Charting Data Create, Save, and Navigate an Excel Workbook Enter Data in a Worksheet Construct and Copy Formulas and Use the SUM Function Format Cells with Merge & Center, Cell Styles, and Themes Chart Data to Create a Column Chart and Insert Sparklines Print a Worksheet, Display Formulas, and Close Excels Check Spelling in a Worksheet Enter Data by Range Construct Formulas for Mathematical Operations Edit Values in a Worksheet Format a Worksheet Chapter 2: Using Functions, Creating Tables, and Managing Large Workbooks Use Flash Fill and the SUM, AVERAGE, MEDIAN, MIN, and MAX Functions Move Data, Resolve Error Messages, and Rotate Text Use COUNTIF and IF Functions and Apply Conditional Formatting Use Date & Time Functions and Freeze Panes Create, Sort, and Filter an Excel Table View, Format, and Print a Large Worksheet Navigate a Workbook and Rename Worksheets Enter Dates, Clear Contents, and Clear Formats Copy and Paste by Using the Paste Options Gallery Edit and Format Multiple Worksheets at the Same Time Create a Summary Sheet with Column Sparklines Format and Print Multiple Worksheets in a Workbook Chapter 3: Analyzing Data with Pie Charts, Line Charts, and What-If Analysis Tools Chart Data with a Pie Chart Format a Pie Chart Edit a Workbook and Update a Chart Use Goal Seek to Perform What-If Analysis Design a Worksheet for What-If Analysis Answer What-If Questions by Changing Values in a Worksheet Chart Data with a Line Chart ACCESS Introduction to Microsoft Access 2019 Chapter 1: Getting Started with Microsoft Access 2019 Identify Good Database Design Create a Table and Define Fields in a Blank Desktop Database Change the Structure of Tables and Add a Second Table Create a Query, Form, and Report Close a Database and Close Access Use a Template to Create a Database Organize Objects in the Navigation Pane Create a New Table in a Database Created with a Template View a Report Chapter 2: Sort and Query a Database Open and Save an Existing Database Create Table Relationships Sort Records in a Table Create a Query in Design View Create a New Query From an Existing Query Sort Query Results Specify Criteria in a Query Specify Numeric Criteria in a Query Use Compound Criteria in a Query Create a Query Based on More Than One Table Use Wildcards in a Query Create Calculated Fields in a Query Calculate Statistics and Group Data in a Query Create a Crosstab Query Create a Parameter Query Chapter 3: Forms, Filters, and Reports Create and Use a Form to Add and Delete Records Filter Records Create a Form by Using the Form Wizard Modify a Form in Layout View and in Design View Create a Report by Using the Report Tool and Modify the Report in Layout View Create a Report by Using the Report Wizard Modify the Design of a Report Keep Grouped Data Together in a Printed Report POWERPOINT Introducing Microsoft PowerPoint 2019 Chapter 1: Getting Started with Microsoft PowerPoint Create a New Presentation Edit a Presentation in Normal View Add Pictures to a Presentation Print and View a Presentation Edit an Existing Presentation Format a Presentation Use Slide Sorter View Apply Slide Transitions Chapter 2: Formatting PowerPoint Presentations Format Numbered and Bulleted Lists Insert Online Pictures Insert Text Boxes and Shapes Format Objects Remove Picture Backgrounds and Insert WordArt Create and Format a SmartArt Graphic Chapter 3: Enhancing a Presentation with Animation, Video, Tables, and Charts Customize Slide Backgrounds and Themes Animate a Slide Show Insert a Video Create and Modify Tables Create and Modify Charts INTEGRATED PROJECTS Chapter 1: Integrating Word, Excel, Access, and PowerPoint