Skip to main content

Worksheet 4 [Working with Queries] Grade 8

Answer the following questions:

Ques 1. Describe the followings:
a. Select query retrieves data from one or more tables and displays the record set in a datasheet. you can also use Select query to group data, and to calculate sum, count average, and other types of total.

b. Parameter query is a type of select query that prompts you for input before it runs. the query then uses your input as criteria that controls the results. For example: You can design it to prompt for two dates.

c. Action query creates a new table or alters your data or database by adding, deleting, updating and appending data from it.

d. Cross tab query uses row headings and column headings, so that you can see your data in terms of two categories at once.

Ques 2. What are the different views of Form in MS ACCESS 2010? Explain.
Ans. There are three main views of Form in MS Access 2010:-
a. FORM VIEW: It is used to enter, edit and view data.
b. DESIGN VIEW: It is used to adjust the design of your form.
c. LAYOUT VIEW: It is used to change the appearance and size of various controls of a form.

Ques 3. Write steps to set the relationship between tables.
Ans. a. Click on the Database tools tab. Select the Relationship button from the Relationship group.
b. The show table window appears, select the required table and click on the add button. the selected table will appear as a small window in the Relationship window. Likewise, add another tables to the Relationship window.
c. Click on the close button to close the show Table dialog box.
d. You can activate the "Queries" tab if your relationship are based on queries, or activate 'both' tab if relationship are based on both the tables and queries.
e. Drag the primary key of the parent table and drop it over the same field in the child table.
f. The cursor changes to an arrow and the Edit relationships dialog box appears.
g. Click on the create button. Access creates the relationship between the tables. this helps in Joining two tables to form a large table. Thus, it reduces data redundancy and data inconsistency.
h. A line linking the two tables will appear indicating that both have been linked on the basis of the lined field.
i. Click on the save button on the Quick Access Toolbar to save the Relationship.

Comments

Post a Comment

Popular posts from this blog

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. Describ
2 comments
Read more

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

Ch-12 SURFING INTERNET

ANSWER THE FOLLOWING QUESTIONS: Ques: How do computers on the internet communicate with each other? Ans. Computers use TCP/IP[Transmission control protocol/Internet protocol) to communicate with each other over the internet. Ques: What do you know about hypertext? Ans. Hypertext is text that links to other information. By clicking on a link in a hypertext document, a user can quickly jump to different content. Ques: Explain the term URL. What is the use of it? Ans. URL refers to the address of a World Wide Web page. As the name suggests, A URL indicates the location of a resource as well as the protocol used to access it. Ques: What do you understand by streaming media? Ans. Streaming media is video or audio content sent in compressed form over the Internet and played immediately, rather than being saved to the hard drive.. With streaming media, a user does not have to wait to download a file to play it. Because the media is sent in a continuous stream of d
8 comments
Read more