Home

The___ operator will cause a record to be selected only if two or more conditions are satisfied

A. Or

B. If or

C. Range

D. And

Correct Answer : D.


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. It is a sign or symbol that specifies, operator, and values that produce a result
  2. It is used to calculate and restructure data for easier analysis of your data. It calculates the sum,
  3. This option allows you to build a new table by entering data directly into the datasheet.
  4. Both conditions display on the same row in the design grid when ___operator is in use
  5. The third stage in designing a database is when we analyze our tables more closely and create a ___________…
  6. Which of the following statement is true
  7. If I create Student field in Fees table to store student_id of Students table, then this Student field…
  8. DCL provides commands to perform actions like
  9. Which is not a view to display a table in Access?
  10. The size of a field with Number data type can not be
  11. A database language concerned with the definition of the whole database structure and schema is ________
  12. Query design window has two parts. The upper part shows
  13. Which of the following expresses correct order?
  14. It is an association established between common fields of two tables.
  15. An Access database object that is used to enter, view or edit records
  16. This key uniquely identifies each record
  17. This data type allows alphanumeric characters and special symbols.
  18. Which of the field has width 8 bytes?
  19. When creating a new table which method can be used to choose fields from standard databases and tables
  20. What do you mean by one to many relationship between Student and Class table?
  21. Queries in Access can be used as
  22. To create queries in Access
  23. It is a query that when run displays its own dialog box prompting you for information, such as
  24. In table design view what are the first column of buttons used for
  25. The two form layout types will display multiple records at one time are tabular and___
  26. While creating relationship, when you drag a field of a field to drop into another table the mouse pointer…
  27. After entering all fields required for a table, if you realize that the third field is not needed, how…
  28. In table design view, which key can be used to switch between the field names and properties panels?
  29. A search value can be an exact value or it can be
  30. The key uniquely identifies each record in a table.