Questions and Answers

MS Access

Questions & Answers

  1. A collection of related tables is called


  1. Which of the following relationship is not valid in MS Access ?

Many to Null

  1. Which is not a view to display a table in Access?

None of above

  1. After creating the table which of the following is correct?

Fields can added and deleted as needed

  1. What do you mean by one to many relationship between Student and Class table?

One student can have many classes

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

datasheet view

  1. What is the use of Cascade Delete Option in MS Access?

It makes sure that all the related records will be deleted automatically from child table when the records from parent table is deleted

  1. The database language that allows you to access or maintain data in a database


  1. A composite key is

The primary key with AutoNumber as the field type

  1. Primary key is

Uniquely identifies each record

  1. Which leads you through the process of creating a table?


  1. How can you link a table with another so that a field in current table will display values in drop down box from another table while entering data:

Look up Wizard

  1. Which of the following may not be a database?

A presentation created in PowerPoint

  1. Cascade delete option

is available in Edit relationship dialog box which makes sure that all the related records will be deleted automatically when the record from parent table is deleted

  1. What are the columns in a Microsoft Access table called?


  1. Validation Rule in a field will

Checks the value entered when user leaves the field

  1. Which is not a command that is selectable from right click menu of a field column?

Rename columns

  1. You have field ‘Gender’ of type Byte NumberHow to limit its value to 0 and 1 only?

By defining validation rule

  1. Which of the following can be an example of a database?

All of above

  1. HSAM stands for ________

Hierarchic Sequential Access Method

  1. A small button with three dots usually displayed at the right of field properties box

Build button

  1. The appropriate Data Type to store Time in MS Access?


  1. Following is not a database model


  1. The report footer section is most useful for displaying:

grand totals

  1. An organized collection of logically related data is known as


  1. Which do you click to display the table\’s primary key and indexes in a separate window?

indexes button

  1. When creating a new table which method can be used to choose fields from standard databases and tables

Create Table using wizard

  1. The task of arranging data in order is called


  1. A primary key in any table has the properties

Both of above

  1. The___ operator will cause a record to be selected only if two or more conditions are satisfied


  1. Which of the following is not a type of relationship that can be applied in Access database

All of above can be applied

  1. The key uniquely identifies each record in a table.

primary key

  1. Database Management Systems are featured with:

The ability to store large amount of data to facilitate easy update, sort and retrieval

  1. In which order do you place the field to sort a Dynaset first by zipcode, then by lastname and then by firstname?

zipcode, lastname, firstname

  1. Which of the following is not an action query?


  1. How many relations may exist between tables in databases?


  1. What is an intersection of a row and a column?


  1. You can set a controls border type to make the border invisible.

Do not display

  1. This key uniquely identifies each record

primary key

  1. Which setting you must modify to print a report using letterhead?


  1. Which of the following Format supports for Data Type Yes/No?

All of Above

  1. Which is not an option for customizing a datasheet window?

change one row\’s height

  1. To create queries in Access

You can use query wizard or design view

  1. Which of the following database object hold data?


  1. To duplicate a controls formatting you can use___


  1. Which field type will you select when creating a new table if you require to enter long text in that field?


  1. In MS Access, Field Value may contain

All of the Above

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


  1. It is an association established between common fields of two tables.


  1. An Access database object that is used to enter, view or edit records


  1. This is the stage in database design where one gathers and lists all the necessary fields for the database project.

data definition

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


  1. In a datasheet, what does each column represent?


  1. When a picture or other graphic image is placed in the report header section it will appear____

Once in the beginning of the report

  1. Which query do you use to answer the question “What is the average salary of the employees”?

Select query

  1. Which of the following data type is used to store logical value in MS Access?


  1. Which of the following is use to get data from user?


  1. In an application created using the database wizard, the main menu is presented as a:

form, called a switchboard

  1. Which of the following statement is true?

In primary key field you can enter duplicate value

  1. In one-to-many relationship the table in ‘one’ side is called _______ and on ‘many’ side is called _______

Parent , Child


Questions & Answers


Leave a Comment

Your email address will not be published. Required fields are marked *