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. The Sort Ascending button will

 
 
 
 

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

 
 
 
 

3. Forms are designed for

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

8. The graphically query tool is known as

 
 
 
 

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

 
 
 
 

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

 
 
 
 

11. What is Z to A order called?

 
 
 
 

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

 
 
 
 

13. The column of a table corresponds to

 
 
 
 

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

 
 
 
 

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

 
 
 
 

16. Every table must have a

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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

 
 
 
 

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