L-6 Forms/ Query Class 8th

 

Class- VIII

Subject: Computer

L-6 Forms and query

A)  Fill in the blanks:

 

1)    Ms-Access is a relational management system.

2)    A database stores vast amount of data.

3)    Reports collect the summarized data from one or more tables.

4)    All the columns in a table are called fields.

5)    It has a field name ‘ID’, which is considered the primary key.

 

B)  Write short notes on :

1)    Forms:

Ans: Forms in Microsoft Access provide a user-friendly interface for interacting with the data in a database. They allow users to view, enter, and edit data in a structured manner.

Forms are designed to present the data in a visually appealing and organized way, often resembling paper forms. They can include text boxes, buttons, drop-down menus, and other controls for data input.

Forms can also include features like validation rules, which help ensure that data entered meets certain criteria. They can be customized to control the flow of information and automate tasks within the database.

2)    Report:

Ans: Reports in Microsoft Access are used to present data in a structured and organized format for printing or viewing on the screen. They are often used to create professional-looking documents based on the information stored in the database.

Reports allow for the inclusion of headers, footers, page numbers, and other elements to enhance the presentation. They can include data from one or more tables and can be customized to display specific information in a desired format.

Reports are particularly useful for summarizing and analyzing data, as well as for generating documents like invoices, statements, or any other form of printed output.

3)    Query:

Ans: Queries in Microsoft Access are used to retrieve, manipulate, and analyze data from one or more tables. They allow users to ask specific questions or perform operations on the data stored in the database.

Queries can be simple, such as retrieving all records that meet certain criteria, or they can be complex, involving multiple tables and various operations like joins, calculations, and aggregations.

They can also be used to update, delete, or append records in a database. Queries provide a powerful tool for extracting meaningful information from a large dataset without the need to manually search through it.

 

C)  Short answer type questions:

 

1)    What is database management system.

Ans: A Database Management System (DBMS) is a software application that enables users to interact with a database. It facilitates the creation, storage, retrieval, and manipulation of data in a structured and organized manner. DBMS provides tools for managing the data, ensuring its integrity, and allowing multiple users to access and work with the database simultaneously.

 

2)    Difference between the relationship and design view.

Ans: Relationship View: In Microsoft Access, Relationship View is used to establish and manage relationships between tables in a database. It visually represents the connections between tables, showing how they are linked based on common fields.

Design View: Design View is where users can define the structure of a table or modify its properties. It allows for the addition of fields, setting data types, specifying primary keys, defining validation rules, and other design-related tasks.

 

3)    Can you create more than one table in the same database? Explain.

Ans: Yes, you can create more than one table in the same database. In fact, it's common to have multiple tables within a single database. Each table can represent a different category of information, and they can be related to one another through common fields. This allows for efficient organization and management of data, enabling users to perform complex queries and generate meaningful reports.

D)   Practical

Create report of General data ( information of students) of your class.

To create a report of general data (information of students) of your class in Microsoft Access, follow these steps:

1.     Open Microsoft Access and select the database in which you want to create the report.

2.     Go to the "Create" tab in the ribbon at the top of the screen.

3.     Click on "Report Design" to open the Report Design view.

4.     In the "Add Existing Fields" section, select the table that contains the general data of students.

5.     Drag and drop the fields (such as name, age, address, etc.) from the table onto the report design surface to include them in the report.

6.     Arrange and format the fields as desired on the report.

7.     Add any headers, footers, and additional elements you want to include in the report.

8.     Save the report by giving it a name.

9.     Close the Report Design view and return to the main database window.

10.  To view or print the report, select it from the list of objects in the database and click "Open".

You have now created a report displaying the general data of students in your class.

 

L-5 HTML and CSS / Class 7th

 Class - 7th 

Subject : Computer

L-5 HTML and CSS

A) Tick the correct option:

1) Which tag is used for ordered list?

a) <li>

b) <ol>

c) <ul>

d) <dl>

Ans: b) <ol>

2) Which of the following can't be the value of list-style-type?

a)  square

b)  circle

c)  ellipse

d)  disc

Ans: c)  ellipse

3) Which element contains definition?

a)  <dl>

b)  <dd>

c)  <dt>

d)  <ul>

Ans: c)    <dt>

4) Which attribute is only used with <ol>?

a)  value

b)  type

c)  compact

d)  start

Ans: b)    type

5) Identify tag which is used for unordered list?

a)  <li>

b)  <ol>

c)  <ul>

d)  <dl>

Ans: c)    <ul>

6) Which type of CSS is used in the below code?

<p style="border:px solid red;">

a)  Inline CSS

b)  Internal CSS

c)  External CSS

d)  None of the above

Ans: a)    Inline CSS

B) Fill in the blanks:

1) By default, ordered list starts with 1.

2) The <li> tag is used to define list item.

3) A list within another list is called nested list.

4) The src stands for source in image tag.

5) Alt  attribute of an image is used, when image is not displayed.

6) 'Background-color' property in CSS used to change the background color of an element in HTML.

C) State 'T' for True or 'F' for False.

1) <IMG> tag is used to insert an image in a web page           TRUE

2) Src attribute specify the source of an image.                       TRUE 

3) By default, unordered list starts with disc.                           TRUE

4) There are two types of images: Inline and External images. FALSE

5) The HTML attribute used to define the inline styles is style. TRUE

6) JPG, PNG, and JPEG are image formats.                               TRUE

D) Short answer type questions:

1) Define a list.

Ans: A list is an HTML element used to group together related items in a specific order or hierarchy.

2) What is the use of Description List?

Ans: A Description List in HTML (<dl>) is used to define terms and provide a description or definition for each term.

3) How we can insert image in a table? give example

Ans: To insert an image in a table, you can use the <img> tag within a <td> (table data) element. Here's an example:

<Table>

<TR>

<TD><img src="image.jpg" alt="description of the image"> </td>

<td> other content</td>

</TR>

</Table>

4) What do you understand by CSS.

Ans: CSS stands for Cascading Style Sheets. It's a stylesheet language used to control the presentation and layout of a web page written in HTML or XML. CSS allows you to apply styles (such as colors, fonts, spacing, etc.) to elements on a webpage, making it visually appealing and user-friendly.

E) Long answer type questions:

1) Differentiate between ordered and unordered list?

Ans: Ordered List vs Unordered List:

• Ordered List: The items in an ordered list are marked with numbers or letters by default. It is created using the <ol> tag.
• Unordered List: The items in an unordered list are marked with bullets (discs, squares, etc.) by default. It is created using the <ul> tag.
• 
  

2) What are the different attributes of an image tag. (list any three)?

Ans: Attributes of an Image Tag:

• src: Specifies the source (URL) of the image.
• alt: Provides alternative text for the image, which is displayed if the image cannot be loaded.
• width and height: Set the dimensions of the image.
• 
  

3) Write any one difference between internal & external style sheet?

Ans: Difference between Internal & External Style Sheet:

• Internal Style Sheet: It is defined within the HTML document using the <style> tag in the head section. It applies styles only to the current document.

• External Style Sheet: It is a separate file with a .css extension that contains all the styles. It is linked to the HTML document using the <link> tag. It can be used to style multiple HTML documents.

F) Application based   questions:

1) Aditi wants to celebrate her birthday. So she is interested to make a list of guests. Suggest her which tag she will use to make list?

Ans: Aditi can use the <ul> (unordered list) or <ol> (ordered list) tags to make a list of guests.

2) Mehul is interested to create a list of state and capitals of India. Which tag you will suggest him to make a list?

Ans: Mehul can use the <dl> (definition list) tag to create a list of states and their capitals in India.

.

L-5 HTML/ Class 6

 Class -VI

L-5 Basic of HTML

A) Fill in the blanks:

1) <title> tag is used to display the title of the document.

2) HTML tags are divided into two categories.

3) We can save our HTML file with .html extensions.

4) <br> tag is used to move your text on next line.

5) The attributes of font tag are color, face and size.

B) State 'T' for True or 'F' for False:

1) <B> tag is used to make out text bold.            TRUE

2) Heading tag has six levels from H1 to H6       TRUE

3) HEAD section contains body part.                   FALSE

4) HTML is a case sensitive language.                 FALSE

5) Container tag has both starting and ending.      TRUE

C) Short answer type questions:

1) Name some popular web browser.

Ans: Some popular web browsers:

1. Google Chrome
2. Mozilla Firefox
3. Microsoft Edge
4. Apple Safari
5. Opera
6. Brave
7. Vivaldi
8. UC Browser
9. Tor Browser

2) How many levels of heading tag have? Name highest and lowest level.

Ans: HTML has six levels of heading tags, ranging from <h1> (highest level) to <h6> (lowest level).

3) Name the tag use to change the appearance of the text. Also give its attributes.

Ans: The <font> tag is used to change the appearance of text in HTML. However, it is now considered obsolete, and the use of CSS is recommended for styling. If you still want to change the appearance of text, consider using CSS properties like font-family, font-size, and color.

D) Long answer type questions:

1) What are the characteristics of HTML language?

Ans: HTML (Hypertext Markup Language) is a markup language used for creating the structure of web pages. Here are some key characteristics of HTML:

1. Markup Language: HTML uses a markup structure with tags to define elements on a web page. Tags are enclosed in angle brackets, such as <tag>.
2. Hierarchy and Nesting: HTML elements can be nested within each other to create a hierarchical structure for content on a web page.
3. Document Structure: HTML documents have a standard structure, including a head section for metadata (title, links to stylesheets, etc.) and a body section for the main content.
4. Platform-Independent: HTML is platform-independent and can be rendered on various devices and browsers, providing a consistent structure for content.
5. Linking and Embedding: HTML allows the creation of hyperlinks to link one page to another or to link to different types of resources. It also supports embedding multimedia elements like images and videos.
6. Semantic Markup: HTML provides a set of semantic tags (e.g., <header>, <footer>, <article>) that give meaning to the content, making it more accessible and understandable for both browsers and developers.
7. Extensibility: HTML can be extended through the use of attributes and custom data attributes to provide additional information about elements.
8. W3C Standards: HTML is maintained and developed by the World Wide Web Consortium (W3C), ensuring standardization and compatibility across different platforms and browsers.
9. Versioned: HTML evolves over time, with new versions introducing features, improvements, and optimizations. HTML5 is the latest major version.

2) Write the basic structure of HTML document.

Ans: The basic structure of an HTML document consists of five essential elements:

1. <!DOCTYPE html>: This declaration informs the browser about the HTML version used in the document.

2. <html>: The root element of an HTML document, encompassing the entire webpage's structure.

3. <head>: Contains metadata about the HTML page, including the title, character encoding, and links to external resources like CSS files.

4. <title>: Specifies the title of the HTML page, which is displayed in the browser's title bar or tab.

5. <body>: Defines the main content of the HTML page, containing all the visible elements like text, headings, images, links, tables, lists, and other interactive components.

3) Differentiate between container and non container tag?

Ans: In HTML, tags are used to define the structure and formatting of a webpage. Among these tags, container tags and non-container tags play distinct roles in organizing and presenting content.

Container tags are paired tags that enclose and group other elements within the webpage. They act as containers or wrappers for other tags, defining sections or blocks of content. Examples of container tags include <div>, <p>, <table>, and <ul>.

Non-container tags, also known as empty tags, are self-closing tags that do not require a closing tag. They represent specific elements or actions within the webpage and do not enclose any other content. Examples of non-container tags include <br>, <hr>, <img>, and <meta>.

4) Expand the terms:

•  <B> Define bold text.
•  <BR> Insert a single line break.
•  <HTML> Define HTML document.
• <HEAD> Define information about the document.
• <TITLE> Define the title of the document which will display at the title bar.
• <BODY> Define document body.
• <H1> to <H6> Define HTML headings.
• <P> Define paragraph.
• <I> Define italic text.
• <U> Define underlined text.
• <FONT> Define font, color and size for the text.
• <SUB> Define subscript text.
• <SUP> Define superscript text.
• <STRONG> Define important text.
• <HR> To insert horizontal rule.
• <IMG SRC> To insert an image.