14.9: Chapter Review - Review Questions
-
- Last updated
- Save as PDF
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?
-
wildcards
-
simple criteria
-
logical operators
-
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?
-
Action query
-
Update query
-
Crosstab query
-
Delete query
3 .
________ let you carry out calculations on record groups rather than performing individual operations.
-
Append queries
-
Update queries
-
Aggregate queries
-
Delete queries
4 .
What can help build and ensure a relationship between two tables?
-
Dropdown Wizard
-
Lookup Wizard
-
Table Wizard
-
Microsoft Wizard
5 .
What kind of form is inserted into another form (known as the primary form)?
-
query form
-
auto-form
-
subform
-
drop-down form
6 .
The most visually intuitive view to use for form modification is ________.
-
Design View
-
Print View
-
Layout View
-
Form View
7 .
Which feature helps the developer control which section of the form the curser moves to next?
-
Report Wizard
-
tab order
-
property sheet
-
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?
-
Text Box
-
Command
-
Combo Box
-
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?
-
Report Header
-
Page Header
-
Group Header
-
Page Footer
10 .
What is the primary purpose of grouping and sorting in Access reports?
-
to display the report title and general information clearly
-
to organize data into sections such as Report Header and Footer
-
to help users quickly identify patterns and trends in the data
-
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?
-
Design View
-
Layout View
-
Form View
-
Print Preview
12 .
What is a macro in the context of Access?
-
a type of database table used to store user data
-
a graphical representation of a database schema
-
a set of instructions for automating tasks or performing operations
-
a programming language used for creating web applications
13 .
How does recording a macro in Access help enhance database functions?
-
It creates queries with multiple criteria.
-
It enables the building of queries that aggregate.
-
It optimizes the Form Wizard to allow users to build a custom form.
-
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?
-
by providing advanced graphic design tools for creating visually appealing forms
-
by automatically generating complex SQL queries for data analysis
-
by offering integration with external databases and servers
-
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?
-
Importing data always alters the source data.
-
Importing data is not as flexible as copying and pasting.
-
Importing data allows you to modify the structure of linked tables that contain the source data.
-
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?
-
Exporting data from Access to Excel is a manual process that requires copying and pasting.
-
The Export Wizard in Access allows you to import data from Excel to Access databases.
-
Access creates a link between the data in Access and Excel when exporting data.
-
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?
-
strategic dashboard
-
analytical dashboard
-
operational dashboard
-
tactical dashboard