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
security rules
B
match conditions
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 data
B
best fit
C
best selector
D
best column
3) The ____ lets you create a report that you can use to print standard or custom labels.
A
Label Wizard
B
Report Wizard
C
Form Wizard
D
Design 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
required
B
default
C
size
D
limit
5) A database is a collection of _____.
A
numbers
B
data
C
objects
D
fields
6) When you open a query object, you ___ the query.
A
enage
B
move
C
save
D
run
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
employee numbers
B
social security numbers
C
birthdates
D
student identification numbers
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
text
C
required
D
default
9) When fields appear in a form, they appear in ____.
A
records
B
text boxes
C
datasheets
D
controls
10) A ____ control is not connected to a record source and is used to display information, lines, rectangles, and pictures.
A
bound
B
unbound
C
record
D
form
11) A ____ control is connected to the field in the record source and is used to display, enter, and update data.
A
record
B
form
C
unbound
D
bound
12) A(n) ____ is a database object that lets you ask the database about the data it contains.
A
report
B
table
C
query
D
form
13) A computerized DBMS is ____ than using file folders.
A
more accurate
B
more flexible
C
much faster
D
all of these
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
print preview
B
record
C
form
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
table
B
query
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 required field
B
a numeric value
C
a field size property
D
a default 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
key
C
infinity
D
clasped hands
18) Point to a button in the Controls group to display its name in a ____.
A
status bar
B
dialog box
C
screen tip
D
menu
19) When you change the row height of a datasheet, the change ____.
A
affects all rows visible on the screen
B
affects all the rows in a datasheet
C
affects the single row currently selected
D
affects all the columns in the datasheet
20) A query can contain ____ of the fields in the table.
A
all
B
some
C
one
D
all of these
*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?