Microsoft Access Questions and Answers

Take Exam

DBMS Microsoft Access programming questions and answers test your knowledge of relational database management and practical data handling. This topic covers database creation, query design, relationships, normalization, and SQL implementation in Microsoft Access. Many placement companies like TCS, CTS, and Capgemini include questions on Access to assess candidates’ understanding of data modeling and query logic. Practicing these programming questions and answers helps students develop the skill to manage and manipulate data efficiently. Learn through real-world examples, SQL query exercises, and short MCQs to strengthen your database fundamentals before interviews and competitive exams.

Microsoft Access

Showing 10 of 94 questions

31. In Access to find the next occurrence of the text specified in the Find and Replace dialog box when the dialog box is closed (Datasheet view and form view only)

  • CTRL + F
  • CTRL + H
  • SHIFT + F4
  • None of these
Show Answer Report

32. In Access to open the Find tab in the Find and Replace dialog box (datasheet view and form view only)

  • CTRL + F
  • CTRL + H
  • SHIFT + F4
  • None of these
Show Answer Report

33. In Access to open the Replace tab in the Find and Replace dialog box (Datasheet view and form view only)

  • CTRL + F
  • CTRL + H
  • SHIFT + F4
  • None of these
Show Answer Report

34. In Access to switch between Edit mode (with insertion point display(D)

  • F2
  • F4
  • F5
  • F6
Show Answer Report

35. In Access to switch to the property sheet (Design view in forms  and reports in both Access database and Access projects)

  • F2
  • F4
  • F5
  • F6
Show Answer Report

36. In Access to switch between the upper and lower portions of a window (Design view of queries, and the Advanced Filter Sort window)

  • F2
  • F4
  • F5
  • F6
Show Answer Report

37. In Access to switch to Form view from form Design view

  • F2
  • F4
  • F5
  • F6
Show Answer Report

38. In Access press to Cycle through the field grid, field properties, Navigation pane, access keys in the Keyboard Access System, Zoom controls, and the security bar (Design view of tables)

  • F6
  • F7
  • F8
  • None of these
Show Answer Report

39. In Access press to open the Choose Builder dialog box (Design view window of forms and reports)

  • F6
  • F7
  • F8
  • None of these
Show Answer Report

40. In Access press to Open the Visual Basic Editor from a selected property in the property sheet for a form or report

  • F6
  • F7
  • F8
  • None of these
Show Answer Report
Questions and Answers for Competitive Exams Various Entrance Test