PRACTICAL (SESSION-5)
ILLUSTRATE THE VARIOUS STEPS TO CREATE
FORM USING FORM WIZARD
The steps to create a Form using Form Wizard
are:
1. First, Select the Forms Option in the Left pane in
Open Office Base, After Clicking on the Forms option,
the Forms window will appear. Afterwards, Press the
Use Wizard to Create Form Option.
2. Now, press on the Use Wizard to Create Form
Option.
3. After Clicking on the Use Wizard to Create Form
Option the Database Form Window will appear.
4.After completing the various steps to customize your Form,
which are:
Now we can see that our form is ready!
ENTER OR REMOVE DATA FROM FORMS
To enter or remove data from a form we can:
1. To remove data just select on the desired data you
want to remove and simply press backspace.
2. To enter data into a form, enter the data you have
cleared from.
DEMONSTRATE TO MODIFY FORMS.
1. Select the form you want to modify and right-click on
the selected form.
2. After clicking on the edit option, the Database Form
window will appear. In this window we can modify our
Form as we wish, we make changes like – we change
font style & size, we make our text bolder, we can
change the position & size of the boxes in the form, etc.
which are shown below:
After modifying the Form press Ctrl + S to save the changes
we have modified.
DEMONSTRATE TO MODIFY BACKGROUND.
1. To Change the background of a Form, firstly, select the
desired form and right click on it, and press the edit
option from the dialog box, after our form has
appeared right-click anywhere in the Form and press
the Edit Paragraph Styles option.
2. After pressing the Edit Paragraph Styles option,
Paragraph Styles: Default will appear, now we can
Edit our form as we wish.
SEARCH RECORD USING FORM
To search records using Form press the search ( )
option in the bottom left corner in the design
view of the desired Form.
1. After, pressing the search option, the Record Search
dialog box will appear.
2. Now, we can easily search any desired record (for ex-
Ansh Yadav ) and press search.
Now, we can see that the record has appeared for which we
have searched i.e., Ansh Yadav
INSERT AND DELETE RECORD USING FORM
VIEW
1. To insert a record using form view press on the add
record option( ) and Add the desired record.
2. After pressing the new record option, a new form will
appear and we can add records as we desire.
Now to Delete a record from a form press the Delete
Record option ( ) at the bottom of the design view
of the desired form.
1. After pressing the Delete Record option, the Warning
dialog box will appear which warns that the deleted
record will not be shown again,
After pressing the Yes option from the dialog box, the
selected record will be permanently deleted from the
form.
ILLUSTRATE THE VARIOUS STEPS TO CREATE
REPORT USING REPORT WIZARD
To create a Report, firstly, press the Report option on the
Left pane.
1. After pressing the Report option, and also the after
pressing Use Wizard to Create Report option, the
Report Wizard window will appear where we can
specify the specifications of our Report such as,
Now, we can see that our form is ready as per our
specifications.
DEMONSTRATE VARIOUS EXAMPLES OF
REPORT
Creating reports in OpenOffice Base involves
designing and generating documents that
present data from your database in a
structured format. Here are some examples of
different types of reports you can create:
1. Basic Tabular Report
Purpose: A simple report that lists data from a
table or query in a structured format.
Example:
o Data Source: A table called Students.
o Fields: Student ID, FirstName, LastName,
Class, GPA.
o Report Layout: The report lists all
students with their ID, first and last name,
class, and GPA in a tabular format.
Steps:
1. Go to Reports and click Use Wizard to
Create Report.
2. Select the Students table as the data
source.
3. Choose the fields to include: Student
ID, FirstName, LastName, Class, and GPA.
4. Customize layout and grouping (if
needed).
5. Save and generate the report.
2. Grouped Report
Purpose: Group data by a certain field, such as
grouping students by class.
Example:
o Data Source: A table called Students.
o Fields: Class, Student ID, FirstName,
LastName, GPA.
o Report Layout: The report groups
students by class, listing all students in
each class together.
Steps:
1. Go to Reports and select Use Wizard to
Create Report.
2. Choose the Students table as the data
source.
3. Select fields: Class, Student ID,
FirstName, LastName, GPA.
4. Choose to group by Class.
5. Customize the layout, including headers
and footers for each group.
6. Save and generate the report.
3. Summary Report
Purpose: Provide summary statistics, such as
averages, counts, or totals.
Example:
o Data Source: A query that calculates the
average GPA per class.
o Fields: Class, Average GPA.
o Report Layout: The report shows each
class and the average GPA of students in
that class.
Steps:
4. Create a query to calculate summary
statistics.
5. Go to Reports and use the wizard to
create a report based on this query.
6. Select fields like Class and Average GPA.
7. Choose a simple layout.
8. Save and generate the report.
4. Invoice Report
Purpose: Generate an invoice-style report,
often used for billing or purchase summaries.
Example:
o Data Source: A table called Orders and a
related table Order Details.
o Fields: Order ID, Customer Name,
Product, Quantity, Price, Total.
o Report Layout: The report displays each
order with the customer’s name, products
ordered, quantity, price, and total
amount.
Steps:
1. Create a query to join Orders and Order
Details.
2. Use the report wizard to create a report
from the query.
3. Select fields such as Order ID, Customer
Name, Product, Quantity, Price, and Total.
4. Customize the layout to resemble an
invoice.
5. Save and generate the report.
5. Labels Report
Purpose: Create mailing labels or name tags.
Example:
o Data Source: A table called Contacts.
o Fields: FirstName, LastName, Address,
City, Postal Code.
o Report Layout: The report is formatted as
labels, with each contact’s details in label
format.
Steps:
1. Create a report and select Labels as the
layout.
2. Choose the Contacts table.
3. Select fields such as FirstName,
LastName, Address, City, and Postal Code.
4. Customize the label layout.
5. Save and generate the report.
6. Graphical Report
Purpose: Include charts and graphs in your
report.
Example:
o Data Source: A table or query that
summarizes sales by month.
o Fields: Month, Total Sales.
o Report Layout: The report includes a
chart that shows sales trends over time.
Steps:
1. Create a query that summarizes data.
2. Use the report wizard to create a
report.
3. Add a chart element to the report.
4. Choose the data series and chart type.
5. Save and generate the report.
These examples should give you a good
foundation for creating various reports in
OpenOffice Base, depending on the type of
data presentation you need.
