AL1 C3 C4 Flashcards
Which of the following is not one of the methods of inserting a field in the query design grid?
opening the table or query in Design view and then double-clicking the desired field
Create a query by clicking the Query Design button in the Queries group on the _____ tab.
Create
In the results of a query using aggregate functions, Access automatically determines the
column heading names
At the first Simple Query Wizard dialog box, the first piece of information you are asked to specify is
the table(s) containing the data to be extracted
Double-clicking a query in the Navigation pane will do which of the following?
Open the query in Datasheet view
Specific information can be extracted from a table by running a(n)
query
A field in a query that contains two criteria statements, either of which can be met to return results, is called a(n) _____ statement.
Or
Which of the following criteria statements will return field values beginning with S and ending in anything?
“S*”
At the third (and last) Simple Query Wizard dialog box, you type a name for the query and then are given options to _____ or _____ the query.
open; modify
If you suspect that a client has mistakenly been entered into your clients table under two different client numbers, you would use a _____ query to find the problem.
find duplicates
To display the aggregate function list in the query design grid, click the _____ button in the _____ group.
Totals; Show/Hide
Which of the following query types requires two tables?
find unmatched
In creating a calculated field, what symbol do you use for division?
forward slash (/)
When you enter criteria statements in your query design grid, Access automatically enters _____ around criteria in text fields and _____ around criteria in date fields.
quotation marks (“ “); pound symbols (#)
In which query design grid row field do you type the equation for a calculated field?
Field
A query field that uses a mathematical equation to determine the contents that display is called a _____ field.
calculated
Queries are used to perform one of the most important database functions, which is to
extract specific data from a table
Which of the following is not one of the options in the drop-down list in the Sort row field in the query design grid?
Alphabetically
In the Crosstab Query Wizard, the first field selected causes
one row to display in the query results datasheet for each group
When modifying a table in Design view, which of the following elements displays in the lower half of the work area rather than the top?
Field Properties
The Access spelling check will not find which of the following kinds of errors?
grammatical errors
Return to Datasheet view from Design view by clicking the View button in the Views group on the _____ tab.
Table Tools Design
When you delete a field, it
cannot be undone with the Undo button
Where is the Spelling button?
in the Records group on the Home tab
To get information about a function using the Tell Me feature, click in the Tell Me text box on the ribbon to the right of the _____ tab and then type the function.
View
Use the keyboard shortcut _____ to display the Find and Replace dialog box with the Find tab selected.
Ctrl + F
When you create a new table in Design view, Access automatically assigns the first field the name _____ and assigns the _____ data type.
ID; AutoNumber
When you click the Ascending button in the Sort & Filter group on the Home tab, data in the active field is sorted as follows:
Text is sorted alphabetically from A to Z, numbers are sorted from lowest to highest, and dates are sorted from earliest to latest
To print specific records in a table, begin by
selecting the records
To move a field in Design view, begin by
clicking the field selector bar at the left side of the row you want to move
Which of the following is not one of the three elements specified for each field in Design view?
sort order
When you delete a field in a table, what happens to the data stored in that field?
It is deleted and cannot be restored
To format text in a specific field, choose the Long Text data type and specify _____ formatting.
rich text
When creating a table, you can switch from Datasheet view to Design view by
clicking the View button
Use the _____ data type to store URLs.
Hyperlink
This data type accepts alphanumeric data up to 65,535 characters in length.
long text
When applying formatting in Datasheet view, the buttons in the Text Formatting group (Bold, Italic, Underline, etc.) apply formatting to
all the data in the table
What does the word query mean?
question
The Run button is in the _____ group on the Query Tools Design tab.
Results
If the results of the calculation should display as currency, apply numeric formatting and define the number of digits past the decimal point using the _____ task pane.
Property Sheet
Clicking the Query Design button opens a query window in the work area and also displays the Show Table dialog box, where you
click the name(s) of the table(s) to be included in the query
What is the minimum number of fields needed to create a crosstab query?
three
Multiple criteria all entered in the same row in the query design grid become a(n) _____ statement.
And
A find unmatched query finds which of the following?
records in one table that do not have matching records in the other related table
How do you start the Lookup Wizard?
Click in the field in the Data Type column, click the option box arrow, and then click Lookup Wizard at the drop-down list
By default, the Long Text data type uses _____ formatting.
plain text
Monetary data should be stored in a field with the _____ data type.
Currency
To apply formatting to data in Datasheet view, use options in the Text Formatting group on the _____ tab.
Home
When creating a calculated field, use _____ to surround the field names.
brackets
In which of the following situations would you use a find unmatched query?
to find customers who have never placed orders
A crosstab query must be built from fields in
one table
A query _____ be designed that combines And and Or statements.
can
The _____ query is useful for identifying loyal customers in an orders table.
find duplicates
A _____ query calculates aggregate functions in which field values are grouped by two fields.
crosstab
When extracting records for a query using the yes/no checkboxes, you must type a _____ for true records containing a checkmark and a _____ for false records that do not contain a checkmark.
1; 0
To add a criterion in the query design grid, click in the field in the Criteria row in the column containing the field name and then
type the criterion statement
To store values that will be only True or False, use the _____ data type.
Yes/No
Use the keyboard shortcut Ctrl + H to do which of the following?
Display the Find and Replace dialog box with the Replace tab selected
What function is inserted by default when you add a Total row to a table?
count
When designing a table in Design view, the text you enter in the Description field will display _____ when the field is active.
in the Status bar
What happens when data is entered that does not satisfy the conditional test established in the Validation Rule property box?
Access rejects the entry and displays an error message
You asked to enter values for the lookup field at the _____ Lookup Wizard dialog box.
second
After completing a table design, save it by clicking the Save button on the
Quick Access Toolbar
To limit the data entered into a field to a specific list of items, use the
Lookup Wizard
What appears on the Run button on the Query Tools Design tab?
exclamation point (!)
To list multiple queries together in the Navigation pane, click the option box arrow in the Navigation pane menu bar and then click _____ at the drop-down list.
Object Type
At the second Simple Query Wizard dialog box, you are asked whether you would like to create a detail or a(n) _____ query.
summary
When typing a description, consider identifying the field’s purpose or contents or
providing instructional information for data entry
What are you asked to indicate at the first Lookup Wizard dialog box?
how the lookup column will get its values
In what order should the fields in the query design grid appear?
in the order in which you want them to display in the query results datasheet
Default values are assigned in the _____ section of Design view.
Field Properties
When a default value is set for a field in a table that already contains data, what happens to the existing entries?
Nothing happens to them
At the first Input Mask Wizard dialog box, you are asked to
choose which input mask the data should look like
Use the _____ property box to enter a statement containing a conditional test that is checked each time data is entered into a field.
Validation Rule
How can you customize the error message that Access displays when a validation rule is violated?
Type the message in the Validation Text property box
Which of the following is not an example of an aggregate function?
Group By
The _____ is used as a wildcard character in query design.
asterisk (*)
To provide a larger area for typing criterion in a query, press _____ to display the Zoom box.
Shift + F2
Which data type should be used to store social security numbers?
Short Text
When creating a calculated field in a query, the field name should be separated from the equation by which of the following?
a colon
What will the criteria “[S-W]*” return?
field values that begin with S through W and end in anything
Which of the following is not one of the steps in creating a find unmatched query?
Click Find Run Unmatched Query
How do you start the Input Mask Wizard?
Click the Build button at the right side of the Input Mask property box
To use the Access Help feature, click the Help button in the Help group on the Help tab or press the _____ key.
F1
To add a Total row to a table in Datasheet view, click the Totals button in the _____ group on the _____ tab.
Records; Home
In the query design grid, selecting the Group By option in the Total field drop-down list does which of the following?
groups the records for statistical calculations
Which of the following is not one of the three basic steps in designing a query?
Sort the data that will be extracted
To start the Simple Query Wizard, begin by clicking the Query Wizard button in the Queries group on the _____ tab.
Create
Which of the following is not one of the options available at the Match drop-down list at the Find and Replace dialog box?
End of Field
When data has been entered at the Find and Replace dialog box, Access will search in _____ by default.
the column where the insertion point is positioned
When you choose Ascending in the query design grid’s Sort row field for a numeric data field, how will the results be sorted?
from lowest to highest
What does the Center button in the Text Formatting group do?
centers all text in the active column
Use the Delete Rows button when deleting a field in _____ view.
Design
An input mask is a _____ that controls how data is entered in the field.
set pattern
When moving a field in Design view by dragging with the mouse pointer, a _____ will be attached to the pointer and a(n) _____ will display in the new position.
gray square; thick black line
The third field selected in the Crosstab Query Wizard
is summarized by an aggregate function
You can build a query in all the following ways except
by saving it as a .qry file
