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

Using wildcards - Microsoft Access Tutorial

From the course: Access 2007: Shortcuts

Start my 1-month free trial

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…

Contents