Home

It is most common type of query. It retrieves records from one or more tables and then displays the

A. Parameter

B. Select

C. crosstab

D. All of above

You can do it
  1. A __ name must be unique within a database
  2. What is a form in MS Access
  3. If I create Student field in Fees table to store student_id of Students table, then this Student field…
  4. A search value can be an exact value or it can be
  5. Which of the field has width 8 bytes?
  6. You can automatically include all of the field in a table in a query by___ a strike that appear list…
  7. Which of the following is not a type of relationship that can be applied in Access database
  8. We can remove a relationship defined between two tables by
  9. The expression builder is an access tool that controls an expression___ for entering an expression
  10. To create primary key for a table when in design view
  11. Queries in Access can be used as
  12. If you need to edit a relationship
  13. It is an association established between common fields of two tables.
  14. While creating relationship, when you drag a field of a field to drop into another table the mouse pointer…
  15. The default and maximum size of text field in Access
  16. Which is not a view to display a table in Access?
  17. A primary key in any table has the properties
  18. Which of the following statement is true?
  19. When a picture or other graphic image is placed in the report header section it will appear____
  20. Query design window has two parts. The upper part shows
  21. Which of the following is not a database object in MS Access?
  22. In a database table, the category of information is called ____________
  23. The two form layout types will display multiple records at one time are tabular and___
  24. The size of a field with Number data type can not be
  25. Cascade update option
  26. This data type allows alphanumeric characters and special symbols.
  27. If you write criteria values vertically (one in a row) it will mean
  28. A __________ enables you to view data from a table based on a specific criterion
  29. Which of the following is a method to create a new table in MS Access?
  30. What happens when you release mouse pointer after you drop the primary key of a table into foreign key…