Home

A __________ enables you to view data from a table based on a specific criterion

A. Form

B. Query

C. Macro

D. Report

Correct Answer : B.


Download Objective type questions of Microsoft Access PDF

Visit our PDF store

Get all objective type questions of Microsoft Access MCQ

You can do it
  1. A database object in MS Access that stores a question about the data in database?
  2. Cascade update option
  3. The size of Yes No field is always
  4. Unlike text data type, this can store up to maximum of 65, 535 characters.
  5. A database language concerned with the definition of the whole database structure and schema is ________
  6. Both conditions display on the same row in the design grid when ___operator is in use
  7. Which of the following store command to retrieve data from database?
  8. Which of the following is NOT a type of Microsoft Access database object?
  9. After entering all fields required for a table, if you realize that the third field is not needed, how…
  10. Which field type will you select when creating a new table if you require to enter long text in that…
  11. This is the stage in database design where one gathers and lists all the necessary fields for the database…
  12. Query design window has two parts. The upper part shows
  13. A part of database that stores only one type of data is
  14. Which of the following can be an example of a database?
  15. To create primary key for a table when in design view
  16. What do you mean by one to many relationship between Student and Class table?
  17. The size of a field with Number data type can not be
  18. DCL provides commands to perform actions like
  19. In table design view, which key can be used to switch between the field names and properties panels?
  20. The key uniquely identifies each record in a table.
  21. What happens when you release mouse pointer after you drop the primary key of a table into foreign key…
  22. Which of the following creates a drop down list of values to choose from a list?
  23. It is a query that when run displays its own dialog box prompting you for information, such as
  24. Which of the following is not a field type in Access
  25. To achieve AND effect when you are entering criteria in a query design window
  26. The task of arranging data in order is called
  27. Every table in relational database contain a field or combination of fields that can uniquely identify…
  28. In one-to-many relationship the table in one side is called _______ and on many side is called _______
  29. What does the show check box in query design window indicate
  30. A __ name must be unique within a database