MS-Access - MS Access MCQ

11:  

A query summarizes information in a grid, organized by regions and months. Which type of query is this?

A.

A cross tab query

B.

An update query

C.

A parameter query

D.

An action query

 
 

Option: A

Explanation :

Click on Discuss to view users comments.

Write your comments here:



12:  

What method can you use to add a new table to your database?

A.

Use Design View to create a table

B.

Enter data directly by using a datasheet

C.

Both of above

D.

None of these

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

Write your comments here:



13:  

The filter by selection feature allows you to filter

A.

Those records that match an entity in a field

B.

Records based on a criterion you specify

C.

Records that meet any of several criteria you specify

D.

All of above

 
 

Option: A

Explanation :

Click on Discuss to view users comments.

Write your comments here:



14:  

How can you display sales grouped by country, region, and salesperson, all at the same time?

A.

Use the Sort Descending command

B.

Use the Pivot table view command

C.

Use the find command on specified groups

D.

All of above

 
 

Option: B

Explanation :

Click on Discuss to view users comments.

Write your comments here:



15:  

What is the memo data type field used for?

A.

To add table

B.

To store objects created in other programs

C.

For long text entries

D.

For shout text entries of no more than 255 characters

 
 

Option: C

Explanation :

Click on Discuss to view users comments.

Write your comments here: