1. Fill in the blanks
a. Data are raw facts such as text, number and symbols.
b. In database, entity may be a person or anything.
c. An example of database is dictionary.
d. An example of DBMS is MS Access.
e. A table contains a number of records using rows and columns.
f. In MS-Access, a table can be created using design view.
g. To insert logical data, we use Yes/No data type.
2 Write whether the following statements are true or false.
a. MS-Access is relational database management system.
True
b. MS-Access provides a user friendly environment.
True
c. In MS-Access, a report can be used to input data.
False
d. Validation rule limits the data that can entered into a field.
True
e. Memory consumption of Date/Time data type is 12 bytes.
False
3. Write the technical terms for the following.
a. Raw facts and figures that can be entered in DBMS.
Data
b. An object of MS-Access that stores data using rows and columns.
Table
c. The software that can handle multiple tables and link them.
MS Access
d. The key field of database that uniquely identifies records.
Primary Key
e. Property of field that is used for alternate name of the field.
Caption
4. Answer the following questions in short:
a. What is data?
Answer A raw fact about anything which does not give any complete meaning is called data.
b. What is record?
Answer A group of related fields that describes a person, place, or thing is called a record. It is also called tuple.
c. What is maximum number of characters that can be used to define a field name?
Answer 64 characters
d. Give two examples of manual database.
Answer A telephone directory, an organizer or printed address book are examples of manual databases.
e. What is default value?
Answer A default value is one that is displayed automatically for the field when you add a new record to the table.
f. What is caption?
Answer Caption is a field property that us used when you want to display an alternate name for the field to make the field name more explanatory.
g. What is index?
Answer Index is one of the important properties of database that speeds up searching and sorting of records using the field.
5. Answer the following questions :
a. What is DBMS? Give any two examples of it.
Ans: The software collection which helps to manage the database is called DBMS.
Examples of DBMS: i) MS-Access ii) Oracle
b. Write any four advantages of DBMS.
Ans: 1. Provides an organized way of storing data
2. Facilitates quick and efficient retrieval of information
3. Reduces data redundancy
4. Improves the consistency of data
c. Define data type. Write any four data types of MS-Access.
Ans: The data type determines the kind of values that users can store in the field.
Four data types of MS Access are : Text, Number, OLE , Yes/No
d. What is field property? Write any two common field properties of MS-Access.
Ans: Field properties are the properties or characteristics of field that describe the characteristics and behaviour of data added to that field.
Two common field properties are : Field Size and Caption
e. Differentiate between field and record.
Ans:
| Field | Record |
|---|
| (i) A field contains data about one aspect of the table subject, such as first name or e-mail address. |
(i) A record contains specific data, like information about a particular employee or a product. |
| (ii) A field is recognized by unique name called field name. |
(ii) A field is recognized by unique key or field name called primary key. |
f. What is table? Write different ways to create a table.
Ans: The basic element of a database which consists of vertical columns and horizontal rows is called table. Since entire data is managed and kept in a table for the future retrieval process , it is also called the primary object of database.
Two ways to create table : (i) Design View (ii) Datasheet View
g. Define primary key? Write any two features of it.
Ans: A field that uniquely identifies each record in the database is called primary key. For example: Bank account number, student registration number etc.
MS-Access neither permits duplicate values in primary key not does it permit null values.
h. What is computerized database? Write its advantages over manual database.
Ans: A computerized database contains electronic organized database handled by DBMS or software that allows storage of huge amount of data in a systematic way which is easy to access when required.
Advantages of Computerized database:
- Provides an organized way of storing data
- Facilitates quick and efficient retrieval of information
- Reduces data redundancy
- Improves the consistency of data
- Allows sharing of data
i. Write any four sub data types of number data type.
Ans: Integer , Long Integer, Single , Double
j. What is sorting? Write any two advantages of sorted database.
Ans: A process of arranging the data items in some sequence or order according to the given criteria is called sorting. It can arrange data in ascending or descending order.
Two advantages of sorting:
(i) Sorting helps to find the data quickly.
(ii) Sorting helps to reduce data redundancy.
7.2 Queries
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?
Ans: 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?
Ans: 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?
Ans: Validation rule limits the values that can be entered into a field.
(d) What is a caption?
Ans: 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?
Ans: 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?
Ans: 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.
Ans: 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?
Ans: 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.
Ans:(i) Form is used to view the records individually.
(ii)Form helps to add new records.
(d) What is a report? Write its use.
Ans: 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)?
Ans:
| 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. |
