Explain the relationship between the Like operator and the wildcard character using an example that describes how to create criteria for all values in a CompanyName field that start with the letter J.
What will be an ideal response?
The criteria for the CompanyName field would be entered as J* in Query Design View. The final criteria would be Like "J*". Access helps you with the syntax and rules of the criteria. The Like operator is used in conjunction with the wildcard character.
You might also like to view...
A command that switches between an on and off state each time it is clicked is called a ________
Fill in the blank(s) with correct word
The following code searches a linked structure. What is the missing code?
probe = headwhile probe != None and targetItem != probe.data:
A. probe.data = next.data B. probe.next = targetItem.data C. probe = probe.next D. probe.head = probe.next