MCQS MS Access Database 6

The post is about Online MCQs MS Access Database with Answers. There are 20 multiple-choice questions from MS-Access Database covering topics related to Database, forms, Tables, Query, and Data Types. Let us start with the MCQs MS Access Database Quiz.

Online MCQs about MS Access Intermediate Part-II with Answers

1. Every table must have a

 
 
 
 

2. Which filtering method allows you to use data in a field as criterion for filtering?

 
 
 
 

3. How find four names that starts with H, the criteria is specified as?

 
 
 
 

4. What is Z to A order called?

 
 
 
 

5. Which data type can be used to define a field that consists of only numbers to be used in calculations?

 
 
 
 

6. Each set of related items in a table is called

 
 
 
 

7. To find a name that start with S, the criteria is written as:

 
 
 
 

8. ————- is used to retrieve data from one or more tables.

 
 
 
 

9. Which data type is the default type in MS-Access?

 
 
 
 

10. Which key is used to move field to field in a table window in datasheet view?

 
 
 
 

11. Which symbol indicates that you are editing a record?

 
 
 
 

12. What is the default size of a Text data type in MS-Access?

 
 
 
 

13. Which of the following is an example of a filter by form expression?

 
 
 
 

14. How many query views are available in MS Access?

 
 
 
 

15. The graphically query tool is known as

 
 
 
 

16. Which data type can be used to define a field that consists of only numbers to be used in calculations?

 
 
 
 

17. The column of a table corresponds to

 
 
 
 

18. Forms are designed for

 
 
 
 

19. The Sort Ascending button will

 
 
 
 

20. What command is required to actually execute a filter on a table?

 
 
 
 

Online MCQs MS Access Database Quiz with Answers

MCQs MS Access Database Quiz

  • Each set of related items in a table is called
  • What is the default size of a Text data type in MS-Access?
  • Which data type is the default type in MS-Access?
  • Every table must have a
  • Which data type can be used to define a field that consists of only numbers to be used in calculations?
  • Which data type can be used to define a field that consists of only numbers to be used in calculations?
  • The column of a table corresponds to
  • Which symbol indicates that you are editing a record?
  • Which key is used to move field to field in a table window in datasheet view?
  • What command is required to actually execute a filter on a table?
  • Which filtering method allows you to use data in a field as criterion for filtering?
  • Which of the following is an example of a filter by form expression?
  • What is Z to A order called?
  • The Sort Ascending button will
  • How find four names that starts with H, the criteria is specified as?
  • The graphically query tool is known as
  • How many query views are available in MS Access?
  • To find a name that start with S, the criteria is written as:
  • ————- is used to retrieve data from one or more tables.
  • Forms are designed for
MCQS MS Access Database Quiz

https://itfeature.com, https://rfaqs.com

Leave a Reply

Discover more from GM Statistics

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

Continue reading