MS Access MCQs

Question 1

In Access to Move down one line

Accepted Answer

DOWN ARROW

Answer

F4 or ALT+DOWN ARROW

Answer

PAGE DOWN

Answer

F9

Question 2

a file containing relatively permanent data is

Accepted Answer

Master file

Answer

Random file

Answer

Transaction file

Answer

Sequential file

Question 3

Which mode sizes an image to fit the control while maintaining the proportions of the original image?

Accepted Answer

Zoom

Answer

Clip

Answer

Fit

Answer

Stretch

Question 4

In Access to Move down one page

Accepted Answer

PAGE DOWN

Answer

F4 or ALT+DOWN ARROW

Answer

DOWN ARROW

Answer

F9

Question 5

Changing the order of this in the query datasheet does not affect the field order in the table.

Accepted Answer

Column

Answer

Record

Answer

Row

Answer

Sort

Question 6

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

Accepted Answer

Queries

Answer

Tables

Answer

Reports

Answer

Forms

Question 7

the complete picture of data stored in database is known as

Accepted Answer

Scheme

Answer

Record

Answer

System flowchart

Answer

Dbms

Question 8

A search value can be an exact value or it can be

Accepted Answer

Wild card character

Answer

Logical Operator

Answer

Relationship

Answer

Comparison operation

Question 9

To create relationship between two tables

Accepted Answer

drag the primary key of a table into foreign key of another table

Answer

drag the foreign key of a table into the primary key of another table

Answer

drag any field from parent table and drop on child table

Answer

Any of above can be done to create relationship