CLASS 8TH

 

E. ANSWER THE FOLLOWING QUESTIONS:

1. Define networking with examples. Give two advantages.

•            A computer network can be defined as a group of computers and others peripheral devices that is linked together for sharing data and hardware resources.
•           For example , if one of the computers in a network has a printer attached to it, them all computers in that network can network can access the printer and use it to print the documents.

Advantages:

• 1.     It provides a facility to transfer the soft copies from one computer to the other at high speed.
• 2.     The users can store their files on remote computers.

 

2. Distinguish between LAN and WAN

                            LAN                                            WAN

1.     It stands for Local                                   1. It stands for Wide Area

Area Network                                             Network.

2.     It covers small geographical area             2. It covers large or wide

    Geographical Area.

3.     It is usually a low speed.                         3. It usually fast speed.

4.     The range of LAN is limited.                  4. The range of WAN is

     Unlimited.

 

 

 

 

3. Give two advantages of Star Topology.

 1. Star topology is very popular because the set up cost is low.

2. Only one cable is required and the configuration is simple.

 

4. Explain Client- Server Architecture in your own words.

·        In a Client –Server Network, several computers called clients or workstations are connected to the main computer called the server.

·        A Server is a computer that provides services to clients and controls access to hardware, software and other resources.

·        Clients are the computers that request services, like data retrieval, storage, etc. from the server.

 

5. Differentiate between a Hub and Switch.

 

                    HUB                                                           SWITCH

1. HUB is broadcast device                                   1.Switch is multitask Device

2. Hub sends data in the form of binary                 2. Switch sends data in the     form of frames

 

 6. What are the components required for wireless networking?

                   There are two components required do wireless networking:-

                                                    1. Wireless Network Carks.

     2.     Access Points or Router

BOOK EXERCISE

______________________________________________________

CHAPTER 2   - LOG ON TO ACCESS

Database:

Organized collection of data.

*Enter

*Manage

*Access

*Analyze -  a large amount of information, quickly and effectively.

Types Of Database

Flat file DB:   Data files that contains records - small, fixed no of fields, without structured relationship.

eg- excel

Relational DB : Stores the data in several tables. eg: Microsoft SQL, Oracle, MySQL.

            Structure of Database

 

 DB gives specific structure to store data.

 *Tables

*Queries

*Reports

TABLES -- Building Blocks of a database, it stores all data in structured manner in forms of rows and columns.

Elements of Table:

• Fields (Column)
• Records(Rows)
• Data

QUERIES:

Large no of datas present in the database. Retrieval and filtration of data from database based upon some conditions. Queries also perform actions  such as

delete

update etc.

FORMS: Accepts the data from the user and forwards it to the table.

REPORTS: Display selected data in a printable format.

         DATABASE MANAGEMENT SYSTEM

 DBMS enables you to create , modify, store and extract data

Advantages of DBMS

1. Efficient and reliable

2. Data redundancy (duplication of data)

3. Efficiency, speed, flexible in searching info

4. Sharing of info

5. Data admin have the control over the database.

Microsoft Access:

RDBMS: We can store large number of data. it can be organize in the form of tables.

Student information table

COMPONENTS OF MICROSOFT ACCESS

**********************************************************************

Class Notes for Chapter2:
Answer the following

1. Define Database. Write two advantages of using a database.

 Database is an organised collection of data. It helps you to enter , manage, access and analyse a large amount of information, quickly and efficiently.

Advantages: Minimum data redundancy, Increased data security and increased consistency.

2. Name and explain the function of any two components of microsoft access 2019 window.

*QuickAccess Toolbar - It is present at the top left corner of the access window. It contains the most frequently used command buttton. By default it has three command buttons, they are Save, Undo and Redo

* Navigation Pane- It is present on the left side of the window. it displays the name of the objects used in the Database like Tables, Queries, Forms, Reports

3.Define all the elements of a table.

Fields, Records, Data.

Field:- All the column in a table are called field. 

Records:- the row in the table are called records. 

Data:- A set of characters that represent a valid value is known as data

4. Differentiate between a form and query.

A Form is created for the user to input information, such as  new data into a record , whereas a query is created to extract information from that form.

5. What is the full form of DBMS? Write two advantages of DBMS.

 DBMS- Database Management System

Advantages: 

*Data Redundency

*Data Integrity.

**********************************************************************

Topics taught in lab:

Lab session Topics:

1.Creating a Database in Access.

2. Creating a Student database in table in Ms Access.

3. Views of a table

4. All the Fields - How to set the fields for particular record.

5.Opening an existing database.

6.Closing Access.

&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&&

CHAPTER 3 - WORKING WITH TABLES

Adding a Table

-Creating Table in Design View

     *Adding Fields in Design View

-Creating Table in Datasheet View

    * Adding Fields in Datasheet View

Rules for Naming a Field

Data Types

Setting Data Type for a Field

Field Properties

Primary Key- It is a field in a table that holds a unique value for every record.

Lab Classes

Answer the following:

1.Define Tables. List the different elements of a table.

    A Table is a collection of data elements organised in rows and columns. * Refer chap 2, 3rd question.

2. What are Data types? List the Various data types available in access.

     Every table consists of fields and each fields has its own set of properties. A fields data type determines what type of data you enter into a field. 

DataTypes are

    *Short text

    *Long Text

    *Number

    *Currency

    *Date/Time

    *Yes/No

    *Hyperlink

   

3. What is the utility of filter in a datasheet view.?

• You can use filter to display specific records in a form, report, query or datasheet.
• By applying a filter, you can able to limit the data in a view without altering the design of the object.

4. Write short notes on the following.

a. Validation Text: Pgno:40

b. Caption Property: Pgno:40

c. Advanced filter: Pg no :44

Chapter 4 : WORKING WITH QUERIES, FORMS AND FORMS

Q&A

1.Define a query . name the different parts of a query window.

Pg no: 63

Tow panes: Top and bottom, Top pane having display table and bottom pane have design grid.

2. Define criteria. How many types of criteria can you apply in a query?

 Page no: 63 & Two types of criteria is available to apply query.

3. What is a form? How is it useful?

Page no 63 & 57

4. Differentiate between form and report.

A form is an Access object that             
allows the user to add and update 
data in one record at a time in a 
table. If you change a record in a
 form, it will be reflected in a table 
also.


Report is an effective way to organise
 and summarise data for viewing 
or printing. It can be created exactly
 in the same way as we create a form.

5. Describe the use of charts in access You can create charts that appear automatically on Access forms so that you can see key information graphically rather than reading it from the data