Reference no: EM132836499

Question 1. What is Database Management System (DBMS)?

Question 2. What do you mean by data processing?

Question 3. List some database applications.

Question 4. What is MS-Access?

Question 5. What is Database?

Question 6. What is the extension of Access database file?

Question 7. What is relational database?

Question 8. What is a key field?

Question 9. What is primary key?

Question 10. What do you mean by foreign key?

Question 11. What are the elements of a database?

Question 12. What is a table?

Question 13. What is a field?

Question 14. What is a record?

Question 15. What is a query?

Question 16. What is a form?

Question 17. What is a report?

Question 18. What are the differences between a form and a report?

Question 19. What is a macro?

Question 20. What is a module?

Question 21. What are the different Number field types in Access?

Question 22. What do you mean by data processing?

Question 23. What are the ten field types in Access?

Question 24. What are the two types of data processing techniques?

Question 25. What is batch processing or offline processing?

Question 26. What is online processing or real-time processing?

Question 27. Who introduced Relational Database Model?

Question 28. What are the front-end and back-end components of a database?

Question 29. What are link tables?

Question 30. What are the objects of Access Database?

Question 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.

Question 32. What is datasheet view?

Question 33. What is a sub-form?

Question 34. What do you mean by filter?

Question 35. What is Lookup Field?

Question 36. What are the three key components of relational database design?

Question 37. Define entity:

Question 38. What are attributes?

Question 39. Define relationship.

Question 40. How many relationships are possible between two tables or entities?

Question 41. What do you understand by one-to-one relationship between two tables?

Question 42. Clarify one-to-many relationship between two tables.

Question 43. Define many-to-many relationship.

Question 44. What is identifying relationship?

Question 45. What are the advantages of normalizing database design?

Question 46. What are the different ways to add a table in Access database?

Question 47. What do you mean by default value for a field in Access table?

Question 48. What is 'Required' property of a field?

Question 49. What do the following formatting symbols mean in Format properties of fields? , @"NULL", @"Not entered", $ 14 55. What is the use of Validation Rule property of a field?

Question 50. What is 'Input Mask' field property?

Question 51. What is the use of Validation Text property of a field?

Question 52. How can you import a table created in another database or other file formats?

Question 53. How can you view the entire data of memo field?

Question 54. What is the easiest way to define a relationship between two tables?

Question 55. What do you understand by Referential Integrity in Relationships?

Question 56. What is the effect of enabling 'Cascade Delete Related Fields' when defining relationship?

Question 57. What is the effect of enabling 'Cascade Update Related Fields' when defining relationship

Question 58. What is an AutoForm?

Question 59. What are the three different forms of auto forms?

Question 60. What is the use of the form design window?

Question 61. What are the ways to create a new form?

Question 62. How can you show only selected records with a form?

Question 63. What is Dynaset?

Question 64. What are the different useful tools available in Design Window to help you with your design work?

Question 65. What is a Field List tool available in Design Window?

Question 66. What is the difference between using a filter and a query to find records?

Question 67. What are the different options that you can use to filter records?

Question 68. How can you apply Filter For option to filter records based on a value of a field?

Question 69. Explain Query.

Question 70. What is an Auto Report?

Question 71. Explain Query Parameters.

Question 72. For what an append query be used?

Question 73. What is a crosstab query wizard?

Question 74. What is the advantage of Report Wizard over an Auto Report?

Question 75. Why Report Design View is important?

Question 76. What is the use of Label Wizard?

Question 77. What are the different auto reports available in Access?

Question 78. What are the different sections of a report?

Question 79. What are some of the database object operations that a user must know?

Question 80. What is a macro?

Question 81. What is the difference between Print Preview and Layout Preview?

Question 82. What are command buttons? How to use command buttons?