Page 100 - Viva ICSE Computer Studies 7 : E-book

3. Templates make database creation process easy and fast. __________
4. We cannot switch among the views. __________
5. Once the data type for a fi eld is specifi ed, another type of data can be
entered for that particular fi eld. __________
C. Name the following.

1. The application software that creates and maintains
a collection of databases _______________
2. Types of databases _______________ _______________
3. Views of a table _______________ _______________
4. Parts of Design view _______________ _______________

5. Number of buttons on the Status bar _______________
D. Answer the following questions.

1. Defi ne database.
2. Describe the structure of database.
3. Enlist and defi ne the elements of a table.
4. Describe the features and components of MS Access 2016.
5. Enlist the rules to name a fi eld.

Building Values and Life Skills

1. Arun is creating a table with details of ‘Employees’. He has included the following fi elds:
Employee ID, Name, Salary and Department. Suggest him the data type to be used for these fi elds.
2. Why is a there a need to store data in an organised manner? Explain with the help of a real-life
example.

Testing Knowledge

Think about various tables that you need to create for the school examination database system and
discuss them with your friends and teacher.

Linking Knowledge

Mathematics: Create a blank database with the name ‘Mathematics’. Enter the marks obtained by the
students of your class in the database.

Lab Fun

Create a database containing the following details about the students of your class.
• Name • Roll Number • Date of Birth • Father’s Name
• Mother’s Name • Address • School Name • School Address
• Mode of Transportation to School

88