Which of the following statements about criteria in a query is NOT true?

  1. Home

Question:
Which of the following statements about criteria in a query is NOT true?

1.Criteria can contain wildcard characters.

2. Criteria in a query selects or excludes certain records.

3.Criteria cannot be specified as an expression.

4.Multiple criteria can be specified using AND, OR, and relational operators.

Posted Date:-2021-02-19 15:14:11

More MCQS Questions and answers

  1. A(n) _____________ is dynamic mathematical calculation that displays a single value for a specific field.
  2. Referential integrity can be enforced if both _______________ belong to the same Microsoft Access database.
  3. The Search tool is best used when searching for ______ data.
  4. The ______ is a wild card that represents one or more characters.
  5. To apply an AutoFormat to an entire Form, what must you select first?
  6. What happens when a user selects a record in a form and presses Delete?
  7. When increasing the Control Padding, space is added where?
  8. Which Form tool creates a new form that show both a form and datasheet views?
  9. Which is NOT a method of creating a table?
  10. Which of the following database objects can have more than one Group Header/Footer section?
  11. Which of the following properties identifies the type of information stored in a field?
  12. Which of the following statements about the Label Wizard is NOT true?
  13. Which of the following views displays the field name, description, and properties of a table?
  14. ______ allows you to resize controls, adjust column widths, move columns, and change labels while viewing the actual data in the report.
  15. A One-To-Many relationship that is not enforcing referential integrity, displays what symbol next to the foreign key field?
  16. A relationship is created between how many tables?
  17. A ____ is a major database object used to display information in a printable page format.
  18. A ____ is a major database object used to display information in an attractive, easy-to-read screen format.
  19. A ____ often display summary data such as totals or counts.
  20. Access file operations can be found by clicking the ____.
  21. Any report, including a basic report, can be modified in __.
  22. Before printing a datasheet, you can use ____ to determine whether to change the page orientation from portrait to vertical orientation.
  23. Database properties do NOT include ___________.
  24. In a query, using the keyword _______________ will return records in which the field value is between two numbers.
  25. In a table, ______(s) are displayed in the order in which they were entered. Most often this order is not useful.
  26. In Datasheet View, new records are added to a table ____.
  27. In Datasheet View, what appears at the top of each column?
  28. In the Field List of a table, the primary key appears _______________.
  29. In the Relationship window, related fields from each table are connected by a(n) _______________.
  30. Print options can be changed in the Print ____.
  31. Referential integrity cannot be set for _______________ relationships.
  32. Relationships between tables can be graphically viewed in the _______________ window.
  33. The common field linking the two datasheets is the _______________ key field in the main datasheet and the _______________ key field in the linked datasheet.
  34. The content and application of the Search tool CANNOT be retained when you ______.
  35. The Input Mask wizard does NOT include the ability to do which of the following?
  36. The insertion point looks like a(n) ____.
  37. The Search tool CANNOT be used on which major Access object?
  38. The Table _______________ Wizard analyzes a database and recommends changes for normalization.
  39. To align controls in rows and columns like a spreadsheet, with labels across the top, which layout should be used?
  40. To remove all Sorts in a table you can click the ______ command.
  41. Using the keyword _______________ will return records in which the field value equals a defined text.
  42. What is one of the advantages for using a form over other Access objects?
  43. What is the keyboard shortcut to move to the last records in a table?
  44. What is the process of eliminating redundant fields by separating data into tables called?
  45. What type of controls are text boxes when data from the recordset is visible?
  46. What type of relationship is created when you select a primary key in both related tables?
  47. Which is not an option for Filter on a text field?
  48. Which is NOT an option of the Picture Size Mode property?
  49. Which major database object stores all data?
  50. Which mode sizes an image to fit the control while maintaining the proportions of the original image?
  51. Which of the following can a Report Wizard NOT do?
  52. Which of the following CANNOT be done to data using a Form?
  53. Which of the following data types automatically generates a consecutive number?
  54. Which of the following database objects extracts information from one or more tables or queries?
  55. Which of the following field properties displays a model or pattern for entering data?
  56. Which of the following field properties enforces the use of parentheses when keying an area code?
  57. Which of the following field properties is an expression that specifies criteria or requirements for entering data?
  58. Which of the following Find and Replace dialog box options finds records in which the beginning of a field matches the Find What entry?
  59. Which of the following functions CANNOT be used in the Totals row?
  60. Which of the following is NOT possible when printing Forms?
  61. Which of the following search criteria is invalid?
  62. Which of the following statements about calculated fields is NOT true?
  63. Which of the following statements about criteria in a query is NOT true?
  64. Which of the following statements about PivotChart View is NOT true?
  65. Which of the following statements about tab order setting is NOT true?
  66. Which of the following statements does NOT hold true for the Top Values property?
  67. Which of the following views enables users to create and modify the sections of a form?
  68. Which of the following views is used to graphically summarize and analyze data in a recordset?
  69. Which report section only prints one time at the end of the report?
  70. Which report section prints once at the bottom of every printed page?
Search
Olete Team
Online Exam Test Top Tutorials are Core Java,Hibernate ,Spring,Sturts.The content on Online Exam Test website is done by expert team not only with the help of books but along with the strong professional knowledge in all context like coding,designing, marketing,etc!