Top 50 MS Access MCQs Questions with Answers Online Test Quiz

1. In MS Access which wildcard matches any number of characters in a string?

2. In MS Access which wildcard matches any single numeric character?

3. In MS Access…………………..rule states that a record from the table cannot be deleted if it is linked to another table record:

4. In Microsoft Access database which of the following is the correct logical data type:

5. In Microsoft Access ………………corresponds to the rows of a table:

6. In Microsoft Access the query “B[ae]ll” finds:

7. Choose the default data type in Microsoft Access database:

8. In MS Access which of the following is used to enter, modify and view data from the records?

9. In Microsoft Access a report is a collection of related..………….:

10. In Microsoft Access maximum number of fields that we can create is:

11. In Microsoft Access database memo data type can store characters up to:

12. Which kind of facility MS Access RDBMS provides:

13. In Microsoft Access the query “1#5” finds:

14. In MS Access every field in the table contains:

15. Which of the following extension specifies the Microsoft Access database file?

16. Microsoft Access stores all the data and defines the structure in………………:

17. Choose the correct option related to four objects of MS Access database:

18. Choose the correct association between the following options:

19. In Microsoft Access which option is used to create a database from scratch?

20. In Microsoft MS Access the query “wh*” finds:

21. In Microsoft Access the query “B[!ae]ll” finds:

22. How many relationships are there in the Microsoft MS Access database that we can use?

23. In MS Access which method is used to create a table?

24. In MS Access which of the following option is NOT available in design view:

25. In Microsoft Access ………………corresponds to the columns of a table:

26. In Microsoft (MS) Access database which of the following view is used to define the structure of a table:

27. In MS Access a report consists of data which is retrieved from………………….:

28. MS Access consists of four components used to store or manipulate data is known as:

29. In Microsoft (MS) Access database which button is clicked to start the search?

30. Microsoft Access RDBMS enables us to:

31. In Microsoft MS Access which of view looks like an electronic spreadsheet like Google sheets:

32. In MS Access which wildcard is used to exclude characters inside the brackets:

33. In Microsoft Access in which view data is entered in tables?

34. In MS Access which of the following is used to search and compile data from the tables?

35. In MS Access the smallest meaningful unit of data is known as:

36. In Microsoft MS Access…………….view is used to edit, add or delete data from a table:

37. In Microsoft Access which of the following is displayed in the title bar of an opened database?

38. MS Access is a product of………..….:

39. Choose the correct full form of RDBMS:

40. In Microsoft (MS) Access database which criteria is used to find the three character name starting with Z:

41. In Microsoft (MS) Access database how many table views are available:

42. In RDBMS a single piece of information is known as:

43. In MS Access which of the following is used to retrieve and present data from the database?

44. In Microsoft Access database system which data type can store pictures and graphs?

45. Choose the default field size of text data type in Microsoft Access database:

46. In Microsoft Access database IDE stands for:

47. In Microsoft MS Access………………..menu is used to switch between table views:

48. Microsoft Access table contains which type of elements?

49. In MS Access which symbol shows that you are in editing mode:

50. Microsoft Access is a member of……………: