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. The two form layout types will display multiple records at one time are tabular and___
  2. To duplicate a controls formatting you can use___
  3. We can remove a relationship defined between two tables by
  4. How can you define a field so that when entering data for that field it will display ****** instead…
  5. In one-to-many relationship the table in one side is called _______ and on many side is called _______
  6. The command center of access file that appears when you create or open the MS Access database file.
  7. To create relationship between two tables
  8. How can you link a table with another so that a field in current table will display values in drop down…
  9. Which of the following is not a field type in Access
  10. Which of the following database object produces the final result to present?
  11. It is a query that when run displays its own dialog box prompting you for information, such as
  12. Every table in relational database contain a field or combination of fields that can uniquely identify…
  13. To create queries in Access
  14. What do you mean by one to many relationship between Student and Class table?
  15. Which of the following creates a drop down list of values to choose from a list?
  16. Unlike text data type, this can store up to maximum of 65, 535 characters.
  17. The size of a field with Number data type can not be
  18. The default and maximum size of text field in Access
  19. It is used to calculate and restructure data for easier analysis of your data. It calculates the sum,
  20. To create primary key for a table when in design view
  21. Which of the following database object hold data?
  22. The__ button on the tool box display data from a related table
  23. When entering field name, how many characters you can type in maximum?
  24. Which of the field has width 8 bytes?
  25. The___ operator will cause a record to be selected only if two or more conditions are satisfied
  26. A small button with three dots usually displayed at the right of field properties box
  27. A __ name must be unique within a database
  28. What is the maximum length a text field can be?
  29. The database language that allows you to access or maintain data in a database
  30. The complete information about an entity in a database is called