Skip to ContentGo to accessibility page
OpenStax Logo
Workplace Software and Skills

Summary

Workplace Software and SkillsSummary

Summary

13.1 What Is a Database?

  • Databases are storage areas for data, small bits of information that are collected all around us. Organizations typically have production systems, which run and store the transactions necessary for the organization itself, and analytical systems, which store historical data that can be analyzed and used for business intelligence.
  • Databases consist of objects, including tables, queries, forms, and reports. These objects can be used for data manipulation and for applications within a business.

13.2 Microsoft Access: Main Features and Navigation

  • Access is a relational database management system that can work with other systems.
  • Access contains typical database objects such as tables, queries, forms, and reports.
  • Closing and saving your work in Access is an important process, as only one database can be open at a time.

13.3 Querying a Database

  • Queries can return data from one or more tables and can sort, limit, or calculate values from tables. SQL is a universal language used for queries; however, it is not necessary in Access.
  • Access queries can be set up using either the Query Wizard or the QBE grid.
  • Joins, representing relationships between fields across tables, can be created, changed, or removed.

13.4 Maintaining Records in a Database

  • Microsoft Access can be used to locate and review records.
  • You will likely add records to a database by importing from other data sources.
  • It is possible to edit or delete records in a database, but these functions are less common.

13.5 Creating Reports in Microsoft Access

  • Reports compile and summarize data in actionable, useful formats that can be used for business decision-making. Reports update with current information each time we open them and can be modified to show only the information most useful to a reader.
  • We can use the Report Wizard to create new reports that we can later customize.
  • Reports can be customized to include images and custom text, like logos.

13.6 Creating Forms in Microsoft Access

  • Forms provide an easy-to-use interface with a database. Most websites use forms for inputting, requesting, and accessing information.
  • Forms can be created and edited using the Form Wizard.
  • Forms can be customized in either Layout View or Design View.
PreviousNext
Order a print copy
Citation/Attribution
Reuse and redistribution of this content in digital or print format:
  • 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 prior written permission.
  • This book uses the Creative Commons Attribution-NonCommercial-ShareAlike License, which means that you can reuse and modify the material only for noncommercial purposes, must attribute OpenStax, and must distribute any derivative works under the same license.
  • Any commercial printing of this textbook, including using a local or custom printer, must be approved by OpenStax, and proper citation provided.
  • OpenStax-copyrighted images, activities, assessments, and similar components of this book are subject to the same licensing – CC-BY-NC-SA. They can be used for noncommercial purposes with attribution. Commercial use requires permission.
  • Permission requests: Anyone who intends to incorporate this content (including text, images, and other components) into large language models, use it in AI offerings, use it commercially (including in print), and/or has questions about another use case is welcome to complete our reuse request form.
Attribution information
  • If you are redistributing all or part of this book in a noncommercial 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 noncommercial digital format, then for every page that includes OpenStax content, you must license the derivative work under the same CC-BY-NC-SA license as the original, and 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

The information below includes the information needed to generate citations in most major styles (APA, MLA, etc.); you must reformat and organize the information as needed to fit the requirements of the style. Use the information below to generate a citation. We recommend using a citation tool such as this one.

© Apr 23, 2026 OpenStax. Textbook content produced by OpenStax is licensed under a Creative Commons Attribution-NonCommercial-ShareAlike License. The OpenStax name, OpenStax logo, OpenStax book covers, OpenStax CNX name, and OpenStax CNX logo, and Rice University name, and Rice University logo trademarks, or wordmarks are not subject to the Creative Commons license and may not be reproduced without the prior and express written consent of Rice University.