Adblocker Detected

Adblocker

Quizack provides Online Quiz and Practice MCQs for Free. Please disable your Ad-Blocker so we can earn from ads and keep this project alive.

Access MCQ Questions Answers

Quizack has made it easy for students and professionals to tackle their pending assessments or certifications by preparing its Access MCQs. Users can cover their deficiencies by evaluating skills through Access multiple choice questions based on the latest topics and terminologies.

Sample Access MCQ

What is a report?

A MACRO controlled document.

The opposite of a query.

The best method for printing the results of data in a database.

A way to store data in a database.

Answer:
The best method for printing the results of data in a database.

Access multiple choice questions List

1. Embedded macros can be attached to the event property of a form, report or control.

2. How can you define how various tables of information are related?

3. What would Format('1267.5', 'Currency') return?

4. What is a report?

5. How to you ensure that a field is filled out properly?

6. What is the maximum number of indexes that you can create on an Access table?

7. If tables are for storing data, what are queries used for?

8. A primary key can be described as:

9. The Is Null criteria searches for fields that are ____.

10. What would LCase('124ABCd') return?

11. Can a primary key be used as a non-primary key in another table?

12. To change the type of data input for a specific field, you:

13. Before you split a database, you should:

14. What happens when you freeze a column?

15. In an Access Query, if you would like your result to display blank values, what criteria would you use?

16. This holds data in a database:

17. The functions of Avg, Sum, Count, etc. can be found in which tool group?

18. Which query can you delete records?

19. What is a primary key?

20. What is the best way to view and print the results of a query?

21. What is a form?

22. Which data type allows for text and numbers to be added to a field?

23. True or False: You cannot assign a Macro to a Command Button.

24. Which database object acts as a storage container for the data?

25. To edit how a form looks, you go to:

26. You can edit the field size for allowable characters in:

27. What character do you use to concatenate two character strings?

28. Which is NOT a valid data type in an Access table?

29. How do you ensure that a field is filled out in a table?

30. Why use a database instead of a spreadsheet?

31. Which of these is a proper example of how to write an equation for a query?

32. Can relationships be between primary keys and non-primary keys?

33. What does field size do?

34. A good feature for having a unique primary key is:

35. What is a caption?

36. To ensure a value no greater than 30 is entered into a field you would use:

37. If you delete a field from a table:

38. What do you call a value that is automatically entered in a filed for new records?

39. Which of these would be a proper way to type a parameter?

40. How do you make sure that a field from a query is displayed in the results?

41. Why should you enter sample data in tables after creating them?

42. When you press the Tab key, which way does the insertion point go?

43. The Where function does what?

44. Which two objects can a report object be based on?

45. What language is used to extend and automate MS Access?

46. Which takes you through the process of creating a table

47. How do you create a new table by importing an Excel Spreadsheet?

48. What is the shortcut key combination for stopping the execution of a query?

49. What is the file extension of an Access 2010 database?

50. Access _____ the saved query each time it is opened.

51. What keyboard shortcut key do you press to get help?

52. You need a shortcut on a form to print a specific report. Which form design tool do you use?

53. Your sales entry form does not tab through in the order you want between fields. You should:

54. What would Len('Tech on the Net') return?

55. Which of these is considered a record?

56. What is each column in a table called?

57. Which Database Tool allows you to identify tables with repeating information and suggest a more normalized table design?

58. If you wanted to create a query that removed records from an existing table, what kind of query would you create?

59. Name the object that is linked to a table that is used to enter data?

60. Where in an Access window can you search for a specific record?

61. What are two ways to enter data into your database?

62. What are relationships for?

63. In the 2007 and later versions of Access, databases are not encrypted when a database password is applied.

64. In query design, if you want to find all records where the CITY field begins with the letter D you would enter:

65. How do you move to the last record in a table?

66. Access will allow Joins between two linked tables on different servers.

67. What type of query is used to show data but that does not alter data on the table?

68. Which 'Filter By Group' Options available in database objects pane:

69. When you use the Max function, you are searching for...

70. What does setting 'Allow Zero Length' to 'Yes' in a text field allow?

71. The Input Mask Wizard is used to....

72. To find records within two dates you use

73. What would Len('124ABCd') return?

74. What is the difference between regular version and runtime version of Microsoft Access?

75. If you wanted to create a query that added records to an existing table (without overwriting existing records), what kind of query would you create?

76. Before deleting a query object in your database you need to check whether any report objects are based on it. How do you do this?

77. To hide repeating data in a column on a report you would set the Hide Duplicates Property to 'No.'

78. Can you modify information while viewing a report?

79. A best practice in managing a relational database such as the Access Jet database engine is:

80. What is the name of a query to which you can add records?

81. What are the 3 buttons for sorting data?

82. You can use SQL to write Queries.

83. An Input Mask is:

84. Which of these is not a valid aggregate function for a query search?

85. Choose the correct criteria to enter when prompting a user for the Customer Name in a Query.

86. Do you have to have relationships set up in Access?

87. How does changing the appearance of a datasheet affect the underlying table structure?

88. You want to limit what people can enter on a Form. The easiest way is to:

89. Where can you find the # of results in a Query?

90. What would Replace('alphabet', 'bet, 'hydro') return?

91. How do you resize a column?

92. When you run a query to find records in related tables, Access, by default, uses...

93. You have imported data from Excel. You want Access to help you split your data into different tables. What do you do?

94. Which is not a valid view for an Access Form?

95. To create a table relationship you would click on...

96. Normalization is the process of:

97. When do you use the Lookup Wizard?

98. The Following statements are all true except:

99. You want to create a flexible query that prompts the user for additional criteria. What will you create?

100. You require a form control that provides a text box to which a drop-down list is attached. Users can either type a value directly into the text box or select from the list of choices available. Which control will you choose?

Quizack experts have observed that online practice plays a crucial part in your learning. Plus you get real exam experience because of the interactive online nature. Hence, you will not only prepare Access exam questions and answers but familiarize yourself with typical scenarios and their patterns. You can also assess your knowledge via Access MCQ online test

You don’t need to spend months consulting multiple sources for the sake of different types of assessments. Quizack makes it easier for you by providing optimal questions. In other words, you will get a dynamic Access practice test online that will be helpful against an IT test, Freelance exam, Employment assessment, online training, or Job interview.

Quizack gives you every medium for the sake of comprehensive study. If you love to take online practice sessions, you can follow testing tools. If you prefer offline study, you can follow Access MCQ PDF. If you need something handy for the sake of study, you can follow us via App. in short, Quizack offers you various topics, multiple mediums, and to-the-point questions. You are urged to promote this thing via social media and invite your friends.

Quizack does not want anything irrelevant, not even a single word. If you think, something is missing or wrong. You are requested to report that immediately through the contact us page.

It is a Quizack mission to compensate the professionals. If you have years of knowledge about this specific subject, you are welcome to contribute by adding some MCQs or Access interview questions. Likewise, Quizack will acknowledge your skills by declaring your name among its contributors.