MCQS MS Access Quiz 7

This post is about the MCQs MS Access Quiz from Intermediate Computer Science Part II. It has 20 multiple-choice questions related to queries, reports, forms, databases, tables, find and research, search criteria, etc. Let’s start with the MCQs MS Access Quiz Intermediate Computer Science Part II.

Online Multiple Choice Questions about MS Access

1. A sub-form can be created using

 
 
 
 

2. Which of the following options represents the fundamental property of a relational database?

 
 
 
 

3. The forms are the ———— end of our database in Microsoft Access.

 
 
 
 

4. A ————- auto form displays one record at a time.

 
 
 
 

5. ———— auto form displays one record at a time.

 
 
 
 

6. ———— can be previewed on the screen before printing.

 
 
 
 

7. You can drag the ————— bar to move the property sheet window around on your screen.

 
 
 
 

8. Microsoft Access is a

 
 
 
 

9. The maximum length of the text type field in MS Access is

 
 
 
 

10. Which of the following is a one-to-many relation?

 
 
 
 

11. A report provides a column for each field of the records in rows under the column header, which is known as

 
 
 
 

12. A form that contains the sub form is called

 
 
 
 

13. A report may be based on

 
 
 
 

14. Which of the following is used to retrieve data from the database and represent it to the user in a formatted way?

 
 
 
 

15. The forms are designed to

 
 
 
 

16. How many basic layouts of forms are there in Microsoft Access?

 
 
 
 

17. How many are the layout of the report?

 
 
 
 

18. A form within another form is called

 
 
 
 

19. In Access press SHIFT + F10 to

 
 
 
 

20. Which of the following is used to retrieve data from one or more database tables to present it to the user in a formatted way?

 
 
 
 

Online MS Access Quiz Intermediate Computer Science Part II

Online MS Access Quiz with Answers

  • How many basic layouts of forms are there in Microsoft Access?
  • The forms are the ———— end of our database in Microsoft Access.
  • A ————- auto form displays one record at a time.
  • A form that contains the sub form is called
  • You can drag the ————— bar to move the property sheet window around on your screen.
  • A report provides a column for each field of the records in rows under the column header, which is known as
  • ———— can be previewed on the screen before printing.
  • Which of the following is used to retrieve data from one or more database tables to present it to the user in a formatted way?
  • How many are the layout of the report?
  • ———— auto form displays one record at a time.
  • The forms are designed to
  • A form within another form is called
  • A sub-form can be created using
  • Which of the following is a one-to-many relation?
  • A report may be based on
  • Which of the following is used to retrieve data from the database and represent it to the user in a formatted way?
  • The maximum length of the text type field in MS Access is
  • Microsoft Access is a
  • In Access press SHIFT + F10 to
  • Which of the following options represents the fundamental property of a relational database?
Online MS Access Quiz with Answers, Intermediate Part II

Statistics MCQs and Data Analysis, R Programming Language

Leave a Reply

Discover more from GM Statistics

Subscribe now to keep reading and get access to the full archive.

Continue reading