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

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

You can do it
  1. Which is not a view to display a table in Access?
  2. After entering all fields required for a table, if you realize that the third field is not needed, how…
  3. The task of arranging data in order is called
  4. While creating relationship, when you drag a field of a field to drop into another table the mouse pointer…
  5. If I create Student field in Fees table to store student_id of Students table, then this Student field…
  6. Which of the following is not a database object?
  7. An Access database object that is used to enter, view or edit records
  8. A composite key is
  9. To create primary key for a table when in design view
  10. When creating a new table which method can be used to choose fields from standard databases and tables
  11. Collection of related records in a database is known as
  12. Which of the following creates a drop down list of values to choose from a list?
  13. In table design view, which key can be used to switch between the field names and properties panels?
  14. We can remove a relationship defined between two tables by
  15. It is a database object to view, change, and analyze data in different ways
  16. Which of the following database object hold data?
  17. Queries in Access can be used as
  18. In one-to-many relationship the table in one side is called _______ and on many side is called _______
  19. A __ name must be unique within a database
  20. You can set a controls border type to make the border invisible.
  21. To create relationship between two tables
  22. Each record is constituted by a number of individual data items which are called
  23. The size of a field with Number data type can not be
  24. You can automatically include all of the field in a table in a query by___ a strike that appear list…
  25. Which of the field has width 8 bytes?
  26. Two tables can be linked with relationship so that the data integrity can be enforced. Where can you…
  27. We can remove a relationship defined between two tables by
  28. To create queries in Access
  29. Which of the following is a method to create a new table in MS Access?
  30. Which of the following may not be a database?