Home

To achieve AND effect when you are entering criteria in a query design window

A. write criteria values vertically one in a row

B. write criteria values horizontally

C. Write criteria values in same field separated with AND

D. Write criteria values in same field separated with &

You can do it
  1. When entering field name, how many characters you can type in maximum?
  2. Which of the following statement is true
  3. After entering all fields required for a table, if you realize that the third field is not needed, how…
  4. Which of the following may not be a database?
  5. We can remove a relationship defined between two tables by
  6. The size of Yes No field is always
  7. An Access database object that is used to enter, view or edit records
  8. If you write criteria values vertically (one in a row) it will mean
  9. A __________ enables you to view data from a table based on a specific criterion
  10. What is the difference between Open and Open Exclusively?
  11. A search value can be an exact value or it can be
  12. A composite key is
  13. When a picture or other graphic image is placed in the report header section it will appear____
  14. The___ operator will cause a record to be selected only if two or more conditions are satisfied
  15. Which field type will you select when creating a new table if you require to enter long text in that…
  16. While creating relationship, when you drag a field of a field to drop into another table the mouse pointer…
  17. What happens when you release mouse pointer after you drop the primary key of a table into foreign key…
  18. A database language concerned with the definition of the whole database structure and schema is ________
  19. Collection of related records in a database is known as
  20. In table design view, which key can be used to switch between the field names and properties panels?
  21. Unlike text data type, this can store up to maximum of 65, 535 characters.
  22. This key uniquely identifies each record
  23. A __ name must be unique within a database
  24. A primary key in any table has the properties
  25. A database object in MS Access that stores a question about the data in database?
  26. We can remove a relationship defined between two tables by
  27. What is the maximum length a text field can be?
  28. To duplicate a controls formatting you can use___
  29. Each record is constituted by a number of individual data items which are called
  30. Which of the following database object hold data?