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.