Microsoft Access Interview Questions

  1. What is Replication Manager?
  2. Explain about Microsoft access?
  3. Explain about managing data tasks?
  4. State some of the uses of MS Access?
  5. How many commands use in access?
  6. How do you create an append query?
  7. State some of the uses append query?
  8. How to migrate the MS access to Oracle?
  9. Explain about relationships and look up fields?
  10. What is the size limitation of an Access database?
  11. How do you remodel an existing Access database?
  12. Detail about how you can import a share point list?
  13. Name at least six file extensions of Microsoft Access?
  14. How do you import data from another access database?
  15. How do you add a developer to a trusted publishers list?
  16. How does Microsoft Access database recover free space?
  17. Explain about the various features present in MS Access?
  18. Explain about the protection features present in MS Access?
  19. How to share a Microsoft Access database across a network?
  20. State some criteria`s and their effects on a ms access database?
  21. How to run a query using macro in Microsoft Access database?
  22. What are the query types available in Microsoft Access database?
  23. How can one get the deleted records in Microsoft Access database?
  24. What happens if the both source and destination are named the same?
  25. What are the advantages of an access database over an oracle database?
  26. What are the steps to be taken for repairing a corrupted Design Master?
  27. How can Parameters be added to a query in Microsoft Access database?
  28. What are the ways to ways to run queries in Microsoft Access database?
  29. State the criteria which a trusted publisher should meet before adding him?
  30. How can one implement the concept of triggers in Microsoft Access database?
  31. Explain the steps for this message “could not delete from the specified tables”?
  32. Explain about creating a report tool by using the report tool and report wizard?
  33. What is the maximum size of a database that can be opened in Microsoft Access?
  34. What is the way for summing up a column in a table in Microsoft Access database?
  35. What are the objects present in the table MsysObjects of Microsoft Access database?
  36. How can I open an MS Access database that has been converted to a current version?
  37. What are the steps to be taken for improving performance in Microsoft Access database?
  38. Would you like to easily automate your MS Access database through menu driven selections?
  39. What are the differences between Table queries and Select queries in Microsoft Access database?
  40. What is the approach or method for implementing user-level security with replication in Microsoft Access database?