Skip to ContentGo to accessibility pageKeyboard shortcuts menu
OpenStax Logo

Review Questions

1 .
Data must be ___________ to be useful for digital transformation.
  1. unorganized
  2. inaccessible
  3. actionable
  4. live
2 .
The most common type of database used to power transactional systems is __________.
  1. NoSQL
  2. RDBMS
  3. SQL
  4. analytical database
3 .
________ link objects together.
  1. Relationships
  2. Flat files
  3. Joins
  4. Queries
4 .
Which database system should be used for testing and experimentation?
  1. production database
  2. development database
  3. transactional database
  4. relational database
5 .
Which object in Access stores data for use?
  1. report
  2. query
  3. table
  4. form
6 .
When would you use Access instead of Excel?
  1. to store data in multiple tables
  2. to perform complex numerical analysis
  3. to create visualizations
  4. to create a PivotTable
7 .
How many databases can be open in Access at one time?
  1. one
  2. two
  3. three
  4. four
8 .
Queries are used in databases to __________.
  1. access and prepare records
  2. raise questions in business discussions
  3. manage simple datasets
  4. write questions for presentations
9 .
In a(n) ______ join, the common fields and data between the two tables are looked at and only displays the matches.
  1. QBE
  2. outer
  3. foreign key field
  4. inner
10 .
The parts of an Access query include __________.
  1. field names and criteria only
  2. table names, field names, and other detail
  3. table names, field names, and sort order
  4. criteria and sort questions only
11 .
When would you navigate through a database using the navigation buttons on the datasheet?
  1. when you have many records to look at
  2. when you want to see thousands of records at a glance
  3. when you do not want to take the time to create a query
  4. when you are looking at a small set of records (e.g., from a query)
12 .
Which statement best explains the process of manually adding a record to a database?
  1. You never add a record manually to a database because this is not a function in Access.
  2. You are unlikely to add a record manually but can do so when necessary.
  3. You are likely to add records to ensure that the database matches the production database.
  4. You will scan records but will not manually input them to update the production database.
13 .
What is the keyboard shortcut to save a record manually?
  1. Ctrl+Enter
  2. Shift+Enter
  3. Ctrl+S
  4. There is no shortcut, you have to use the Home tab.
14 .
Why should you use reports when working with a database?
  1. because data is confusing
  2. because data is ugly
  3. because reports are attractive
  4. because reports provide data in a more usable form
15 .
If you want an image to show up at the top of each page of the report, where do you put it?
  1. detail section
  2. in the page header
  3. in the footer
  4. in the report header
16 .
Reports in Access are best used to summarize what type of information?
  1. record detail
  2. header code
  3. total code
  4. summary header
17 .
Which tab may not be available unless you select multiple items in the form?
  1. Form Design
  2. Format
  3. Arrange
  4. Create
18 .
What tool provides an efficient way to create a form?
  1. Form Wizard
  2. Form Code
  3. Form Grid
  4. Form SQL
19 .
Forms can be created based on __________.
  1. reports or other forms
  2. tables or queries
  3. tables or reports
  4. queries or other forms

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
  • 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
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.