How To Create Wildcard Queries In Access 2010


show more Creating wildcard queries provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training show less
please wait ...

Creating wildcard queries

Wildcards allow us to run queries when we don't have an exact match for our criteria. For example, I was having a conversation with one of my customers, and I know I put a comment in the notes about oils, but I don't remember who it was or what I said. So let's make a Query. Click on Create and go to Query Design. Double-click on Customers. Close the Show Table window. Let's put up the Company Name, their Phone number, the person who I was talking to, ContactFirst and ContactLast, and then the Notes.

Now because I know that I mentioned oil, but I don't know if that was at the beginning or the end of the sentence, I put in Wildcards. Hold the Shift key down and put it an asterisk. This indicates that there may be text before the word oil in this sentence. Then type the word oil and put in another asterisk, because I'm not sure if there were words after the word oil in the sentence. Now I'm going to view the Query and sure enough, I have three customers where I ment...

Creating wildcard queries
Video duration: 1m 24s 3h 30m Beginner

Viewers:

Creating wildcard queries provides you with in-depth training on Business. Taught by Alicia Katz Pollock as part of the Access 2010 Essential Training

please wait ...