Microsoft Access Questions and Answers
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
61. Which of the following type s of queries re action queries?
- Update Queries
- Crosstab Queries
- Parameter Queries
- Append Queries
62. A query prompts a user for a data and then displays only records that contain the specified date. The type of a query is this
- A parameter query
- A crosstab query
- An update query
- An action query
63. Which of the following is NOT A report section ?
- Reprt Header section
- Summary section
- Page header section
- Details section
64. You can display a database object in design view by
- Opening the database object and clicking the view button on the toolbar
- Selecting the database object and clicking the design button on the database window
- Selecting the database object and press Ctrl + V
- Opening the database object and selection Tools.Design view
65. If you are creating a cross tab query, what must table you are querying contain ?
- Lots of confusing information
- More than 100 records
- At least one field
- None of the above
66. A query summarizes information in grid, organized by regions and months. Which type of query is this ?
- A cross tab query
- An update query
- A parameter query
- An action query
67. What type of text box does the toolbox and to a form ?
- Unbound
- Bound
- Rebound
- Calculated
68. The filter by section feature allows you to filter
- Those records that match an entity in a field
- Records based on a criterion you specify
- Records that meet any of several criteria you specify
- All of above
69. What is the memo data type field used for ?
- To add table
- To store objects created in other programs
- For long text entries
- For shout text entries of no more than 255 characters
70. What is the purpose of the description column in Table Design View ?
- To define the data type applied to each field within the table
- To describe the data that should be entered in each field
- To entere lookup data that the field should refer to
- None of the above