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