Database Concepts 4
Tests concepts of database and knowledge of MS Access
- 1.
Mary has created a database which has two tables, a categories table and a products table. For a particular category there can be many products. She wants to find out for which category there are no products. Which type of query should she use?
- A.
Simple Query Wizard
- B.
Crosstab Query Wizard
- C.
Finding Duplicates Query Wizard
- D.
Finding Unmatched Query Wizard
Correct Answer
D. Finding Unmatched Query Wizard -
- 2.
A field that is a primary key in another table is called a ____________________
- A.
Special key
- B.
Foreign key
- C.
Simple key
- D.
Composite key
Correct Answer
B. Foreign key -
- 3.
Which of the following is not a function of a form?
- A.
Allows you to change the data type of a field
- B.
Browse the contents of a table
- C.
Enter data in a table
- D.
Modify data in a table
- E.
Delete data from a table
Correct Answer
A. Allows you to change the data type of a field -
- 4.
_______________ controls on a form are not linked to the fields in a table.
- A.
Bound
- B.
Unbound
- C.
Boundary
- D.
Calulated
Correct Answer
B. Unbound -
- 5.
_________________ controls are linked to a field in a table.
- A.
Bound
- B.
Unbound
- C.
Boundary
- D.
Calulated
Correct Answer
A. Bound -
- 6.
_________________ controls are used to display a calulated value based on one or more fields in a table.
- A.
Bound
- B.
Unbound
- C.
Boundary
- D.
Calulated
Correct Answer
D. Calulated -
- 7.
John Smith sells computer parts. He maintains a database of inventory items with their respective names and prices. A customer wants to know the most expensive sound speakers in Smith's store. Which query wizard can John Smith run to answer the customer's query?
- A.
Simple Query Wizard
- B.
Crosstab Query Wizard
- C.
Finding Duplicates Query Wizard
- D.
Finding Unmatched Query Wizard
Correct Answer
A. Simple Query Wizard -
- 8.
Ronald Billing wants to search for duplicate records in a table or query of a Microsoft Access database. Which of the following wizards will Ronald use to perform this operation?
- A.
Simple Query Wizard
- B.
Crosstab Query Wizard
- C.
Finding Duplicates Query Wizard
- D.
Finding Unmatched Query Wizard
Correct Answer
C. Finding Duplicates Query Wizard -
- 9.
Which of the following measuring unit is used to measure the font size in the forms of Access database?
- A.
Points
- B.
Picas
- C.
Pixels
- D.
Meters
Correct Answer
A. Points -
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 18, 2022Quiz Edited by
ProProfs Editorial Team -
Jun 21, 2008Quiz Created by
Kumar_niten
Back to top