MS Access MCQs

Question 1

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

Accepted Answer

Both of above

Answer

Use Design View to create a table

Answer

Enter data directly by using a datasheet

Answer

All of the above

Question 2

The complete information about an entity in a database is called

Accepted Answer

Record

Answer

Data

Answer

Information

Answer

Field

Question 3

In order to use dbms, it is important to understand

Accepted Answer

One sub schema

Answer

The physical schema

Answer

All sub schemas that the sytem supports

Answer

Both a and b

Question 4

A ________ is a unit of information in a ________

Accepted Answer

field, record

Answer

record, field

Answer

data source, field

Answer

record, data source

Question 5

Which of the following query type is best suitable to analyze data?

Accepted Answer

Cross tab queries

Answer

Parameter queries

Answer

Action queries

Answer

None of above

Question 6

Which tool is used to generate printout of a table's structure?

Accepted Answer

Documenter

Answer

Analyzer

Answer

Designer

Answer

Generator

Question 7

Search engines use a(n) __________ to automatically index sites.

Accepted Answer

crawler

Answer

query

Answer

enterprise

Answer

sitebuilder

Question 8

Which of the following views displays the field name, description, and properties of a table?

Accepted Answer

Design View

Answer

Datasheet View

Answer

Layout View

Answer

Table View

Question 9

A database can be best described as

Accepted Answer

Organized collection of data

Answer

Useful presentation of data

Answer

Graphical representation of data

Answer

All of above