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 creating a new table which method can be used to choose fields from standard databases and tables
  2. This key uniquely identifies each record
  3. Which field type will you select when creating a new table if you require to enter long text in that…
  4. To sort records in a table
  5. You can set a controls border type to make the border invisible.
  6. Which of the following is not a database object?
  7. The size of a field with Number data type can not be
  8. Which of the following statement is true
  9. The__ button on the tool box display data from a related table
  10. Which of the following statement is true?
  11. While creating relationship, when you drag a field of a field to drop into another table the mouse pointer…
  12. The task of arranging data in order is called
  13. It is most common type of query. It retrieves records from one or more tables and then displays the
  14. To duplicate a controls formatting you can use___
  15. A __ name must be unique within a database
  16. Which of the following is a method to create a new table in MS Access?
  17. Which of the following expresses correct order?
  18. The database language that allows you to access or maintain data in a database
  19. What is a form in MS Access
  20. A database language concerned with the definition of the whole database structure and schema is ________
  21. The expression builder is an access tool that controls an expression___ for entering an expression
  22. What are the columns in a Microsoft Access table called?
  23. After entering all fields required for a table, if you realize that the third field is not needed, how…
  24. A part of database that stores only one type of data is
  25. In table design view, which key can be used to switch between the field names and properties panels?
  26. To create a new table, in which method you dont need to specify the field type and size?
  27. It is a database object to view, change, and analyze data in different ways
  28. Which of the following creates a drop down list of values to choose from a list?
  29. Cascade update option
  30. In a database table, the category of information is called ____________