Kips Class 8 IT Beans Chapter 4 Working with Tables

Chapter 4 Working with Tables

Brain Developers
A. Fill in the blanks:
1. In Memo data types, we can store a maximum of 65,536 characters.
2. The AutoNumber generates a sequential number, whenever a new record is added to a table.
3. A field property is an attribute that defines the field’s appearance or behaviour within a database.
4. Tab key is used to move to the next column.
5. Hyperlink stores up to 1 GB of data.
6. The text data types is used to store text.
7. The Primary key is a toggle key.
8. To delete a row, first select the row and then click on delete rows button on the Design tab.

B. State True or False:
1. A table can have only one Primary key. (True)
2. Remove Sort command is located in the Sort & Filter group. (True)
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)
Correct Answer:
Shift + Tab key moves the cursor to the previous field.
6. It is not essential to specify data type for a field name. (False)
Correct Answer:
It is essential to specify data type for a field name.
7. A number data type can store only integer values. (False)
Correct Answer:
A number data type can store integer values as well as decimal values.
8. OLE data type stores a link to a web page. (False)
Correct Answer:
OLE data type is used to embed an object created in another application 

C. Application Based Questions:
1. Your teacher has shown you the following table structure:

Application Based Question

In your opinion, 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.
Answer:
Mobile number

2. 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?
Answer:
OLE object

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
Answer:
a) Shift + Tab

2. What is the maximum number of characters that can be used to define a field name?
a) 46
b) 62
c) 64
Answer:
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
Answer:
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
Answer:
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
Answer:
a) Ctrl + W

6. Which icon indicates the Edit mode in Access?
a) Eraser
b) Pen
c) Pencil
Answer:
c) Pencil

E. Answer the following:
1. Define the term Table with respect to Microsoft Access.
Answer:
A table is a database object, which is used to store information in an organised manner. It consists of rows and columns with small rectangles called cells, where rows and columns intersect. These records and columns are referred to as records and fields respectively.

2. What do you mean by Data types?
Answer:
Data types are used to declare the fields of a table. A data type determines the type of data, a particular field can accept. 

3. Explain the use of Primary key in a table.
Answer:
Primary key is a standard feature of every database management system. A Primary key is a sort of check on the table that uniquely identifies each record in a table. It doesn’t contain any duplicate data. A table can have only one Primary key. The value in the Primary key field is different for every record and thus helps in uniquely identifying the record.

4. State the difference between OLE and Hyperlink.
Answer:

• OLE: This is used to embed an object created in another application, such as Microsoft Word document, Excel spreadsheet, or PowerPoint presentation into the Access table. 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.

5. What do you understand by the term Field Property?
Answer:
A Field Property is an attribute that defines the field’s appearance or behaviour within a database.

6. How will you sort the data within a table?
Answer:

• Select the field that has to be sorted.
• Click on the drop-down arrow next to the right of the field.
• Select either Sort Smallest to Largest or Sort Largest to Smallest option from the drop-down list.
• The database will be sorted.

7. Name the views in which a table can be displayed.
Answer:
Design view and Datasheet view are the two views in which a table can be displayed.

No comments:

Post a Comment

Also read!

Class 6 Solutions

• Class 7

Class 7 Computer Kips Solutions
Class 7 Gul Mohar English Solutions
English Grammar Class 7
English Writing Skills Class 7
Class 7 Map Pointing Solutions
Class 7 NCERT Civics Solutions
Class 7 NCERT Civics Notes
Class 7 NCERT Civics Extra Questions
Class 7 NCERT Geography Solutions
Class 7 NCERT Geography Notes
Class 7 NCERT Geography Extra Questions
Class 7 NCERT History Solutions
Class 7 NCERT History Notes
Class 7 NCERT History Extra Questions
Class 7 NCERT Maths Solutions
Class 7 NCERT Science Solutions
Class 7 NCERT Science Notes
Class 7 NCERT Science Extra Questions

• Class 8

Class 8 Kips Artificial Intelligence Solutions
Class 8 Gul Mohar English Solutions
English Grammar Class 8
English Writing Skills Class 8
Class 8 Map Pointing Solutions
Class 8 NCERT Civics Solutions
Class 8 NCERT Civics Notes
Class 8 NCERT Civics Extra Questions
Class 8 NCERT Geography Solutions
Class 8 NCERT Geography Notes
Class 8 NCERT Geography Extra Questions
Class 8 NCERT History Solutions
Class 8 NCERT History Notes
Class 8 NCERT History Extra Questions
Class 8 NCERT Maths Solutions
Class 8 NCERT Science Solutions
Class 8 NCERT Science Notes
Class 8 NCERT Science Extra Questions
Class 8 NCERT Science Exemplar
Class 8 NCERT Science MCQs

Class 9 Solutions

• Class 10

Class 10 Kips Artificial Intelligence Solutions
Class 10 NCERT English Solutions
→ Class 10 Map Pointing Solutions
Class 10 NCERT Civics Solutions
Class 10 NCERT Civics Notes
Class 10 NCERT Civics Extra Questions
Class 10 NCERT Geography Solutions
Class 10 NCERT Geography Notes
Class 10 NCERT Geography Extra Questions
Class 10 NCERT History Solutions
→ Class 10 NCERT History Notes
Class 10 NCERT History Extra Questions
Class 10 NCERT Maths Solutions
Class 10 NCERT Science Solutions
Class 10 NCERT Science Notes
Class 10 NCERT Science Extra Questions

• Computer languages
Python Basics

• Extra Activities
Extra Activities

• Extra Knowledge
Extra Information
General Knowledge
Historical Places in India
Latest technology
Physical Sciences
Facts

• Mathematics quick links
Mathematical Terms
Maths Tricks

CONTACT US