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

Question : 1

The complete picture of data stored in database is known as

a) Record

b) Scheme

c) System flowchart

d) DBMS

Question : 2

An identification field in a record. Select the best fit for answer

a) Record

b) File

c) Database

d) Key field

Question : 3

Which control does access use to link data access page components to access data?

a) Microsoft Dynamic Data Control

b) Microsoft Data Connection Control

c) Microsoft Office Data Source Control

d) None of the above

Question : 4

In Form view, which command displays records alphabetically?

a) Find

b) Advanced Filter/Sort

c) Sort

d) All of the above

Question : 5

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 : 6

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