Wildcards Entries In Access 2010

WHERE is the virtually used command in SQL, providing easiest way to pull out specific data from table. Even though you can use SQL commands in Access 2010, but CLI (CLI) brings monotony on and database novices usually get their custody on a tool which offers simple GUI layout. So the world-class alternative more or less in Accession is to use wildcard entries, aka, Like/Unlike conditions, which offers innumerable ways of pull out desired info from tables, queries, etc.

To begin with, launch Access 2010 and pilot to Create tab and click Query Design.

create query design

For illustrating victimisation Wildcards in Access, we have created Student Scaling database having multiple tables. Straightaway we will be adding these tables in Query Project. Upon click Query Excogitation, Show Table dialog will appear, listing tables contained in database. Look-alike-click put of(s) which you want to insert and click Close.

add tables

It will insert table with their fields in a loge, now start adding table fields in Enquiry design bottom window glass by double clicking wanted table fields in respective table box seat.

add fields

At once we want to view all the pertinent information nigh students who secured A grade. For this, we will be using a wildcard entry. From Grade Secured field, we wish write LIKE condition in Criteria course.

like a

Below Query Tools Design tab, click Lam to perform the query.

design run

One executing Inquiry, IT will show all the students who secured A grade.

query

For instance, we need to view all the students having phone numbers starting with '13'. For this we volition spell this wildcard entry low Phone No field.

Like "13*"

The asterisk at the remnant indicates that we want to find tabu record in field, having selfsame start value(s) i.e in our case IT is 13.

like 13

On working interrogation, it will promptly show us all the students having headphone numbers starting with specified numbers.

phone numbers

We also wish to know how which canonical courses students have premeditated, for this, we will be adding Course postpone and add Class constitute in Query Design underside pane.

courses

Now will be writing asterisk wildcard entry, low Course Name sphere.

which goes like this;

Similar "*Presentation*"

like into

On running Query, it will show lonesome staple courses, i.e, title start with 'Intro'

intro

From Wildcard examples demonstrated in aforementioned database, you might get an idea of having endless ways to manipulate the table fields, as IT gives you more firm control over database and brings ease to draw ou data now.

You might be interested in some other slipway of using Wildcard entries in database;

Not Comparable "13*" It would return all the field data leave off data starting with '13'

Like "*13" It would return field data end with values 13.

Corresponding "J?" IT would return two characters' data starting with J.

Like "J#" It would return wholly the two characters' value start with J and where second quality is a number.

You can also check impermissible previously reviewed guides on Using Formulation Builder in Access code 2010 & How to set Query Criteria in Access 2010 through Reasonable Operators.