Ms Access interview questions – page 3

____ is not a valid data type in MS Access.

1. Auto number
2. Currency
3. Memo
4. Picture

Which of the following creates a drop down list of values to choose from?

1. ID
2. Hyperlink
3. Lookup wizard
4. Clip object

A ____ enables you to view data from a table based on a specific criterion.

1. Query
2. Modules
3. Form
4. Report

In MS Access “ Hyperlink” Data Type can store

1. Web Address
2. Email Address
3. Path of a File
4. All of Above

It is a database object to view, change, and analyze data in different ways

1. Form
2. Report
3. Query
4. All of the above

The executive responsible for the data processing function in an organization is

1. PMC
2. DBMS
3. DPMT
4. DPE

A _____ is an area reserved for a specific piece of data.

1. Report
2. Key
3. Record
4. Field

What is the maximum length a text field can be?

1. 75
2. 120
3. 255
4. 265

In Access, ____ are used to store the data.

1. Report
2. Form
3. Table
4. Query

Which tool do you use to create a query object?

1. Table query wizard
2. Simple query wizard
3. Simple filer wizard
4. Database wizard

Open the Save As dialog box

1. F1
2. F2
3. F10
4. F12

_____ enables the user to automatically insert numbers in a sequential or random number.

1. Auto Number
2. Look up Wizard
3. Hyperlink
4. Ole object