Atjaunināt sīkdatņu piekrišanu

Technology for Success and Shelly Cashman Series MicrosoftĀ®Office 365 & Office 2019 New edition [Mīkstie vāki]

4.33/5 (12 ratings by Goodreads)
(Austin Community College), (Bentley University), , (Western Kentucky University), (The Software Resource), (NA), (NA), (The Software Resource), (University of Delaware), (University of Central Florida)
  • Formāts: Paperback / softback, 976 pages, height x width x depth: 40x215x276 mm, weight: 2109 g
  • Izdošanas datums: 13-May-2019
  • Izdevniecība: Course Technology Inc
  • ISBN-10: 0357026381
  • ISBN-13: 9780357026380
Citas grāmatas par šo tēmu:
  • Mīkstie vāki
  • Cena: 95,78 €*
  • * ši ir gala cena, t.i., netiek piemērotas nekādas papildus atlaides
  • Standarta cena: 119,73 €
  • Ietaupiet 20%
  • Grāmatu piegādes laiks ir 3-4 nedēļas, ja grāmata ir uz vietas izdevniecības noliktavā. Ja izdevējam nepieciešams publicēt jaunu tirāžu, grāmatas piegāde var aizkavēties.
  • Daudzums:
  • Ielikt grozā
  • Piegādes laiks - 4-6 nedēļas
  • Pievienot vēlmju sarakstam
Technology for Success and Shelly Cashman Series Microsoft®Office 365 & Office 2019 New editionPalielināt
  • Formāts: Paperback / softback, 976 pages, height x width x depth: 40x215x276 mm, weight: 2109 g
  • Izdošanas datums: 13-May-2019
  • Izdevniecība: Course Technology Inc
  • ISBN-10: 0357026381
  • ISBN-13: 9780357026380
Citas grāmatas par šo tēmu:
Permanent link: https://www.kriso.lv/db/9780357026380.html
Keywords:
Master the latest version of Microsoft Office and take advantage of today's ever-changing world of technology with TECHNOLOGY FOR SUCCESS AND SHELLY CASHMAN SERIES MICROSOFT OFFICE 365 & OFFICE 2019. Part of the highly acclaimed Shelly Cashman Series that has introduced computer skills to millions of students like you, this edition offers a proven approach that's effective, no matter what your learning style. Meaningful topics within manageable lessons demonstrate how to apply concepts to your academic, professional, and personal lives. A step-by-step, screen-by-screen approach guides you in expanding your understanding of Microsoft Office 2019 through experimentation, critical thought and personalization. Updated activities, case scenarios and an emphasis on employability demonstrate the importance of what you're learning as you master the keys to using Microsoft Office 2019 effectively and become a savvy user of today's technology.
Getting to Know Microsoft Office Versions OFF-1
Using SAM Projects and Textbook Projects SAM-1
Introduction to Technology for Success: Computer Concepts CC 1-1
Technology for Success: Computer Concepts
Module One Impact of Digital Technology
Module Objective: Analyze the ways in which technology has revolutionized the last quarter of the century. Explain Society's Reliance on Technology
CC 1-2
Outline the History of Computers
CC 1-2
Explain the Impact of the Internet of Things and Embedded Computers
CC 1-3
ATMs and Kiosks
CC 1-4
IoT at Home
CC 1-5
IoT in Business
CC 1-5
Discover Uses for Artificial Intelligence
CC 1-6
Explore the Impact of Virtual Reality
CC 1-6
The Digital Divide
CC 1-7
Develop Personal Uses for Technology
CC 1-7
Explore Personal Uses for Technology
CC 1-7
Use Robotics and Virtual Reality
CC 1-8
Utilize Technology in Daily Life
CC 1-9
Use Technology to Assist Users with Disabilities
CC 1-10
Apply Green Computing Concepts to Daily Life
CC 1-11
Enterprise Computing
CC 1-12
Explain the Role of Technology in the Professional World
CC 1-13
List the Ways that Professionals Might Use Technology in the Workplace
CC 1-13
Technology in K-12 Education
CC 1-13
Technology in Higher Education
CC 1-13
Technology in Healthcare
CC 1-13
Technology in the Transportation Industry
CC 1-13
Technology in Manufacturing
CC 1-14
Explore Technology Careers
CC 1-14
Explore How You Might Prepare for a Career in Technology
CC 1-16
Summary
CC 1-18
Review Questions
CC 1-18
Discussion Questions
CC 1-19
Critical Thinking Activities
CC 1-19
Key Terms
CC 1-19
Module Two The Web
Module Objective: Complete research using information gathered from reliable online sources. Explain the Role of the Web in Daily Life
CC 2-2
Define Web Browsing Terms
CC 2-2
Explain the Purpose of a Top-Level Domain
CC 2-5
Describe Internet Standards
CC 2-5
Describe Websites and Webpages
CC 2-5
Identify the Types of Websites
CC 2-6
Explain the Pros and Cons of Web Apps
CC 2-8
Identify the Major Components of a Webpage
CC 2-9
Identify Secure and Insecure Websites
CC 2-10
Use E-commerce
CC 2-10
Explain the Role of E-commerce in Daily Life
CC 2-11
Use E-commerce in Business Transactions
CC 2-11
Use E-commerce in Personal Transactions
CC 2-12
Find E-commerce Deals
CC 2-13
Apply Information Literacy Skills to Web Searches
CC 2-13
Define Information Literacy
CC 2-14
Explain How Search Engines Work
CC 2-14
Use Search Tools and Strategies
CC 2-14
Refine Web Searches
CC 2-15
Conduct Online Research
CC 2-17
Use Specialty Search Engines
CC 2-17
Evaluate Online Information
CC 2-18
Gather Content from Online Sources
CC 2-19
Apply Information Literacy Standards
CC 2-21
Summary
CC 2-22
Review Questions
CC 2-23
Discussion Questions
CC 2-24
Critical Thinking Activities
CC 2-24
Key Terms
CC 2-25
Module Three Computer Hardware
Module Objective: Demonstrate familiarity with using and maintaining computer hardware. Categorize the Various Types of Computer Hardware
CC 3-2
Define Each Component of Computer Hardware
CC 3-2
Visually Identify Types of Computer Hardware
CC 3-4
Explain How Computers Represent Data
CC 3-5
Explain the Benefits of Internal, External, and Cloud-Based Storage Solutions
CC 3-6
Explain the Pros and Cons of Using Different Types of Computers, Including All-in-Ones, Tablets, Mobile Devices, and Desktop Computers
CC 3-7
Determine Which Hardware Features Are Personally Necessary to Consider When Purchasing a Computer
CC 3-9
Demonstrate Familiarity with Input and Output Devices
CC 3-14
Experiment with Input Devices
CC 3-14
Experiment with Output Devices
CC 3-16
Explain How to Install Computer Hardware
CC 3-17
Maintain Hardware Components
CC 3-18
Measure the Performance of Computer Hardware
CC 3-18
Explain How to Troubleshoot Problems with Hardware and Peripherals
CC 3-18
Explain the Necessary Steps to Maintain Computer Hardware
CC 3-25
Explain How to Restore a Device and Its Associated Hardware and Software
CC 3-26
Summary
CC 3-27
Review Questions
CC 3-27
Discussion Questions
CC 3-28
Critical Thinking Activities
CC 3-28
Key Terms
CC 3-28
Module Four Operating Systems and File Management
Module Objective: Keep your chosen operating systems running smoothly, through personalization and maintenance. Compare Operating Systems
CC 4-2
Differentiate Between an Operating System and System Software
CC 4-2
Differentiate Between Operating Systems
CC 4-3
Identify Desktop Components
CC 4-5
Explain How an Operating System Works
CC 4-7
The Purpose of an Operating System
CC 4-7
How an Operating System Manages Memory
CC 4-8
Steps in the Boot Process
CC 4-8
How Operating Systems Manage Input and Output
CC 4-9
Personalize an Operating System to Increase Productivity
CC 4-10
Customize System Software
CC 4-10
Customize Hardware Using System Software
CC 4-11
Manage Desktop Windows
CC 4-12
Use Administrative Tools
CC 4-13
Manage Files and Folders
CC 4-16
Compress and Uncompress Files
CC 4-16
Save Files to Folders and File Systems
CC 4-16
Determine File Properties
CC 4-17
Manage File Names and File Placement
CC 4-18
Manage Folder Names and Folder Placement
CC 4-18
Organize Files Using File Management Tools
CC 4-19
Summary
CC 4-20
Review Questions
CC 4-20
Discussion Questions
CC 4-21
Critical Thinking Activities
CC 4-21
Key Terms
CC 4-21
Module Five Software and Apps
Module Objective: Demonstrate familiarity with common apps and productivity software. Explain How to Use Apps as Part of Your Daily Life
CC 5-2
Define Application Software
CC 5-2
Describe the Purpose of Each Key Type of App
CC 5-3
Describe Types of Apps
CC 5-3
Identify Common Features of Apps
CC 5-4
Use Mobile Apps
CC 5-5
Use Common Features of Productivity and Graphics Apps
CC 5-9
Identify Apps and Productivity Suites Related to Word Processing, Spreadsheet, Presentation, and Database Software
CC 5-10
Use Word Processing Software for Basic Word Processing Functions
CC 5-11
Format Documents Using Word Processing Software
CC 5-13
Use Spreadsheet Software to Manage Basic Workbooks
CC 5-14
Use Presentation Software to Create and Share Presentations
CC 5-19
Use Database Software to Manage Basic Databases
CC 5-24
Use Graphics Software
CC 5-28
Summary
CC 5-32
Review Questions
CC 5-33
Discussion Questions
CC 5-33
Critical Thinking Activities
CC 5-34
Key Terms
CC 5-34
Module Six Security and Safety
Module Objective: Safeguard against the major health and safety risks associated with regular computer use. Discuss Computer Safety and Health Risks
CC 6-2
Determine the Risks to Computer Security and Safety
CC 6-3
Understand the Risks to Physical, Behavioral, and Social Health
CC 6-5
Describe Common Cybersecurity Attacks
CC 6-8
Use Protective Measures to Safeguard Computers and Data
CC 6-12
Explain the Steps to Protect Computer Equipment
CC 6-12
Protect Mobile Devices and Your Privacy
CC 6-15
Use Strong Authentication
CC 6-17
Explain the Benefits of Encryption
CC 6-20
Discuss Measures to Prevent Identity Theft and Protect Financial Information
CC 6-21
Protect Yourself While Online
CC 6-23
Summary
CC 6-24
Review Questions
CC 6-25
Discussion Questions
CC 6-26
Critical Thinking Activities
CC 6-26
Key Terms
CC 6-26
References
CC 6-27
Microsoft Word 2019
Module One Creating and Modifying a Flyer
Objectives
WD 1-1
What Is Word?
WD 1-1
Introduction
WD 1-2
Project: Flyer with a Picture
WD 1-2
Starting and Using Word
WD 1-3
To Start Word and Create a Blank Document
WD 1-3
The Word Window
WD 1-5
To Display a Different Tab on the Ribbon
WD 1-10
To Adjust the Margins
WD 1-11
Entering Text in a Document
WD 1-12
To Type Text
WD 1-12
To Change the Zoom to Page Width
WD 1-13
To Display Formatting Marks
WD 1-14
Wordwrap
WD 1-14
To Wordwrap Text as You Type
WD 1-15
Spelling and Grammar Check
WD 1-15
To Enter More Text with Spelling and Grammar Errors
WD 1-16
To Check Spelling and Grammar as You Work in a Document
WD 1-16
To Insert a Blank Line
WD 1-18
To Enter More Text
WD 1-19
Navigating a Document
WD 1-20
To Save a Document for the First Time
WD 1-21
Formatting Paragraphs and Characters
WD 1-23
Font, Font Sizes, and Themes
WD 1-24
To Change the Document Theme
WD 1-25
To Center a Paragraph
WD 1-27
To Center Another Paragraph
WD 1-28
Formatting Single versus Multiple Paragraphs and Characters
WD 1-28
To Select a Line
WD 1-28
To Change the Font Size of Selected Text
WD 1-29
To Change the Font of Selected Text
WD 1-30
To Change the Case of Selected Text
WD 1-31
To Apply a Preset Text Effect to Selected Text
WD 1-32
To Shade a Paragraph
WD 1-33
To Select a Paragraph
WD 1-34
To Change the Font Color of Selected Text
WD 1-35
To Change the Font Size of Selected Text
WD 1-35
To Change the Zoom Percentage
WD 1-36
To Select Multiple Lines
WD 1-37
To Change the Font Size of Selected Text
WD 1-38
To Number a List of Paragraphs
WD 1-38
To Undo and Redo an Action
WD 1-40
To Bullet a List of Paragraphs
WD 1-40
AutoFormat As You Type
WD 1-42
To Remove a Hyperlink
WD 1-42
To Center Another Paragraph
WD 1-43
To Use the Mini Toolbar to Format Text
WD 1-43
To Select a Group of Words
WD 1-45
To Underline Text
WD 1-45
To Italicize Text
WD 1-46
To Select Nonadjacent Text
WD 1-47
To Bold Text
WD 1-48
Selecting Text
WD 1-48
To Save an Existing Document with a Different File Name
WD 1-49
Inserting and Formatting a Picture in a Word Document
WD 1-50
To Center a Paragraph
WD 1-51
To Insert a Picture from a File
WD 1-51
To Change the Zoom to One Page
WD 1-53
To Resize an Object Proportionally
WD 1-53
To Apply a Picture Style
WD 1-55
To Apply a Picture Effect
WD 1-56
Enhancing the Page
WD 1-57
To Change Theme Colors
WD 1-58
To Add a Page Border
WD 1-59
To Change Spacing before and after Paragraphs
WD 1-60
To Change the Document Properties
WD 1-61
To Save an Existing Document with the Same File Name
WD 1-62
To Close a Document
WD 1-63
Correcting Errors and Revising a Document
WD 1-64
Types of Changes Made to Documents
WD 1-64
To Open a Document
WD 1-64
To Change the Zoom to Page Width
WD 1-65
To Insert Text in an Existing Document
WD 1-65
Cutting, Copying, and Pasting
WD 1-66
To Delete or Cut Text
WD 1-66
To Copy and Paste
WD 1-67
To Display the Paste Options Menu
WD 1-68
To Move Text
WD 1-69
To Switch to Read Mode
WD 1-70
To Switch to Print Layout View
WD 1-71
To Save a Document with the Same File Name
WD 1-71
To Print a Document
WD 1-71
Using Word Help
WD 1-72
To Use the Tell Me Box
WD 1-73
To Use the Help Pane
WD 1-74
Obtaining Help while Working in Word
WD 1-75
To Sign Out of a Microsoft Account
WD 1-75
To Exit Word
WD 1-76
Summary
WD 1-77
Apply Your Knowledge
WD 1-78
Extend Your Knowledge
WD 1-80
Expand Your World
WD 1-82
In the Lab
WD 1-84
Module Two Creating a Research Paper
Objectives
WD 2-1
Introduction
WD 2-1
Project: Research Paper
WD 2-1
MLA Documentation Style
WD 2-2
Changing Document Settings
WD 2-4
To Start Word and Specify Settings
WD 2-4
Styles
WD 2-4
To Modify a Style
WD 2-5
Adjusting Line and Paragraph Spacing
WD 2-6
To Change Line Spacing
WD 2-6
To Remove Space after a Paragraph
WD 2-7
To Update a Style to Match a Selection
WD 2-8
Creating a Header
WD 2-8
To Insert a Header
WD 2-9
To Right-Align a Paragraph
WD 2-10
To Enter Text in a Header
WD 2-10
To Insert Page Numbers
WD 2-10
To Close the Header
WD 2-12
Typing the Research Paper Text
WD 2-12
To Enter Name and Course Information
WD 2-13
To Click and Type
WD 2-14
Keyboard Shortcuts for Formatting Text
WD 2-15
To Format Text Using a Keyboard Shortcut
WD 2-15
To Display the Rulers
WD 2-16
To First-Line Indent Paragraphs
WD 2-16
To AutoCorrect as You Type
WD 2-18
To Use the AutoCorrect Options Button
WD 2-18
To Create an AutoCorrect Entry
WD 2-19
The AutoCorrect Dialog Box
WD 2-20
To Enter More Text
WD 2-21
Citations
WD 2-22
To Change the Bibliography Style
WD 2-22
To Insert a Citation for a New Source
WD 2-23
To Enter More Text
WD 2-25
Footnotes
WD 2-25
To Insert a Footnote
WD 2-26
To Insert a Citation Placeholder
WD 2-27
Footnote Text Style
WD 2-28
To Modify a Style Using a Shortcut Menu
WD 2-28
To Edit a Source
WD 2-30
To Edit a Citation
WD 2-32
Working with Footnotes and Endnotes
WD 2-33
To Enter More Text
WD 2-34
To Count Words
WD 2-34
Automatic Page Breaks
WD 2-35
To Enter More Text and Insert a Citation Placeholder
WD 2-35
To Hide and Show White Space
WD 2-35
To Edit a Source
WD 2-37
To Enter More Text
WD 2-38
Creating an Alphabetical Works Cited Page
WD 2-38
To Insert a Page Break
WD 2-39
To Apply a Style
WD 2-39
To Center Text
WD 2-40
To Create a Bibliographical Reference List
WD 2-40
Proofreading and Revising the Research Paper
WD 2-42
To Edit a Source Using the Source Manager Dialog Box
WD 2-43
To Update a Field (the Bibliography)
WD 2-43
To Open the Navigation Pane
WD 2-45
To Go to a Page
WD 2-45
To Insert a Citation Using an Existing Source
WD 2-46
To Move a Citation
WD 2-47
To Find Text
WD 2-47
To Replace Text
WD 2-48
Find and Replace Dialog Box
WD 2-49
To Use the Thesaurus
WD 2-49
To Check Spelling and Grammar at Once
WD 2-50
The Main and Custom Dictionaries
WD 2-52
To Save and Print the Document
WD 2-53
To Use Smart Lookup
WD 2-54
To Use Researcher
WD 2-54
To Change the Zoom to Multiple Pages
WD 2-55
To Change Read Mode Color
WD 2-56
Working with Comments in a Document
WD 2-57
To Insert a Comment
WD 2-57
To Insert Another Comment
WD 2-58
To Go To a Comment
WD 2-59
To Edit a Comment in a Comment Balloon
WD 2-60
To Go to a Comment
WD 2-60
To Reply to a Comment
WD 2-60
To Hide and Show Comments
WD 2-61
To Delete a Comment
WD 2-61
To Delete All Comments
WD 2-62
To Exit Word
WD 2-63
Summary
WD 2-63
Apply Your Knowledge
WD 2-64
Extend Your Knowledge
WD 2-65
Expand Your World
WD 2-68
In the Lab
WD 2-69
Module Three Creating a Business Letter
Objectives
WD 3-1
Introduction
WD 3-1
Project: Business Letter
WD 3-1
To Start Word and Change Word Settings
WD 3-3
Creating a Letterhead
WD 3-4
To Insert a Shape
WD 3-5
Floating versus Inline Objects
WD 3-6
To Change an Object's Position
WD 3-7
To Change an Object's Text Wrapping
WD 3-8
To Apply a Shape Style
WD 3-8
To Change the Shape Outline
WD 3-9
To Apply a Shape Effect
WD 3-10
To Add Text to a Shape
WD 3-10
To Use the 'Increase Font Size' Button
WD 3-11
To Bold Selected Text and Save the Letterhead Document
WD 3-12
To Insert an Online Picture
WD 3-12
To Resize a Picture to a Percent of the Original Size
WD 3-14
To Change the Color of a Picture
WD 3-15
To Adjust the Brightness and Contrast of a Picture
WD 3-16
To Add a Picture Border
WD 3-16
To Change an Object's Text Wrapping
WD 3-17
To Move an Object
WD 3-18
To Copy an Object
WD 3-18
To Use Paste Options to Paste an Object
WD 3-18
To Move an Object
WD 3-19
To Flip an Object
WD 3-19
To Format and Enter Text
WD 3-20
To Insert a Symbol from the Symbol Gallery
WD 3-20
To Enter Text
WD 3-21
To Add a Paragraph Border
WD 3-21
To Clear Formatting
WD 3-22
Creating a Business Letter
WD 3-23
To Save a Document with a New File Name
WD 3-24
To Apply a Style
WD 3-24
Using Tab Stops to Align Text
WD 3-25
To Display the Ruler
WD 3-26
To Set Custom Tab Stops
WD 3-26
To Insert the Current Date in a Document
WD 3-27
To Enter the Inside Address and Salutation
WD 3-28
Tables
WD 3-29
To Insert an Empty Table
WD 3-30
To Enter Data in a Table
WD 3-31
To Enter More Data in a Table
WD 3-32
To Apply a Table Style
WD 3-32
To Select a Column
WD 3-34
Selecting Table Contents
WD 3-35
To Insert a Row in a Table
WD 3-35
Deleting Table Data
WD 3-37
To Add More Text
WD 3-37
To Bullet a List as You Type
WD 3-38
To Enter More Text and then Save the Letter
WD 3-39
Working with SmartArt Graphics
WD 3-39
To Insert a Page Break
WD 3-39
To Enter and Format Text
WD 3-40
To Add and Format a Paragraph Border
WD 3-41
To Clear Formatting
WD 3-43
To Apply a Style and Enter More Text
WD 3-43
To Change the Underline Style
WD 3-44
To Use the Format Painter Button
WD 3-45
SmartArt Graphics
WD 3-46
To Insert a SmartArt Graphic
WD 3-47
To Delete Shapes from a SmartArt Graphic
WD 3-49
To Add Text to Shapes in a SmartArt Graphic
WD 3-50
To Add a Shape to a SmartArt Graphic
WD 3-51
To Add More Shapes and Text to a SmartArt Graphic
WD 3-52
To Change Colors of a SmartArt Graphic
WD 3-54
To Apply a SmartArt Style
WD 3-55
To Resize the SmartArt Graphic
WD 3-55
To Save and Print the Letter
WD 3-56
Enhancing a Document's Accessibility
WD 3-56
Addressing and Printing Envelopes and Mailing Labels
WD 3-57
To Address and Print an Envelope
WD 3-57
Envelopes and Labels
WD 3-58
Summary
WD 3-59
Apply Your Knowledge
WD 3-60
Extend Your Knowledge
WD 3-62
Expand Your World
WD 3-64
In the Lab
WD 3-65
Microsoft PowerPoint 2019
Module One Creating and Editing Presentations with Pictures
Objectives
PPT 1-1
What Is PowerPoint?
PPT 1-1
Project: Presentation with a Bulleted List and Pictures
PPT 1-2
Starting and Using PowerPoint
PPT 1-3
To Start PowerPoint and Create a Blank Presentation
PPT 1-3
The PowerPoint Window
PPT 1-5
To Display a Different Tab on the Ribbon
PPT 1-10
Creating a Title Slide
PPT 1-11
To Choose a Presentation Theme
PPT 1-11
To Enter the Presentation Title
PPT 1-13
Correcting a Mistake When Typing
PPT 1-14
Paragraphs
PPT 1-14
To Enter the Presentation Subtitle Paragraph
PPT 1-14
To Zoom a Slide
PPT 1-15
Formatting Characters
PPT 1-16
Fonts and Font Styles
PPT 1-16
To Select a Paragraph
PPT 1-16
To Italicize Text
PPT 1-17
To Increase Font Size
PPT 1-17
To Select a Word
PPT 1-17
To Change the Text Color
PPT 1-18
To Zoom a Slide
PPT 1-19
To Save a Presentation for the First Time
PPT 1-19
Adding a Slide with a Bulleted List
PPT 1-22
To Add a New Title and Content Slide
PPT 1-22
Creating a Multilevel Bulleted List
PPT 1-23
To Enter a Slide Title
PPT 1-23
To Select a Text Placeholder
PPT 1-24
To Type a Multilevel Bulleted List
PPT 1-24
To Type the Remaining Text
PPT 1-26
To Select a Group of Words
PPT 1-26
To Bold Text
PPT 1-27
To Increase Font Size
PPT 1-27
To Underline Text
PPT 1-27
Adding Slides, Changing Slide Layouts, and Changing the Theme
PPT 1-28
To Add a New Slide and Enter a Slide Title and Headings
PPT 1-28
To Change the Font
PPT 1-30
To Add a Slide with the Title Only Layout
PPT 1-31
To Enter a Slide Title
PPT 1-32
To Change the Theme
PPT 1-32
PowerPoint Views
PPT 1-34
To Move to Another Slide in Normal View
PPT 1-34
Inserting, Resizing, and Moving Pictures
PPT 1-36
To Insert a Picture into a Slide without a Content Placeholder
PPT 1-36
To Insert another Picture into a Slide without a Content Placeholder
PPT 1-38
To Insert Another Picture into a Slide without a Content Placeholder
PPT 1-38
To Insert a Picture into a Content Placeholder
PPT 1-39
Resizing Photos and Illustrations
PPT 1-39
To Proportionally Resize Pictures
PPT 1-40
To Resize the Picture on Slide 2
PPT 1-41
To Resize the Picture on Slide 4
PPT 1-41
To Move Pictures
PPT 1-42
To Insert Another Picture into a Slide without a Content Placeholder
PPT 1-43
To Rotate a Picture
PPT 1-43
To Nonproportionally Resize the Picture on Slide 2
PPT 1-44
To Move a Slide in Normal View
PPT 1-46
To Save a Presentation with the Same File Name
PPT 1-46
To Close a File Using Backstage View
PPT 1-47
To Open a Recent File Using Backstage View
PPT 1-47
Making Changes to Slide Text Content
PPT 1-48
Replacing Text in an Existing Slide
PPT 1-49
Deleting Text
PPT 1-49
To Delete Text in a Placeholder
PPT 1-49
To Change the Theme Colors
PPT 1-50
To Add Notes
PPT 1-51
Checking Spelling
PPT 1-52
To Check Spelling
PPT 1-53
Document Properties
PPT 1-54
Changing Views
PPT 1-55
To Change Views
PPT 1-55
Viewing the Presentation in Slide Show View
PPT 1-56
To Start Slide Show View
PPT 1-56
To Move Manually through Slides in a Slide Show
PPT 1-58
Saving and Printing Files
PPT 1-59
To Save a File with a Different File Name
PPT 1-59
To Print Full Page Slides
PPT 1-59
To Preview and Print a Handout
PPT 1-61
To Print Speaker Notes
PPT 1-62
To Change the Print Color
PPT 1-63
Using PowerPoint Help
PPT 1-64
To Obtain Help Using the Search Box
PPT 1-64
Obtaining Help while Working in PowerPoint
PPT 1-66
To Obtain Help Using the Tell Me Box
PPT 1-67
To Sign Out of a Microsoft Account
PPT 1-67
Summary
PPT 1-68
Apply Your Knowledge
PPT 1-69
Extend Your Knowledge
PPT 1-71
Expand Your World
PPT 1-72
In the Lab
PPT 1-73
Module Two Enhancing Presentations with Shapes and SmartArt
Objectives
PPT 2-1
Introduction
PPT 2-1
Project-Presentation with SmartArt and Shapes
PPT 2-1
Downloading a Theme and Editing Slides
PPT 2-3
To Search for and Download an Online Theme
PPT 2-3
To Save the Presentation
PPT 2-5
To Delete a Slide
PPT 2-5
To Create a Title Slide
PPT 2-7
To Align a Paragraph
PPT 2-7
To Create the First Text Slide
PPT 2-8
To Insert a Symbol
PPT 2-9
To Copy a Symbol
PPT 2-11
To Add a Hyperlink to a Paragraph
PPT 2-12
Creating and Formatting a SmartArt Graphic
PPT 2-13
To Convert Text to a SmartArt Graphic
PPT 2-14
To Edit SmartArt Shape Text
PPT 2-15
Text Pane
PPT 2-16
To Edit SmartArt Bulleted Text
PPT 2-17
To Format Text Pane Characters
PPT 2-18
To Change the SmartArt Layout
PPT 2-19
To Edit the Title Text
PPT 2-21
To Duplicate a Slide
PPT 2-21
To Insert a SmartArt Graphic
PPT 2-22
To Add Text to the SmartArt Graphic
PPT 2-23
To Apply a SmartArt Style
PPT 2-24
Inserting and Formatting a Shape
PPT 2-25
To Insert a Shape
PPT 2-25
Resizing Shapes
PPT 2-27
To Resize a Shape Proportionally
PPT 2-28
To Resize a Shape Nonproportionally by Entering an Exact Measurement
PPT 2-28
To Select All Slide Content
PPT 2-30
To Apply a Shape Style
PPT 2-31
To Copy and Paste a Shape
PPT 2-32
To Add Text to a Shape
PPT 2-33
To Select Shapes
PPT 2-34
To Format Shape Text
PPT 2-34
To Change a Shape Fill Color
PPT 2-35
Positioning Slide Elements
PPT 2-36
Aligning and Distributing Objects
PPT 2-37
To Display the Drawing Guides
PPT 2-38
To Display the Ruler
PPT 2-38
To Display the Gridlines
PPT 2-39
To Position a Shape Using Guides, Gridlines, and the Ruler
PPT 2-40
To Position the Remaining Shapes
PPT 2-41
To Distribute Shapes
PPT 2-41
To Align a Shape
PPT 2-42
To Position the Arrow Shape
PPT 2-43
To Flip a Shape
PPT 2-44
To Change the Stacking Order
PPT 2-44
To Group Objects
PPT 2-45
To Insert Additional Shapes
PPT 2-46
To Merge Shapes
PPT 2-47
To Hide the Grid and Guides
PPT 2-48
To Hide Rulers
PPT 2-48
To Apply a Picture Fill to a Shape
PPT 2-49
To Change a Shape Outline Weight
PPT 2-50
To Change a Shape Outline Color
PPT 2-51
To Change a Shape Outline Style
PPT 2-52
To Apply an Effect to a Shape
PPT 2-52
To Rotate a Shape to an Exact Value
PPT 2-53
To Add a Slide Title
PPT 2-54
To Add and Format a Shape
PPT 2-54
Adding a Footer
PPT 2-55
To Add a Footer with Fixed Information
PPT 2-55
Adding a Transition
PPT 2-56
To Add a Transition between Slides
PPT 2-57
To Save and Print the Presentation
PPT 2-59
Summary
PPT 2-59
Apply Your Knowledge
PPT 2-60
Extend Your Knowledge
PPT 2-63
Expand Your World
PPT 2-64
In the Lab
PPT 2-66
Module Three Inserting WordArt, Charts, and Tables
Objectives
PPT 3-1
Introduction
PPT 3-1
Project-Presentation with WordArt, a Chart, and a Table
PPT 3-1
Adding a Chart to a Slide and Formatting
PPT 3-3
To Run PowerPoint, Apply a Theme, and Save the Presentation
PPT 3-3
To Delete a Placeholder
PPT 3-4
To Insert a Chart
PPT 3-5
To Replace Sample Data
PPT 3-6
To Resize a Chart
PPT 3-8
To Align a Chart
PPT 3-9
To Change a Chart Style
PPT 3-10
To Change the Shape Outline Color
PPT 3-11
To Change the Shape Outline Weight
PPT 3-12
To Change the Title and Legend Font and Font Size
PPT 3-13
Adding a Table to a Slide and Formatting
PPT 3-13
Tables
PPT 3-14
To Insert an Empty Table
PPT 3-14
To Enter Data in a Table
PPT 3-15
To Apply a Table Style
PPT 3-16
To Add Borders to a Table
PPT 3-17
To Add an Effect to a Table
PPT 3-18
To Insert a Table Row
PPT 3-19
To Insert a Table Column
PPT 3-20
To Resize a Table
PPT 3-21
To Align a Table
PPT 3-22
To Add a Slide Title
PPT 3-23
Inserting and Formatting a Text Box
PPT 3-23
To Insert a Text Box and Format Text
PPT 3-23
To Format Text Box Characters
PPT 3-24
Inserting and Moving Slides
PPT 3-26
To Reuse Slides from an Existing Presentation
PPT 3-27
To Move a Slide in Slide Sorter View
PPT 3-29
Inserting Pictures and Adding Effects
PPT 3-30
To Delete a Picture
PPT 3-30
To Insert and Resize a Picture into a Slide without Content Placeholders
PPT 3-31
To Crop a Picture
PPT 3-31
Adjusting Picture Colors
PPT 3-33
To Color a Picture
PPT 3-34
To Add an Artistic Effect to a Picture
PPT 3-35
To Change the Picture Softness
PPT 3-36
To Apply a Picture Style
PPT 3-37
To Size a Picture
PPT 3-37
To Move a Picture
PPT 3-38
To Align Pictures
PPT 3-39
Creating and Formatting WordArt
PPT 3-40
To Insert WordArt
PPT 3-40
To Change the WordArt Shape
PPT 3-41
To Change the WordArt 3-D Rotation Effect
PPT 3-43
To Change the WordArt Text Fill Color
PPT 3-44
To Change the WordArt Text Outline Color
PPT 3-44
To Convert Text to WordArt
PPT 3-45
To Resize WordArt Proportionally
PPT 3-45
Animating Slide Content
PPT 3-46
Custom Animations
PPT 3-46
To Animate an Object Using an Entrance Effect
PPT 3-47
To Change Animation Direction
PPT 3-47
To Change the Animation Start Option
PPT 3-48
To Preview an Animation Sequence
PPT 3-49
To Change the Animation Duration
PPT 3-49
To Animate Text
PPT 3-50
To Change the Animation Sequence Effect Option
PPT 3-50
Adding Media to Slides
PPT 3-51
To Insert a Video File
PPT 3-52
To Resize a Video Clip
PPT 3-53
To Move a Video Clip
PPT 3-54
To Change Video Contrast
PPT 3-54
To Play a Video File Automatically
PPT 3-55
To Add a Transition between Slides
PPT 3-56
To Run a Slide Show with Animations and Video
PPT 3-56
To Save and Print the Presentation
PPT 3-57
Summary
PPT 3-57
Apply Your Knowledge
PPT 3-58
Extend Your Knowledge
PPT 3-60
Expand Your World
PPT 3-61
In the Lab
PPT 3-62
Microsoft Excel 2019
Module One Creating a Worksheet and a Chart
Objectives
EX 1-1
Introduction
EX 1-1
Project: Real Estate Budget Worksheet and Chart
EX 1-1
Starting and Using Excel
EX 1-4
What Is Excel?
EX 1-4
To Start Excel and Create a Blank Workbook
EX 1-5
The Excel Window
EX 1-7
To Display a Different Tab on the Ribbon
EX 1-12
Selecting a Cell
EX 1-12
Entering Text
EX 1-12
To Enter the Worksheet Titles
EX 1-13
AutoCorrect
EX 1-15
To Enter Column Titles
EX 1-15
To Enter Row Titles
EX 1-17
Entering Numbers
EX 1-18
To Enter Numbers
EX 1-18
Calculating Sums and Using Formulas
EX 1-20
To Sum a Column of Numbers
EX 1-20
Using the Fill Handle to Copy a Cell to Adjacent Cells
EX 1-21
To Copy a Cell to Adjacent Cells in a Row
EX 1-22
To Calculate Multiple Totals at the Same Time
EX 1-24
Calculating Average, Maximum, and Minimum Values
EX 1-25
To Enter a Formula Using the Keyboard
EX 1-26
To Copy a Cell to Adjacent Cells in a Row Using the Fill Handle
EX 1-27
Saving the Project
EX 1-27
To Save a Workbook
EX 1-28
Formatting the Worksheet
EX 1-30
Font Style, Size, and Color
EX 1-32
To Change a Cell Style
EX 1-32
To Change the Font
EX 1-34
To Apply Bold Style to a Cell
EX 1-35
To Increase the Font Size of a Cell Entry
EX 1-36
To Change the Font Color of a Cell Entry
EX 1-37
To Center Cell Entries across Columns by Merging Cells
EX 1-38
To Format Rows Using Cell Styles
EX 1-39
To Format Numbers in the Worksheet
EX 1-41
To Adjust the Column Width
EX 1-42
To Use the Name Box to Select a Cell
EX 1-44
Other Ways to Select Cells
EX 1-44
Adding a Pie Chart to the Worksheet
EX 1-45
To Add a Pie Chart
EX 1-46
To Apply a Style to a Chart
EX 1-48
Changing the Sheet Tab Names and Colors
EX 1-49
To Move a Chart to a New Sheet
EX 1-49
To Change the Sheet Tab Name and Color
EX 1-50
Document Properties
EX 1-51
Printing a Worksheet
EX 1-52
To Preview and Print a Worksheet in Landscape Orientation
EX 1-53
Viewing Automatic Calculations
EX 1-56
To Use the AutoCalculate Area to Determine a Maximum
EX 1-56
Correcting Errors
EX 1-57
Correcting Errors while Entering Data into a Cell
EX 1-57
Correcting Errors after Entering Data into a Cell
EX 1-57
Undoing the Last Cell Entry
EX 1-59
Clearing a Cell or Range of Cells
EX 1-59
Clearing the Entire Worksheet
EX 1-60
Using Excel Help
EX 1-60
To Obtain Help Using the Search Text Box
EX 1-61
Obtaining Help while Working in an Office App
EX 1-63
To Obtain Help Using the Tell Me Box
EX 1-63
To Save a Workbook with a Different File Name
EX 1-64
To Sign Out of a Microsoft Account
EX 1-64
Summary
EX 1-65
Apply Your Knowledge
EX 1-66
Extend Your Knowledge
EX 1-68
Expand Your World
EX 1-69
In the Lab
EX 1-69
Module Two Formulas, Functions, and Formatting
Objectives
EX 2-1
Introduction
EX 2-1
Project: Worksheet with Formulas and Functions
EX 2-2
Entering the Titles and Numbers into the Worksheet
EX 2-4
To Enter the Worksheet Title and Subtitle
EX 2-4
To Enter the Column Titles
EX 2-5
To Enter the Salary Data
EX 2-5
Flash Fill
EX 2-6
To Use Flash Fill
EX 2-7
To Enter the Row Titles
EX 2-8
To Change the Sheet Tab Name and Color
EX 2-8
Entering Formulas
EX 2-9
To Enter a Formula Using the Keyboard
EX 2-9
Arithmetic Operations
EX 2-10
Order of Operations
EX 2-10
To Enter Formulas Using Point Mode
EX 2-11
To Copy Formulas Using the Fill Handle
EX 2-13
Option Buttons
EX 2-14
To Determine Totals Using the AutoSum Button
EX 2-14
To Determine the Total Tax Percentage
EX 2-15
Using the AVERAGE, MAX, MIN, and other Statistical Functions
EX 2-16
To Determine the Highest Number in a Range of Numbers Using the Insert Function Dialog Box
EX 2-16
To Determine the Lowest Number in a Range of Numbers Using the Sum Menu
EX 2-18
To Determine the Average of a Range of Numbers Using the Keyboard
EX 2-20
To Copy a Range of Cells across Columns to an Adjacent Range Using the Fill Handle
EX 2-21
Verifying Formulas Using Range Finder
EX 2-22
To Verify a Formula Using Range Finder
EX 2-22
Formatting the Worksheet
EX 2-23
To Change the Workbook Theme
EX 2-24
To Format the Worksheet Titles
EX 2-25
To Change the Background Color and Apply a Box Border to the Worksheet Title and Subtitle
EX 2-26
To Apply a Cell Style to the Column Headings and Format the Total Rows
EX 2-27
To Format Dates and Center Data in Cells
EX 2-28
To Apply an Accounting Number Format and Comma Style Format Using the Ribbon
EX 2-29
To Apply a Currency Style Format with a Floating Dollar Sign Using the Format Cells Dialog Box
EX 2-30
To Apply a Percent Style Format and Use the Increase Decimal Button
EX 2-31
Conditional Formatting
EX 2-31
To Apply Conditional Formatting
EX 2-32
Conditional Formatting Operators
EX 2-34
Changing Column Width and Row Height
EX 2-35
To Change Column Width
EX 2-35
To Change Row Height
EX 2-38
Checking Spelling
EX 2-39
To Check Spelling on the Worksheet
EX 2-40
Additional Spelling Checker Considerations
EX 2-41
Printing the Worksheet
EX 2-41
To Change the Worksheet's Margins, Header, and Orientation in Page Layout View
EX 2-42
To Print a Worksheet
EX 2-44
To Print a Section of the Worksheet
EX 2-45
Displaying and Printing the Formulas Version of the Worksheet
EX 2-46
To Display the Formulas in the Worksheet and Fit the Printout on One Page
EX 2-47
To Change the Print Scaling Option Back to 100°
EX 2-48
Summary
EX 2-49
Apply Your Knowledge
EX 2-50
Extend Your Knowledge
EX 2-51
Expand Your World
EX 2-52
In the Lab
EX 2-53
Module Three Working with Large Worksheets, Charting, and What-If Analysis
Objectives
EX 3-1
Introduction
EX 3-1
Project: Financial Projection Worksheet with What-If Analysis and Chart
EX 3-2
To Enter the Worksheet Titles and Apply a Theme
EX 3-5
Rotating Text and Using the Fill Handle to Create a Series
EX 3-5
To Rotate Text in a Cell
EX 3-5
To Use the Fill Handle to Create a Series of Month Names
EX 3-7
Using the Auto Fill Options Menu
EX 3-8
To Increase Column Widths
EX 3-9
To Enter and Indent Row Titles
EX 3-10
Copying a Range of Cells to a Nonadjacent Destination Area
EX 3-10
To Copy a Range of Cells to a Nonadjacent Destination Area
EX 3-11
Using the Paste Options Menu
EX 3-12
Using Drag and Drop to Move or Copy Cells
EX 3-12
Using Cut and Paste to Move Cells
EX 3-13
Inserting and Deleting Cells in a Worksheet
EX 3-13
To Insert a Row
EX 3-14
Inserting Columns
EX 3-15
Inserting Single Cells or a Range of Cells
EX 3-15
Deleting Columns and Rows
EX 3-16
To Enter Numbers with Format Symbols
EX 3-16
To Enter the Projected Monthly Sales
EX 3-17
To Enter and Format the System Date
EX 3-18
Absolute versus Relative Addressing
EX 3-20
To Enter a Formula Containing Absolute Cell References
EX 3-22
Making Decisions-The IF Function
EX 3-24
To Enter an IF Function
EX 3-25
To Enter the Remaining Formulas for January
EX 3-26
To Copy Formulas with Absolute Cell References Using the Fill Handle
EX 3-27
To Determine Row Totals in Nonadjacent Cells
EX 3-28
Nested Forms of the IF Function
EX 3-29
Adding and Formatting Sparkline Charts
EX 3-30
To Add a Sparkline Chart to the Worksheet
EX 3-30
To Change the Sparkline Style and Copy the Sparkline Chart
EX 3-31
To Change the Sparkline Type
EX 3-32
Customizing Sparkline Charts
EX 3-33
Formatting the Worksheet
EX 3-33
To Assign Formats to Nonadjacent Ranges
EX 3-34
To Format the Worksheet Titles
EX 3-36
To Assign Cell Styles to Nonadjacent Rows and Colors to a Cell
EX 3-37
To Copy a Cell's Format Using the Format Painter Button
EX 3-38
To Format the What-If Assumptions Table
EX 3-39
Adding a Clustered Column Chart to the Workbook
EX 3-39
To Draw a Clustered Column Chart on a Separate Chart Sheet Using the Recommended Charts Feature
EX 3-40
To Insert a Chart Title
EX 3-42
To Add Data Labels
EX 3-42
To Apply Chart Filters
EX 3-43
To Add an Axis Title to the Chart
EX 3-44
To Change the Chart Style
EX 3-45
To Modify the Chart Axis Number Format
EX 3-46
To Remove Filters and Data Labels
EX 3-47
Organizing the Workbook
EX 3-48
To Rename and Color Sheet Tabs
EX 3-48
To Reorder the Sheet Tabs
EX 3-48
To Check Spelling in Multiple Sheets
EX 3-49
To Preview and Print the Worksheet
EX 3-49
Changing the View of the Worksheet
EX 3-50
To Shrink and Magnify the View of a Worksheet or Chart
EX 3-50
To Split a Window into Panes
EX 3-52
To Remove the Panes from the Window
EX 3-53
To Freeze Worksheet Columns and Rows
EX 3-53
To Unfreeze the Worksheet Columns and Rows
EX 3-55
What-If Analysis
EX 3-55
To Analyze Data in a Worksheet by Changing Values
EX 3-55
Goal Seeking
EX 3-56
To Goal Seek
EX 3-56
Insights
EX 3-58
To Use the Smart Lookup Insight
EX 3-58
Accessibility Features
EX 3-59
Summary
EX 3-60
Apply Your Knowledge
EX 3-61
Extend Your Knowledge
EX 3-62
Expand Your World
EX 3-64
In the Lab
EX 3-65
Microsoft Access 2019
Module One Databases and Database Objects: An Introduction
Objectives
AC 1-1
Introduction
AC 1-1
Project-Database Creation
AC 1-1
Creating a Database
AC 1-4
To Create a Database
AC 1-5
To Create a Database Using a Template
AC 1-6
The Access Window
AC 1-6
Navigation Pane and Access Work Area
AC 1-6
Determining Tables and Fields
AC 1-7
Naming Tables and Fields
AC 1-7
Determining the Primary Key
AC 1-7
Determining Data Types for the Fields
AC 1-7
Creating a Table in Datasheet View
AC 1-9
To Modify the Primary Key
AC 1-10
To Define the Remaining Fields in a Table
AC 1-12
Making Changes to the Structure
AC 1-13
To Save a Table
AC 1-14
To View the Table in Design View
AC 1-15
Checking the Structure in Design View
AC 1-16
To Close the Table
AC 1-16
To Add Records to a Table
AC 1-17
Making Changes to the Data
AC 1-20
Navigation Buttons
AC 1-21
To Resize Columns in a Datasheet
AC 1-21
To Create a Table in Design View
AC 1-24
Correcting Errors in the Structure
AC 1-25
Populating the Patients Table
AC 1-25
To Close the Table
AC 1-26
To Resize Columns in a Datasheet
AC 1-26
Importing Additional Access Database Tables into an Existing Database
AC 1-26
Additional Database Objects
AC 1-29
Creating Queries
AC 1-29
To Use the Simple Query Wizard to Create a Query
AC 1-29
Using Queries
AC 1-31
Creating Forms
AC 1-31
To Create a Form
AC 1-31
Using a Form
AC 1-34
To Create a Report Using the Report Wizard
AC 1-34
Using Layout View in a Report
AC 1-36
Database Properties
AC 1-37
Special Database Operations
AC 1-37
Backup and Recovery
AC 1-37
Compacting and Repairing a Database
AC 1-38
Additional Operations
AC 1-39
To Exit Access
AC 1-39
Summary
AC 1-40
Apply Your Knowledge
AC 1-41
Extend Your Knowledge
AC 1-42
Expand Your World
AC 1-43
In the Lab
AC 1-44
Module Two Querying a Database
Objectives
AC 2-1
Introduction
AC 2-1
Project - Querying a Database
AC 2-1
Creating Queries
AC 2-3
To Create a Query in Design View
AC 2-3
To Add Records to the Database
AC 2-5
To Add Fields to the Design Grid
AC 2-6
Determining Criteria
AC 2-7
Running the Query
AC 2-7
To Use Text Data in a Criterion
AC 2-7
Using Saved Queries
AC 2-9
Wildcards
AC 2-9
To Use a Wildcard
AC 2-10
To Use Criteria for a Field Not Included in the Results
AC 2-12
Creating a Parameter Query
AC 2-13
To Create and View a Parameter Query
AC 2-14
To Use a Parameter Query
AC 2-15
To Use a Number in a Criterion
AC 2-16
Comparison Operators
AC 2-17
To Use a Comparison Operator in a Criterion
AC 2-17
Using Compound Criteria
AC 2-19
To Use a Compound Criterion Involving AND
AC 2-19
To Use a Compound Criterion Involving OR
AC 2-20
Special Criteria
AC 2-21
Sorting
AC 2-22
To Clear the Design Grid
AC 2-22
To Import a Table
AC 2-23
To Sort Data in a Query
AC 2-23
To Omit Duplicates
AC 2-24
To Sort on Multiple Keys
AC 2-26
To Create a Top-Values Query
AC 2-28
Joining Tables
AC 2-29
To Join Tables
AC 2-30
To Change Join Properties
AC 2-32
To Create a Report from a Query
AC 2-34
To Print a Report
AC 2-35
Creating a Form for a Query
AC 2-36
To Create a Form for a Query
AC 2-36
Using a Form
AC 2-37
Exporting Data from Access to Other Applications
AC 2-37
To Export Data to Excel
AC 2-38
Text Files
AC 2-40
Adding Criteria to a Join Query
AC 2-41
To Restrict the Records in a Join
AC 2-42
Calculations
AC 2-43
To Use a Calculated Field in a Query
AC 2-43
To Change a Caption
AC 2-46
To Calculate Statistics
AC 2-47
To Use Criteria in Calculating Statistics
AC 2-49
To Use Grouping
AC 2-51
Crosstab Queries
AC 2-52
To Create a Crosstab Query
AC 2-53
Customizing the Navigation Pane
AC 2-56
To Customize the Navigation Pane
AC 2-56
Summary
AC 2-57
Apply Your Knowledge
AC 2-59
Extend Your Knowledge
AC 2-60
Expand Your World
AC 2-61
In the Lab
AC 2-62
Module Three Maintaining a Database
Objectives
AC 3-1
Introduction
AC 3-1
Project - Maintaining a Database
AC 3-1
Updating Records
AC 3-2
To Create a Split Form
AC 3-3
To Use a Form to Add Records
AC 3-5
To Search for a Record
AC 3-5
To Update the Contents of a Record
AC 3-7
To Delete a Record
AC 3-7
Filtering Records
AC 3-8
To Use Filter By Selection
AC 3-9
To Toggle a Filter
AC 3-10
To Clear a Filter
AC 3-10
To Use a Common Filter
AC 3-11
To Use Filter By Form
AC 3-12
To Use Advanced Filter/Sort
AC 3-13
Filters and Queries
AC 3-14
Changing the Database Structure
AC 3-15
To Change a Number Field Size in Design View
AC 3-17
To Add a New Field
AC 3-19
To Create a Lookup Field
AC 3-20
To Add a Multivalued Field
AC 3-22
To Add a Calculated Field
AC 3-23
To Save the Changes and Close the Table
AC 3-25
Mass Changes
AC 3-25
To Use an Update Query
AC 3-26
Validation Rules
AC 3-28
To Change a Field Size
AC 3-28
To Specify a Required Field
AC 3-29
To Specify a Range
AC 3-29
To Specify a Default Value
AC 3-30
To Specify a Collection of Legal Values
AC 3-30
To Save the Validation Rules, Default Values, and Formats
AC 3-31
Updating a Table That Contains Validation Rules
AC 3-32
Making Additional Changes to the Database
AC 3-34
To Change the Contents of a Field
AC 3-34
To Use a Lookup Field
AC 3-34
To Use a Multivalued Lookup Field
AC 3-35
Changing the Appearance of a Datasheet
AC 3-37
To Include Totals in a Datasheet
AC 3-37
To Remove Totals from a Datasheet
AC 3-38
To Change Gridlines in a Datasheet
AC 3-39
To Change the Colors and Font in a Datasheet
AC 3-40
Using the Datasheet Formatting Dialog Box
AC 3-41
To Close the Datasheet without Saving the Format Changes
AC 3-41
Multivalued Fields in Queries
AC 3-42
To Include Multiple Values on One Row of a Query
AC 3-42
To Include Multiple Values on Multiple Rows of a Query
AC 3-43
To Test an Existing Query with a Multivalued Field
AC 3-44
Referential Integrity
AC 3-44
To Specify Referential Integrity
AC 3-45
Effect of Referential Integrity
AC 3-48
To Use a Subdatasheet
AC 3-49
Handling Data Inconsistency
AC 3-51
Ordering Records
AC 3-51
To Use the Ascending Button to Order Records
AC 3-52
Summary
AC 3-53
Apply Your Knowledge
AC 3-54
Extend Your Knowledge
AC 3-55
Expand Your World
AC 3-56
In the Labs
AC 3-56
Index IND-1
Sandra Cable is the author and co-author of numerous books with Course Technology, including both introductory and advanced levels of Microsoft Excel and Access. In addition to working full time for an international corporation in Dallas, she volunteers to teach at seminars and in classrooms, sharing her simple, proven approaches for mastering today's computer applications. She holds a Ph.D. in education from Texas A&M University-Commerce. Jennifer T. Campbell has written and co-authored several other leading technology texts, including TECHNOLOGY FOR SUCCESS; DISCOVERING COMPUTERS: DIGITAL TECHNOLOGY, DATA, AND DEVICES; DISCOVERING THE INTERNET; WEB DESIGN: INTRODUCTORY; MICROSOFT EXPRESSION WEB INTRODUCTORY CONCEPTS AND TECHNIQUES; COMPUTER LITERACY BASICS: MICROSOFT OFFICE 2007 COMPANION; and MICROSOFT OFFICE QUICK REFERENCE POCKET GUIDE. For over 25 years, she has served integral roles in computer educational publishing as an editor, author and marketing manager. She holds a Bachelor of Arts in English from The College of William and Mary. Dr. Mark Ciampa is a professor of analytics and information systems and the program director of the graduate Cybersecurity Data Analytics program in the Gordon Ford College of Business at Western Kentucky University in Bowling Green, Kentucky. Prior to this, he was an associate professor and served as Director of Academic Computing at Volunteer State Community College in Gallatin, Tennessee for 20 years. Mark has worked in the IT industry as a computer consultant for businesses, government agencies and educational institutions. He has published over 25 articles in peer-reviewed journals and books. He is also the author of over 30 technology textbooks from Cengage, including "Security+ Guide to Network Security Fundamentals," 8e, "CompTIA CySA+ Guide to Cybersecurity Analyst," 3e, "CWNA Guide to Wireless LANs," 3e, "Guide to Wireless Communications," "Security Awareness: Applying Practical Cybersecurity In Your World," 6e and "Networking BASICS." Dr. Ciampa holds a PhD in technology management with a specialization in digital communication systems from Indiana State University and has certifications in security and healthcare. Barbara Clemens has been a writer, editor, software product manager and instructor for more than 30 years. She has worked with Addison-Wesley Publishing, Course Technology and Cengage Learning. Ms. Clemens has edited and written numerous leading Microsoft® Office and Microsoft® Windows textbooks and has created instructional videos and online courses for MS Office. Steven M. Freund serves as a lead instructor of various Microsoft® Office, computer concepts, programming and internet technology courses throughout Central Florida. An integral author for the successful Shelly Cashman Series® since 2001, he has presented at the annual customer conference, the Shelly Cashman Series Institute and other customer events. Freund has co-authored multiple editions of DISCOVERING COMPUTERS, MOZILLA FIREFOX, WINDOWS® INTERNET EXPLORER, WINDOWS® OFFICE and DREAMWEAVER books. In addition, he has written numerous successful instructor supplements. He attended the University of Central Florida. Mark Frydenberg is a Senior Lecturer of Computer Information Systems at Bentley University in Waltham, Massachusetts. He also serves as the Director of the CIS Sandbox, Bentleys technology social learning space, which prepares students to succeed in their CIS courses and to thrive in a technology-driven business world. Professor Frydenberg teaches courses in technology concepts, Python and technology trends. His research focuses on digital literacy, collaborative learning and pedagogies for engaging students with technology. Professor Frydenberg has presented at academic and applied technology conferences and events throughout the U.S. and Europe. He is also an author of several editions of DISCOVERING COMPUTERS, and he authored WEB 2.0 CONCEPTS AND APPLICATIONS in the popular Shelly Cashman Series. Ralph Hooper has more than 30 years of teaching experience in mathematics and computer science at the university level. His professional interests include data science, machine learning, and computational thinking. Ellen F. Monk is an Assistant Professor of Management Information Systems in the Lerner College of Business and Economics at the University of Delaware. Her areas of interest encompass enterprise resource planning systems and undergraduate MIS education, including databases, advanced spreadsheets and data analytics. Dr. Monk holds a B.S. in chemical engineering, an M.B.A., and a Ph.D. in MIS. Lisa Ruffolo has served as a technical writer and editor for more than 30 years. She is pursuing an emphasis in operating systems and digital literacy. She has edited top-selling books in the fields of introduction to computing, Microsoft Office, PC repair and computer programming. Lisa Ruffolo has served as a technical writer and editor for more than 30 years. She is pursuing an emphasis in operating systems and digital literacy. She has edited top-selling books in the fields of introduction to computing, Microsoft Office, PC repair and computer programming. Susan L. Sebok is a retired professor at South Suburban College in South Holland, Illinois. She also is a licensed attorney. Working with the leading SHELLY CASHMAN SERIES® since 1993, she has co-authored several successful textbooks, including multiple versions of DISCOVERING COMPUTERS and MICROSOFT® POWERPOINT® books. She holds both Master of Arts and Juris Doctor degrees. Joy Starks has taught at Indiana University Purdue University Indianapolis for 20 years. She has written chapters in several of the best-selling Shelly Cashman Series Office books and has authored the Photoshop, Java Programming, and Microsoft® Publisher series of books. She speaks and presents at various conferences, seminars and forums across the U.S. Misty E. Vermaat has more than 30 years of experience in the field of computer and information technology. In addition to consulting in the field, she was Associate Professor at Purdue University Calumet, teaching or developing Microsoft® Office, computer concepts, database management, systems analysis and design and programming courses. Since 1990, Ms. Vermaat has led the development of THE SHELLY CASHMAN SERIES and has authored and co-authored numerous Series textbooks, including many editions of DISCOVERING COMPUTERS, DISCOVERING COMPUTERS FUNDAMENTALS, MICROSOFT® PUBLISHER and MICROSOFT® WORD books.