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