Exam
Name___________________________________
MULTIPLE CHOICE. Choose the one alternative that best completes the statement or answers the question.
1)
To locate records in which a field is left blank, what should be used as the criteria for that field?
1)
A)
Is NOT Null
B)
<>Null
C)
=Null
D)
Is Null
Answer:
Explanation:
A)
B)
C)
D)
2)
In Datasheet view, which of the following is NOT true when a one–to–many relationship exists?
2)
A)
Plus signs indicate that the many table has related records.
B)
Data from the many table displays on a subdatasheet.
C)
Plus signs will display in the datasheet of the one table.
D)
No entries can be made in the many table without a related record in the one table.
Answer:
Explanation:
A)
B)
C)
D)
3)
When looking for a date during the week beginning 8/2/2015 and ending 8/8/2015, which of the
following would be the correct criteria?
3)
A)
>8/2/2015 AND <8/8/2015
B)
>8/2/2015<8/8/2015
C)
Between 8/2/2015 and 8/8/2015
D)
Between 8/1/2015 and 8/9/2015
Answer:
Explanation:
A)
B)
C)
D)
4)
Which of the following expressions would correctly add a calculated field named Discount that is
20 percent of the Price field?
4)
A)
Discount: [Price]*0.20
B)
Let Discount=[Price]*0.20
C)
Discount=Price*20%
D)
[Discount]:[Price *20%]
Answer:
Explanation:
A)
B)
C)
D)
1
5)
Regarding the sorting of query results, which of the following is FALSE?
5)
A)
Ascending order would order records from A to Z.
B)
The sort can be applied in either Design or Datasheet view.
C)
Only the sort order specified in Datasheet view is saved with the query design.
D)
If the results are to be used in a report, the sort should be specified in Query Design view.
Answer:
Explanation:
A)
B)
C)
D)
6)
When establishing a relationship, common fields do NOT necessarily need to have
6)
A)
the same field name.
B)
the same data type.
C)
the same field size.
D)
common data.
Answer:
Explanation:
A)
B)
C)
D)
7)
When Baseball is placed on the Criteria row of the Sport field and Football is placed on the OR row
for the same field, the only way to specify scholarship amounts greater than $400 for both sports is
to
7)
A)
enter Between $400 And ? on the OR row in the field for the scholarship amount.
B)
enter >400 on the Criteria row in the field for the scholarship amount.
C)
enter >400 on both the Criteria and OR rows in the field for the scholarship amount.
D)
enter >400 on the OR row in the field for the scholarship amount.
Answer:
Explanation:
A)
B)
C)
D)
8)
When you are searching for a numbered street address on Maple, but aren’t sure whether it’s Maple
Avenue, Maple Street, or Maple Way, which of the following criteria would you use?
8)
A)
???Maple*
B)
Maple
C)
*Maple*
D)
Maple*
Answer:
Explanation:
A)
B)
C)
D)
2
9)
Which of the following is possible if referential integrity is enforced within a one–to–many
relationship?
9)
A)
Appending new records to the many table before adding related records to the one table
B)
Creating a new record in the many table for which there is no related record in the one table
C)
Deleting a record from the many table if there is a related record in the one table
D)
Deleting a record from the one table if there are related records in the many table
Answer:
Explanation:
A)
B)
C)
D)
10)
To create a crosstab query based on two tables, you must
10)
A)
create a select query on which to base the crosstab query.
B)
do nothing; crosstab queries cannot be based on two tables.
C)
create a crosstab relationship in the Relationships window.
D)
select the fields from the Show Table dialog box.
Answer:
Explanation:
A)
B)
C)
D)
11)
The address 123 Main Street would NOT display using the criteria
11)
A)
?? Main St??
B)
??? Main Street
C)
*M*
D)
*Main S*
Answer:
Explanation:
A)
B)
C)
D)
12)
In a query, to sort Z to A by Department (outermost), then A to Z by Lastname (innermost),
12)
A)
Lastname would be to the left of Department in the query design grid.
B)
Department would be to the left of Lastname in the query design grid.
C)
the Totals Row would need to be active.
D)
the order of the fields in the design grid does not matter.
Answer:
Explanation:
A)
B)
C)
D)
3
13)
Which of the following is NOT a true statement regarding a select query?
13)
A)
A select query displays the results in Datasheet view.
B)
A complex select query should be created using the Query Wizard.
C)
A select query displays a subset of records that meet the specified criteria.
D)
A select query retrieves specific data from one or more tables.
Answer:
Explanation:
A)
B)
C)
D)
14)
Sorting a table in descending order by a Last Name field would NOT
14)
A)
sort ONLY the Last Name field, thus mixing up the records.
B)
leave the order of the First Name field unaffected.
C)
result in a downward arrow appearing on the Last Name field
D)
place Young before Smith.
Answer:
Explanation:
A)
B)
C)
D)
15)
If you accidentally place two copies of the same table list in the Relationships window, which is the
correct method for removing the extra table?
15)
A)
Right–click the table, and select Remove Table.
B)
Right–click the table, and select Hide Table.
C)
Click the table, and then on the Design Tab, in the Relationships group, click Remove Table.
D)
Right–click the table, and select Delete Table.
Answer:
Explanation:
A)
B)
C)
D)
16)
Where can you view the security and privacy settings for Access?
16)
A)
Trust Center
B)
Securities Settings dialog box
C)
Properties dialog box
D)
Control Panel
Answer:
Explanation:
A)
B)
C)
D)
4
17)
If you want the records in a table to be sorted by last name and then by first name within each last
name, you would need to
17)
A)
sort Firstname as the innermost field in descending order.
B)
sort Lastname as the outermost field in descending order.
C)
sort Lastname as the innermost field in ascending order.
D)
sort Lastname as the outermost field in ascending order.
Answer:
Explanation:
A)
B)
C)
D)
18)
When searching for “Red” or “Rad” or “Rid” or “Rod”, but NOT “Rodney” or “Reed” or “Ron”, which
of the following criteria should be used?
18)
A)
R*d
B)
R?d
C)
R*
D)
R??
Answer:
Explanation:
A)
B)
C)
D)
19)
Which is the correct expression for calculating 20 percent of the existing field Cost?
19)
A)
20%(Cost)
B)
Cost * 20
C)
[Cost * 20%]
D)
[Cost]*0.20
Answer:
Explanation:
A)
B)
C)
D)
20)
Which is the primary advantage of creating a new query based on an existing query?
20)
A)
An additional subset of records is added to the database, increasing flexibility.
B)
It takes up less disk space to save an existing query with a new name.
C)
It saves time if your new query uses the same fields as the existing query.
D)
Because the new query is based on an existing query, both can share the same primary key.
Answer:
Explanation:
A)
B)
C)
D)
21)
Which of the following would NOT be displayed for a criteria of R*d?
21)
A)
Ramrod
B)
Ready
C)
Read
D)
Red
Answer:
Explanation:
A)
B)
C)
D)
5
22)
To find a contribution amount of $300 or greater, the entry in the Amount field’s criteria should be
22)
A)
>300.
B)
>=300.
C)
300.
D)
>=$300.
Answer:
Explanation:
A)
B)
C)
D)
23)
Which of the following is NOT true regarding security alerts?
23)
A)
They can be resolved by users on a one–time basis in most situations.
B)
They warn when potentially dangerous active content exists.
C)
They display on the Message Bar below the Ribbon.
D)
They can be resolved permanently by most college users in the Trust Center.
Answer:
Explanation:
A)
B)
C)
D)
24)
Which of the following is NOT a function that can be used with the Totals button?
24)
A)
SUM
B)
LOWEST
C)
MAX
D)
AVG
Answer:
Explanation:
A)
B)
C)
D)
SHORT ANSWER. Write the word or phrase that best completes each statement or answers the question.
25)
An association established between two tables based on common fields is called a(n)
________.
25)
Answer:
relationship
Explanation:
26)
The most common relationship type in Access is the ________ relationship.
26)
Answer:
one–to–many
Explanation:
27)
When all the fields, criteria, and sort orders have been set in the design grid, for the results
to be shown, you must ________ the query.
27)
Answer:
run
Explanation:
28)
To create a query based on two tables, the two tables must share a common, or key,
________.
28)
Answer:
field
Explanation:
6
29)
Match the following terms to their meaning:
I. Table area A. a database object that retrieves specific data from
one or more tables
II. Design grid B. displays the design of the query
III. Run C. table or tables from which a query selects its data
IV. Data source D. displays the subset of records with the selected criteria
V. Select query E. displays the field lists for tables that are used in a query
29)
Answer:
E, B, D, C, A
Explanation:
30)
In a query, conditions that identify the specific records you are looking for are called
________.
30)
Answer:
criteria
Explanation:
31)
To select records in which the Reply Date field is not empty, use ________ as the criteria for
the Reply Date.
31)
Answer:
Is Not Null
Explanation:
32)
When you enter a text string as a query criteria, Access will add ________ around the entry.
32)
Answer:
quotes, quotation marks
Explanation:
33)
The ________ is the field in the related table used to connect to the primary key in another
table.
33)
Answer:
foreign key
Explanation:
34)
When a relationship exists between tables, the relationship is represented in the
Relationships window by a(n) ________.
34)
Answer:
join line
Explanation:
35)
Match the following aggregate function to what it does:
I. SUM A. provides the number of records in a field
II. LAST B. averages the values in a field
III. COUNT C. totals the values in a field
IV. MIN D. displays the final value in a field
V. AVG E. locates the smallest value in a field
35)
Answer:
C, D, A, E, B
Explanation:
36)
Match the following terms to their meaning:
I. Referential integrity A. looks for values within a range
II. Text string B. SUM, AVG, MIN, and MAX are examples
III. Property Sheet C. sequence of characters used as criteria in a query
IV. Between . . . And D. ensures that data in a related table is valid
V. Aggregate function E. used to customize fields in a query
36)
Answer:
D, C, E, A, B
Explanation:
7