Question 1

The data in a Pivot Table report is categorized using

Accepted Answer

A) Column headings 
B) Items from the Pivot Table field list 
C) Header rows 
D) All of above 
A) Column headings 
B) Items from the Pivot Table field list 
C) Header rows 
D) All of above B

Question 2

APPEND command is used to

Accepted Answer

A) Add record to the end of active database file and starts full screen data entry 
B) Add Record to the start of active database file 
C) Add record to the start of active database file and starts full screen data entry 
D) Add record to the end of database file 
A) Add record to the end of active database file and starts full screen data entry 
B) Add Record to the start of active database file 
C) Add record to the start of active database file and starts full screen data entry 
D) Add record to the end of database file A

Question 3

The use of integrated collections of database records and files for data storage and processing. The best fit for answer:

Accepted Answer

A) Database management approach 
B) DBMS uses 
C) Database administrator 
D) Query language 
A) Database management approach 
B) DBMS uses 
C) Database administrator 
D) Query language D

Question 4

A database that contains tables linked by common fields is called a

Accepted Answer

A) Centralized database 
B) Flat file database 
C) Relational database 
D) None of above 
A) Centralized database 
B) Flat file database 
C) Relational database 
D) None of above

Question 5

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

Accepted Answer

A) Database management approach 
B) DBMS uses 
C) Database administrator 
D) Query language 
A) Database management approach 
B) DBMS uses 
C) Database administrator 
D) Query language

Question 6

One of the type libraries that you can use to programmatically connect to Microsoft Access data is

Accepted Answer

A) Collaborative Data Objects 
B) ActiveX Data Objects 
C) Dynamic Data Interfaces 
D) None of the above 
A) Collaborative Data Objects 
B) ActiveX Data Objects 
C) Dynamic Data Interfaces 
D) None of the above

Question 7

DBMS allows you to create, interrogate, and maintain a database, create reports, and develop application programs, select the best fit answer

Accepted Answer

A) Database management approach 
B) DBBMS uses 
C) Database administrator 
D) Query language 
A) Database management approach 
B) DBBMS uses 
C) Database administrator 
D) Query language

Question 8

It Is used to build and modify database objects and also to create new queries

Accepted Answer

A) Datasheet view 
B) Design view 
C) Print preview 
D) Layout preview 
A) Datasheet view 
B) Design view 
C) Print preview 
D) Layout preview

Question 9

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

Accepted Answer

A) Datasheet view 
B) Design view 
C) Print preview 
D) Layout preview 
A) Datasheet view 
B) Design view 
C) Print preview 
D) Layout preview

Question 10

How do you freeze a field a column or field in Microsoft Access?

Accepted Answer

A) Click anywhere in the column and select Edit>Freeze Column form the menu 
B) Place an ice cube in the column 
C) Click anywhere in the column and click the freeze button on the toolbar 
D) Right click the column and select freeze columns from the shortcut menu 
A) Click anywhere in the column and select Edit>Freeze Column form the menu 
B) Place an ice cube in the column 
C) Click anywhere in the column and click the freeze button on the toolbar 
D) Right click the column and select freeze columns from the shortcut menu

Question 11

Which of the following columns can not be found in the macro design window?

Accepted Answer

A) Arguments column 
B) Comment column 
C) Conditions column 
D) Actions column 
A) Arguments column 
B) Comment column 
C) Conditions column 
D) Actions column

Question 12

Examples of centralized multi-user databases are

Accepted Answer

A) Barclays' Bank customer accounts 
B) Supermarket stock control, organ donor database, client database 
C) Airline reservations and other national global booking systems 
D) None of above 
A) Barclays' Bank customer accounts 
B) Supermarket stock control, organ donor database, client database 
C) Airline reservations and other national global booking systems 
D) None of above

Question 13

It examines a small portion or sample of your data in a report before printing it.

Accepted Answer

A) Datasheet view 
B) Design view 
C) Print preview 
D) Layout preview 
A) Datasheet view 
B) Design view 
C) Print preview 
D) Layout preview

Question 14

When a customer makes an online hotel booking, the database is updated in

Accepted Answer

A) Batch mode 
B) Pseudo real-time 
C) One month 
D) All of above 
A) Batch mode 
B) Pseudo real-time 
C) One month 
D) All of above

Question 15

Which of the following is not a command to find specific word or phrases in a database?

Accepted Answer

A) Click the find button on the toolbar 
B) Click the find button on the record navigation button area 
C) Press Ctrl+F 
D) Select Edit>Find from the menu. 
A) Click the find button on the toolbar 
B) Click the find button on the record navigation button area 
C) Press Ctrl+F 
D) Select Edit>Find from the menu.

Question 16

It shows the appearance and layout of a report, table or form in order to confirm what will be printed.

Accepted Answer

A) Datasheet view 
B) Design view 
C) Print preview 
D) Layout preview 
A) Datasheet view 
B) Design view 
C) Print preview 
D) Layout preview

Question 17

Modules are

Accepted Answer

A) selection of commands used to automate repetitive tasks 
B) programs written in Visual C++ 
C) Object tabs 
D) Group of records 
A) selection of commands used to automate repetitive tasks 
B) programs written in Visual C++ 
C) Object tabs 
D) Group of records

Question 18

New record is added using

Accepted Answer

A) Append record from browse menu 
B) Append record into from browse menu 
C) Add record from edit menu 
D) All of above 
A) Append record from browse menu 
B) Append record into from browse menu 
C) Add record from edit menu 
D) All of above

Question 19

A good query system

Accepted Answer

A) Can accept English language commands 
B) Allows non-programmers to access information stored in a database 
C) Can be accessed only by data prssing professionals 
D) Both (
A)  and (
B)  
A) Can accept English language commands 
B) Allows non-programmers to access information stored in a database 
C) Can be accessed only by data prssing professionals 
D) Both (
A)  and (
B)

Question 20

This DBMS feature allows users to easily interrogate a database. Select the best fit for answer

Accepted Answer

A) Database management approach 
B) DBMS uses 
C) Database administrator 
D) Query language 
A) Database management approach 
B) DBMS uses 
C) Database administrator 
D) Query language

The data in a Pivot Table report is categorized using

APPEND command is used to

The use of integrated collections of database records and files for data storage and processing. The best fit for answer:

A database that contains tables linked by common fields is called a

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

One of the type libraries that you can use to programmatically connect to Microsoft Access data is

DBMS allows you to create, interrogate, and maintain a database, create reports, and develop application programs, select the best fit answer

It Is used to build and modify database objects and also to create new queries

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

How do you freeze a field a column or field in Microsoft Access?

Which of the following columns can not be found in the macro design window?

Examples of centralized multi-user databases are

It examines a small portion or sample of your data in a report before printing it.

When a customer makes an online hotel booking, the database is updated in

Which of the following is not a command to find specific word or phrases in a database?

It shows the appearance and layout of a report, table or form in order to confirm what will be printed.

Modules are

New record is added using

A good query system

This DBMS feature allows users to easily interrogate a database. Select the best fit for answer

Database Fundamentals and Management

Database Management and Terminology

Database Management and Usage

Database Management and Access

Database Management System DBMS

Microsoft Access and Database Management: Tips and Techniques

Filters

Exam 3: Database Management System

The data in a Pivot Table report is categorized using

APPEND command is used to

The use of integrated collections of database records and files for data storage and processing. The best fit for answer:

A database that contains tables linked by common fields is called a

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

One of the type libraries that you can use to programmatically connect to Microsoft Access data is

DBMS allows you to create, interrogate, and maintain a database, create reports, and develop application programs, select the best fit answer

It Is used to build and modify database objects and also to create new queries

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

How do you freeze a field a column or field in Microsoft Access?

Which of the following columns can not be found in the macro design window?

Examples of centralized multi-user databases are

It examines a small portion or sample of your data in a report before printing it.

When a customer makes an online hotel booking, the database is updated in

Which of the following is not a command to find specific word or phrases in a database?

It shows the appearance and layout of a report, table or form in order to confirm what will be printed.

Modules are

New record is added using

A good query system

This DBMS feature allows users to easily interrogate a database. Select the best fit for answer

Database Fundamentals and Management

Database Management and Terminology

Database Management and Usage

Database Management and Access

Database Management System DBMS

Microsoft Access and Database Management: Tips and Techniques

Filters