Sunday, November 18, 2012

Std - 8 - Chapter 5

Creating Web Page Using HTML

1.
What is the use of <IMG> tag?

<IMG> tag is used to add pictures in web pages.
Eg: <IMG SRC=”hello.jpg”>
2.
How do you make a text bold in the HTML document?

Type <B>
Type the text
Type </B>
3.
State the use of <TABLE> tag.

Table tag is used to add table in your web page.  Inside the <Table> tag <TR> is used to add table rows and <TD> is used to add table columns.
4.
What are headers in a web page? Why are they used?

Headers are like chapter headings of a book.  We can use six different headers in our web page.  Header tag is written as <Hn> and </Hn> where n is a number from 1 to 6.
Eg: <H1>Welcome to my web page</H1>
5.
Differentiate between ordered list and unordered list?

An ordered list is a numbered list.  It starts with the <OL> tag.  An unordered list is a bulleted list. It starts with <UL> tag.  In both list items can be added with <LI> tag.
6.
Write the procedure to add background colour to your web page.

<BODY BGCOLOR=”RED”>
Type the Text
</BODY>
7.
How do you change the font colour of your text in HTML?

Font color is used to change the colour of the text. 
Type <FONT COLOR=”Colour Name”>
Type the text
Type </FONT>
8.
Explain the use of anchor tag with example.

<A> tag is used define hyperlink.  The HREF attribute is used set the location or URL of the destination page or site.  The text between the opening and closing anchor tag becomes the hypertext or link text.
Steps:
Type <A HREF=”location”>
Type the text
Type </A>
9.
State the use of Comments in HTML.

Comments are like notes.  Comments are not visible in the browser.
To add comments
Type <!
Type the comments
Type >

Saturday, November 17, 2012

Std - 8 - Chapter 4

Introduction to HTML

1.
What is a text editor?

Text editor are programs that are used to create or compose HTML documents.
2.
What are attributes?

Attributes offers many options for the tag.  Attributes can have values.  Attributes are written within angular brackets one after another with a space in between each of them.
3.
What is the use of <TITLE> tag?

This tag is used to give title to the HTML document.  This tag is used inside the <HEAD> tag.
4.
What is a server?

The individual computers are connected to some powerful computers called servers.
5.
Which are the reserved symbols in HTML?

Greater than (>), Less than (<), Straight double quotes (“ “) and Ampersand (&) symbols are reserved symbols in HTML.
6.
Define website and web page?

Websites are the files that stored by web servers.  The pages or documents contained by websites are called web pages.
7.
What are tags in HTML?

A tag is an HTML command that controls the structure and appearance of the page or document that is created. Every tag has attributes or special properties.
8.
Differentiate between empty tag and non-empty tag?

Empty tags are those that do not require a closing tag. Eg. <HR>, <BR>
Non-empty tags require an opening (ON) tags and closing (OFF) tags. Eg. <HTML>, <BODY>
9.
What is HTML? Write some features of HTML?

HTML stands for Hyper Text Markup Language.  HTML allows the user to link several related information already stored in the computer or server that can be accessed from anywhere around the world.
Features:
·         HTML documents are simple text files.
·         There is no need of compiling as in the case of other programming languages.
·         It is not a case sensitive language.
·         HTML documents can be viewed on any type of computer platform.
10.
How are HTML documents viewed in web browsers?

Web browsers act as HTML formatters.
Steps to view HTML: (Open any web browser)
1)      Click the File menu -> Open
2)      Click Browse button.
3)      From the dialog box, select the location and choose your html file and click Open button.
We can also view our HTML document by directly opening the .html file from the location where we have saved it.

Sunday, September 2, 2012

Std - 8 - Chapter 3

MS Access 2007: Queries, Forms and Reports
1.
When do you use a Form?
Form is a graphical representation of a table.  Forms are useful to add, update and delete records in a table.
2.
What is the use of Criteria row in the Query design grid?
Criteria row helps to filter the records according to a given criteria.
3.
Name the three views in which a form is displayed.
Form View, Layout View and Design View.
4.
How do you adjust the design of your form?
By clicking the design button and adjust our form accordingly.
5.
How do you create a form?
1.      Select the table for which you want to create the form
2.      Click the Create tab on the Ribbon
3.      Click Form in the Forms group.
6.
Define a query, form, report.
Query: a query displays specific records from a table that meet a certain criteria.
Form: A form is a graphical representation of a table.
Report: A report is an effective way to present the data in a printed format.
7.
Explain the design grid of the query window.
Design grid helps to add fields to the query and also specify the criteria.  Design grid contains
a)      Field row: displays the fields from the selected table.
b)      Table row: displays the name of the table
c)      Sort row: is used to filter the data in ascending or descending order.
d)     Show row: displays check mark which indicates that this field will be visible when the query is run.
e)      Criteria row: is used to specify the condition on the basis of which the records will be filtered.
f)       Or row: is used to specify multiple criteria.
8.
How do you apply multiple criteria to the same table? Explain through an example.
You can apply multiple criteria to the same table. If you place two criteria on the same line, Access will only retrieve records where both criteria are met. For example, if you want all records where the State is equal to "DE" and the Last Name is equal to Smith, you would set the State field to = "DE" and the Last Name field to = "Smith" and you would place both criteria on the same line.

If you place one set of criteria on the Criteria line and the second set of criteria on the Or line, Access will retrieve records if either criteria are met. For example, you want all records where the State is equal to "DE" or the Last Name is equal to Smith. You would set the State field to = "DE" and the Last Name field to = "Smith" and you would place one set of criteria on the Criteria line and the other set of criteria on the Or line. Access will bring back all records where the state equals DE and all records where the Last Name is equal to Smith no matter what the State is. You can add additional AND, OR statements by using the lines below the Or line. For And clauses, place the criteria on the same line; for Or clauses, place the criteria on separate lines.
9.
Lab Practicals
1.      Page No: 34 (Practical in Computer Lab)
2.      Page No: 37 (Hands-on Activity)

for extra reading
http://www.baycongroup.com/access2007/05_access.html

Std - 8 - Chapter 2

MS Access: Learn to use Access 2007
1.
What is RDBMS?
RDBMS is a Relational Data Base Management System Relational DBMS. This adds the additional condition that the system supports a tabular structure for the data, with enforced relationships between the tables. 
2.
What are forms and reports used for?
A form is simply a way to enter data into the database and reports are designed to be printed.
3.
Name all the data types available in MS Access.
Text Field, Numeric Field, Currency Field, Date/Time Field, Memo Field, Yes/No field.
4.
Name the shortcut key to quit MS Access.
Alt + F4
5.
Mention the different ways to create a database.
Creating a blank or empty database, Using the database Wizard, and using a template.
6.
What are the manipulation operations that can be done on a table?
Add, Update and delete a record are the manipulation operations on a table.
7.
Define the terms: Record, Field, Table, and Query.
Record: records describe information sources.
Field: are the building blocks of records.  Fields are the sections of a record where information is stored.
Table: A table is a collection of data about a specific topic.
Query: A query is used to extract information from a database.
8.
Differentiate Datasheet View and Design View
Datasheet View displays the view, which allows us to enter raw data into the database.  Design view displays the view, which allows us to enter fields, data types and the description into the database table.
9.
What is a primary key? State its use in a table.
The primary key is the unique identifier for each record, such as an employee number or admission number of a student.
10.
Write some advantages of a database.
Easy retrieval of data
Easy sharing of data
Reduced data redundancy
Reduced updating errors and increased consistency
Greater data integrity
Data security
Easy manipulation of data etc. 
11.
What do you understand by table structure?
A table structure identifies the name, size and types of various fields.
12.
What is the use of creating relationships between tables?
We can create queries, forms and reports to display information from several tables at once.
13.
Explain the text and numeric field types.
Text Field: A text field contains letters, numbers and symbols.  The numbers in a text field are considered as text and cannot be used for calculation.
Numeric Field: It contain numbers and does not accept letters or other symbols except numbers.

Std 7 - Chapter - 7 More on Internet

Chapter - 7 More on Internet 1. What is World Wide Web? The World Wide Web (abbreviated as WWW...