Skip to main content

Worksheet 3 [Working with Tables] Grade8

Answer the following questions:

Ques 1. What is a Relational database?
Ans. A Relational database is a collective set of multiple data sets organized by tables, records and columns. relational databases establish a well-defined relationship between database tables.

Ques 2. What do you know about Field Property?
Ans. A field property is an attribute that defines the field's appearance or behavior within a database.

Ques 3. Differentiate between Text Data type and Memo Data type.
Ans. 


Ques 4. Write steps to set the field's properties.
Ans. a. click on the field name for which you want to set the field properties.
b. You will observe that the general tab is selected by default in the 'Field Properties' area.
c. Set the properties of all the fields as required.
d. After finishing the task, you must save the table by clicking on the save button on Quick Access Toolbar.
e. The table is now added to the navigation pane.

Ques 5. Describe the views of table. Also explain how to switch between different views.
Ans. There are two views of table:
a. Design View: In design view of the table, you can enter the field names, their data types and description. the design view is divided into two parts: Field Grid Pane and Field properties Pane.

b. Datasheet View: Datasheet view is used to enter data in a table.

To Switch between different views:
a. Click on the view option in the views group on the Home tab to change the desired view.
                                         or
Click on the Design view or Datasheet view buttons at the right corner of the status bar.

Comments

Post a Comment

Popular posts from this blog

Worksheet 5 [Adobe Photoshop CS3] Grade 8

Answer the following questions: Ques 1. Describe the components of Adobe Photoshop CS3. Ans. 1. TITLE BAR: It is the top most horizontal bar of the application window that displays the name of the program. 2. TEXT MENU: It is located below the title bar. It shown the ten different menus like file, edit, image, layout, select, filter, analysis, view, window and help. 3. CONTEXT MENU: Immediately below the text menu, is the context menu. The items in this menu change to reflect the options associated with the tool being selected. It is also known as Options bar. 4. WORK-SPACE: it contains the image that you want to edit. it is also known as image window. 5.TOOLS PALETTE: Along the left side of the Photoshop window, we find the Tools Palette. It works like an artist's paint box and holds a variety of tools which help us to draw paint,  and manipulate the images. Ques 2. What do you understand by "Expand Dock". Ans. The Expand dock is present on the top ...
2 comments
Read more

Worksheet 2 [Log on to Access] Grade 8

Answer the following questions: Ques 1. Differentiate the followings: a. File vs. Database b. Field vs. Record c. Primary key vs. Composite key Ques 2. Define templates. Ans. Templates are pre-built database focused on a specific task. These can be used instantly and can also be downloaded. Ques 3. What are the different database objects in Microsoft Access. Ans. The different database objects in Microsoft Access are tables, queries, forms and reports. Ques 4. Define DBMS. Ans. DBMS stands for Database Management System. It is an application software, which is used to create, modify and extract data from a database. It manages and organizes the records in the form of tables. Ques 5. Describe any five components of MS ACCESS 2010. Ans.a. TITLE BAR: It is located at the top of the window and displays the name of the current database. b. QUICK ACCESS TOOLBAR: This toolbar is present at the top left corner of the Access Window. it contain...
2 comments
Read more

Ch-6 ADOBE PHOTOSHOP CS3

Answer the following Questions: Ques 1. What is Adobe Photoshop? Describe the features of Adobe Photoshop. Ans. Adobe Photoshop, popularly known as Photoshop, is a graphics editing program developed by Adobe System. Features of Photoshop CS3 professional are: a. Revised user-friendly interface. b. Photo-editing or manipulation in lesser time with little efforts. c. Create graphics for web applications with reduced file size. d. Layer effects preserve the original state of an image while manipulating another version of it through another layer. e. Crop or resize picture without losing quality of image. f. Enhance or change the color of an image by adjusting the brightness, contrast and color balance, etc. g. Remove the unwanted object from the picture by using Vanishing point tool. h. With the new quick selection tool, users need to click and drag across an image to make fast selections. Ques 2. Explain the use of Magic Wand Tool? Ans. The Magic Wand Tool, simply know...
2 comments
Read more