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
71. What is the propose to a sub datasheet?
- To provide a hierachial view of related tables or queries in a single window
- To display grouped data in a report
- To display summarized data.
- All of the above
72. Which of the following is not a selection technique ?
- To select a word, double click the word
- To select an entire table click the empty bosx to the left of the field names
- To select row, click the record selector box to the left of the row
- to select a column, double click anywhere in the column
73. How can you display Pivt Table report summary data in a currency format ?
- Use custom calculation
- Type in the currency symbol
- Modify the field settings
- None of the above
74. What method can you use to add a new table to your database ?
- Use Design View to create a table
- Enter data directly by using a datasheet
- Both of above
- All of the above
75. Which action do you use in a a macro to automatically send a report shanshot in an email message ?
- Use mail
- Send object
- Run macro
- All of the above
76. How can you display sales grouped by country, region and salesperson, all at the same time ?
- Use the Sort Descending Command.
- use the Pivot table view command
- Use the find command on specified groups
- All of above
77. The Checking operation performed on input dta is called the
- Validation of data
- Verification of data
- Cross check
- Control of data
78. A form defines
- Where data is placed on the screen
- The width of each field
- Both (A) and (B)
- All of the above
79. The following method you can use to add a new table to your database
- Use Design View to create a table
- Enter data directly by using a datasheet
- Both of above
- All of the above
80. The following you can use in a macro to automatically send a report snapshot in an email message
- Use mail
- Send object
- Run macro
- All of the above