Review Game Zone
Flash Cards
(current)
Games
Teachers
Search
Access Review MC
Test Description: Access Review MC questions
Instructions: Answer all questions to get your test result.
1) When you create relationships, Access uses this rule to ensure there are matching values in the common field.
A
match conditions
B
security rules
C
field rules
D
referential integrity
2) When re-sizing a column, selecting ____ automatically re-sizes the column to the best width for the data contained in the column.
A
best column
B
best selector
C
best data
D
best fit
3) The ____ lets you create a report that you can use to print standard or custom labels.
A
Label Wizard
B
Form Wizard
C
Design Wizard
D
Report Wizard
4) If you were applying for a loan online, and you entered your social security number with only 8 digits instead of 9, you would receive an error message. This is because the field ____ property was set for 9 characters.
A
limit
B
size
C
default
D
required
5) A database is a collection of _____.
A
data
B
fields
C
numbers
D
objects
6) When you open a query object, you ___ the query.
A
run
B
save
C
enage
D
move
7) A primary key should be unique for every record. All of these values are good candidates to use as a table's primary key field EXCEPT
A
social security numbers
B
student identification numbers
C
employee numbers
D
birthdates
8) If you are entering data for customers and all of your customers live in Texas, you may want to enter Texas as the ____ value property to the state field. *
A
format
B
required
C
text
D
default
9) When fields appear in a form, they appear in ____.
A
datasheets
B
controls
C
text boxes
D
records
10) A ____ control is not connected to a record source and is used to display information, lines, rectangles, and pictures.
A
form
B
unbound
C
bound
D
record
11) A ____ control is connected to the field in the record source and is used to display, enter, and update data.
A
bound
B
record
C
unbound
D
form
12) A(n) ____ is a database object that lets you ask the database about the data it contains.
A
query
B
table
C
form
D
report
13) A computerized DBMS is ____ than using file folders.
A
much faster
B
more flexible
C
all of these
D
more accurate
14) When a form is displayed in ____ view, you will see each record in the record source, one at a time, in the form.
A
form
B
print preview
C
record
D
design
15) A ____ is a database object that displays data from one or more tables or queries in a format that has a similar appearance to a paper form.
A
query
B
table
C
report
D
form
16) If you were applying for a loan online and forgot to enter your address, you would receive an error message you must enter a value. The address field property was probably set as
A
a default value
B
a field size property
C
a required field
D
a numeric value
17) If a row selector for an ID field has a(n) ____ symbol in it, it indicates that the field is the table's primary key.
A
lock
B
infinity
C
key
D
clasped hands
18) Point to a button in the Controls group to display its name in a ____.
A
menu
B
screen tip
C
dialog box
D
status bar
19) When you change the row height of a datasheet, the change ____.
A
affects all the columns in the datasheet
B
affects the single row currently selected
C
affects all the rows in a datasheet
D
affects all rows visible on the screen
20) A query can contain ____ of the fields in the table.
A
one
B
all of these
C
all
D
some
*select an answer for all questions
Check Results & Get Answers
Play Games with the Questions Above
Teachers: Create FREE classroom games with your questions
Click for more info!
©2007-2024
ReviewGameZone.com
|
About
|
Privacy
|
Contact
|
Terms
|
Site Map
WAIT! Find what you needed?
×
Still Looking for the Answers?
Have Another Question?
Play a Review Game with These Questions?
Want to Make Your Own Test Like This One?