Microsoft Access – Set 3

New set of MCQ Questions in the category of Microsoft Access. In this Multiple Choice Question set you will get MCQ Questions from  Microsoft Access, this is 8th set of this series. Correct Answers of these Questions are give below of this Question Set.

1 Which of the following is use to get data from user?
A. Query
B. Pages
C. Form
D. Report

2 Which of the following is invalid field name?
A. Student.Address
B. Student’sAddress      
C. Student_Address
D. Student Address

3 Primary key is
A. Uniquely identifies each record
B. Cannot be repeated
C. AutoNumber is example of Primary key
D. All of the above

4 To create a table in Access
A. Database should be created before create table
B. Table can be created using Table Templates
C. There must be at least one Primary key in a table
D. All of the above

5 Which of the following is use to view or print the data in organized manner?
A. Query
B. Report
C. Table
D. Form

6 In a table to insert User’s Voice, Data field should be
A. OLE Object
B. SoundField
C. VoiceField
D. Memo

7 In a table Multiple Primary Keys can be set
A. True
B. False

8 After creating the table which of the following is correct?
A. Fields cannot be added
B. Fields cannot be deleted
C. Fields can added but only once
D. Fields can added and deleted as needed

9 Validation Rule in a field will
A. Checks the value entered when user leaves the field
B. Displays the value in specified format when user leaves the field
C. Defines the appearance for the text
D. There is no option of Validation Rule

10 Query can be use to select data from
A. Single Table
B. Multiple Tables
C. Both A & B

11 Data can be import into Access Database from

1. Word Files
2. Excel Files
3. PowerPoint Files
4. HTML Files

12 What is the use of Referential Integrity in MS Access?

1. It allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table
2. It does not allow to enter a value in the foreign key field of a child table if that value exist in the primary key of the parent table
3. It allow to enter a value in the Primary key field of a child table if that value exist in the Foreign key of the parent table
4. None of above

13 In MS Access, Field Value may contain

1. Text
2. Date & Time
3. Picture
4. All of the Above

14 Which of the following is the DBMS type

1. Flat File System
2. Hierarchical DBMS
3. Relational DMBS
4. All of the Above

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

1. Many to Many
2. Many to Null
3. One to One
4. One to Many

16 A collection of related tables is called

1. Row
2. Record
3. Database
4. File

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

1. Yes/No
2. True/False
3. On/Off
4. All of Above

18 Queries can be created in Access by

1. Typing Queries in SQL View
2. Drag and Drop fields on Query Builder
3. Using Query Wizard
4. All of the Above

19 Relationship can be establish between two tables by

1. Drag Primary key of a table into Foreign key of another table
2. Drag Foreign key of a table into Primary key of another table
3. Drag any key of a table into any key of another table
4. All of the above

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

1. It makes sure that all the records from the parent table and child table is deleted from selected database
2. It makes sure that all the related records will be deleted automatically from child table when the records from parent table is deleted
3. It makes sure that all the related records will be deleted automatically from Parent table when the records from child table is deleted
4. None of above

Answers
1 – C / 2 – A / 3 – D / 4 – D / 5 – B / 6 – A / 7 – A / 8 – D / 9 – A / 10 – C
11 – B / 12 – A / 13 – D / 14 – D / 15 – B / 16 – C / 17 – D / 18 – D / 19 – A / 20 – B