Database and MS Access Questions

Database and MS Access Questions – This can be quite confusing for the beginners to start preparing Database and MS Access for competitive questions. At the same time, many just wonder what would be the questions for interview from databases?

Here I collect some of the basic and intermediate level questions that can guide you the direction for your preparation.

I have offered sample answers for these questions and you can download it as PDF file.

Database & Access Questions

1. What is Database Management System (DBMS)?
2. What do you mean by data processing?
3. List some database applications.
4. What is MS-Access?
5. What is Database?
6. What is the extension of Access database file?
7. What is relational database?
8. What is a key field?
9. What is primary key?
10. What do you mean by foreign key?
11. What are the elements of a database?
12. What is a table?
13. What is a field?
14. What is a record?
15. What is a query?
16. What is a form?
17. What is a report?
18. What are the differences between a form and a report?
19. What is a macro?
20. What is a module?
21. What are the different Number field types in Access?
22. What do you mean by data processing?
23. What are the ten field types in Access?
24. What are the two types of data processing techniques?
25. What is batch processing or offline processing?
26. What is online processing or real-time processing?
27. Who introduced Relational Database Model?
28. What are the front-end and back-end components of a database?
29. What are link tables?
30. What are the objects of Access Database?
31. What is the meaning of following field properties? Field Size, Format, Input Mask, Caption, Decimal Places, Default Value, Validation Rule, Validation Text, Required, Allow Zero Length, Indexed.
32. What is datasheet view?
33. What is a sub-form?
34. What do you mean by filter?
35. What is Lookup Field?
36. What are the three key components of relational database design?
37. Define entity:
38. What are attributes?
39. Define relationship.
40. How many relationships are possible between two tables or entities?
41. What is cardinality?
42. What do you understand by one-to-one relationship between two tables?
43. Clarify one-to-many relationship between two tables.
44. Define many-to-many relationship.
45. What is identifying relationship?
46. What are the advantages of normalizing database design?
47. What are the E.F. Codd’s normal forms?
48. How is “no nulls” constraint implemented for an attribute?
49. How is a “no changes” constraint implemented for an attribute?
50. How is a “no duplicates” constraint implemented for an attribute?
51. What are the different ways to add a table in Access database?
52. What do the following formatting symbols mean in Format properties of fields? <,  >,   @”NULL”,  @”Not entered”,  $
53. What do you mean by default value for a field in Access table?
54. What is ‘Required’ property of a field?
55. What is ‘Input Mask’ field property?
56. What is the use of Validation Rule property of a field?
57. What is the use of Validation Text property of a field?
58. How can you import a table created in another database or other file formats?
59. How can you view the entire data of memo field?
60. What is the easiest way to define a relationship between two tables?
61. What do you understand by Referential Integrity in Relationships?
62. What is the effect of enabling ‘Cascade Delete Related Fields’ when defining relationship?
63. What is the effect of enabling ‘Cascade Update Related Fields’ when defining relationship?
64. What is a switchboard?
65. What is an AutoForm?
66. What are the three different forms of auto forms?
67. Each object on the form has its own property sheet. What are the different ways to evoke property sheet?
68. What is the form view?
69. What are controls? How to use them? Give examples for control.
70. What is the use of the form design window?
71. What are the ways to create a new form?
72. How can you show only selected records with a form?
73. What are the different useful tools available in Design Window to help you with your design work?
74. What is a Field List tool available in Design Window?
75. What is the difference between using a filter and a query to find records?
76. What are the different options that you can use to filter records?
77. How can you apply Filter For option to filter records based on a value of a field?
78. Explain Query.
79. What is Dynaset?
80. Explain Query Parameters.
81. For what an append query be used?
82. What is a crosstab query wizard?
83. What is an Auto Report?
84. What is the advantage of Report Wizard over an Auto Report?
85. Why Report Design View is important?
86. What is the use of Label Wizard?
87. What are the different auto reports available in Access?
88. What are the different sections of a report?
89. What is the difference between Print Preview and Layout Preview?
90. What are command buttons? How to use command buttons?
91. What is a macro?
92. What are some of the database object operations that a user must know?
93. What is a switchboard?

Answers:

Please check ‘Downloads’ menu to find the PDF file that contains the answers to these questions listed here.