Page 32 - 2501_KVS_C-8

3. One can ____________ a field either by ascending or descending order during the
creation of a query.
4. We can add or delete ____________ (s) from the table at the time of creation of
a table using wizard.

5. One can give ____________ name to a field/column during the creation of a query
using wizard.

C. State whether these statements are true or false.
1. Any number of columns may be added to the table during creation
using wizard. _________

2. A wizard is a step-by-step guide to create a table only. _________
3. Query is a request of information from the table. _________
4. A query may have few or all columns as per the need of information. _________
5. A query once created cannot be deleted. _________

Something to Do

1. Create a table named “Customers” using Wizard that will having the following fields:

Field Name Data Type
CustomerID Integer
First Name Varchar
CompanyName Varchar
MobileNumber Integer
Department Varchar
Also, add any 10 records into the above table on your own.
2. Create the following queries on the above table “Customers” using Wizard:

(a) To display the name of those customers who have “Finance” Department. (Add
some values of “Finance” in the Department column).

(b) To display the name and mobile number of all customers in ascending order of their
first names.

(c) To display all records in descending order of their Mobile Number.
(d) To display the name of all the customers who have Mobile Number less than

9555565555.

30 KVS DELHI REGION 2025