Page 250 - Computer - 10(A&B)

4. What is the use of Yes/No field?
5. What is the purpose of reports?
6. What is the purpose of forms?
7. What is the Date/Time data type?

8. What are queries?
9. What does RDBMS stand for?
10. What do you understand by data types?

11. What is the use of AutoValue property?
12. Which area in the Query Design view is used to set the Field criteria?

D. Short answer questions.

1. What are the two major advantages of using Database Management System?
2. Which different methods are used to generate queries in Base?
3. What are the steps to set a primary key in a table?
4. How will you execute a query?

5. How can you create a table in Design view?
6. Write the steps to create a form using the Form Wizard.

7. Write the steps to create a query using the Query Wizard.
8. Write are the steps to generate report of a table using the Report Wizard.

E. Long answer questions.
1. Database Management System has emerged as one of the useful tool for better management of
information in the computer system. Describe some of its major application areas where it is getting
used these days.
2. You have to create a database to store the information about the students participating in the annual
function of the school. What will be the possible fields in your table and their data types? Also, tell the
field in your table which will act as primary key field.
3. Base gives you two options to choose the way to create table structure. What is the difference between
these two? Describe the advantages and disadvantages of each one of these.
4. Look at the fields of a table named ‘Teacher’ given below. Write the data type you will select for each
field, giving suitable reason for each one of them.
Tcode T_Name Address Designation Date of Joining Subject

5. Create a table having the following fields and add ten records.
Field Data Type
Item Code Number
Item Name Text

Price Float
Quantity Sold Number

6. Create a query to:
a. display all the items and their quantity sold.
b. display the items whose quantity sold is more than 100.
132