Ms Access interview questions – page 2

Which of the following is database management system software?

1. Firefox
2. MS Access
3. MS PowerPoint
4. MS Word

In which of the following view, you can’t change the table data?

1. Pivot table view
2. Datasheet view
3. Design view
4. Both (a) and (b)

____ are the set Visual Basic procedures and declarations stored as one unit.

1. Tables
2. Reports
3. Macros
4. Modules

The checking operation performed on input data is called the

1. Control of data
2. Validation of data
3. Cross check
4. Verification of data

A search value can be exact value or it can be

1. Wild card character
2. Comparison operation
3. Relationship
4. Logical operator

Which of the following is not a Form style available in the Form Wizard dialog box?

1. Stone
2. Standard
3. Highlights
4. Blends

_____ button helps to search quickly for every occurrence of a specific word or phrase.

1. Justify
2. Find
3. Bullet
4. Sort

Which program do you use to edit code for data access pages?

1. Microsoft script editor
2. Microsoft data access pages editor
3. Microsoft code editor
4. All of these

In how many views, you can create a table in Access?

1. 2
2. 4
3. 6
4. 8

Which of the following is not a field type in access?

1. Ole object
2. Hyperlink
3. Memo
4. Lookup wizard

To switch between to Form view from design view, press ____

1. F5
2. F8
3. F9
4. F11

It is a query that when run displays its own dialog box prompting you for information, such as

1. Append
2. Parameter
3. Crosstab
4. Select

This form displays multiple records, one per row, in the form window

1. Justified
2. Columnar
3. Tabular
4. Datasheet

In a database table, the category of information is called ____

1. Tuple
2. Field
3. Record
4. All of above

The columns in a Microsoft Access table are called as ____

1. Fields
2. Macro
3. Columns
4. Records

In Access table, column is also known as ____

1. Type
2. Data
3. Record
4. Field

Which of the following is not a valid Data Type in MS Access?

1. AutoNumber
2. Currency
3. Picture
4. Memo

Row in an Access table is also known as ____

1. Type
2. Data
3. Record
4. Field

The appropriate Data Type to store Time in MS Access?

1. Time cannot be stored
2. Time
3. Time Only
4. Date/Time

Which of the following data type stores text or a combination of text and numbers?

1. Ole
2. Text
3. Currency
4. Number

Unlike text data type, this can store up to maximum of 65,535 characters.

1. Date/time
2. Number
3. Memo
4. All of above

In MS Access, AutoNumber Data Type

1. Can be Sequential
2. Can be Random
3. Only A & B
4. Can be Edited

In MS Access, which data type is appropriate to store large text and numbers?

1. Large Text
2. OLE
3. Memo
4. Text

Which is the valid data type in Access?

1. Currency
2. Text
3. Number
4. All of the above

The default data type for a field is

1. Varchar
2. AutoNumber
3. Number
4. Text

This data type allows alphanumeric characters and special symbols.

1. Auto number
2. Memo
3. Text
4. All of the above

Microsoft Access is a _____

1. Network Database Model
2. RDBMS
3. ORDBMS
4. OODBMS

Which of the following is not a type of Microsoft access database object?

1. Macros
2. Modules
3. Worksheets
4. Table

A subset of characters within a data field is known as

1. Byte
2. File
3. Record
4. Data string

Press _____ to quit MS Access.

1. Tab +F4
2. Esc+ W
3. Ctrl +F4
4. Alt+F4