Skip to ContentGo to accessibility pageKeyboard shortcuts menu
OpenStax Logo

Table of contents
  1. Preface
  2. 1 Technology in Everyday Life and Business
    1. Chapter Scenario
    2. 1.1 Computing from Inception to Today
    3. 1.2 Computer Hardware and Networks
    4. 1.3 The Internet, Cloud Computing, and the Internet of Things
    5. 1.4 Safety, Security, Privacy, and the Ethical Use of Technology
    6. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  3. 2 Essentials of Software Applications for Business
    1. Chapter Scenario
    2. 2.1 Software Basics
    3. 2.2 Files and Folders
    4. 2.3 Communication and Calendar Applications
    5. 2.4 Essentials of Microsoft 365
    6. 2.5 Essentials of Google Workspace
    7. 2.6 Collaboration
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  4. 3 Creating and Working in Documents
    1. Chapter Scenario
    2. 3.1 Navigating Microsoft Word
    3. 3.2 Formatting Document Layout in Microsoft Word
    4. 3.3 Formatting Document Content in Microsoft Word
    5. 3.4 Collaborative Editing and Reviewing in Microsoft Word
    6. 3.5 Document Design
    7. 3.6 Navigating Google Docs
    8. 3.7 Formatting Layout and Content in Google Docs
    9. 3.8 Collaborative Editing and Reviewing in Google Docs
    10. 3.9 Versions and Version History
    11. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  5. 4 Document Preparation
    1. Chapter Scenario
    2. 4.1 Microsoft Word: Advanced Formatting Features
    3. 4.2 Working with Graphics and Text Tools in Microsoft Word
    4. 4.3 Managing Long Documents in Microsoft Word
    5. 4.4 Google Docs: Enhanced Formatting Features
    6. 4.5 Working with Graphics and Text Tools in Google Docs
    7. 4.6 Managing Long Documents in Google Docs
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  6. 5 Advanced Document Preparation
    1. Chapter Scenario
    2. 5.1 Creating Different Document Types in Microsoft Word
    3. 5.2 Mail Merge in Microsoft Word
    4. 5.3 Creating Forms in Microsoft Word
    5. 5.4 Creating Different Document Types in Google Docs
    6. 5.5 Creating Forms in Google Docs
    7. 5.6 Advanced Collaboration in Google Docs
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  7. 6 Preparing Presentations
    1. Chapter Scenario
    2. 6.1 Presentation and Design Essentials
    3. 6.2 Designing a Presentation in Microsoft PowerPoint
    4. 6.3 Formatting Microsoft PowerPoint Slides: Layout and Design Principles
    5. 6.4 Adding Visuals and Features to Microsoft PowerPoint Slides
    6. 6.5 Designing a Presentation in Google Slides
    7. 6.6 Creating Google Slides: Layout and Text
    8. 6.7 Adding Visuals and Features to Google Slides
    9. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  8. 7 Advanced Presentation Skills
    1. Chapter Scenario
    2. 7.1 Effective Presentation Skills
    3. 7.2 Finalizing a Slide Collection
    4. 7.3 Preparing a Microsoft PowerPoint Collection for Presentation
    5. 7.4 Preparing a Google Slides Collection for Presentation
    6. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  9. 8 Content Management Systems and Social Media in Business
    1. Chapter Scenario
    2. 8.1 What Are Content Management Systems?
    3. 8.2 Common Content Management Systems
    4. 8.3 Creating Content with a Content Management System
    5. 8.4 Search Engine Optimization
    6. 8.5 Social Media in Business
    7. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  10. 9 Working with Spreadsheets
    1. Chapter Scenario
    2. 9.1 Microsoft Excel Basics
    3. 9.2 Text and Numbers in Microsoft Excel
    4. 9.3 Calculations and Basic Formulas in Microsoft Excel
    5. 9.4 Formatting and Templates in Microsoft Excel
    6. 9.5 Google Sheets Basics
    7. 9.6 Text and Numbers in Google Sheets
    8. 9.7 Calculations and Basic Formulas in Google Sheets
    9. 9.8 Formatting and Templates in Google Sheets
    10. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  11. 10 Advanced Excel Formulas, Functions, and Techniques
    1. Chapter Scenario
    2. 10.1 Data Tables and Ranges
    3. 10.2 More About Formulas
    4. 10.3 Using Arithmetic, Statistical, and Logical Functions
    5. 10.4 PivotTables
    6. 10.5 Auditing Formulas and Fixing Errors
    7. 10.6 Advanced Formatting Techniques
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  12. 11 Advanced Excel Spreadsheets: Statistical and Data Analysis
    1. Chapter Scenario
    2. 11.1 Understanding Data, Data Validation, and Data Tables
    3. 11.2 Statistical Functions
    4. 11.3 What-If Analysis
    5. 11.4 PivotTables/Charts
    6. 11.5 Data Analysis Charts
    7. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  13. 12 Using Excel in Accounting and Financial Reporting
    1. Chapter Scenario
    2. 12.1 Basic Accounting
    3. 12.2 Financial Functions in Microsoft Excel
    4. 12.3 Integrating Microsoft Excel and Accounting Programs
    5. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  14. 13 Understanding and Using Databases
    1. Chapter Scenario
    2. 13.1 What Is a Database?
    3. 13.2 Microsoft Access: Main Features and Navigation
    4. 13.3 Querying a Database
    5. 13.4 Maintaining Records in a Database
    6. 13.5 Creating Reports in Microsoft Access
    7. 13.6 Creating Forms in Microsoft Access
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  15. 14 Advanced Database Use
    1. Chapter Scenario
    2. 14.1 Advanced Queries in Microsoft Access
    3. 14.2 Multiple Table Forms
    4. 14.3 Customizing Forms
    5. 14.4 Customizing Reports
    6. 14.5 Using Macros
    7. 14.6 Data Analysis and Integration
    8. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
      6. Case Exercises
  16. 15 Integrating Applications
    1. Chapter Scenario
    2. 15.1 Microsoft 365: Collaboration and Integration
    3. 15.2 Microsoft Word: Integration with Microsoft Excel and Microsoft Access
    4. 15.3 Microsoft Word and Microsoft PowerPoint Integration
    5. 15.4 Microsoft Excel and Microsoft PowerPoint Integration
    6. 15.5 Microsoft Excel and Microsoft Access Integration
    7. 15.6 Integrating Data from Other Programs into Google Workspace
    8. 15.7 New Developments: The Role of Artificial Intelligence
    9. 15.8 Mastering Workplace Software Skills: A Project
    10. Chapter Review
      1. Key Terms
      2. Summary
      3. Review Questions
      4. Practice Exercises
      5. Written Questions
  17. Index

Practice Exercises

20 .
Find a dataset from Kaggle that catches your eye. Make sure that the dataset you select is relatively small (<50 MB), and click Download. Open the data file in Excel or a text editor like Notepad. Note the kind of data included in your data file and how it is structured. What kind of data does your file include? How does your file organize individual items of data? What kind of company or organization might this data be useful for?
21 .
Imagine that you are setting up a database to support a company’s human resources function. Explain the benefits of using Access to a leadership team that is considering what software your department will need.
22 .
The foundation of a digital organization is its data platform. Choose a business that provides products or services and consider the organization’s data landscape and what types of databases are likely in use. Use evidence from the company’s website and marketing materials to support your prediction.
23 .

Build a simple database and create a query that joins information. You are currently working with information about the sales and marketing team. You want to keep track of the team members and the regions they work with. Set up a database with the following tables (remember, you would separate this data into at least two tables to make the database more efficient and easy to work with):

Table:TeamMember
TMID
TMFirstName
TMLastName
TMPhone
TMEmail
Table:SalesRegion
SalesRegionName
SalesRegionNotes
Table:SalesRecord
TMID
SalesRegion

Once you have set up the tables, create a query that returns the team member’s first and last names and the sales region they are assigned to. Add any fields you think are necessary to create a list of team members’ names with their region. You may want to try sorting to improve the query output.

24 .
Imagine that you are conducting a human resources analysis. You have a table containing all the names and personal information for a team of employees. You have another table that contains the learning records for all training and certifications that individuals have completed. Both tables have a field called EMPLID, which stores the employee ID. Design a query that returns the EMPLID, employee name, location, and all training or learning activities they have completed. After you design the query, write it in SQL. (Use Microsoft's Access SQL support page for assistance with the code.)
Table: EMPLInfo
EmplID
EmplFirstName
EmplLastName
EmplAddress
EmplCity
EmplState
EmplZip
Table: EMPLLearning
EmplID
TrainingName
TrainingDate
25 .

Importing records is an important function when working with a database like Access. Complete the following steps to create a database from scratch:

  1. Create a blank database using Access and then import the colors.csv file from the LEGO Database found on Kaggle.
  2. Then use your navigation buttons to do the following:
    1. Add a record with the values:
      ID: 2000
      Name: Vivid burgundy
      RGBN: 990033
      is_trans: f
    2. Modify the record to say “dragon-scale burgundy.”
    3. Delete the record.
    4. Undo the change.
26 .
LEGO has decided to stop offering the following colors: Sand Purple, Dark Green, Light Salmon, Metallic Gold, and Lavender. They have tasked you with removing these colors from their database. Using your database with the imported colors.csv file from the LEGO Database on Kaggle, locate and delete all records for the colors listed.
27 .
WorldCorp leadership would like a visually attractive list of all employees that can be used in a publication. They would like the WorldCorp logo to appear on the file and would like to display each employee’s first and last name, alphabetized by last name. Please create a report that meets these criteria using the Human Resources Data Set from the Kaggle website.
28 .

The WorldCorp Human Resources Department has asked you to create reports to support the following inquiries using the Human Resources Data Set from the Kaggle website. Before creating the reports, look at the type of data available and decide what data needs to be included or omitted. Which fields should be considered to answer these inquiries?

  • Which employees have high performance scores? Low performance scores?
  • Which departments are currently the most diverse?
  • How has the company acquired its most diverse employees to date?
  • Is pay equitable across all divisions and positions in the company?
29 .
Imagine that you are the human resources manager for the Northeast WorldCorp region. You have a dataset of employees from the region, and you would like to be able to look through employee records to identify employees who may be unhappy in their position so you can offer support and intervention. Using the Human Resources Data Set from Kaggle, import the data and create a form that will allow you to navigate between employee records to look at employee performance, satisfaction, and other data you think would be useful in determining whom you can assist.
30 .
Using the Human Resources Data Set from Kaggle (or the database you built in Exercise 1), create forms that support the following business functions:

  • Evaluating employee performance (including attendance and lateness)
  • Understanding employee roles (including position, department, location)
  • Reviewing employee hiring information (including recruitment and position)
31 .
The internet runs on forms. Most of the websites you interact with are based on databases using forms for what you see. Look at a website you use frequently and identify which screens are likely forms that show you data from the underlying website database. Using the form you have identified, determine what the table(s) under it likely hold. Draw the table and explain your rationale, including a screen capture of the form you based your work on.
Citation/Attribution

This book may not be used in the training of large language models or otherwise be ingested into large language models or generative AI offerings without OpenStax's permission.

Want to cite, share, or modify this book? This book uses the Creative Commons Attribution License and you must attribute OpenStax.

Attribution information
  • If you are redistributing all or part of this book in a print format, then you must include on every physical page the following attribution:
    Access for free at https://openstax.org/books/workplace-software-skills/pages/1-chapter-scenario
  • If you are redistributing all or part of this book in a digital format, then you must include on every digital page view the following attribution:
    Access for free at https://openstax.org/books/workplace-software-skills/pages/1-chapter-scenario
Citation information

© Jan 3, 2024 OpenStax. Textbook content produced by OpenStax is licensed under a Creative Commons Attribution License . The OpenStax name, OpenStax logo, OpenStax book covers, OpenStax CNX name, and OpenStax CNX logo are not subject to the Creative Commons license and may not be reproduced without the prior and express written consent of Rice University.