1. What is data?
2. Which of the following is unstructured data?
3. Which type of data is partially organized, such as XML or JSON files?
4. What is a database?
5. Which of the following is NOT a characteristic of a database?
6. Relational databases store data in:
7. Which type of database is best for big data applications?
8. A DBMS is:
9. Which of the following is NOT a function of a DBMS?
10. Which function of a DBMS ensures that multiple users can access data simultaneously without conflicts?
11. Which of the following is an example of a NoSQL database?
12. Data independence in a DBMS means:
13. One of the benefits of a DBMS is reduced redundancy. What does this mean?
14. Which of the following is a key function of a DBMS for maintaining data integrity in case of system failures?
15. Microsoft SQL Server is an example of:
16. Tables in a database store data in a structured format using:
17. What is a primary key in a table?
18. Foreign keys are used to:
19. What is the main purpose of forms in a database?
20. Which of the following is NOT a type of form?
21. Select queries are used to:
22. Action queries are used to:
23. What is a parameter query?
24. The primary function of macros in a DBMS is to:
25. Single Action Macros are designed to:
26. Which of the following is an example of a compound macro?
27. What is a benefit of using queries in a database?
28. Validation rules in forms help to:
29. Rows in a table represent:
30. Which of the following is NOT a component of a form?
31. A record in a database table is:
32. Which of the following is NOT part of a record structure?
33. In a one-to-one (1:1) relationship, each record in Table A:
34. A one-to-many (1:M) relationship means:
35. A many-to-many (M:M) relationship is usually implemented using:
36. Indexing in a database is used to:
37. A composite index is created:
38. A unique index:
39. A primary key:
40. A foreign key is used to:
41. A composite key:
42. What is the primary purpose of indexing in a database?
43. A unique key is different from a primary key because:
44. In a many-to-many relationship between students and courses, a composite key might consist of:
45. A foreign key:
46. What is the primary purpose of Microsoft Access?
47. Which of the following applications is NOT part of the Microsoft Office suite?
48. What is a key benefit of MS Access for small to medium-sized organizations?
49. Tables in MS Access are used to:
50. Which component of MS Access is used for data entry and modification?
51. In MS Access, queries are used to:
52. Forms in MS Access:
53. Macros in MS Access are used to:
54. Reports in MS Access are mainly used to:
55. One of the key features of MS Access is:
56. MS Access is particularly useful for:
57. Which of the following is NOT a component of MS Access?
58. What makes MS Access an excellent choice for personal projects?
59. Which of the following is a use case where MS Access might be helpful?
60. Which of the following is NOT a benefit of using MS Access?
61. Which data type in MS Access can store alphanumeric data with a maximum length of 255 characters?
62. What is the maximum length of a Long Text field in MS Access?
63. Which data type is specifically designed for storing monetary values in MS Access?
64. What is the range of values that the Date/Time data type can store in MS Access?
65. What type of data does the Lookup Wizard data type in MS Access allow users to select?
66. What is the first step in creating a table using the Table Design View in MS Access?
67. How can you add a new field to an existing table in Design View?
68. What is the effect of deleting a table in MS Access?
69. Which of the following is NOT a method to format tables in MS Access?
70. To enforce a specific format for data entry in a field, which feature would you use?
71. Which data type in MS Access is used to store alphanumeric data with a maximum length of 255 characters?
72. What is the maximum storage capacity for the Currency data type in MS Access?
73. Which of the following data types allows users to attach files directly to a record?
74. What property is used to enforce a specific format for data entry in MS Access?
75. In which scenario would you use the Lookup Wizard data type?
76. How can you create a new table using the Table Design View?
77. To delete a field from a table in Design View, what must you do?
78. What is the purpose of setting a field's "Required" property to "Yes"?
69. What does conditional formatting in MS Access allow you to do?
70. Which method allows you to create a query by selecting specific tables and fields visually?
71. What happens when you delete a query in MS Access?
72. How can you filter results in a query to show only records that meet specific criteria?
73. If you want to count the number of records in a query, which option should you use?
74. Which of the following is a common use case for a simple query?
75. What is the primary purpose of forms in MS Access?
76. Which method allows you to create a form by choosing a layout and style?
77. In Design View, which tab do you use to add controls like text boxes and labels to a form?
78. To modify an existing form, what is the first step?
79. What happens when you delete a form in MS Access?
80. Reports in MS Access are primarily used for:
81. Which method would you use to group and sort data when creating a report?
82. To modify an existing report, which option should you choose in the Navigation Pane?
83. What is the purpose of macros in MS Access?
84. Which steps are required to attach a macro to a control on a form?
85. To delete a macro, what is the first step?
86. What should you do to save a form after making changes in Design View?
