NEW
Font size
WorksheetsAccess Chapter 3 Computer Applications MC
Total questions: 25
Worksheet time: 13mins
__________ is the Access object designed to extract data from one or more tables.
Datasheet
Report
Form
Query
_________ is the dialog box used to add tables to a query.
query table
edit
show table
add table
The __________ command instructs Access to carry out the instructions and display the results of a query.
run
go
start
begin
Adding the ___________ type of statement to the query design grid will cause Access to display only certain records.
comment
criterion
description
objective
Multiple criteria entered in the same Criteria row becomes a __________ statement.
AND
OR
ELSE
SUM
Multiple criteria entered in different criteria rows becomes a ___________ type of statement.
AND
OR
ELSE
SUM
_________ is the character between the text and the mathematical expression for the values.
plus sign
minus
colon
asterisk
Use the ____________ to be guided through a series of dialog boxes to generate a form.
form button
form wizard
form generator
form box
The Add Existing Fields button is located in the __________ group on the Form Layout Tools Design tab.
views
tools
themes
controls
Use the _____________ key to select multiple control objects in a form or report.
F1
Alt
Shift
Ctrl
Use the __________ object when you want to specify which fields to print.
table
form
query
report
____________ is the default orientation.
portrait
landscape
full
autofit
What is the name of the field place holder where data is entered or edited in a form.
text box control
label control object
caption
control property
Placing multiple criterion statements on the same row in your query design grid means that ________.
Each criterion statement must be satisfied
Any one of the criteria statements must be satisfied
None of the criterion statements must be satisfied
An error will occur
You can add fields from another table to a form using the ________ task pane in Layout View.
Insert field
Form design
Field List
Navigation
You cannot add or edit data while viewing the __________ feature in Access.
table
query
form
report
The Run button in the Results Group on the Query Tools Design tab displays which of the following symbols?
Exclamation point
Question mark
Asterisk
Ampersand
Use the __________ view to make changes to a form.
form
layout
design
datasheet
A black join line with the number one at each end indicates which type of relationship between two tables?
one-to-many
one-to-one
singular
locked
What type of statement is often used to create mailing labels?
Neither AND or OR
AND
AND or OR
OR
What is the name of the field place holder where data is entered or edited in a form?
text box control
label control object
caption
control property
__________ is the term for the lower half of the query design window.
Design grid
Subdata sheet
Sub form
Sandbox
How are a report and a form similar?
They are comprised of a series of objects referred to as cobwebs.
They contain the same fields
They can be found in layout view
They can be modified the same way
You are using a query with a criterion statement to return records with a specific date value. The date portion of the criterion statement is enclosed in _____________.
question marks
exclamation points
pound symbols
slashes
In mathematical calculation, field names in the mathematical expression are ________.
Separated by a comma
Encased in parenthesis
Followed by a colon
Encased in square brackets
