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 &

Please do not use chat terms. Example: avoid using "grt" instead of "great".

You can do it
  1. Which field type can store photos?
  2. After entering all fields required for a table, if you realize that the third field is not needed, how…
  3. This key uniquely identifies each record
  4. The two form layout types will display multiple records at one time are tabular and___
  5. Unlike text data type, this can store up to maximum of 65, 535 characters.
  6. The key uniquely identifies each record in a table.
  7. If I create Student field in Fees table to store student_id of Students table, then this Student field…
  8. Following is not a database model
  9. What is a form in MS Access
  10. If you write criteria values vertically (one in a row) it will mean
  11. Which of the following is not a type of relationship that can be applied in Access database
  12. You can set a controls border type to make the border invisible.
  13. Which of the following statement is true
  14. Which of the following creates a drop down list of values to choose from a list?
  15. Which of the following is not a field type in Access
  16. Every table in relational database contain a field or combination of fields that can uniquely identify…
  17. To create relationship between two tables
  18. A database language concerned with the definition of the whole database structure and schema is ________
  19. To create a new table, in which method you dont need to specify the field type and size?
  20. The___ operator will cause a record to be selected only if two or more conditions are satisfied
  21. Microsoft Access is a
  22. If you need to edit a relationship
  23. Which of the following is not a database object?
  24. We can remove a relationship defined between two tables by
  25. It is most common type of query. It retrieves records from one or more tables and then displays the
  26. The database language that allows you to access or maintain data in a database
  27. To create primary key for a table when in design view
  28. This is the stage in database design where one gathers and lists all the necessary fields for the database…
  29. It is an association established between common fields of two tables.
  30. Two tables can be linked with relationship so that the data integrity can be enforced. Where can you…