From the course: Access 2007: Shortcuts
Unlock the full course today
Join today to access over 22,400 courses taught by industry experts or purchase this course individually.
Using wildcards - Microsoft Access Tutorial
From the course: Access 2007: Shortcuts
Using wildcards
There may be times when you're running a query, but you don't know the exact spelling of a name, or you want several variations of a match to appear. In both of these cases, you can take advantage of wildcard characters to represent the letters or words that may vary. Go up to the Create ribbon and to the right, choose Query Design. Add your Customers table to the query and then close the Table window. I'll expand this out to make it longer and add Company and Notes to the grid below. In the Company column, click on the Criteria line and type, asterisk deli asterisk. The asterisk represents unknown letters, any number of them. By putting an asterisk before and after the word deli, I'm telling Access that deli can appear in the beginning, the middle, or the end of the name. Run the query and you have three different matches. Now go back to Design view. Notice that Access has added in the word Like and quotation marks around my search string. Now let's edit this. Take out the first…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
-
-
Using wildcards5m 33s
-
Using IN instead of OR1m 34s
-
Hiding query fields50s
-
Changing captions1m 42s
-
Finding duplicate records2m 17s
-
Moving records with append and delete queries4m 32s
-
Using make-table queries2m 23s
-
Creating an update query2m 49s
-
Turning a query into a PivotTable2m 22s
-
Turning a query into a PivotChart2m 8s
-
Using SQL statements2m 27s
-
-
-
-
-
-
-