Microsoft Access
This quiz is designed to ensure students are familiar with the terminology associated with the�Microsoft Access Database application.
- 1.
Which of he following is NOT a part of a database?
- A.
Tables
- B.
Records
- C.
Fields
- D.
Worksheets
Correct Answer
D. Worksheets -
- 2.
In a database, each _________________ contains a collection of related data.
- A.
Table
- B.
Record
- C.
Field
- D.
None of the above
Correct Answer
A. Table -
- 3.
In a database, a _____________ is a unit of information about one individual or item.
- A.
Table
- B.
Record
- C.
Field
- D.
File
Correct Answer
C. Field -
- 4.
The use of a password can help preserve a database's _____________.
- A.
Privacy
- B.
Security
- C.
Accurace
- D.
Integrity
Correct Answer
B. Security -
- 5.
Which of the following is a way to sort data?
- A.
Chronologically
- B.
Alphabetically
- C.
Numerically
- D.
All of the above
- E.
None of the above
Correct Answer
D. All of the above -
- 6.
If you sort data in order of decreasing value such as Z-A, or 10-1, what type of sort are you using?
- A.
Ascending
- B.
Descending
- C.
Incremental
- D.
Exponential
Correct Answer
B. Descending -
- 7.
What is a query?
- A.
A question you ask a database
- B.
A question you ask a record
- C.
A question you ask a table
- D.
A question you ask a field
Correct Answer
A. A question you ask a database -
- 8.
Once tables are created and defined, Access will automatically save data as you type without clicking save.
- A.
True
- B.
False
Correct Answer
A. True -
- 9.
What does a filter do?
- A.
Make more records available
- B.
Hide records from view
- C.
Slow down processing
- D.
Add to the quantity of data
Correct Answer
B. Hide records from view -
- 10.
If you want to view some but not all information in a table so you can insert data in a certain field for multiple records which feature would you most likely use?
- A.
Find & Replace
- B.
Filter
- C.
Sort
- D.
Freeze Panes
Correct Answer
D. Freeze Panes -
- 11.
A database is an organized collection of information.
- A.
True
- B.
False
Correct Answer
A. True -
- 12.
Databases typically store all of the data you entered into one combined table.
- A.
True
- B.
False
Correct Answer
B. False -
- 13.
A field's data type determines what kind of information can be stored there.
- A.
True
- B.
False
Correct Answer
A. True -
- 14.
A computerized database can store millions of telephone numbers.
- A.
True
- B.
False
Correct Answer
A. True -
- 15.
One disadvantage of computerized databases is that they limit your ability to arrange information.
- A.
True
- B.
False
Correct Answer
B. False -
- 16.
A database is a collection of related information, but a database management system is a type of software program.
- A.
True
- B.
False
Correct Answer
A. True -
- 17.
A property rental database acts as an index to let users find and view all properties leased by landlords.
- A.
True
- B.
False
Correct Answer
A. True -
- 18.
A query lets you speed up the prowsing process by finding information that matches specifically to your criteria.
- A.
True
- B.
False
Correct Answer
A. True -
- 19.
The same features that make databases efficient tools also enables them to keep data secure.
- A.
True
- B.
False
Correct Answer
B. False -
- 20.
If you sort a database's information chronologically, then you are sorting letters and symbols.
- A.
True
- B.
False
Correct Answer
B. False -
Quiz Review Timeline +
Our quizzes are rigorously reviewed, monitored and continuously updated by our expert board to maintain accuracy, relevance, and timeliness.
-
Current Version
-
Mar 04, 2019Quiz Edited by
ProProfs Editorial Team -
Jun 09, 2015Quiz Created by
Back to top