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

91. You can keep the sum([Sales]) to calculate the totals for each month in

  • the report footer section
  • the page footer section
  • the month group footer section
  • the summary section
Show Answer Report

92. The procedure for selecting multiple controls on a report?

  • Hold down the shift key as you click each object that you want to select
  • If the controls are aligned along a horizontal or vertical line, click the horizontal or vertical ruler above or to the left of the controls
  • Hold down the Ctrl key as you click each object that you want to select
  • All of these above are true
Show Answer Report

93. The following database object can you import from one Microsoft Access database to another?

  • Queries
  • Tables
  • Forms
  • All of the above
Show Answer Report

94. What field type is used to store picture in a table?

  • Memo
  • OLE
  • Hyperlink
  • None
Show Answer Report
Questions and Answers for Competitive Exams Various Entrance Test