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

Review Questions

Workplace Software and SkillsReview Questions

Review Questions

1 .
You need to review a database and identify orders placed by a specific customer for more than $50. What type of criteria should you use for this Access query?
  1. wildcards
  2. simple criteria
  3. logical operators
  4. null criteria
2 .
What kind of action query would you use to make global changes to a group of records in a table that needs updating?
  1. Action query
  2. Update query
  3. Crosstab query
  4. Delete query
3 .
________ let you carry out calculations on record groups rather than performing individual operations.
  1. Append queries
  2. Update queries
  3. Aggregate queries
  4. Delete queries
4 .
What can help build and ensure a relationship between two tables?
  1. Dropdown Wizard
  2. Lookup Wizard
  3. Table Wizard
  4. Microsoft Wizard
5 .
What kind of form is inserted into another form (known as the primary form)?
  1. query form
  2. auto-form
  3. subform
  4. drop-down form
6 .
The most visually intuitive view to use for form modification is ________.
  1. Design View
  2. Print View
  3. Layout View
  4. Form View
7 .
Which feature helps the developer control which section of the form the curser moves to next?
  1. Report Wizard
  2. tab order
  3. property sheet
  4. Field list
8 .
Some customers may find that predefined options on a form do not meet their needs. Which control provides customers with the option of entering a new value on a form?
  1. Text Box
  2. Command
  3. Combo Box
  4. Tab order
9 .
Which section of a report do you use for information that might normally appear on a cover page, such as a logo, title, or date?
  1. Report Header
  2. Page Header
  3. Group Header
  4. Page Footer
10 .
What is the primary purpose of grouping and sorting in Access reports?
  1. to display the report title and general information clearly
  2. to organize data into sections such as Report Header and Footer
  3. to help users quickly identify patterns and trends in the data
  4. to format the report with different font styles and colors
11 .
In Access, which view should you use to review a report and see how it will look when you run it?
  1. Design View
  2. Layout View
  3. Form View
  4. Print Preview
12 .
What is a macro in the context of Access?
  1. a type of database table used to store user data
  2. a graphical representation of a database schema
  3. a set of instructions for automating tasks or performing operations
  4. a programming language used for creating web applications
13 .
How does recording a macro in Access help enhance database functions?
  1. It creates queries with multiple criteria.
  2. It enables the building of queries that aggregate.
  3. It optimizes the Form Wizard to allow users to build a custom form.
  4. It creates a system to accomplish similar operations easily and efficiently.
14 .
How can Visual Basic for Applications (VBA) enhance the capabilities of Access for developers?
  1. by providing advanced graphic design tools for creating visually appealing forms
  2. by automatically generating complex SQL queries for data analysis
  3. by offering integration with external databases and servers
  4. by allowing developers to automate tasks, create custom interfaces, analyze data, integrate with other applications, and generate custom reports
15 .
When you import data into Access from an external source, what happens to the source data?
  1. Importing data always alters the source data.
  2. Importing data is not as flexible as copying and pasting.
  3. Importing data allows you to modify the structure of linked tables that contain the source data.
  4. Importing data creates a copy of the data in the destination database without altering the source data.
16 .
When you export data from Access to Excel, what does the Export Wizard do?
  1. Exporting data from Access to Excel is a manual process that requires copying and pasting.
  2. The Export Wizard in Access allows you to import data from Excel to Access databases.
  3. Access creates a link between the data in Access and Excel when exporting data.
  4. The Export Wizard allows you to save the export routine for future use and automate the export operation.
17 .
Which type of dashboard is focused on tracking short-term operational processes and metrics?
  1. strategic dashboard
  2. analytical dashboard
  3. operational dashboard
  4. tactical dashboard
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.