Kips IT/Cyber Beans Class 8 Chapter 3 Solutions WORKING WITH MS ACCESS 2010

Kips Cyber Beans Class 8 Chapter 3 Solutions is part of Kips Cyber Beans Computer Class 8. Here we have given Kips Cyber Beans Class 8 Chapter 3 Solutions Working with MS Access 2010.

Textbook Kips Cyber Beans
Class 8
Subject Computer
Chapter 3
Chapter Name Working with MS Access 2010
Other Chapters Chapter 1
Chapter 2
Chapter 4
Chapter 5
Chapter 6
Chapter 7
Chapter 8
Chapter 9
Chapter 10

Kips Cyber Beans Class 8 Chapter 3 Solutions Working with MS Access Brain Developer

Brain Developer

A. Fill in the Blanks:

1. A Database is an organised way of storing information.

2. All the columns in a table are called Fields.

3. A Record contains the values for all the fields that belong to a single person or an entity.

4. In Memo data type, we can store a maximum of 65,535 characters.

5. The AutoNumber generates a sequentialnumber whenever anewrecord is addedto a table.

6. Hyperlink Stores up to 1GB ofdata.

7. The Primary key is a Toggle key.


B. State True or False:

1. You can create a relationship between twotables by using a unique field. – TRUE

2. Tables, queries, reports, and forms can be created in Microsoft Access. – TRUE

3. DBMS stands for Data and Business Management Software. – FALSE

4. A table can have only one Primary key. – TRUE

5. Access saves the table automatically after saving it once. – TRUE

6. The Primary key button is available on the Design tab. – TRUE

7. OLE data type stores a link to a web page. – FALSE


C. Application Based Questions:

Mansi wants to close the table after saving by using shortcut keys. Which key combination will you suggest her to use?
Apex corporation is designing a database for all its employees. The designers want to store the passport size photograph of each employee linked to their respective names. Can you suggest which data type should they use?

D. Multiple Choice Questions:

1. ……………. Is an application software,which is used to create, modify, and extract data fro database.

a) DBMS b) DBBS c) DDMS

2. is the standard file name extension for database in Microsoft Office Access 2010.

a) .abcd b) .accd c) .accdb

3. ………… are the user friendly interfaces that facilitate the process of entering data in tables an queries.

a) Report b) Forms c) Queries

4. Which key moves the cursor to the previous field in Datasheet View?

a) Shift+Tab b) Shift+F6 c) Ctrl+Tab

5. What do you call the area where you can view the record numbers you have entered in a table?

a) Record Bar b) Record Tab c) Record Navigation Bar

6. Which icon indicates the Edit mode in Access?

a) Eraser b) Pen c) Pencil


E. Answer the following:

What is Database? Give examples of database.

A database is an organised way of storing information. It helps us to manage and access large amount of information quickly and efficiently. A telephone diary, a dictionary, list of groceries in a grocery store, catalogue in a library, and a list of customers in a bank are a few examples of a database.

Explain any four features of Microsoft Access.

Features of Microsoft Access:
a) Access provides the facility to break large information into small parts, so that it is easy to access the information.
b) Data redundancy (duplication of data) is reduced.
c) It increases the efficiency, speed, and flexibility in searching and accessing information.
d)Access facilitates sharing of data. Different users can use the same database to extract data according to their needs.

What are the types of databases? Explain each of them briefly.

There are mainly two types of databases:
a) Flat File Database: A flat file database refers to data files that contain records, which have a small, fixed number of fields, without any structured relationship. For example, Microsoft Excel.
b) Relational Database: A relational database stores data in several tables and link those tables together to get a common piece of information. For example, Microsoft Access, Microsoft SQL, Oracle, etc.

What do you mean by Data types?

Data types are used to declare the fields of a table. A data type determines the type of data, a specific field can accept. Once the data type is defined, we cannot enter a different type of data in it. If we try to do so, an error message will be displayed.

Explain the use of primary key in a table.

A Primary key is a check on the table that uniquely identifies each record in a table. It does not contain any duplicate data. A table can have only one Primary key. Access uses the Primary key to relate the table’s record to those in another table.

State the difference between OLE and Hyperlink data types.

OLE – It stands for Object Linking and Embedding. It is used to embed an object created in another application, such as Microsoft Word document, Excel spreadsheet, or PowerPoint presentation into the Access table. It stores up to 2 GB of data.
Hyperlink – The Hyperlink data type can store links to web pages, web sites, files on an Intranet or LAN on your computer. It stores up to 1 GB of data.

Name the views in which a table can be displayed.

A table can be viewed in the following two views:
DESIGN VIEW: In Design View of the table, you can enter the field names, their data types, and description.
DATASHEET VIEW: Datasheet View is used to enter data in a table.


F. Define the following terms:

Tables: Tables are the building blocks of a database. They store the complete data in a structured manner, i.e ., in the form of rows and columns. Every table has a finite.

Data: A set of characters that represents a valid value is known as data.

Reports: Reports are used at two display the selected data in printable format. Reports collect the summarise data from one or more tables/queries and organised it in a printable form.


Other Chapter Solutions