MCQ Sets

MS Access MCQ Questions Set 01

by Leave a Comment

This is MS Access MCQ Questions Set 01. The set contains 20 multiple questions with four possible answers. However, there is one and only one correct answer for each question.

To attempt the quiz, please select the correct answer by marking the respective radio button and click 'Show Result' button.

Please allow a few moments for the page to update with the results.

MS Access MCQ Questions Set 01


ms access mcq questions banner logo

MS Access Multiple Choice Questions

1. If you write criteria values vertically (one in a row) it will mean
 
 
 
 
2. To assign a macro to an event, users need to open the form in Design View.
 
 
 
 
3. This form displays the field name labels down the left side of the column, with the data for each field just to the right of its corresponding label.
 
 
 
 
4. The size of Yes No field is always
 
 
 
 
5. A small button with three dots usually displayed at the right of field properties box
 
 
 
 
6. This key uniquely identifies each record
 
 
 
 
7. Saving a database in access is done
 
 
 
 
8. Which field type can store photos?
 
 
 
 
9. To create relationship between two tables
 
 
 
 
10. In table design view, which key can be used to switch between the field names and properties panels?
 
 
 
 
11. If a piece of data is stored in two places in the database, then a
 
 
 
 
12. In this form, a single record may appear in multiple rows in the form window in order to fully display the field name label and data.
 
 
 
 
13. The insertion point looks like a(n) ____.
 
 
 
 
14. A __________ enables you to view data from a table based on a specific criterion
 
 
 
 
15. Changing the order of this in the query datasheet does not affect the field order in the table.
 
 
 
 
16. A __________ enables you to view data from a table based on a specific criterion
 
 
 
 
17. In access, the best types of queries to use for data analysis are:
 
 
 
 
18. Which is not an option for customizing a datasheet window?
 
 
 
 
19. __________ is used to build ?intuitive? queries.
 
 
 
 
20. The command center of? access file that appears when you create or open the MS Access database file.
 
 
 
 

 

MS Access MCQ Questions

This quiz contains Microsoft Access Database Questions that are most probable for any competitive exams. These Access Database Questions cover various topic from MS Access 2003, Access 2007 and 2010.

For MS Access Interview Questions please visit Download menu to find an eBook (pdf file). The eBook contains short explanation to each of important concepts in Database and MS Access. The questions ranges from basic introductions to advanced concepts.

Related to: Microsoft Access Quiz Answers, Microsoft Access Answers

Find other quizzes on Database & Access

MS Access MCQ Questions Quiz 02MS Access MCQ Questions Set 03

[youtube=https://www.youtube.com/watch?v=3e-wDKi5yuM]
https://www.youtube.com/watch?v=3e-wDKi5yuM

Leave a Reply

Your email address will not be published. Required fields are marked *

Recent Comments