True/False
Indicate whether the sentence or statement is true
or false.
|
|
|
1.
|
A primary
key field contains unique information for each record.
|
|
|
2.
|
The only way
to create an Access table is to use the Table Wizard.
|
|
|
3.
|
It is
possible to import data from other sources such as a spreadsheet to create an Access
table.
|
|
|
4.
|
You add
field descriptions and other field properties in Table Datasheet View.
|
|
|
5.
|
You can
delete a field from a table in Table Design View.
|
|
|
6.
|
As you add
more field property entries, you are generally expanding the amount or type of data that can be
entered into a field.
|
|
|
7.
|
From the
Database window, you can double-click a table object to open it in Datasheet View.
|
|
|
8.
|
You can
change the font and color of a datasheet.
|
|
|
9.
|
You can
print a datasheet.
|
|
|
10.
|
To turn on
(or off) the Formatting (Datasheet) toolbar, use the Toolbars option on the View menu.
|
|
|
11.
|
The records
of a datasheet are automatically sorted in ascending order on the first field.
|
|
|
12.
|
The Find and
Replace dialog box allows you to specify whether the search should be case sensitive.
|
|
|
13.
|
The Find and
Replace dialog box allows you to specify whether Access looks for search criteria in the current
field or in all fields.
|
|
|
14.
|
The question
mark (?) is the wildcard character which stands for any single character in find
criteria.
|
|
|
15.
|
The asterisk
(*) is the wildcard used to represent one and only one character in find criteria.
|
|
|
16.
|
The Sort
Ascending button sorts numbers before letters.
|
|
|
17.
|
When you
perform a "find," all records that match the criteria will appear on the datasheet at the
same time.
|
|
|
18.
|
Queries
evaluate multiple sort fields in a left-to-right order making the leftmost sort field the primary
sort field.
|
|
|
19.
|
You can sort
by more than one field in a datasheet.
|
|
|
20.
|
Filtering
displays all of the records at all times.
|
|
|
21.
|
Once you
have filtered a datasheet to display a subset of records, you can still sort the records, but you
cannot use the find feature.
|
|
|
22.
|
The easiest
way to filter the records for an exact match is to use the Filter By Form feature.
|
|
|
23.
|
To filter
for comparative data and to specify more complex criteria, use the Filter By Selection
feature.
|
|
|
24.
|
Primary key
fields can have a null entry.
|
|
|
25.
|
To add,
delete, or change fields in a query, you use Query Design View.
|
|
|
26.
|
You can
edit, navigate, sort, find, and filter in Query Datasheet View just like you can in Table Datasheet
View.
|
|
|
27.
|
The
resulting datasheet of both a filter and query can be used to enter and edit data.
|
|
|
28.
|
A query is
commonly used as the source of data for a form or report.
|
|
|
29.
|
A filter can
calculate sums, averages, counts, and other types of summary statistics across records.
|
|
|
30.
|
A form or
report can be based on a filter.
|
|
|
31.
|
Filters are
saved as objects in an Access database.
|
|
|
32.
|
The upper
portion of the Query Design View shows field lists.
|
|
|
33.
|
A filter can
be used to create calculated fields.
|
|
|
34.
|
A query can
be used to create calculated fields.
|
Multiple Choice
Identify the
letter of the choice that best completes the statement or answers the question.
|
|
|
35.
|
A zip code
field should be given which data type? a. | Alphanumeric | b. | Text | c. | Numeric | d. | AutoNumber | | |
|
|
|
36.
|
A telephone
field should be given which data type? a. | Number | b. | Currency | c. | Text | d. | AutoNumber | | |
|
|
|
37.
|
The
individual pieces of information stored in individual fields in the database are
called a. | Datasheets | b. | Objects | c. | Raw data | d. | Field types | | |
|
|
|
38.
|
A Memo data
type field will store up to ____ characters.
|
|
|
39.
|
Which data
type stores combinations of text and numbers up to 255 characters? a. | Text | b. | Memo | c. | Number | d. | OLE Object | | |
|
|
|
40.
|
Which data
type stores lengthy text such as comments or notes? a. | Text | b. | Memo | c. | Number | d. | Hyperlink | | |
|
|
|
41.
|
Which data
type stores quantities? a. | Text | b. | AutoNumber | c. | Yes/No | d. | Number | | |
|
|
|
42.
|
Which data
type should be used for a birthdate field? a. | Text | b. | Memo | c. | Date/Time | d. | Lookup Wizard | | |
|
|
|
43.
|
Which data
type should be used for monetary values? a. | Currency | b. | AutoNumber | c. | Number | d. | Money | | |
|
|
|
44.
|
Which data
type is used to sequentially order each record added to a table? a. | Hyperlink | b. | Web | c. | Lookup Wizard | d. | AutoNumber | | |
|
|
|
45.
|
Which data
type stores only one of two values? a. | OLE Object | b. | Hyperlink | c. | Yes/No | d. | Null | | |
|
|
|
46.
|
Which data
type links files created in other programs such as pictures, sound clips, documents, or
spreadsheets? a. | Lookup | b. | OLE Object | c. | Yes/No | d. | Link Wizard | | |
|
|
|
47.
|
Which data
type stores Web addresses? a. | Lookup Wizard | b. | Hyperlink | c. | WWW Address | d. | HTML | | |
|
|
|
48.
|
A
PurchasePrice field should probably be which data type? a. | Text | b. | Number | c. | Monetary | d. | Currency | | |
|
|
|
|
|
|
49.
|
The table in
the figure above, is shown in ____ view. a. | Datasheet | b. | Object | c. | Update | d. | Design | | |
|
|
|
50.
|
Which of the
following field properties is NOT required for each field? a. | Format | b. | Field Name | c. | Data Type | d. | All are required | | |
|
|
|
|
|
|
51.
|
In the
figure above, item 4 points to the ____ button. a. | Find and Replace | b. | Look
In | c. | Sort
Order | d. | Filter By Form | | |
|
|
|
52.
|
In the
figure above, item 6 points to the ____ button. a. | Filter | b. | Remove | c. | Add | d. | Find | | |
|
|
|
53.
|
In the
figure above, clicking the button identified by item 5 will ____. a. | Apply or remove the
current filter | b. | Sort the records in descending order | c. | Filter the records
based on selected data | d. | Filter the records based on more than one selection
criteria | | |
|
|
|
54.
|
In the
figure above, item 1 points to the ____ button. a. | Sort Ascending | b. | Sort
Descending | c. | Find | d. | Find and Replace | | |
|
|
|
55.
|
In the
figure above, item 2 points to the ____ button a. | Filter Ascending | b. | Filter
Descending | c. | Sort Ascending | d. | Sort
Descending | | |
|
|
|
56.
|
In the
figure above, item 3 points to the ____ button a. | Filter and Sort | b. | Filter By
Selection | c. | Filter By Form | d. | Apply
Filter | | |
|
|
|
57.
|
This button
searches for a string of characters in the current field or all fields. a. | Find | b. | Sort Ascending | c. | Filter By
String | d. | Filter By Criteria | | |
|
|
|
58.
|
The wildcard
character that stands for a single number digit is ____. a. | Asterisk
(*) | b. | Question mark
(?). | c. | Double quotation mark
(") | d. | Pound sign (#) | | |
|
|
|
59.
|
The wildcard
character that stands for any group of characters is the ____. a. | Period
(.) | b. | Semicolon
(;) | c. | Asterisk
(*) | d. | Plus sign
(+) | | |
|
|
|
60.
|
The wildcard
character that stands for any single character is the ____. a. | Ampersand
(&) | b. | Question mark (?) | c. | Exclamation mark
(!) | d. | Caret
(^) | | |
|
|
|
61.
|
Which of the
following comparison operators means "greater than"?
|
|
|
62.
|
Which of the
following comparison operators means "less than or equal to"?
|
|
|
63.
|
Which of the
following comparison operators means "not equal to"?
|
|
|
64.
|
To find
numbers greater than or equal to 500, use which comparison operator?
|
|
|
65.
|
To find all
records where there is any entry in the field, even if the entry is 0, use which
criteria? a. | <>0 | b. | Is Not Null | c. | *=* | d. | *<>* | | |
|
|
|
66.
|
A(n) ____ is
a temporary view of the data whose criteria is discarded when you close the
datasheet. a. | Query | b. | Filter | c. | Find | d. | Union | | |
|
|
|
|
|
|
67.
|
In the
figure above, item 3 points to ____. a. | The Title field | b. | A field
list | c. | The Category
field | d. | A criteria entry | | |
|
|
|
68.
|
In the
figure above, item 2 points to the Orders ____. a. | Criteria cells | b. | Datasheet
view | c. | Field
list | d. | Design
grid | | |
|
|
|
69.
|
In the
figure above, item 1 points to the ____ View button. a. | Design | b. | Query | c. | Datasheet | d. | Table | | |
|
Completion
Complete each sentence or
statement.
|
|
|
70.
|
The table
object contains the raw ____________________, the individual pieces of information stored in the
database.
|
|
|
71.
|
The data
____________________ determines what type of information you can enter in a field.
|
|
|
72.
|
A Text data
type field stores up to ____________________ characters.
|
|
|
73.
|
The
____________________ Wizard provides interactive help to create field names and data types for each
field in a new table.
|
|
|
|
|
|
74.
|
In the
figure above, item 2 points to the ____________________ field symbol.
|
|
|
75.
|
In the
figure above, the currently selected field is ____________________.
|
|
|
76.
|
In the
figure above, the data type of the Phone field is ____________________.
|
|
|
77.
|
Field
____________________ are additional characteristics of a field such as its size or default
value.
|
|
|
78.
|
Each
database object has a(n) ____________________ View in which you can modify its
structure.
|
|
|
79.
|
The
____________________ property contains the default label for a field when it is displayed in a
datasheet or on a form.
|
|
|
80.
|
Sorting in a
Z to A, then 9 to 0 order is called a(n) ____________________ order.
|
|
|
81.
|
____________________ refers to locating a specific piece of data within a field or
within the entire datasheet.
|
|
|
82.
|
Filter By
____________________ filters records based on selected data and hides records that do not
match.
|
|
|
83.
|
Sorting
records in a 0 to 9 then A to Z order is a(n) ____________________ order.
|
|
|
84.
|
Filter By
____________________ filters records based on more than one selection criteria by using a special
window.
|
|
|
85.
|
____________________ refers to reorganizing the records in either ascending or
descending order based on the contents of a field.
|
|
|
86.
|
____________________ means temporarily isolating a subset of records.
|
|
|
87.
|
____________________ are symbols you can use as substitutes for characters to find
information that matches your find criteria.
|
|
|
88.
|
The first
sort field is called the ____________________ sort field.
|
|
|
89.
|
The second
sort field is called the ____________________ sort field.
|
|
|
90.
|
____________________ are rules or limiting conditions you set to determine which
records will appear when a filter is applied.
|
|
|
91.
|
Is Not
____________________ will find all records where there is any entry in the field, even if the entry
is 0.
|
|
|
92.
|
Is
____________________ criteria will find all records where no entry has been made in the
field.
|
|
|
93.
|
A(n)
____________________ is a database object that creates a datasheet of specified fields and records
from one or more tables.
|
|
|
94.
|
In Query
Design View, the query design ____________________ shows you the fields that you have requested for
the query.
|
|
|
95.
|
A(n)
____________________ is a temporary view of the data whose criteria are discarded when you remove it
or close the datasheet.
|
|
|
96.
|
The upper
portion of Query Design View shows a table's ____________________ list.
|
|
|
97.
|
Click the
____________________ View button in Query Design View to display the resulting fields and records in
that query.
|
|
|
98.
|
Every object
in the database has a ____________________ View in which you change the structure of the
object.
|
|
|
99.
|
Additional
criteria on the same row of the query grid are considered ____________________
criteria.
|
|
|
100.
|
Criteria
placed on different rows of the query design grid are considered ____________________
criteria.
|
|
|
101.
|
The
____________________ key field is the common field on the "many" side of a one-to-many
relationship.
|