Computer Science
Class-VIII
Chapter-5 Databases and MS- Access
A. Fill in the blanks:
1. The table is the basic element of a __________ model.
Answer: Rlational Database
2. Records and fields together make up the ___________.
Answer: Table
3. Data redundancy means _____________ of data.
Answer: Duplication
4. In MS-Access, all objects of a database are stored in a single file and the file name has a ________ extension.
Answer: MDB
5. The components of a Design View window are ______, ______, and _____.
Answer: Field definition grid, Field properties pane, Navigation Pane
6. MS-Access will not allow you to delete__________ field.
Answer: Primary Key
7. One can not enter duplicate valuels in a _________ field.
Answer: Primary Key
B. Write whether true or false:
1. A database is simply an organized collection of information or data.
Answer: T
2. Each specific piece of information in a table in known as a number.
Answer: F
3. All objects of a database are stored in a single file.
Answer: T
4. One can create new tables using the Table Design View window.
Answer: T
5. A field name can be up to 100 characters long.
Answer: F
6. The default value of the field size is 50.
Answer: T
7. MS-Access adds quotation marks around a text default value.
Answer: T
C. Tick the correct option:
1. It organizes data into rows called records and columns called fields.
a. Table b. Biodata
Answer: Table
2. A relational DBMS where data is arranged in the form of tables.
a. MS-PowerPoint b. MS-Access
Answer: MS-Access
3. In MS-Access, the file name has an extension, which is
a. MDB b. MBD
Answer: MDB
4. In MS-Access Database window, these small programs are used to automate a repetitive task.
a. Modules b. Macros
Answer: Macros
5. It is used for entering field names, data types and descriptions.
a. Field Grid Pane b. Field Properties Pane
Answer: Field Grid Pane
D. Answer the following questions:
1. What do you mean by a Database Management System?
Answer: Database management involves creating, modifying, deleting and adding data in files. The software that performs these functions is known as Database Mangement System (DBMS).
2. Can you define a record, a field and a value?
Answer: A record is also known as row and field is also called column.
Each record contains information about one item. Each field define information of a certain type for all records. Piece of information in a table is known as a value.
3. What are the object-naming rules in MS-Access?
Answer:
* Can be up to 64 characters long.
* Can not begin with leading spaces.
* Can not include control characters.
* Can not include a double quotation mark(" ").
4. In how many ways can a table be opened?
Answer: There are two ways:
1. Top-to-bottom approach
2. Bottom-to-top approach
5. What are the two views which help in creating a table?
Answer:
* Creating a Table using Datasheet view: When you create a table through the Datasheet view, a spreadsheet-like format appears.
* Creating a Table using Design view: The Table Design view window is another place where you can create new tables.
6. What are the different ways of selecting a key as a primary key?
Answer: There are different ways of selecting a primary key:
1. Select the field to be used as a primary key and select the primary key button in the table design toolbar.
2. Select the field to be used as a primary key and select the primary key option from the edit menu.
3. Right click the mouse on the field selection cell to display the shortcut menu and select the primary key option.
7. What is a validation rule?
Answer: Data validation enables you to limit values that can be accepted into a field. Validation may be automatic. You can also define any data validation rules that your field requires.
For example: The rule #1000 in the Data Validation rule box mean that the value entered should be less than or equal to 1000.
E. Differentiate between:
1. A database and a table.
Answer: A database is simply an organized collection of information or data.
A Table is a combination of rows and columns. Row is also called Record and Column is also called Field.
2. Creating a table in the Datasheet View and the Design View.
Answer:
* Creating a Table using Datasheet view: When you create a table through the Datasheet view, a spreadsheet-like format appears.
* Creating a Table using Design view: The Table Design view window is another place where you can create new tables.
No comments:
Post a Comment