Class 8 Chapter 4 Let’s Learn Access 2013

 

Chapter 4

Let’s Learn Access 2013

 

A. Tick (ü) the correct answer and fill in the blank.

1. Microsoft Access 2013 is an example of as DBMS software.

2. Query component of a database is used to extract specific information from one or more tables.

3. Short Text is the default data type of a field.

4. Information in a table stored in column is known as fields.

5. Data in a table can be entered in Datasheet view.

 

B. Match the following.

C. Name these icons. 

D. Answer in short.

 

Que 1. Name some of the commonly used Database Management system software.

Ans - Some of the popular Database Management System software are Access, OpenOffice Base, Oracle, Microsoft SQL Server, MySQL, Sybase, etc.

 

Que 2 Name the different sections of the design view.

Ans - The design view is divided in two sections i.e., Field grid area and Field properties area.

 

Que 3 What do you mean by database?

Ans - Database is an organised collection of related data values in such a way that they can be used to generate useful information which is necessary for the decision making process.

 

Que 4 What is the primary key?

Ans - A table should have at least one field that has a unique value for each record. This field is called the primary key of the table. Example -Roll Number, Aadhar Card Number, etc.

 

Que 5 Define the terms: Record, Field, Table.

Ans –   Record – The information stored in a row is called Record.

           Field – The information stored in a column is called Field.

Table – The collection of related information stored in the form of rows and columns is called Table.

       

 

E. Answer in detail.

 

Que 1. What is Database Management System? Describe any two applications of DBMS?

Ans - A computer-based application used to create, store and manipulate the database is called DBMS (Database Management System). It helps in the quick retrieval of processed information from large complicated databases. Some of the popular Database Management System software are Access, Oracle, MySQL, Microsoft SQL Server, etc.

 

Que 2. What is the difference between the Datasheet view and the Design view?

Ans - Design View

The table view that is used to design the structure of a table is called the design view. It is used to specify names, data types and descriptions of fields.

Datasheet View

The table view that is used to enter, delete or modify data in a table is called datasheet view. The table in this view is displayed in rows and columns.

 

Que 3 Write the steps to create a table using the design view.

Ans - To create table using design view–

Step 1: Click on Create tab and from the Tables group, click on Table Design.

A blank table structure will open in design view.

Step 2: Click in the Field Name column and enter the field name.

Step 3: Click in the Data Type column and choose the suitable data type for that field.

Step 4: Repeat the above process to add rest of the table fields.

Step 5: Once finished with the process of defining table fields, save your table and give it a suitable name.

Que 4. How do you set a primary key in a table?

Ans - To set primary key in a table–

Step 1: Select the field name in the Design View, you want to use as a primary key field.

Step 2: Click on Primary Key in the Tools group on the Design tab. A key indicator gets added to the left of the field name in the field grid area.

Step 3: Save the table structure.

 

Que 5. Write the steps to add a new field in the existing table using Datasheet view?

Ans - To add a new field in the existing table using Datasheet view–

Step 1: Right-click on the column header where the new column is to be inserted.

Step 2: Choose Insert Field from the shortcut menu to add new data field.

Que 6. How do you add a new field in an existing table using Design view?

Ans - To add a new field in the existing table using Design view–

Step 1: Select the field name before which you want to add a new field. Click on Insert Rows from the Design tab.

Step 2: Enter the new field name in the Field Name column of the Field grid area.

Step 3: In the Data Type column, select the field data type for the newly added field. Save the changes.