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.
