Access 2016 Quiz 1) What view normally appears when you double-click a table? (1
ID: 3738584 • Letter: A
Question
Access 2016 Quiz
1)
What view normally appears when you double-click a table? (1 point)
a.Datasheet view
b.Form view
c.Design view
d.Layout view
2)
What type of filter displays records based on a criterion you choose? (1 point)
a.Exact Match filter
b.Selection filter
c.Toggle filter
d.Filter by Report
3)
Which of the following is not a valid criteria in a filter? (1 point)
a. Is Null
b. =>14
c. ="Fred"
d. <>125
4)
To view or modify a table's structure you would go to what view? (1 point)
a. Design
b. Form
c. Layout
d. Datasheet
5)
How many records do most forms display? (1 point)
a. All the records at the same time
b. 0 (Forms don't display records)
c. 1
d. 2
6)
To move a field you ________. (1 point)
a. right-click the column heading and select Move Column
b. left-click the column heading, then drag the field to where you want it
c. do nothing. You can't move a field
d. right-click the column heading, then drag the field to where you want it
7)
Most users enter information into a database through the use of a ________. (1 point)
a. macro
b. form
c. table in datasheet view
d. query
8)
Which method of creating a database demands the least amount of expertise in Access? (1 point)
a. Importing an Excel spreadsheet
b. Using a template
c. Creating a blank desktop database
d. Creating a custom web app
9)
If you want fewer records to display, you should use which operator in your filter? (1 point)
a. AND
b. OR
c. NOR
d. NOT
10)
What are the two ways you can view a table? (1 point)
a. Datasheet and Form views
b. Design and Datasheet views
c. Design and Layout views
d. Datasheet and Layout views
Explanation / Answer
Access 2016 Quiz
1) What view normally appears when you double-click a table?
Answer : a.Datasheet view
2) What type of filter displays records based on a criterion you choose?
Answer :b.Selection filter
3) Which of the following is not a valid criteria in a filter?
Answer : b. =>14
4) To view or modify a table's structure you would go to what view?
Answer : a. Design
5) How many records do most forms display?
Answer : c. 1
6) To move a field you ________
Answer : b. left-click the column heading, then drag the field to where you want it
7) Most users enter information into a database through the use of a ________.
Answer :b. form
8) Which method of creating a database demands the least amount of expertise in Access?
Answer :b. Using a template
9) If you want fewer records to display, you should use which operator in your filter?
Answer :a. AND
10) What are the two ways you can view a table?
Answer : b. Design and Datasheet views