1000+ Microsoft Access Multiple Choice Question Answer [Solved]

1. A search value can be an exact value or it can be
A. Logical Operator
B. Relationship
C. Wild card character
D. Comparison operation
Answer : C

2. To duplicate a controls formatting you can use___
A. Manager
B. Wizard
C. Painter
D. Control
Answer : C

3. An Access database object that is used to enter, view or edit records
A. Table
B. Form
C. Query
D. Report
Answer : B

4. When entering field name, how many characters you can type in maximum?
A. 60
B. 64
C. 68
D. Any number of character
Answer : B

5. Which is not a view to display a table in Access?
A. Datasheet View
B. Design View
C. Pivot Table & Pivot Chart View
D. None of above
Answer : D

6. A __ name must be unique within a database
A. Table
B. Field
C. Record
D. Character
Answer : A

7. The default and maximum size of text field in Access
A. 50 and 255 Characters
B. 8 and 1 GB
C. 266 characters & 64000 characters
D. None of above
Answer : A

8. The third stage in designing a database is when we analyze our tables more closely and create a ___________ between tables
A. relationship
B. Join
C. Query
D. None of these
Answer : A

9. A database can be best described as
A. Organized collection of data
B. Useful presentation of data
C. Graphical representation of data
D. All of above
Answer : A

10. A __________ enables you to view data from a table based on a specific criterion
A. Form
B. Query
C. Macro
D. Report
Answer : B

11. Both conditions display on the same row in the design grid when ___operator is in use
A. OR
B. IN
C. AND
D. LIKE
Answer : C

12. Two tables can be linked with relationship so that the data integrity can be enforced. Where can you find Relationship Command?
A. Home Tab
B. Create Tab
C. External Data Tab
D. Database Tab
Answer : D

13. In one-to-many relationship the table in one side is called _______ and on many side is called _______
A. Child , Parent
B. Parent , Child
C. Brother , Sister
D. Father , Son
Answer : B

14. Which of the following database object produces the final result to present?
A. Forms
B. Reports
C. Queries
D. Tables
Answer : B

15. A database object in MS Access that stores a question about the data in database?
A. Table
B. Form
C. Query
D. Report
Answer : C

16. A composite key is
A. Required when a table does not have any unique fields in it
B. The primary key with AutoNumber as the field type
C. Made up of two or more fields to uniquely identify records
D. Is a foreign key that uniquely identifies records
Answer : C

17. Which of the field has width 8 bytes?
A. Memo
B. Number
C. Date/Time
D. Hyperlink
Answer : C

18. While creating relationship, when you drag a field of a field to drop into another table the mouse pointer changes into
A. a doctors sign
B. thin + sign
C. outline rectangle
D. None of above
Answer : C

19. What are the columns in a Microsoft Access table called?
A. Rows
B. Records
C. Fields
D. Columns
Answer : C

20. To create a new table, in which method you dont need to specify the field type and size?
A. Create table in Design View
B. Create Table using wizard
C. Create Table by Entering data
D. All of above
Answer : C

21. Referential integrity means
A. 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
B. 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
C. 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
D. All of above
Answer : A

22. A part of database that stores only one type of data is
A. Report
B. Field
C. Query
D. Record
Answer : B

23. To create relationship between two tables
A. drag the primary key of a table into foreign key of another table
B. drag the foreign key of a table into the primary key of another table
C. drag any field from parent table and drop on child table
D. Any of above can be done to create relationship
Answer : A