13.9: Chapter Review - Review Questions
-
- Last updated
- Save as PDF
Review Questions
1 .
Data must be ___________ to be useful for digital transformation.
-
unorganized
-
inaccessible
-
actionable
-
live
2 .
The most common type of database used to power transactional systems is __________.
-
NoSQL
-
RDBMS
-
SQL
-
analytical database
3 .
________ link objects together.
-
Relationships
-
Flat files
-
Joins
-
Queries
4 .
Which database system should be used for testing and experimentation?
-
production database
-
development database
-
transactional database
-
relational database
5 .
Which object in Access stores data for use?
-
report
-
query
-
table
-
form
6 .
When would you use Access instead of Excel?
-
to store data in multiple tables
-
to perform complex numerical analysis
-
to create visualizations
-
to create a pivot table
7 .
How many databases can be open in Access at one time?
-
one
-
two
-
three
-
four
8 .
Queries are used in databases to __________.
-
access and prepare records
-
raise questions in business discussions
-
manage simple datasets
-
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.
-
QBE
-
outer
-
foreign key field
-
inner
10 .
The parts of an Access query include __________.
-
field names and criteria only
-
table names, field names, and other detail
-
table names, field names, and sort order
-
criteria and sort questions only
11 .
When would you navigate through a database using the navigation buttons on the datasheet?
-
when you have many records to look at
-
when you want to see thousands of records at a glance
-
when you do not want to take the time to create a query
-
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?
-
You never add a record manually to a database because this is not a function in Access.
-
You are unlikely to add a record manually but can do so when necessary.
-
You are likely to add records to ensure that the database matches the production database.
-
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?
-
Ctrl+Enter
-
Shift+Enter
-
Ctrl+S
-
There is no shortcut, you have to use the Home tab.
14 .
Why should you use reports when working with a database?
-
because data is confusing
-
because data is ugly
-
because reports are attractive
-
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?
-
detail section
-
in the page header
-
in the footer
-
in the report header
16 .
Reports in Access are best used to summarize what type of information?
-
record detail
-
header code
-
total code
-
summary header
17 .
Which tab may not be available unless you select multiple items in the form?
-
Form Design
-
Format
-
Arrange
-
Create
18 .
What tool provides an efficient way to create a form?
-
Form Wizard
-
Form Code
-
Form Grid
-
Form SQL
19 .
Forms can be created based on __________.
-
reports or other forms
-
tables or queries
-
tables or reports
-
queries or other forms