Microsoft Office 365: In Practice, 2019 Edition (CIT)

✍ Scribed by Randy Nordell Professor of Business Technology Ed.D.

• Publisher: McGraw-Hill Education
• Year: 2019
• Tongue: English
• Leaves: 1249
• Category: Library

✦ Synopsis

Microsoft® Office365/2019: In Practice offers a fresh approach to teaching today's students Microsoft® Officeskills by clearly introducing skills in logical order: 1) Topic 2) Instructionand 3) Practice.
Nordell's TIP approach builds a foundation for success by helpingstudents apply what they learn, and provides transferable skills that allowstudents to grasp critical thinking beyond the textbook assignments.

In Practice seamlessly integrates with SIMnet,McGraw-Hill Education's learning and assessment solution, which houses contentto help students practice and master computing concepts and Microsoft® Officeskills. In Practice auto-graded projects allow students to practicetheir skills in a live Office application, and upon completion receiveimmediate feedback and insights.

The integration of the In Practice textbook series with SIMnet,helps meet the diverse needs of students and accommodate individual learningstyles.

✦ Table of Contents

Cover
Microsoft® Office 365: IN PRACTICE: 2019
dedication
brief contents
contents
about the authors
preface
instructor walkthrough
acknowledgments
windows & office
Intro Chapter: Windows 10, Office 365/2019, and File Management
Chapter Overview
Student Learning Outcomes (SLOs)
Case Study
Intro. 1—Using Windows 10
Windows 10
Microsoft Account
Windows Desktop and Taskbar
Start Menu
Add Apps
Customize the Start Menu
Customize the Taskbar
File Explorer
OneDrive
OneDrive Online
Cortana
Task View
Settings
Action Center
Intro. 2—Using Microsoft Office
Office 2019 and Office 365
Office 365 Products, Versions, and Update Channels
Office Desktop Apps, Office Mobile Apps, and Office Online
Open an Office Desktop Application
Office Start Page
Backstage View
Office Help—Tell Me
Mouse and Pointers
Touch Mode and Touch-Screen Gestures
Intro. 3—Creating, Saving, Closing, and Opening Office Files
Create a New File
Save a File
AutoSave
Create a New Folder When Saving a File
Save As a Different File Name
Office File Types
Close a File
Open an Existing File
Pause & Practice Intro-1
Intro. 4—Working with Files
File Views
Change Display Size
Manage Multiple Open Files and Windows
Snap Assist
Intro. 5—Printing, Sharing, and Customizing Files
Print a File
Export as a PDF File
Document Properties
Share a File
Program Options
Intro. 6—Using the Ribbon, Tabs, and Quick Access Toolbar
The Ribbon, Tabs, and Groups
Ribbon Display Options
Buttons, Drop-Down Lists, and Galleries
Dialog Boxes, Task Panes, and Launchers
ScreenTips
Radio Buttons, Check Boxes, and Text Boxes
Quick Access Toolbar
Customize the Quick Access Toolbar
Intro. 7—Using Context Menus, the Mini Toolbar, and Keyboard Shortcuts
Context Menu
Mini Toolbar
Keyboard Shortcuts
Function Keys on a Laptop
Pause & Practice Intro-2
Intro. 8—Organizing and Customizing Folders and Files
Create a Folder
Move and Copy Files and Folders
Rename Files and Folders
Delete Files and Folders
Create a Zipped (Compressed) Folder
Extract a Zipped (Compressed) Folder
Pause & Practice Intro-3
Chapter Summary
Using Microsoft Windows 10 and Office 365
Guided Project Intro-1
Guided Project Intro-2
Independent Project Intro-3
Independent Project Intro-4
Challenge Project Intro-5
Challenge Project Intro-6
word
CHAPTER 1: Creating and Editing Documents
Chapter Overview
Student Learning Outcomes (SLOs)
Case Study
1.1—Creating, Saving, and Opening Documents
Create a New Document
Save a Document
AutoSave
Save As a Different File Name
Open a Document
Pin a Frequently Used Document
1.2—Entering and Selecting Text
Type Text and Use Word Wrap
Show/Hide Formatting Symbols
Select Text
AutoComplete
AutoCorrect and AutoFormat
AutoCorrect Smart Tag
Add Custom AutoCorrect Entry
1.3—Using Paragraph Breaks, Line Breaks, and Non-Breaking Spaces
Paragraph Breaks
Line Breaks
Spaces and Non-Breaking Spaces
Pause & Practice: Word 1-1
1.4—Moving and Copying Text
Move Text
Copy Text
Paste Text and Paste Options
Clipboard Pane
Undo Change
Redo and Repeat Change
1.5—Changing Fonts, Font Sizes, and Attributes
Font and Font Size
Bold, Italic, and Underline Font Styles
Other Font Style Buttons
Change Case
Font Dialog Box
Font Color
Underline Style and Color
Font Effects
Character Spacing
Text Effects
Format Painter
Clear All Formatting
Change Default Font and Font Size
Pause & Practice: Word 1-2
1.6—Changing Text Alignment, Line Spacing, and Paragraph Spacing
Default Settings
Paragraph Alignment
Line Spacing
Paragraph Spacing
Paragraph Dialog Box
Change Default Line and Paragraph Spacing
1.7—Using Smart Lookup and Proofreading Tools
Smart Lookup and the Smart Lookup Pane
Automatic Spelling and Grammar Notifications
Editor Pane
Customize the Dictionary
The Thesaurus
Word Count
Read Aloud
Learning Tools
1.8—Customizing Document Properties
Document Properties
Advanced Properties
Print Document Properties
Pause & Practice: Word 1-3
Chapter Summary
Check for Understanding
Using Microsoft Word 365
Guided Project 1-1
Guided Project 1-2
Guided Project 1-3
Independent Project 1-4
Independent Project 1-5
Independent Project 1-6
Improve It Project 1-7
Challenge Project 1-8
Challenge Project 1-9
Challenge Project 1-10
CHAPTER 2: Formatting and Customizing Documents
Chapter Overview
Student Learning Outcomes (SLOs)
Case Study
2.1—Customizing Margins and Page Layout
Page Layout Settings
Margin Settings
Page Setup Dialog Box
Page Orientation
Paper Size
Vertical Alignment
Use the Ruler
Page Movement
2.2—Setting, Using, and Editing Tab Stops
Set a Tab Stop
Set a Tab Stop Using the Tabs Dialog Box
Set a Tab Stop Using the Ruler
Move a Tab Stop
Remove a Tab Stop
Add a Tab Leader
Change Default Tab Stops
2.3—Using Indents
Left and Right Indents
First Line and Hanging Indents
Remove Indents
Pause & Practice: Word 2-1
2.4—Inserting Page Numbers, Headers, and Footers
Page Numbering
Insert Page Number
Edit Page Number in Header or Footer
Different First Page
Page Number Format
Remove Page Number
Insert Header and Footer Content
Number of Pages Field
Date and Time
Document Properties
Built-In Headers, Footers, and Page Numbers
Pause & Practice: Word 2-2
2.5—Using Page and Section Breaks
Page Breaks
Section Breaks
Edit Page and Section Breaks
2.6—Using Bulleted, Numbered, and Multilevel Lists
Create a Bulleted List
Customize a Bulleted List
Create a Numbered List
Customize a Numbered List
Multilevel Lists
2.7—Using Styles and Themes
Style Gallery
Apply a Built-In Style
Modify a Style
Apply a Theme
Pause & Practice: Word 2-3
2.8—Using Find and Replace and Resume Assistant
Find
Find and Replace
Go To
Resume Assistant
2.9—Using Borders, Shading, and Hyperlinks
Apply Built-In Borders
Customize Borders
Apply Shading
Apply a Page Border
Insert a Horizontal Line
Create a Hyperlink
Edit or Remove a Hyperlink
Pause & Practice: Word 2-4
Chapter Summary
Check for Understanding
Using Microsoft Word 365
Guided Project 2-1
Guided Project 2-2
Guided Project 2-3
Independent Project 2-4
Independent Project 2-5
Independent Project 2-6
Improve It Project 2-7
Challenge Project 2-8
Challenge Project 2-9
Challenge Project 2-10
CHAPTER 3: Collaborating with Others and Working with Reports
Chapter Overview
Student Learning Outcomes (SLOs)
Case Study
3.1—Using Comments
Change User Name
Insert a Comment
Ink Comments
Review Comments
Reply to a Comment
Resolve Comment
Edit and Delete Comments
3.2—Using Track Changes and Sharing
Track Changes
Display for Review Views
Accept and Reject Changes
Reviewing Pane
Share an Online File
Create a Sharing Link
Pause & Practice: Word 3-1
3.3—Using Footnotes and Endnotes
Insert a Footnote
Insert an Endnote
View Footnotes and Endnotes
Customize Footnotes and Endnotes
Modify Footnote and Endnote Format
Modify Footnote and Endnote Styles
Convert Footnotes and Endnotes
Move Footnotes and Endnotes
Delete Footnotes and Endnotes
3.4—Creating a Bibliography and Inserting Citations
Report Styles
Bibliography Styles
Add a New Source
Insert a Citation
Insert a Placeholder
Manage Sources
Edit Citations and Sources
Use the Researcher
Insert a Bibliography
Pause & Practice: Word 3-2
3.5—Inserting a Table of Contents
Use Heading Styles for a Table of Contents
Insert a Built-In Table of Contents
Insert a Custom Table of Contents
Modify a Table of Contents
Update a Table of Contents
Remove a Table of Contents
3.6—Inserting a Cover Page
Insert a Built-In Cover Page
Customize Cover Page Content
Customize Document Property Content
Add or Remove Document Property Fields
Customize Content Control Fields
Remove a Cover Page
3.7—Using Advanced Headers and Footers
Page and Section Breaks
Built-In Headers, Footers, and Page Numbers
Customize Header and Footer Content
Different First Page Header and Footer
Different Odd and Even Pages
Link to Previous Header or Footer
Format Page Numbers
Navigate between Headers and Footers
Remove a Header or Footer
Pause & Practice: Word 3-3
Chapter Summary
Check for Understanding
Using Microsoft Word 365
Guided Project 3-1
Guided Project 3-2
Guided Project 3-3
Independent Project 3-4
Independent Project 3-5
Independent Project 3-6
Improve It Project 3-7
Challenge Project 3-8
Challenge Project 3-9
Challenge Project 3-10
CHAPTER 4: Using Tables,Columns, and Graphics
Chapter Overview
Student Learning Outcomes (SLOs)
Case Study
4.1—Creating and Editing Tables
Tables
Navigate within a Table
Table Tools Layout Tab
Select Table and Text
Add Rows and Columns
Merge and Split Cells
Copy or Move Columns and Rows
Delete Columns and Rows
Delete a Table
4.2—Arranging Text in Tables
Resize Columns and Rows
AutoFit a Table
Distribute Rows and Columns
Text Alignment
Cell Margins
Table Properties Dialog Box
Sort Data in Tables
Pause & Practice: Word 4-1
4.3—Formatting and Editing Tables
Table Tools Design Tab
Table Borders
View Gridlines
Table Shading
Table Styles
Table Style Options
Insert a Formula in a Table
Update a Formula
Convert Text to a Table
Pause & Practice: Word 4-2
4.4—Using Columns
Preset Column Settings
Customize Columns
Convert Text to Columns
Insert a Column Break
Balance Columns
Pause & Practice: Word 4-3
4.5—Working with Graphics
Pictures and Online Pictures
Insert a Picture
Use Alt Text
Insert an Online Picture
Resize a Graphic
Wrap Text around a Graphic
Position a Graphic
Insert a Caption
Group Graphic Objects
4.6—Working with Other Graphic Objects
Insert and Customize a Shape
Insert and Customize SmartArt
Insert and Customize WordArt
Modify Graphics with Styles
Insert Icons and 3D Models
Insert Online Video
Insert Symbols and Special Characters
Pause & Practice: Word 4-4
Chapter Summary
Check for Understanding
Using Microsoft Word 365
Guided Project 4-1
Guided Project 4-2
Guided Project 4-3
Independent Project 4-4
Independent Project 4-5
Independent Project 4-6
Improve It Project 4-7
Challenge Project 4-8
Challenge Project 4-9
Challenge Project 4-10
excel
CHAPTER 1: Creating and Editing Workbooks
Chapter Overview
Student Learning Outcomes (SLOs)
Case Study
1.1—Creating, Saving, and Opening a Workbook
Create a New Workbook
Save and Close a Workbook
Open a Workbook
Save a Workbook with a Different File Name
Workbook File Formats
1.2—Entering and Editing Data
Enter Labels and Values
Edit Cell Contents
Replace or Clear Cell Contents
Align and Indent Cell Contents
Select Cells
The Fill Handle
AutoComplete
Cut, Copy, and Paste Cell Contents
Move or Cut Cell Contents
The Office Clipboard
Copy Cell Contents
Paste Options
Pause & Practice: Excel 1-1
1.3—Using the SUM Function
Function Syntax
Copy the SUM Function
Edit the Function Argument
1.4—Formatting a Worksheet
Font Face, Size, Style, and Color
The Format Painter
Number Formats
Borders and Fill
Cell Styles
Workbook Themes
Pause & Practice: Excel 1-2
1.5—Modifying Columns and Rows
Adjust Column Width and Row Height
AutoFit Columns and Rows
Wrap Text, Merge Cells, and Center Across Selection
Insert and Delete Columns and Rows
Hide and Unhide Columns and Rows
1.6—Inserting, Deleting, and Moving Worksheets
Insert and Delete Worksheets
Rename Worksheets and Change Tab Color
Move and Copy Worksheets
Pause & Practice: Excel 1-3
1.7—Modifying the Appearance of a Workbook
Workbook Views
Zoom Options
Freeze Panes
Split a Worksheet into Panes
Hide or Unhide Worksheets
Switch Windows Command
View Multiple Worksheets
1.8—Finalizing a Workbook
Check Spelling
Document Properties
The Properties Dialog Box
The Page Setup Dialog Box
Margins, Page Orientation, and Paper Size
Headers and Footers
Page Breaks
Preview and Move a Page Break
Remove a Manual Page Break
Customize Print Settings
Scale to Fit
Print Area
Print a Worksheet or Workbook
Pause & Practice: Excel 1-4
Chapter Summary
Check for Understanding
Using Microsoft Excel 365
Guided Project 1-1
Guided Project 1-2
Guided Project 1-3
Independent Project 1-4
Independent Project 1-5
Independent Project 1-6
Improve It Project 1-7
Challenge Project 1-8
Challenge Project 1-9
Challenge Project 1-10
CHAPTER 2: Working with Formulas and Functions
Chapter Overview
Student Learning Outcomes (SLOs)
Case Study
2.1—Building and Editing a Formula
Type a Formula
Point and Click to Build a Formula
Edit a Formula
2.2—Setting Mathematical Order of Operations
Multiple Operators in a Formula
2.3—Using Absolute, Mixed, Relative, and 3D References
Copy a Formula with a Relative Reference
Build and Copy a Formula with an Absolute Reference
Build and Copy a Formula with a Mixed Reference
Create a Formula with a 3D Reference
Range Names and Formula AutoComplete
2.4—Using Formula Auditing Tools
The Formula Auditing Group
Trace Precedents and Dependents
The Formula Correction Message Window
Circular Reference
Pause & Practice: Excel 2-1
2.5—Working with Statistical and Date & Time Functions
Average Function
Count Functions
Max and Min Functions
AutoCalculate
Today and Now Functions
Pause & Practice: Excel 2-2
2.6—Working with Financial, Logical, and Lookup Functions
The Function Arguments Dialog Box
PMT Function
IF Function
Lookup Functions
2.7—Using Math & Trig Functions
Round Function
Sumif Function
SUMPRODUCT Function
Pause & Practice: Excel 2-3
Chapter Summary
Check for Understanding
Using Microsoft Excel 365
Guided Project 2-1
Guided Project 2-2
Guided Project 2-3
Independent Project 2-4
Independent Project 2-5
Independent Project 2-6
Improve It Project 2-7
Challenge Project 2-8
Challenge Project 2-9
Challenge Project 2-10
CHAPTER 3: Creating and Editing Charts
Chapter Overview
Student Learning Outcomes (SLOs)
Case Study
3.1—Creating a Chart Object and a Chart Sheet
Create a Chart Object
Excel Chart Types
Size and Position a Chart Object
Create a Chart Sheet
3.2—Using Quick Layouts and Chart Styles
Apply a Quick Layout
Apply a Chart Style
Change Chart Colors
Print a Chart
Pause & Practice: Excel 3-1
3.3—Editing Chart Elements and Data
Add and Remove Chart Elements
Chart and Axes Titles
Data Labels
Data Table
Trendlines
Switch Row and Column Data
Change the Chart Type
Filter Source Data
Edit Source Data
3.4—Formatting Chart Elements
Apply a Shape Style
Apply Shape Fill, Outline, and Effects
The Format Task Pane
3.5—Using Pictures, Shapes, and WordArt in a Chart
Use a Picture as Shape Fill
Insert Shapes
Use WordArt in a Chart
Pause & Practice: Excel 3-2
3.6—Building Pie and Combination Charts
Create a 3-D Pie Chart
Pie Chart Elements and Options
Create a Combination Chart
Combination Chart Elements and Options
3.7—Creating Sunburst and Waterfall Charts
Create a Sunburst Chart
Create a Waterfall Chart
3.8—Inserting and Formatting Sparklines
Insert Sparklines
Sparkline Design Tools
Clear Sparklines
Pause & Practice: Excel 3-3
Chapter Summary
Check for Understanding
Using Microsoft Excel 365
Guided Project 3-1
Guided Project 3-2
Guided Project 3-3
Independent Project 3-4
Independent Project 3-5
Independent Project 3-6
Improve It Project 3-7
Challenge Project 3-8
Challenge Project 3-9
Challenge Project 3-10
CHAPTER 4: Formatting, Organizing, and Getting Data
Chapter Overview
Student Learning Outcomes (SLOs)
Case Study
4.1—Creating and Formatting an Excel Table
Create an Excel Table
Table Styles and Options
The Table Tools and Properties Groups
Structured References and Table Formulas
4.2—Applying Conditional Formatting
Highlight Cells Rules
Top/Bottom Rules
Use a Formula for a Rule
Data Bars, Color Scales, and Icon Sets
Manage Conditional Formatting Rules
Pause & Practice: Excel 4-1
4.3—Sorting Data
Sort Options
Sort Data by One Column
Sort Data by Multiple Columns
Sort Data by Cell Attribute
Sort Data in an Excel Table
4.4—Filtering Data
AutoFilters
Custom AutoFilter
Advanced Filter
4.5—Using Subtotals, Groups, and Outlines
The Subtotal Command
Outline Buttons
Create an Auto Outline
Define Groups
Pause & Practice: Excel 4-2
4.6—Importing Data
Text Files
Word Documents
Access Database Files
Web Site Data
Workbook Queries and Connections
Flash Fill
4.7—Exporting Data
Export Data as a Text File
Export Data via the Clipboard
SharePoint Lists
Pause & Practice: Excel 4-3
4.8—Building and Formatting PivotTables
Create a PivotTable
The PivotTable Fields Pane
Field Settings
Format a PivotTable
PivotTable Layout
Refresh a PivotTable
Calculated Fields
Create a PivotChart
Pause & Practice: Excel 4-4
Chapter Summary
Check for Understanding
Using Microsoft Excel 365
Guided Project 4-1
Guided Project 4-2
Guided Project 4-3
Independent Project 4-4
Independent Project 4-5
Independent Project 4-6
Improve It Project 4-7
Challenge Project 4-8
Challenge Project 4-9
Challenge Project 4-10
access
CHAPTER 1: Creating a Database and Tables
Chapter Overview
Student Learning Outcomes (SLOs)
Case Study
1.1—Understanding Database Concepts
Organize Data
The Access Interface
Examine Access Objects
Use the Navigation Pane
Use Datasheet and Design View of a Table
Pause & Practice: Access 1-1
1.2—Creating and Managing a Database
Templates
Database Properties
Create a Blank Database
Access Naming Rules
Data Types
Create and Save Database Objects
Open Database Objects
Rename Database Objects
Delete Database Objects
Close and Open a Database
Back Up and Recover a Database
1.3—Creating and Using a Table in Datasheet View
Create a New Table in Datasheet View
Edit the Default Primary Key
Add New Fields
Add New Fields by Entering Field Names
Add New Fields by Entering Data
Delete Fields
Edit Properties in Datasheet View
Add a Table Description
Save a Table
Close a Table
Open a Table
Rename a Table
Add, Edit, and Delete Records
Pause & Practice: Access 1-2
1.4—Importing Data Records from Excel
1.5—Exploring Datasheet View
Navigation Buttons
Refine the Datasheet Layout
Modify the Field Order
Select a Display Font Face and Font Size
Modify the Row Height
Modify the Column Width
Modify the Field Alignment
Display Gridlines
Display Alternate Row Colors
Use the Datasheet Formatting Dialog Box
Hide and Unhide Table Fields
Add Total Rows
Save Changes
Pause & Practice: Access 1-3
1.6—Using Search, Sort, and Filter Tools to Find Records in a Table
Search Data in a Table
Sort Data in a Table with Datasheet View
Sort Data on a Single Field
Sort Data on Multiple Fields
Remove Sorting Criteria
Filter Data in a Table with Datasheet View
Create a Filter by Selection
Create a Text Filter, Number Filter, or Date Filter
Create Compound Filter Criteria
Remove Filter Criteria
Pause & Practice: Access 1-4
Chapter Summary
Check for Understanding
Using Microsoft Access 365
Guided Project 1-1
Guided Project 1-2
Guided Project 1-3
Independent Project 1-4
Independent Project 1-5
Independent Project 1-6
Improve It Project 1-7
Challenge Project 1-8
Challenge Project 1-9
Challenge Project 1-10
CHAPTER 2: Using Design View, Data Validation, and Relationships
Chapter Overview
Student Learning Outcomes (SLOs)
Case Study
2.1—Creating a Table in Design View
Create a New Table in Design View
Add New Fields
Define a Primary Key
Delete Fields in a Table
Save, Close, Rename, and Open a Table
Property Update Options Smart Tag
Switch between Datasheet and Design Views
2.2—Setting Field Properties
Set the Field Size
The Format Property
Number and Currency Field Formats
Date/Time Field Formats
Yes/No Field Formats
Short Text and Long Text Field Formats
The Caption Property
Set the Default Value
The Required Property
The New Values Property
Pause & Practice: Access 2-1
2.3—Understanding Data Integrity and Data Validation
2.4—Integrating Data Validation in Tables
Field Validation Rules
Record Validation Rules
Test Validation Rules
Create Validation Text
Create a Lookup Field
Define an Input Mask
2.5—Changing Field Properties after Records Are Added into a Table
Pause & Practice: Access 2-2
2.6—Understanding and Designing Relational Databases
Relational Principles
The Steps to Design a Relational Database
Three Types of Relationships
One-to-One Relationship
One-to-Many Relationship
Many-to-Many Relationship
Understand a Foreign Key
Create Relationships between Tables
Define a Relationship Using the Relationships Window
Enforce Referential Integrity
Cascade Updates
Cascade Deletes
Save a Relationship
Delete a Relationship between Tables
Edit a Relationship between Tables
2.7—Printing the Contents of a Table
Preview the Data Records
Print the Data Records without Previewing
2.8—Using the Compact & Repair Database Utility
Pause & Practice: Access 2-3
Chapter Summary
Check for Understanding
Using Microsoft Access 365
Guided Project 2-1
Guided Project 2-2
Guided Project 2-3
Independent Project 2-4
Independent Project 2-5
Independent Project 2-6
Improve It Project 2-7
Challenge Project 2-8
Challenge Project 2-9
Challenge Project 2-10
CHAPTER 3: Creating and Using Queries
Chapter Overview
Student Learning Outcomes (SLOs)
Case Study
3.1—Understanding Queries and Using the Simple Query Wizard
3.2—Creating, Running, and Editing a Query in Design View
Create a Query Based on a Single Table
Add Fields into a Query
Run a Query
Switch between Datasheet and Design Views
Save and Close a Query
Open a Saved Query
Rename a Query
Create a Query Based on Multiple Tables
Edit Fields in Query Design
3.3—Adding a Criterion to a Query
Single Criterion
Comparison Operators
Use Wildcards in Criteria
The ? Wildcard Character
The * Wildcard Character
The # Wildcard Character
Pause & Practice: Access 3-1
3.4—Controlling the Display of Query Results
Unique Values Property
Show Option for Query Fields
Apply Sorting
3.5—Defining Multiple Criteria in a Query
The AND Operator
The OR Operator
Combine the AND and OR Operators
Pause & Practice: Access 3-2
3.6—Creating and Using a Simple Parameter Query
Create a Parameter
The Parameter Data Type
Use Wildcards in a Parameter Query
3.7—Adding Calculated Fields to a Query
Enter a Formula in a Calculated Field
Troubleshoot Calculated Fields
Functions in a Calculated Field
Pause & Practice: Access 3-3
3.8—Creating and Using a Summary Query
Aggregate Functions
Build a Summary Query
Pause & Practice: Access 3-4
Chapter Summary
Check for Understanding
Using Microsoft Access 365
Guided Project 3-1
Guided Project 3-2
Guided Project 3-3
Independent Project 3-4
Independent Project 3-5
Independent Project 3-6
Improve It Project 3-7
Challenge Project 3-8
Challenge Project 3-9
Challenge Project 3-10
CHAPTER 4: Creating and Using Forms and Reports
Chapter Overview
Student Learning Outcomes (SLOs)
Case Study
4.1—Creating and Working with a Simple Form
The Form Wizard
The Form Button
The Split Form
View or Modify a Form
Save a Form
Open a Saved Form
Delete a Form
Pause & Practice: Access 4-1
4.2—Creating and Customizing a Form in Layout View
Create a Form Using the Blank Form Button
Form Controls
Form Control Layouts
Add Fields to a Control Layout
Delete Fields from a Control Layout
Customize a Form in Layout View
Change Control Layouts
Adjust Control Widths and Heights
Add and Delete Rows and Columns in a Control Layout
Move a Control within a Layout
Adjust Control Positioning on a Form
Add a Title, Date, or Logo to a Form
Create a Form from a Template with Application Parts
4.3—Facilitating Data Input with a Form
Restrict a Form to Data Entry
Limit Edits and Deletions on a Form
Add a Command Button
Test a Form
Pause & Practice: Access 4-2
4.4—Creating and Working with a Simple Report
The Report Wizard
View or Modify a Report
Save a Report
Open a Saved Report
Delete a Report
4.5—Creating and Customizing a Report in Layout View
The Blank Report Button
Report Controls
Report Control Layouts
Add and Delete Fields in a Control Layout
Customize a Report in Layout View
Change Control Layouts
Adjust Column Widths
Add and Delete Rows and Columns in a Control Layout
Move a Control within a Layout
Adjust Control Positioning on a Report
Add a Title, Logo, Date, or Page Numbers to a Report
Pause & Practice: Access 4-3
4.6—Adding Grouping, Sorting, and Totals
Sorting
Add a Group to a Report
Group and Sort Options
Add Totals to a Report
4.7—Using Conditional Formatting in a Report
Conditional Formatting Rules
Add Conditional Formatting to a Report
Manage Conditional Formatting Rules
4.8—Printing a Report
Preview a Report
Print a Report without Print Preview
Format and Print a Report with Multiple Columns
Pause & Practice: Access 4-4
Chapter Summary
Check for Understanding
Using Microsoft Access 365
Guided Project 4-1
Guided Project 4-2
Guided Project 4-3
Independent Project 4-4
Independent Project 4-5
Independent Project 4-6
Improve It Project 4-7
Challenge Project 4-8
Challenge Project 4-9
Challenge Project 4-10
powerpoint
CHAPTER 1: Creating and Editing Presentations
Chapter Overview
Student Learning Outcomes (SLOs)
Case Study
1.1—Creating, Opening, and Saving Presentations
PowerPoint Start and Open Pages
Views
Save and Close a Presentation
Share and Export Options
1.2—Working with Slides, Layouts, Placeholders, and Text
Add Slides and Choose Layouts
Enter Text in Placeholders
Align, Move, and Resize Placeholders
Edit Text
Change Text Case
Change List Bullet Symbols
The Format Painter
Reuse Slides from Another Presentation
Check Spelling and Word Usage
Use PowerPoint Designer with Listed Information
Use PowerPoint QuickStarter to Research Content
1.3—Navigating between Slides and Organizing Content
Navigate between Slides
Copy, Paste, and Duplicate Slides
Select Multiple Slides
Rearrange Slide Order
Delete Slides
Pause & Practice: Powerpoint 1-1
1.4—Changing Theme Colors and Fonts
Change Theme Colors
Change Theme Fonts
Use the Slide Master to Change Theme Colors and Fonts
1.5—Inserting Headers and Footers
Create a Slide Footer
Create a Notes and Handouts Header
Pause & Practice: Powerpoint 1-2
1.6—Working with a Picture from a File
Insert a Picture and Select a Design Ideas Layout
Resize a Picture
Align a Picture
1.7—Applying and Modifying Transitions
Select Effect Options
1.8—Exploring Print Options
Preview a Presentation
Print a Slide
Print a Handout
Print an Outline
1.9—Applying Properties
Pause & Practice: Powerpoint 1-3
Chapter Summary
Check for Understanding
Using Microsoft PowerPoint 365
Guided Project 1-1
Guided Project 1-2
Guided Project 1-3
Independent Project 1-4
Independent Project 1-5
Independent Project 1-6
Improve It Project 1-7
Challenge Project 1-8
Challenge Project 1-9
Challenge Project 1-10
CHAPTER 2: Illustrating with Pictures and Information Graphics
Chapter Overview
Student Learning Outcomes (SLOs)
Case Study
2.1—Working with Shapes, Styles, Effects, and Colors
Shapes and Text Boxes
Style Galleries and Effect Options
Outline Weight and Style
Solid and Gradient Colors
Custom Colors
Color Matching with the Eyedropper
Picture, Texture, or Pattern Fills
WordArt Styles and Text Effects
2.2—Working with Icons and 3D Models
Insert and Format Icons
Insert and Adjust 3D Models
2.3—Working with Pictures
Apply Picture Styles and Effects
Crop a Picture
Change Picture Colors
Set a Transparent Color
Compress Pictures
Insert Online Pictures and Illustrations
Creative Commons Licensing
Pause & Practice: Powerpoint 2-1
2.4—Creating a Table
Insert and Draw Methods
Move and Select
Insert and Delete Rows and Columns
Merge and Split Cells
Adjust Sizing
2.5—Formatting a Table
Table Style Options and Effects
Shading and Border Colors
Cell Alignment
Cell Margins and Text Direction
Pause & Practice: Powerpoint 2-2
2.6—Creating a SmartArt Graphic
SmartArt Layouts
Add Text
2.7—Formatting a SmartArt Graphic
SmartArt Styles
Change Colors
Change Layouts
Add Shapes
Pause & Practice: Powerpoint 2-3
2.8—Creating a Chart
Enter Data and Edit
Change Chart Type
2.9—Formatting a Chart
Chart Styles and Colors
Format Chart Elements
Legend and Data Labels
Explode a Pie Slice
Pause & Practice: Powerpoint 2-4
Chapter Summary
Check for Understanding
Using Microsoft PowerPoint 365
Guided Project 2-1
Guided Project 2-2
Guided Project 2-3
Independent Project 2-4
Independent Project 2-5
Independent Project 2-6
Improve It Project 2-7
Challenge Project 2-8
Challenge Project 2-9
Challenge Project 2-10
CHAPTER 3: Preparing for Delivery and Using a Slide Presentation
Chapter Overview
Student Learning Outcomes (SLOs)
Case Study
3.1—Creating Custom Theme and Background Colors
Custom Theme Colors
Custom Background Colors
Format a Background with Pattern and Gradient Fills
Format a Background with Picture and Texture Fills
3.2—Applying Animation
Add Entrance, Exit, and Emphasis Effects
Effect Options, Timing, and Duration
3.3—Linking to an Online Video
Format an Online Video
Play an Online Video
Obtain Permission
Pause & Practice: Powerpoint 3-1
3.4—Using Rehearsal Techniques
Speaker Notes
Rehearse Timings
Set Timings Manually
Prepare for Mishaps
3.5—Controlling Display Options
Adjust Slide Size
Presenter View
Pause & Practice: Powerpoint 3-2
3.6—Presenting Using Projection Equipment
Position Equipment
Navigate in a Slide Show
Control Slide Display
Blank Slides
Hide and Reveal Slides
Use Keyboard Shortcuts
Remote Control and Laser Pointer
3.7—Using Annotation Pens
Pause & Practice: Powerpoint 3-3
3.8—Preparing a Self-Running Presentation
Record a Slide Show with Narration
Set Up a Kiosk Presentation with Looping
3.9—Packaging a Presentation for CD or Folder
Pause & Practice: Powerpoint 3-4
Chapter Summary
Check for Understanding
Using Microsoft PowerPoint 365
Guided Project 3-1
Guided Project 3-2
Guided Project 3-3
Independent Project 3-4
Independent Project 3-5
Independent Project 3-6
Improve It Project 3-7
Challenge Project 3-8
Challenge Project 3-9
Challenge Project 3-10
appendices
APPENDIX A: Microsoft Office Shortcuts
glossary
index