Home

It is a query that when run displays its own dialog box prompting you for information, such as

A. Select

B. crosstab

C. Parameter

D. Append

You can do it
  1. In a database table, the category of information is called ____________
  2. Which field type can store photos?
  3. A search value can be an exact value or it can be
  4. What is the difference between Open and Open Exclusively?
  5. When creating a new table which method can be used to choose fields from standard databases and tables
  6. Database Management Systems are featured with:
  7. If you write criteria values vertically (one in a row) it will mean
  8. In table design view, which key can be used to switch between the field names and properties panels?
  9. DCL provides commands to perform actions like
  10. What are the columns in a Microsoft Access table called?
  11. In one-to-many relationship the table in one side is called _______ and on many side is called _______
  12. How can you link a table with another so that a field in current table will display values in drop down…
  13. To create queries in Access
  14. Unlike text data type, this can store up to maximum of 65, 535 characters.
  15. The size of a field with Number data type can not be
  16. After entering all fields required for a table, if you realize that the third field is not needed, how…
  17. It is used to calculate and restructure data for easier analysis of your data. It calculates the sum,
  18. Which of the following expresses correct order?
  19. What do you mean by one to many relationship between Student and Class table?
  20. A __________ enables you to view data from a table based on a specific criterion
  21. To sort records in a table
  22. Queries in Access can be used as
  23. The expression builder is an access tool that controls an expression___ for entering an expression
  24. Collection of related records in a database is known as
  25. This option allows you to build a new table by entering data directly into the datasheet.
  26. A __ name must be unique within a database
  27. This is the stage in database design where one gathers and lists all the necessary fields for the database…
  28. If I create Student field in Fees table to store student_id of Students table, then this Student field…
  29. The two form layout types will display multiple records at one time are tabular and___
  30. To create primary key for a table when in design view