Interview questions

Microsoft Access interview questions

47 questions. Tap “Show answer” to check yourself.

  1. Name at least six file extensions of Microsoft Access?

  2. Detail about how you can import a sharepoint list?

  3. Explain about managing data tasks?

  4. State some criteria`s and their effects on a ms access database?

  5. State the criteria which a trusted publisher should meet before adding him?

  6. How can I open an MS Access database that has been converted to a current version?

  7. I am using the Switchboard Manager in MS Access. I am getting an error message "There was an error executing this command."

  8. When I assigned a primary key to my table in Microsoft Access, I was expecting my data to be sorted. Am I using the correct procedure?

  9. What is the maximum size of a database that can be opened in Microsoft Access?

  10. What is the size limitation of an Access database?

  11. Explain about creating a report tool by using the report tool and report wizard?

  12. How do you create an append query?

  13. Explain about the protection features present in MS Access?

  14. What happens if the both source and destination are named the same?

  15. What is a template?

  16. How do you import data from another access database?

  17. Explain about Microsoft access?

  18. How many Sub Reports added in One MainReport?

  19. Would you like to easily automate your MS Access database through menu driven selections?

  20. What format should my database be saved in to allow different versions of Microsoft Access to open the database?

  21. What is Replication Manager?

  22. State some of the uses append query?

  23. Explain the steps for this message "could not delete from the specified tables"?

  24. Can I use ExecuteReader() in if-else. Because in my code which is in C# ExecuteReader() in if is executing and in else it is not please tell me the solution.

  25. In MS Access, the long and short date option does not show 4 digit years. How do I achieve the mm/dd/yyyy format?

  26. Explain about the various features present in MS Access?

  27. How does Microsoft Access database recover free space?

  28. State some of the uses of MS Access?

  29. Explain about relationships and look up fields?

  30. How to insert and retrive images on MSACCESS using java

Companies that ask Microsoft Access questions