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

Computer Etiquette

Always ensure to set the correct data type for a particular fi eld.

Tech Terms

RDBMS: Relational Database Management System
DBMS: Database Management System, an application software that creates and maintains
a collection of databases
Tables: Database fi les logically organised in the form of rows and columns

Templates: Ready-to-use database objects
Data Type: The type of data that is to be entered in a fi eld
Primary Key: A key in a relational database that is unique for each record

Quick Recall

• The application software that creates and maintains a collection of databases is called Database
Management System (DBMS).
• Microsoft Access is a part of the Microsoft Offi ce Suite.
• Queries are used to access the required information from a database.

• Templates make the database creation process easy and fast.
• There are two views to work on a table: Design view and Datasheet view.
• A data type for a fi eld can be set in either Design view or Datasheet view.

A. Fill in the blanks.

1. A database helps you to organise the collected data in a ______________________.
2. Reports are the layouts designed for ______________ or ______________ the data of a
database.
3. A data type defi nes the type of data for a _____________.
4. An __________________ creates unique values automatically on creation of a new record.
5. Primary keys must contain ____________ values, and cannot contain ____________ values.

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

1. A spreadsheet provides unlimited features for databases. __________
2. DBMS manages all the functions of a database. __________

87