Looking for MCQ MS Access Questions to prepare your competitive exams? You landed to very appropriate website, we have large collection of MCQ MS Access Questions.

This is the second set that presents ten multiple choice questions with four options each. Select the correct answers by marking the radio button alongside. Remember, there is one and only one correct answer for every question.

When you finish attempting all the questions, you can click on ‘Show Result’ button to check your answers and display the result. Correct answers are marked with green tick and wrong ones with red cross.

Enjoy MS Access MCQ Quiz – Set 02!

Microsoft Access MCQ Quiz Set 02

MS Access Multiple Choice Questions

Enter email to receive quiz results:

1. The Allow _____ property controls whether new records can be added through the form.

 Additions

 Edits

 Deletions

 Data Entry

2. Which is not a view for displaying a report object?

 Datasheet view

 Design view

 Print preview

 Layout preview

3. Which of the following store command to retrieve data from database?

 Forms

 Reports

 Queries

 Tables

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

 indexes button

 primary key button

 view datasheet button

 view design button

5. When entering field name, how many characters you can type in maximum?

 60

 64

 68

 Any number of character

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

 Address book of all the suppliers of a company

 Salary sheet of all the employees of a company

 Records of daily sales transactions of a company

 All of above

7. If a piece of data is stored in two places in the database, then a

 Storage space is wasted

 Changing the data is one spot will cause data inconsistency

 It can be more easily accessed

 Both a and b

8. Which of the following is a condensed form of standard generalized markup language?

 HTML

 XML

 XSD

 XSL

9. Which of the following is not a view for interacting with a form object?

 Datasheet view

 Design view

 Form view

 Layout view

10. DCL provides commands to perform actions like

 Change the structure of tables

 insert, update or delete records and data values

 authorizing access and other control over database

 None of above

11. It is a sign or symbol that specifies, operator, and values that produce a result

 operator

 query

 expression

 None of the above

12. Referential integrity means

 Do not enter a value in the foreign key field of a child table if that value does not exist in the primary key of the parent table

 Do not enter a value in the primary key field of child table if that value does not exist in? the primary key of the parent table

 Do not enter a value in the foreign key field of a parent table if that value does? not exist in the primary key of the child table

 All of above

13. Before printing a datasheet, you can use ____ to determine whether to change the page orientation from portrait to vertical orientation.

 Design View

 Datasheet View

 Office View

 Print Preview

14. What does the show check box in query design window indicate

 It indicates whether the field is to be used or not

 It indicates whether the field is to be displayed in query result or not

 It indicates whether the field names to be displayed in query result or not

 None of above

15. Which of the following statements about option group is incorrect?

 It is a control object.

 It is bound to two fields.

 It is a control to identify a choice.

 It contains a set of controls representing choices.

16. It is most common type of query. It retrieves records from one or more tables and then displays the

 Parameter

 Select

 Crosstab

 All of above

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

 Create table in design view

 Create table using wizard

 Create table by entering data

 All of above

18. The Search tool is best used when searching for ______ data.

 simple

 multiple

 unique

 formatted

19. It is a database object to view, change, and analyze data in different ways

 Query

 Form

 Report

 None of the above

20. What is one of the advantages for using a form over other Access objects?

 Utilizes field placement to improve the efficiency of data entry.

 Forms store information more efficiently.

 Forms show the summary of all the records.

 Forms cannot be edited.

 Loading…