MS Access MCQ Questions and Answers – Part 3

MS Access MCQ questions and answers for the preparation of tests, exams, and certifications. So you will find questions about Access Relational Database Management System. and much more. This systematic learning method will easily prepare anyone to pass their exam.
 

1. The operator ______ will make sure that the record is selected only if two or more conditions are met

A NOT

B XOR

C OR

D AND

Answer  
 

2. What type of field can store images?

A Hyperlink

B OLE

C Memo

D Text

Answer  

3. What is the maximum length of a text field?

A 255

B 256

C 257

D 355

Answer  

4. Microsoft Access is a _______

A OODBMS

B ORDBMS

C SGBDR

D None of the above

Answer  
 

5. DCL provides commands to perform actions such as _______

A Change the structure of the tables

B Access authorization and other control over the database

C Insert, update or delete records and data values

D All the answers are true

Answer  

6. Which of the following commands will extract data from the database?

A Queries

B Forms

C Records

D Reports

Answer  

7. A part of the database that stores a single type of data is _________

A Record

B Form

C Field

D Report

Answer  

8. A database can be described as _______

A Useful data presentation

B Keeps data organized

C Graphical representation of data

D None of the above

Answer  
 

9. The set of linked records in a database is called _________

A Relation

B Record

C File

D Table

Answer  

10. The complete information about an entity in a database is called ________

A Relation

B Record

C File

D Table

Answer  
MCQPractice competitive and technical Multiple Choice Questions and Answers (MCQs) with simple and logical explanations to prepare for tests and interviews.Read More