Ch-8:Database Management System

 

1.      Fill in the blanks:

 

a. Query allows to display, delete, and update data.

b. Action query makes permanent change in the table of data.

c. In MS-Access only table object stores data.

d. Form allows users to view, edit and enter new records.

e. To find the hard copy output, we use report

 

2.      State whether the following statements are true or false.

 

a. Memory consumption of Yes/No data type is 1 byte. False

b. MS-Access is a product of Microsoft Corporation. True

c. MS-Access is RDBMS.True

d. Update query can be used to insert calculated data to the table. True

e. Delete query is an example of non-action query. False

f. Form makes data entry and editing easier. True

 

3.      Write the technical terms for the following:

 

a. Object of MS-Access that stores data Table

b. Data type that inserts numbers automatically Autonumber

c. Arrangement of data in ascending or descending order Sorting

d. Key field that uniquely identifies the records Primary Key

e. Object of MS-Access which is used to view, edit and insert data Form

f. Data type of MS access that consumes least amount of memory Yes/No

 

4.      Answer the following questions in short:

 

(a) What is a query?

  An important object of database that allows user to view data and change data of the database with the different criteria is called query.

 

(b) What is a report?

  A report is one of the components of MS-Access. It is used to display the data as per the format selected by the user. It is a summary of the data contained in one or more tables on queries.

 

(c) What is validation rule?

  Validation rule limits the values that can be entered into a field.

 

(d) What is a caption?

  Caption is a field property that is used when you want to display an alternate name for the field to make the field name more explanatory.

 

(e) What is record?

  A group of related fields that describes a person, place, or thing is called a record. It is also called tuple.

(f) What is memo data type?

  Memo is a data type of MS Access which can store the alphanumeric characters from 0-65535 characters.

 

5. Answer the following questions :

 

(a)Define action query? Give two examples of it.

  Action query performs an action on data in a table. You can use an action query to insert new records, to update existing records, or to delete existing records. Action query makes permanent change in the table of data. Example: Changing name spelling of a student, updating the computer marks etc.

 

(b) What is a form? What are the different ways to create a form?

  Form is a database object used primarily to displays records on screen, to make it easier to enter new records and to make changes to the existing records. Two ways to create a form : Form design and Form Wizard

 

(c) Write any two uses of a form.

 (i) Form is used to view the records individually.

(ii)Form helps to add new records.

 

(d) What is a report? Write its use.

  A report is one of the components of MS-Access. It is used to display the data as per the format selected by the user. It is a summary of the data contained in one or more tables on queries. Uses of Report: (i) Report is used to get the summary or result. (ii) Report helps to print the output in an effective way.

 

(e) Differentiate between action query and non-action query(select Query)?   

Action Query	Non-action Query
(i) Action query makes permanent change to database.	(i) Non-action query does not make any changes to database.
(ii) While running action query alert message appears.	(ii) While running non-action query no alert message will appear.