Databases Ch2 ; 3 review – Flashcards
45 test answers
Unlock all answers in this set
Unlock answers 45question
primary and foreign
answer
A database table can contain these two different types of keys
Unlock the answer
question
one
answer
A table should be about ____ subject(s)
Unlock the answer
question
the primary key field
answer
When a table is opened, it is sorted by
Unlock the answer
question
cannot
answer
A primary key field ___ contain the same value for different records.
Unlock the answer
question
foreign
answer
When a relationship is established between two tables, the primary key in one table is joined to the ___ key in the other table.
Unlock the answer
question
must
answer
Data in a foreign key field ___ match data in the primary key field of the related table.
Unlock the answer
question
primary
answer
In a one-to-many relationship, the table containing the "one" is referred to as the ___ table.
Unlock the answer
question
Drag the common field from the primary table to the related table.
answer
In defining a one-to many relationship between two tables, what is the next step after having placed the two tables in the relationships window?
Unlock the answer
question
the infinity symbol
answer
In the Relationships window, what symbol or character signifies the "many" side of a one-to-many relationship?
Unlock the answer
question
the primary table; the related table
answer
Choosing Cascade Update Related Fields and Cascade Delete Related Records in the Edit Relationships dialog box will cause primary key updates and deletes in ___ to be automatically executed in __.
Unlock the answer
question
Relationships window
answer
Once a relationship has been established between tables, clicking the Relationships button causes the ___ to display.
Unlock the answer
question
expand indicators
answer
The plus symbols (+) in a subdatasheet are referred to as
Unlock the answer
question
query
answer
You can extract specific information from a table or multiple tables by running a(n)
Unlock the answer
question
extract specific data from a table
answer
Queries are used to perform one of the most important database functions, which is to
Unlock the answer
question
save as a .qry file
answer
You can build a query in all the following ways except
Unlock the answer
question
CREATE
answer
Create a query design button in the queries group on the ___ tab.
Unlock the answer
question
add the relevant table(s) or queries to the work area
answer
When creating a new query with the Query Design button, the first thing you will need to do after clicking the button is to
Unlock the answer
question
type the criterion statement
answer
To establish a criterion in the query design grid, click inside the appropriate Criteria row field and then
Unlock the answer
question
Results
answer
In which group on the QUERY TOOLS DESIGN tab will you find the Run button
Unlock the answer
question
asterisk (*)
answer
Which character is used as a wildcard symbol in query design
Unlock the answer
question
quotation marks (" "); pound symbols (#)
answer
When you enter criteria statements in your query design grid, access automatically enters __ around criteria in text fields and ___ around criteria in date fields.
Unlock the answer
question
"S*"
answer
Which of the following criteria statements would return field values beginning with S and ending in anything?
Unlock the answer
question
field values that begin with S through W and end in anything
answer
What would the criteria "[S-W]*" return?
Unlock the answer
question
lowest to highest
answer
When you choose Ascending in the query design grid's Sort row field for a numeric data field,the results will be sorted
Unlock the answer
question
Object type
answer
If you have several queries in your database and would like to see them displayed together in the Navigation pane, click the Navigation pane Menu bar and then click ___ at the drop-down list.
Unlock the answer
question
Or
answer
When a field in a query contains two criteria statements, either of which can be met to return results, this is referred to as a(n)___statement.
Unlock the answer
question
And
answer
Multiple criteria all entered in the same row in the query design grid is considered a(n)___statement.
Unlock the answer
question
calculated
answer
A query field that uses a mathematical equation to determine the contents that display is called a __field.
Unlock the answer
question
forward slash (/)
answer
In creating a calculate field, what symbol do you use for division
Unlock the answer
question
brackets ([])
answer
When creating a calculated field, use __ to surround the fields names
Unlock the answer
question
colon (:)
answer
When creating a calculated field in a query, the field name should be separated form the equation by a(n)
Unlock the answer
question
column heading names
answer
In the results of a query using aggregate functions, Access automatically determines the
Unlock the answer
question
one row to display in the results datasheet for each group
answer
In the Crosstab Query Wizard, the first field you select causes
Unlock the answer
question
three
answer
What is the minimum number of fields needed to create a crosstab query
Unlock the answer
question
it is summarized by aggregate function
answer
What happens to the third field selected in the Crosstab Query Wizard
Unlock the answer
question
one table or query
answer
Crosstab queries must be built from fields contained in
Unlock the answer
question
find duplicates
answer
If you suspect that a client has been entered into your Clients table under two different client numbers, you would use a ___ query to find the problem
Unlock the answer
question
find duplicates
answer
The ____ query is useful in identifying loyal customers in an Orders table.
Unlock the answer
question
find unmatched
answer
Which of the following query types requires two tables?
Unlock the answer
question
records in one table that have no matching record in the other related table.
answer
A find unmatched query finds
Unlock the answer
question
to find customers who have never placed orders
answer
In which of the following situations would you use a find unmatched query.
Unlock the answer
