Home

To create queries in Access

A. You can drag and drop fields on query builders

B. you can type the SQL command in SQL view

C. You can use query wizard or design view

D. All of above

Share this question with your friends

Correct Answer : D.


Download Objective type questions of Microsoft Access PDF

Get all objective type questions of Microsoft Access MCQ

Related Questions

  1. Two tables can be linked with relationship so that the data integrity can be enforced. Where can you…
  2. To sort records in a table
  3. You can automatically include all of the field in a table in a query by___ a strike that appear list…
  4. Unlike text data type, this can store up to maximum of 65, 535 characters.
  5. The___ operator will cause a record to be selected only if two or more conditions are satisfied
  6. The__ button on the tool box display data from a related table
  7. Which of the following is not a database object in MS Access?
  8. We can remove a relationship defined between two tables by
  9. A database language concerned with the definition of the whole database structure and schema is ________
  10. The command center of access file that appears when you create or open the MS Access database file.
  11. If you need to edit a relationship
  12. Which of the following is not a type of relationship that can be applied in Access database
  13. Which of the following is not a field type in Access
  14. The two form layout types will display multiple records at one time are tabular and___
  15. Query design window has two parts. The upper part shows
  16. To duplicate a controls formatting you can use___
  17. Which of the following may not be a database?
  18. If you write criteria values vertically (one in a row) it will mean
  19. It is used to calculate and restructure data for easier analysis of your data. It calculates the sum,
  20. When a picture or other graphic image is placed in the report header section it will appear____
  21. Queries in Access can be used as
  22. Following is not a database model
  23. A search value can be an exact value or it can be
  24. A primary key in any table has the properties
  25. DCL provides commands to perform actions like
  26. The size of a field with Number data type can not be
  27. The size of Yes No field is always
  28. What do you mean by one to many relationship between Student and Class table?
  29. To create queries in Access
  30. It is an association established between common fields of two tables.

Please do not use chat terms. Example: avoid using "grt" instead of "great".

Submit
Load More..

Also checkout these categories

Phylum - Echinodermata MCQ Clock MCQ Plants Physiology MCQ Order & Ranking MCQ Cloze Test MCQ Chain Rule MCQ Machine Input Mi-set 2 MCQ XML Markup MCQ Rearrangement Set 7 MCQ Rearrangement Set 6 MCQ Direction MCQ Electro-Chemistry MCQ