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

Question : 1

A specialist in charge of the database of an organization select the best fit for answer

a) Database management approach

b) DBMS uses

c) Database administrator

d) Query language

Question : 2

How can you add a table to the relationship window?

a) Select Tools>Add table from the menu

b) Select the table from the table list on the toolbar

c) Click the show table button on the toolbar

d) Select Edit>Add table from the menu

Question : 3

Pivot Table report data must meet which of the following criteria?

a) It must be in tabular form, have unique column labels, and each row must represent a unique piece of data

b) Any dates should be formatted with the data format and blank rows or columns should be removed

c) It must be in tabular form, have unique column lagels, and all rows must be sorted

d) Both (A) and (B)

Question : 4

The data in a Pivot Table report is categorized using

a) Column headings

b) Items from the Pivot Table field list

c) Header rows

d) All of above

Question : 5

What’s the best Access object for an invoice you’ll mail to customers?

a) A report

b) A form

c) A table

d) All of the above

Question : 6

The ….. presents data in a way similar to an excel spreadsheet

a) Datasheet view

b) Design view

c) Print preview

d) Layout preview