MCQ Sets

MS Access MCQ Questions Set 04 – Online Quiz

Updated:    

Welcome to yet another quiz – the Microsoft Access MCQ Questions Set 04.

We tried to cover all the topic within MS Access and Database Management System (DBMS) so that you can test every aspect and prepare your exams better.

You’ll find ten multiple choice questions in this set with four possible options each. There is one and only one correct answer for each question.

Please mark the correct answer and click on ‘Show Result’ button at the bottom to get the result of your online quiz.

Microsoft Access MCQ Questions

 

MS Access & DBMS Quiz Set 04


MS Access Multiple Choice Questions

1. Which of the following is a method to create a new table in MS Access?
 
 
 
 
2. The page count of a report can be determined by clicking the _______ button.
 
 
 
 
3. Which report section only prints one time at the end of the report?
 
 
 
 
4. It is a database object to view, change, and analyze data in different ways
 
 
 
 
5. DCL provides commands to perform actions like
 
 
 
 
6. in MS Access, which data type is appropriate to store large text and numbers?
 
 
 
 
7. Which of the following is the file extension for an Extensible Markup Language?
 
 
 
 
8. Which query do you use to answer the question "Which employees earn more than $5000 a month"?
 
 
 
 
9. In Datasheet View, new records are added to a table ____.
 
 
 
 
10. A(n) _____ is an image control that displays in the background of a page on a form or report.
 
 
 
 
11. Which of the following statement is true
 
 
 
 
12. A relationship is created between how many tables?
 
 
 
 
13. Which of the following statements about calculated fields is NOT true?
 
 
 
 
14. Which action will optimize your database performance?
 
 
 
 
15. The basic elements of a form or a report are called:
 
 
 
 
16. __________ is the clear leader for personal databases.
 
 
 
 
17. A search value can be an exact value or it can be
 
 
 
 
18. The ______ is a wild card that represents one or more characters.
 
 
 
 
19. In table design view, which key can be used to switch between the field names and properties panels?
 
 
 
 
20. Which report section prints once at the bottom of every printed page?
 
 
 
 

 

We hope this MS Access MCQ questions were helpful for you!

If you like this set, don’t forget to subscribe and share it on social networks.

Comments

  1. Which of the following is not a field type in Access

    a. Memo
    b. Hyperlink
    c. OLE Object
    d. Lookup Wizard
    (Problem: It shows option d but lookup wizard is also field type, isn’t it?)

    Reply

  3. 152. Which of the following is not a valid Data Type in MS Access?
    a. Memo
    b. Picture (answer)
    c. Currency
    d. AutoNumber
    ( It is correct answer)
    ————————————————————-
    172. In MS Access, Field Value may contain
    a. Text
    b. Date & Time
    c. Picture
    d. All of the Above(answer)
    (Problem: How option D is correct answer when there is Picture as field which is not field type)

    Reply

    • Chandra,

      MS Access do not have a field type named ‘Picture” but you can store pictures in OLE fields. So pictures can be field values though Picture is not a field type. 🙂

      Reply

      • Hi sir..i have found mcqs of excel and word in series form like (1-368) and (1-368) respectively…..But i cant able to find mcqs of access kindly help me….will be thankful 🙂

        Reply

Leave a Reply

Your email address will not be published. Required fields are marked *

Recent Comments