Q. Which of the following are common ways to enforce data validation when entering data into an Access form?
✅ Correct Answer: (C)
A and B
Basics of Database Management System MCQs and Notes
Q. Pivot Table reports are good for
✅ Correct Answer: (A)
Analyzing large amounts of data
Q. What did the first Table Analyzer do?
✅ Correct Answer: (A)
Analyze the data in a set of flat files and automatically create a relational database system from that information
Q. Which field allow to select items from drop down list?
✅ Correct Answer: (C)
A lookup Field
Q. What is a Grouped Report?
✅ Correct Answer: (C)
A report that displays data grouped by fields you specify
Q. What’s the best Access object for an invoice you’ll mail to customers?
✅ Correct Answer: (A)
A report
Q. The largest unit of a database is
✅ Correct Answer: (B)
A field
Q. What is the primary difference between a pivot table report and a cross tab query?
✅ Correct Answer: (B)
You can’t pivot a cross tab query
Q. Need to see all the information from two tables on one form. Insert
✅ Correct Answer: (B)
A subform
Q. All of the following terms are related to computerized databases except which one?
✅ Correct Answer: (A)
Search