MS Access MCQ with Answers

Parameter

Select

crosstab

All of above

Open statement opens access database files and Open Exclusively opens database files of other program like Oracle

Open Exclusive locks whole database so that no one can access it whereas Open locks only the record that is being accessed

Both Open and Open Exclusively are same

Open Exclusive command does not exist in MS Access

Reports can be used to retrieve data from tables and calculate

Queries can be printed in well formatted manner and presented as the information

Queries can include calculated fields that do not exist in table

Reports and forms are similar but forms are use to print but reports to display on screen only

Select

crosstab

Parameter

Append

Parameter

Select

crosstab

Append