Page 277 - IT 402 v2.0 class 10
P. 277
se i ard to create uery...
reate uery in S view...
xample: onsider a database in which a data of the ustomers is stored in a table namely S OM S and
in this table many records are having there with the names of the city as N. I and we have to display
only those records in which name of the city is stored as N. I .
Now let us use uery for the same.
Create Query in Design View.... [Single Table]
et us now learn how to create uery in esign view in Single able.
lick on the ueries icon from the atabase indow.
lick on the option reate uery in esign iew .... option to create a uery in esign view.
he uery esign window opens:
Queries Icon
Step 1: Select the table from the dd able or uery window and click on the dd button.
Follow the steps if you want to include more than one table in the uery.
The selected table appears on the window below the standard toolbar.
Step 2: lick on Field dropdown box and select the fields that will be displayed in the uery. he user can
apply the criteria for sorting with conditions that will be applied in the uery by clicking on Sort and
selecting the condition.
Database Management 275

