Class 8 Computer Chapter-4 ''Working With Queries''

 Chapter-4 ''Working with Queries''

A) Fill in the Blanks:-

1) Queries are made on Tables.

2) In a query, the Criteria property is used to set the condition on the basis of which the records are filtered.

3) We can set multiple criteria in a query using Or property.

4) Sort property is used to filter the data either in ascending order or descending order.

5) The bottom pane of the select query window displays the Design Grid.

6) A Report is an effective way to organize and summarize data in a printed form.

B) State True or False. Also correct the false statement.

1)Queries help us to retrieve information from one or more tables that meet a specific condition.:-True.

2)Query window is divided into three parts.:-False. Query window is divided into two parts.

3)To specify multiple criteria, Or property is used.:-True.

4)We cannot run a query without saving it.:-False. We can run a query window without saving it also.

5)The Sort property is used to filter the data either in ascending order or descending order.:-True.

6)Queries are used to explain the specific data.:-True.

7)Once a relationship is set, it cannot be deleted.:-False. Once a relationship is set, it can be deleted.

8)MS Access provides two ways to create Select queries.:-True.

C)Application Based Questions.:-

1)Swati created a database of her classmates and entered 30 records in it. The teacher asked her to show the data of those students who have scored less than 50% marks. Suggest the method to apply this criteria.

Ans:- Swati needs to create query with criteria as <50%.

2)Johnson and Johnson company has a huge database of employees. The company wants to maintain the privacy of each employee and has given the instructions to computer operators to update each record, one at a time. Which database object should they use to perform this task?

Ans:- They should use FORM object to perform this task.

D)Multiple Choice Questions:-

1)b-Update

2)b-two

3)c-Wizard

4)a-Selected Table

5)b-Three

6)a-Primary Key

E)Answer the following Questions:-

Q1) What is a Query?

Ans: A query is a database object that helps us to retrieve and view information from one or more database tables that meet a specific condition or criteria we define.

Q2) Explain the parts of a Query window.

Ans: The query window is divided into two parts/panes:Top pane & Bottom pane.                                                                                                         The Top Pane displays the table(s) selected for the query. In case of multiple tables, the field lists are joined by a line.                                   The Bottom Pane displays the Design Grid. The Design Grid contains Fields, Table, Show, Sort, Criteria and Or. 

Q3) What do you understand by criteria?

Ans: Criteria property contains the condition on the basis of which the records are filtered in the Query output. We specify criteria in the criteria row on the design grid.

Q4) Into how many types a query can be categorized?

Ans: Queries can be categorized into four types- Select Query, Update Query, Cross Tab Query, Append Query.

Q5) Explain how to add fields to a query.

Ans: We can add fields to a query by dragging them from the field list to the design grid or by double-clicking on the field. The design grid is similar to a spreadsheet with columns representing each field in the query.

Q6) What is a Form? Briefly explain its use.

Ans: A form is an MS Access object that allows the user to add and update data in one record at a time in a table.                                                               Usage of form: Data can be inserted, updated and deleted from a table using the FORM object.

Class 8 Computer Chapter 3''Working with Tables''

Chapter-3''Working with Tables''

A)Fill in the blanks.

1) In 'Text' data type, we can store a maximum of 255  characters.

2)Auto Number generates a sequential number whenever a new record is added to a table.

3)MS Access uses the Primary  key to relate the table's record to those in another table.

4)Tab key is used to move to the next column.

5)Hyperlink stores up to 1 GB of data.

6)Memo data type is used for descriptive fields.

7)The Primary Key is a Tuggle key.

8)To delete a field, first select the field and then click on Delete rows button on the design tab.

B)Stste True or False. Also correct the false statement.

1)A table can have only one primary key: False. A table can have many Primary Keys.

2)Clear All Sorts command is located in the Records Group on the Home Tab: False. Clear All Sorts command is located in Sort & Filter Group on the Home Tab.

3)Access saves the table automatically after saving it once: True.

4)The Primary Key button is available on the Design Tab: True.

5)Shift+Tab Key moves the cursor to the next field: False. Tab Key moves the cursor to the next field.

6)It is not essential to specify data type for a field name: False. It is essential to specify data type for a field name.

7)A number data type can store integer values: True.

8)OLE data type stores a link to a web page: False. Hyperlink data type store a link to a web page.

C)Application Based Questions.

1)Your teacher has shown you the following table structure:

                (Please match the table structure from the book)

According to you which column header should be chosen as the Primary key for this table? Please note that the column header ID is inserted by default. Hence, do not include this in your answer.

Ans:- According to me 'Mobile Number' column header should be chosen as Primary Key.

2)Apex corporation is designing a database for all its employees. The designer want to store the passport size photograph of each employee linked to their respective names. Can you suggest which data type should they use?                                                                                                                                   Ans:- They should use either OLE or Attachment data type.

D)Multiple Choice Questions.

1)Which key moves the cursor to the previous field in Datasheet view?

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

Ans:- a)Shift+Tab

2)What is the maximum numbers of characters that can be used to define a table name?

a)46                         b)62                        c)64

Ans:- c)64

3)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

Ans:- c)Record Navigation Bar

4)Which shortcut key combination is used to go to the specific record by using the Current Record Box?

a)Alt+F6                 b)Alt+F5                   c)Alt+F4

Ans:- b)Alt+F5

5)Which of the key combination is used to save the changes and close the table?

a)Ctrl+W                b)Ctrl+V                     c)Ctrl+M

Ans:- a)Ctrl+W

6)Which icon indicates the edit mode in Access?

a)Pencil                  b)Pen                           c)Eraser

Ans:- a)Pencil

E)Answer the Following .

Q1)What is a Table?

Ans:-A Table is a database object which consists of rows and columns. It is used to store information in an organized way. In MS Access a table can have a maximum 255 columns and unlimited rows.

Q2)What do you mean by data types?

Ans:-A data type is a type that determines the type of data a particular field can accept. In MS Access 2007 there are 11 data types. These are Text, Number, Memo, Date/Time, Auto Number, Yes/No, OLE, Hyperlink, Lookup Wizard, Attachment and Currency.

Q3)What is the use of Primary Key?

Ans:-Primary key is used to (i)uniquely identify records from a group of records, (ii)to relate/join tables in a database.

Q4)How will you insert a new field in an existing table?

Ans:- Steps:

i)Open the table in Design view.

ii)Click on the row where you want to add.

iii)Click on insert rows button in the Tools Group on Design tab.

iv)Enter a field name and a data type for the new field on the blank row.

v)Save the table.

Q5)How will you delete a record?

Ans:- Steps:

i)Open the table in Datasheet view.

ii)Click on the row header to select the record and press Delete key or right-click and select 'Delete Record' option from the Context menu option.

Q6)How will you sort the data within a table?

Ans:- Steps:

i)Open the table in Datasheet view.

ii)Select the desired field.

iii)Click the Drop-Down arrow at the top of the field.

iv)Select 'Sort A to Z' for Ascending order or 'Sort Z to A' for descending order of sorting.

Q7)How will you add a new row to a table?

Ans:- Steps:

i)Open the table in Datasheet View.

ii)Place the cursor at the last field of a record and press the Tab key. The cursor will appear in the new row.

iii)Now enter a new record according to the field. 

Class 8 Computer Chapter-2 ''Log on to Access''.

 Ch-2''Log on to Access''

A) Fill in the Blanks:                                                                                                                                 1)A Database is an organized way of storing information.                                                         2)A relational database stores data in tables that are linked together using common  fields.                                                                     3)A File is a collection of related records.         4)Alt+F4 key combination is used to quit the MS Access.                                            5)Queries in Access helps you to get the information on a specific topic from the              information stored in database.                                                                                                                                                                                                                                                                                           B) State True or False. Also correct the false           statement:                                                                                                                                                                                                                                1)MS Access is a database management             system:- False. MS Access is a relational          database management system(RDBMS).                                                                                                2)Database is of two types, DBMS and RDBS:-   False. A database is of two types, Flat File       Database and Relational Database.                                                                                                             3)In Flat File Database system, you can make links:- False. In flat file database we cannot make links.                                                                          

  4)You can create a relationship between two tables using a unique field:- False. We can create a relationship between two tables using a common field.                                                                                                                              5)Tables, Queries, Reports and Forms can be created in MS Access:-True.                                                                                                           6)DBMS stands for Data and Business Management Software:-False. DBMS stands for database management system.                                                                                                                                                                                               7)A column name is also called a field name:-True.                                                                                                                                                                                                                                                      C) Application Based Questions:                          1)Supriya is being given an assignment to create a table using template. Suggest her the option which she should select after opening MS Access.                                                                                                                                               Ans:-The option that she should select is Table Template after opening MS Access.                                                                          2)Mansi wants to quit MS Access after saving a database by using shortcut keys. Which key combination will you suggest her to use?       Ans:-I will suggest her to use Alt+F4 key combination key.                    

D) Multiple Choice Questions:                                                                    

1)                is the shortcut key combination to save the database.              

a)Ctrl+C                    b)Ctrl+S                             c)Ctrl+V    Ans:- Ctrl+S                                                                                                                                                                                                                                                                                                         2)                is an application software which is used to create and manage a database.                                                                                

a)DBBS                     b)DBMS                       c)DDMS     Ans:-DBMS                                                                          

3)                is the standard file name extension for database in MS Access 2007.                                          

a).abcd                     b).accdb                       c).accd          Ans:- .accdb                                                                         

 

4)There are mainly                 types of database.           

a)Two                       b)Three                       c)Four              Ans:-Two                                                                          

E)Answer the Following Questions:                                

Q1)What is a database? Give examples of a database.

Ans:-A database is an organized collection of related information or data stored in files. In addition to storing data, we can also access, sort and summarize information related to data. There are mainly two types of database. These are flat file database and relational database.                                                                          Examples of database:-MS Access, ORACLE, MS SQL.                                                                            

Q2)Explain any four features of MS Access.                      Ans:- The following are the main four features of MS Access database:-                                                                a)Data redundancy(duplication of data) is reduced.   b)It increase the efficiency, speed and flexibility in searching and accessing information.                              c)It facilitates sharing of data among different users of the database.                                                                    d)It provides data security features and maintains data integrity.                                                                       

Q3)What are the types of database? Explain each of them briefly.                                                Ans:-There are two types of database. These are flat file database and relational database.                               

Flat File Database: A flat file database can store and retrieve information. It is not capable of linking fields together. Example: MS Excel etc.                                         

Relational Database: A relational database can not only store and retrieve information. Example: MS Access, ORACLE etc.                                                                 

F)Define the following:                                                 

1)Field:- A column within a table that contains only one type of information is called a field. Fields are also known as attributes. In a Student Table Roll No. , Name, Class are fields.                                                     

2)Record:- A collection of fields makes one record. A record displays all the information about a single entity. In a Student Table 1, Suresh Das, VIII-B is a record. Like that a table can contain group of records.

3)Reports:- In MS Access, Report is an effective way to organize and summarize data for the viewing or printing.                                                                                

            

Class 8 Computer ch-1 Networking Concepts

Lesson 1-Networking Concepts

A) Fill in the blanks

1)Communication system allows us to talk to any person in the world at any time.

2)A computer network enables two or more computers to share data and resources.

3)In a network, modification or upgradation of the software is done at a single point only.

4)The computers that communicate with each other are called Nodes.

5)A network maintained without using wires is called Wireless Networking.

6)LAN and MAN are the different types of networking.

B)State true or false.

1)Nodes and servers have the same function.

Ans:-True

2)LAN stands for Large Area Network.

Ans:-False

3)Network cards are used to physically attach a computer.

Ans:-True

4)WAN stands for Wide Area Network.

Ans:-True

5)WAP stands for Wired Access Point.

Ans:-False

6)In a Client-Server Network, there is no central network.

Ans:-False

C)Application Based Questions.

1)Mr. Ravi has set up his office with 50 computers. He wants to connect computers and peripheral devices within his office building with wires. Which type of network will you suggest him to use?

Ans:-I will suggest him to use Local Area Network(LAN) type of network.

2)Which type of network architecture is most suitable when a few number of computers, having similar power and capacity, are to be networked together?

Ans:-Peer-To-Peer type of network architecture is the most suitable for the mentioned network.

3)Shagun wants to physically attach a computer to a network so that it can participate in network communication. Which card would you suggest her to use?

Ans:-I will suggest Shagun to use Network Interface Card(NIC) or Ethernet Network Card.

4)Anjali wants to send business card of her client to one of her friends by interconnecting mobile phone using short-range wireless connection. Which technology would be the most suitable for her?

Ans:-Bluetooth Wireless Technology

D)Multiple Choice Questions.

1)Which is the most commonly used network card

i.Wifi   ii.Bluetooth    iii.Ethernet Network Card

Ans:-iii-Ethernet Network Card

2)Which wireless technology is used to interconnect mobile phones, computers, printers using a short range wireless connection?

i.Hub    ii.Bluetooth    iii.Both

Ans:-ii-Bluetooth

3)What do we call the computers which are connected to the servers?

i.Nodes    ii.Laptops    iii.PC

Ans:-i-Nodes

4)................. security means protecting data and resources from access by unauthorized persons.

i.Network    ii.Information    iii.Resource Sharing

Ans:-i-Network

5)................. is a device that connects wireless communication devices to form a wireless network.

i.WAN    ii.WiFi    iii.WAP

Ans:-iii-WAP

E)Answer the following questions.

Q1)What is networking? Give relevent examples.

Ans:-Computer networking can be defined as a group of computers or other peripheral devices that are linked together for the purpose of sharing data and hardware resources. The computers in a network may be limited through wire or wireless         

      Some examples are:-

• Communication network of Telephone system which enables us to talk to anyone, anywhere, any time.
• Network of Banks/ATM.
• Video Conferencing.
• Internet etc.

Q2)List some advantages of networking.

Ans:-The advantages of networking are:-

• Efficient use of storage media.
• Preserving information.
• Reduction in hardware costs.
• Efficiency.
• Reduces Redundancy of Paper Works.
• Quickest Document Delivery.

Q3)Differentiate between LAN and WAN.

Ans:-     LAN                                 WAN

i.   It is a Local Area Network       i. It is a Wide Area Network 

ii.  Two or more computers are     ii. Two or more computers are 

    connected within small area      connected which are located at far 

    such as room, office or a            away places.

    campus.

iii. Computers are physically          iii. Computers are linked by 

    connected with wires.                 communication facilities like 

                                                        telecommunication and satellite 

                                                        signals.

iv. Data Transmission speed is        iv. Data Transmission speed is 

     high.                                             slow.

Q4)What do you understand by network security?

Ans:-Network security means protecting data and resources from access by unauthorized persons. There are two generals levels of Network Security:-

a)Login Security

b)Rights Security

Q5) Explain client-server network.

Ans:-In client-server network, several computers are connected to a central computer called Server, the computers which are connected to the server are called clients or workstations server computers provides services to the client computers.

F)Define the following terms:-

1)WAP:-It is a wireless access point. It is a device that connects wireless communication devices to form a wireless network.

2)Bluetooth:-It is a wireless technology used to interconnect mobile phones, computers, printers. Using short range wireless connection.

3)Server:-It is a computer in client server network architecture which provides services to the client and control access to hardware, software and other resources. Server computers are generally powerful computer with fastest processor and higher storage capacity compared to client computers.

4)Node:-The computers in a network can communicate with each other as well as work independently. Each computer in a network is called a Node. Eg:-bridge, switches, hubs, modems, printers, servers are nodes to computer network.