DBMS (MS-Access)

  1. What is Database?
    • Database is a collection of interrelated data/information used to represent information to an information system. Read More... 
  2. What is data and information?
  3. What is database file?
  4. What are the objectives of database systems?
  5. What is Database Management System (DBMS)?
  6. What are the advantages and disadvantages of DBMS? / What are the features of DBMS.
  7. What are the differences between Database and DBMS?
  8. What is Relational Database Management System (RDBMS)?
  9. What is Ms-Access? What are objects of MS-Access?
  10. What are the features of Ms-Access?
  11. What is data type? What are the different data types supported by Ms-Access?
  12. What is table? What is its purpose? In how many ways table can be created?
  13. What is table design view window? What are the two types of panes in table design view window?
  14. What is a field? What is field size?
  15. What is record?
  16. What is a field name?
  17. What is query? What are its types?
  18. What are the advantages/uses of query?
  19. What is select query? What are its uses?
  20. What is action query? What are its types?
  21. What is parameter query?
  22. What is crosstab query?
  23. What is an append query?
  24. What are advantages of append query?
  25. What is an update query?
  26. What is delete query?
  27. What is make table query?
  28. What is primary key? What is the advantage of primary key? 
  29. What is foreign key? What is the use of foreign key? 
  30. What is composite or compound key?
  31. What is form? What are the advantages of form in MS-Access?
  32. What is report? What is the purpose of report?
  33. What is wizard? What are its uses?
  34. What is redundant data? or What is data redundancy?
  35. What is data processing?
  36. What are the advantages of form over table?
  37. What are the differences between form and report?
  38. What is data sorting or sorting?
  39. What is data filter or filtering? 
  40. What are the methods for filtering?
  41. What are the differences between query and sorting? 
  42. What are the differences between query and filtering?
  43. What is data validation? What is its importance? 
  44. What is validation rule and validation text? 
  45. What is normalization?
  46. What is referential integrity?
  47. What is formatting table?  
  48. What is Look Up fields?
  49. Why table or query is needed to create form?
  50. What are the different controls that can be used within a form?
  51. What are the differences between database and table?
  52. What is the advantage of sorted data over unsorted data?
  53. What are the differences between "cascade update related fields" and "cascade update related records"?
  54. What is an input mask?
  55. What is an index? Write the importance of creating indexes of table.
  56. What is relationship? What are its types?
  57. What is one-to-one relation? 
  58. What is many-to-many relation?