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.