Ms Access interview questions

In MS Access, OLE objects Data type can store

1. Microsoft Excel Spreadsheets
2. Microsoft Word documents
3. Sounds
4. All of the above

A part of database that stores complete information about an entity such as employee, sales, orders etc.

1. Record
2. File
3. Field
4. Query

In table design view, which key can be used to switch between the field names and properties panels?

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

To create queries in Access

1. You can drag and drop fields on query builders
2. You can type the SQL command in SQL view
3. You can use query wizard or design view
4. All of the above

Which of the following is not a selection technique?

1. To select a row, click the record selector box to the left of the row
2. To select a column, double click anywhere in the column
3. To select a word, double click the word
4. To select an entire table click the empty box to the left of the field names

To create a table in MS Access

1. Database should be created before creating a table
2. You should allow atleast one Primary key in a table
3. Table can be created using Table Templates
4. All of the above

Database access levels are specified so as to define who can access what in a database, it is identified through

1. User ID
2. Password
3. Status
4. All of these

The default and maximum size of text field in access

1. 50 and 255 characters
2. 266 characters and 6400 characters
3. 288 characters and 6880 characters
4. 299 characters and 6499 characters

Press _____ to cyle between open windows.

1. Ctrl + F4
2. Ctrl + F6
3. Ctrl + F7
4. Ctrl + F12

You can automatically include all of the field in a table in a query by _____ a strike that appear list box in query design view.

1. Double clicking
2. Right clicking
3. Clicking
4. All the above

What is a database?

1. It is a collection of data arranged in rows
2. It is a collection of data arranged in columns
3. It is a collection of data arranged in rows and columns
4. All of the above

To open an existing database, press

1. Ctrl + O
2. Ctrl + P
3. Ctrl + E
4. Ctrl + X

The option allows you to build a new table by entering data directly into the datasheet.

1. Datasheet view
2. Design view
3. Link table
4. All of the above

Queries in Access can be used as

1. View, change and analyze data in different ways
2. A source of records for forms and reports
3. Both a and b
4. None of these

To sort records in a table

1. Open table, click on the field on which the sorting is to be done, then click sort button on database toolbar
2. Click the field heading to sort it ascending or descending
3. Open table, click sort button on database toolbar, choose field based on which to sort, click ok
4. All of the above

In MS Access “Lookup Wizard” is used to

1. to select value from another table
2. to select values from Excel Sheet
3. to select from previous values
4. not a valid data type

The command center of access file that appears when you create or open the ms access database file.

1. Switchboard
2. Design view Window
3. Database Window
4. Query Window

In MS Access, Text data type may contain maximum character of

1. 255 character
2. 256 character
3. 1064 character
4. No limit

To rename a selected object, press

1. F2
2. F3
3. F4
4. F5

_____ key is uniquely identifies each record.

1. Field Name
2. Unique key
3. Primary key
4. Key record

Which of the following is a method to create a new table in MS access?

1. Create table by entering data
2. Create table using wizard
3. Create table in design view
4. All of above

The expression builder is an access tool that controls an expression _____ for entering an expression.

1. Palette
2. Box
3. Cell
4. Table

Which of the following is a method to create a new table in MS-Access?

1. Create table using wizard
2. Create table in design view
3. Create table in data sheet view
4. All of the above

Which of the following database objects asks a question of information in a database and then displays the result?

1. Forms
2. Reports
3. Tables
4. Queries

Which of the following Data Type is used to store picture in MS Access?

1. Picture cannot be stored
2. Memo
3. OLE object
4. Picture

A _____ name must be unique within a database.

1. Character
2. Table
3. Record
4. Field

Which control does access use to link data access page components to access data?

1. Microsoft Default Connection Control
2. Microsoft Data Connection Control
3. Microsoft Dynamic Data Control
4. Microsoft Office Data Source Control

Which of the following database object is created first before any other created?

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

In access, this displays the results of a calculation in a query

1. Child field
2. Calculated field
3. Source field
4. Lookup field

Data items groped together for storage purposes are called a

1. Record
2. List
3. String
4. Title