37)
The part of the Access window that groups the commands for performing related database
tasks on tabs is the ________.
37)
Answer:
Ribbon
Explanation:
38)
The table or tables from which a query gets its data are referred to as the query’s data
________.
38)
Answer:
source
Explanation:
39)
Match the following terms to their meaning.
I. Form view A. a way to view a table’s structure
II. Layout view B. a way to view the records in a form, but not change
the form’s layout or design
III. Design view C. a way to view a table’s contents
IV. Datasheet view D. a way to make changes to a form or to a report while
the object is open
39)
Answer:
B, D, A, C
Explanation:
40)
The ________ box is the small box at the left of a record in Datasheet view which, when
clicked, selects the entire record.
40)
Answer:
record selector
Explanation:
41)
The process of applying design rules and principles to ensure that your database performs
as expected is known as ________.
41)
Answer:
normalization
Explanation:
42)
A database ________ is a preformatted database designed for a specific purpose.
42)
Answer:
template
Explanation:
43)
When creating a form, the Access view that allows changes while the object is open is
________ view.
43)
Answer:
Layout
Explanation:
44)
The small box at the left of a record in Datasheet view which, when clicked, selects the
entire record is the ________ box.
44)
Answer:
record selector
Explanation:
45)
The field in one or more tables used to join tables together is called a(n) ________ field.
45)
Answer:
common
Explanation:
8
46)
Match the following terms to their meaning.
I. First principle of database design A. Microsoft Access 2010, for example
II. Normalization B. eliminate redundant data
III. Relational database C. apply principles to ensure database
performs as expected
IV. Second principle of database design D. employ techniques to ensure accuracy
V. DBMS E. multiple collections of data are related
to one another
46)
Answer:
B, C, E, D, A
Explanation:
47)
Match the following terms to their meaning.
I. Query A. table or tables from which you will select fields for a
query
II. Select query B. walks you step–by–step through a process
III. Data source C. finds the records that match specific criteria in a query
IV. Run D. used to create subsets of data that you can use to answer
specific questions
V. Wizard E. used to ask a question
47)
Answer:
E, D, A, C, B
Explanation:
48)
An Excel spreadsheet can contain several tables; unlike Access, however, no ________ can
be created between these Excel tables.
48)
Answer:
relationship
Explanation:
49)
The part of the Access window that shows the name of the database is the ________.
49)
Answer:
title bar
Explanation:
50)
If a field is shortened after being populated, the danger is that some information might be
“cut off” or ________.
50)
Answer:
truncated
Explanation:
51)
Match the following terms to their meaning.
I. Database A. data that has been organized in a useful manner
II. Information B. collects and organizes data
III. Data C. a preformatted database designed for a specific
purpose
IV. Template D. used to store and work with data
V. Object E. facts about people, events, things, or ideas
51)
Answer:
B, A, E, C, D
Explanation:
52)
When previewing a report, ________ indicate how the report would break across pages if
you print it.
52)
Answer:
dotted lines
Explanation:
9
53)
Match the following terms to their meaning.
I. Destination table A. the file being imported into Access
II. Link B. a connection to data in another file
III. Import C. add new records to an existing table
IV. Append D. the table into which you import or append data
V. Source file E. copy data from one source to another
53)
Answer:
D, B, E, C, A
Explanation:
54)
The Primary Key icon contains a picture of a(n) ________.
54)
Answer:
key
Explanation:
55)
After a query has been designed, to find the records that match the criteria, Access must
________ the query.
55)
Answer:
run
Explanation:
56)
DBMS is an acronym for ________.
56)
Answer:
database management system
Explanation:
57)
The width of columns in tables can be automatically increased or decreased to fit the
contents; this is known as ________.
57)
Answer:
Best Fit
Explanation:
58)
Match the following terms to their meaning.
I. Populate A. control how a field displays and how data can be
entered in the field
II. Field B. filling a database table with data
III. Record C. define the kind of data you can type in a field
IV. Field properties D. all the categories of data pertaining to one person,
place, thing, event, or idea
V. Data types E. column containing a category of data
58)
Answer:
B, E, D, A, C
Explanation:
59)
To fill one or more tables with data is to ________ it.
59)
Answer:
populate
Explanation:
60)
The process of copying data from one source or application to another is ________.
60)
Answer:
importing
Explanation:
TRUE/FALSE. Write ‘T’ if the statement is true and ‘F’ if the statement is false.
61)
Each field in a table can have only one data type.
61)
Answer:
True
False
Explanation:
10
62)
Headers and footers in tables and queries can be edited by the user before printing.
62)
Answer:
True
False
Explanation:
63)
A field contains a single piece of information for each record.
63)
Answer:
True
False
Explanation:
64)
The Design view icon features a pencil, a ruler, and a protractor.
64)
Answer:
True
False
Explanation:
65)
A primary key refers to the field in the table that uniquely identifies a record.
65)
Answer:
True
False
Explanation:
66)
The Text data type can describe numbers not used in calculations.
66)
Answer:
True
False
Explanation:
67)
You can view a table in either Datasheet view or Design view.
67)
Answer:
True
False
Explanation:
68)
When data in a table becomes redundant, it usually means that you need fewer tables.
68)
Answer:
True
False
Explanation:
69)
A select query creates subsets of data to answer specific questions, then displays them in the
query’s datasheet.
69)
Answer:
True
False
Explanation:
70)
Redundancy in databases is a desirable characteristic.
70)
Answer:
True
False
Explanation:
71)
To append data to a table, the table must already be created, and it must be closed.
71)
Answer:
True
False
Explanation:
72)
A database template contains prebuilt tables, queries, and forms to perform a specific task, such as
tracking a large number of events.
72)
Answer:
True
False
Explanation:
73)
When records have no unique value, the AutoNumber data type is a useful way to automatically
create a unique number for each record.
73)
Answer:
True
False
Explanation:
11
74)
Raw, collected data– – to which no structure has been added– – is all that is needed for a database.
74)
Answer:
True
False
Explanation:
75)
You can make permanent changes to a table’s structure in either Datasheet view or Design view.
75)
Answer:
True
False
Explanation:
76)
In Form view, you can view a form’s records but cannot change the layout or design of the form.
76)
Answer:
True
False
Explanation:
77)
In Print Preview, if the Next Page button is dimmed, it means there are no more pages.
77)
Answer:
True
False
Explanation:
78)
A Microsoft Access table is similar in structure to a Microsoft Excel worksheet.
78)
Answer:
True
False
Explanation:
79)
By default, tables are sorted in ascending order by the primary key field.
79)
Answer:
True
False
Explanation:
80)
The default field size for the Text data type is 255.
80)
Answer:
True
False
Explanation:
81)
When you create a table using the Blank Database command, by default Access designates the first
field as the primary key field.
81)
Answer:
True
False
Explanation:
82)
To append data to a table, the table must be open.
82)
Answer:
True
False
Explanation:
83)
The Multiple Items form enables display or entry of multiple records, but with simplified layout.
83)
Answer:
True
False
Explanation:
84)
To conserve space when planning a database, information should be organized by the largest
useful parts possible.
84)
Answer:
True
False
Explanation:
85)
The purpose of a database is to store data so that information can be obtained easily by asking
questions.
85)
Answer:
True
False
Explanation:
12
86)
Field names are listed at the beginning of each row in Datasheet view.
86)
Answer:
True
False
Explanation:
87)
Microsoft Access is NOT a relational database.
87)
Answer:
True
False
Explanation:
88)
The Unique check box is the indicator on the Ribbon in Datasheet view that a field is the primary
key.
88)
Answer:
True
False
Explanation:
89)
Access forms can display only one record at a time.
89)
Answer:
True
False
Explanation:
13