data base management system (DBMS) set 3 Detailed Explanation And More Example

Question : 1

How do you update Pivot Table report data after changes are made to the source data?

a) Save your changes, close the workbook, and then reopen it.

b) Select the Pivot Table worksheet and press F9 on the keyboard

c) Click the report, and on the Pivot Table toolbar, click the refresh data button

d) All of the above

Question : 2

Which of the following are common ways to enforce data validation when entering data into an Access form?

a) Create an input mask to restrict the kind of value that can be entered in positions across the field.

b) Define a validation rule for that field

c) A and B

d) none of the above

Question : 3

In Form view, which command displays records alphabetically?

a) Find

b) Advanced Filter/Sort

c) Sort

d) All of the above

Question : 4

Customers, Orders. What’s their best relationship?

a) Many-to-many

b) One-to-one

c) One-to-many

d) All of the above

Question : 5

What is the first step in creating a form or report with the form wizard or report wizard?

a) Selecting the fields that you want to appear in the form or report

b) Selecting the underlying table or query on which you want to base the form or report

c) Reading several screens of mostly useless information and clicking next

d) Selecting how the form or report should be formatted

Question : 6

Which action will optimize your database performance?

a) Set the record set type to Snapshot

b) Use the compact and repair database tool

c) Create a replica of the database

d) All of the above