To create a new database, click the arrow next to the New database . In the drop – down me nu, select Database . This opens the Database Wizard. You… [601164]

1

CREATING A NEW DATABASE

To create a new database, click the arrow next to the
New
database
. In the drop
–
down me
nu,
select Database .
This opens the Database Wizard. You can also open the Database Wizard using
File > New > Database.

1
st
–

step



The first step of the
*
Database Wizard has one question with two choices: Create a new
database or Connect to an existing database. For this example, select Create a new
database and then click Next.

2
nd
–
step



The second step has two questions with two cho
ices each. The default choice for the first
question is
Yes register the database

for me and the default choice for the second
question is Open the database for editing. Make sure these choices are selected and click
Finish.

3
rd
–
step



Save the new d
atabase with the name Norton_database and to find the location that can
be used to save as your
Qua
ries
, Form

and Report

Creating Tables

There are four (4) tables required to create in this Notown database
a)

Album

b)

Instrument

c)

Musician

d)

Song

Album

Require of this table



Procedure



Observation



Result

2

atabase with the name Norton_database and to find the location that can
be used to save as your
database

name

and

start to create different task like
and Report
.

There are four (4) tables required to create in this Notown database

atabase with the name Norton_database and to find the location that can
start to create different task like
Table
,

1
st
.

for creating table of Album of a database
Procedure



Click Table and select
Using the

Using the Wizard to create a table


Every table requires a Primary key field. (What this field does will be explained later.)
We will use this field to number our entries and want that number to automatically
increase as
we add each entry.


To work with tables, click the Tables icon in the Database list, or use .The three tasks that
you can perform on a table are in the Task

Set field types and formats

Observation



In this step you give the fields their properties. When you click a field, the information on
the right changes. You can then make changes to meet your needs.
at a time, and make the changes listed below.
Then field the space of fie
Field type

AlbumIdentifier

Speed

Title

ssn(FK)

Copyright

3

for creating table of Album of a database

Using the
Wizard to create a table

Using the Wizard to create a table

Every table requires a Primary key field. (What this field does will be explained later.)
We will use this field to number our entries and want that number to automatically
we add each entry.

To work with tables, click the Tables icon in the Database list, or use .The three tasks that
you can perform on a table are in the Task

In this step you give the fields their properties. When you click a field, the information on
the right changes. You can then make changes to meet your needs.

Click each field, one
at a time, and make the changes listed below.

Then field the space of fie
ld name and field type

Formats

(Text [Varchar] )
(Text [Varchar] )
(Text [Varchar] )
(Text [Varchar] )
Date [date]

Every table requires a Primary key field. (What this field does will be explained later.)
We will use this field to number our entries and want that number to automatically
To work with tables, click the Tables icon in the Database list, or use .The three tasks that
In this step you give the fields their properties. When you click a field, the information on
Click each field, one
(Text [Varchar] )

(Text [Varchar] )

(Text [Varchar] )

(Text [Varchar] )

Result

After observation the table displayed like this after fill

Instruments

Require of this table



Procedure



Observation



Result

Procedure



Click Table and select Using the Wizard to create a table

4

After observation the table displayed like this after fill
ing

all field type and format type
Click Table and select Using the Wizard to create a table

all field type and format type

Using the Wizard to create a table


Every table requires a Primary key field. (What this field does will be explained later.)
We will use this field to number our entries and want that number to automatically
increase as we add each entry.


To work with tables, click the Tables icon in the
you can perform on a table are in the Task

Set field types and formats

Observation



In this step you give the fields their properties. When you click a field, the information on
the right changes. You can then make changes to meet your needs.
at a time, and make the changes listed below.
Then field the space of fie
Field type

Instru_id

N
ame

K
ey

ssn(FK)

Result



After observation the table displayed like this after filling all field type and format type

5

Using the Wizard to create a table

Every table requires a Primary key field. (What this field does will be explained later.)
We will use this field to number our entries and want that number to automatically
increase as we add each entry.

To work with tables, click the Tables icon in the
Database list, or use .The three tasks that
you can perform on a table are in the Task

In this step you give the fields their properties. When you click a field, the information on
the right changes. You can then make changes to meet your needs.

Click each field, one
at a time, and make the changes listed below.

Then field the space of fie
ld name and field type

Formats

(Integer[
INTEGER]
(Text [
VARCHAR
(Text [
VARCHAR
(Text [
VARCHAR
After observation the table displayed like this after filling all field type and format type
Every table requires a Primary key field. (What this field does will be explained later.)
We will use this field to number our entries and want that number to automatically
Database list, or use .The three tasks that
In this step you give the fields their properties. When you click a field, the information on
Click each field, one
INTEGER]
)

VARCHAR
] )

VARCHAR
] )

VARCHAR
] )

After observation the table displayed like this after filling all field type and format type

Musicians

Require of this table



Procedure



Observation



Result

Procedure



Click Table and select Using the Wizard to create a table

Using the Wizard to create a table


Every table requires a Primary key field. (What this field does will be explained later.)
We will use this field to number our entries and want that number to automatically
increase as we add each entry.


To work with tables, click the Tables icon in the
you can perform on a table are in the Task

Set field types and formats

Observation



In this step you give the fields their properties. When you click a field, the information on
the right changes. You can then make changes to meet your needs.
at a time, and make the changes listed below.

6

Click Table and select Using the Wizard to create a table

Using the Wizard to create a table

Every table requires a Primary key field. (What this field does will be explained later.)
We will use this field to number our entries and want that number to automatically
increase as we add each entry.

To work with tables, click the Tables icon in the
Database list, or use .The three tasks that
you can perform on a table are in the Task

In this step you give the fields their properties. When you click a field, the information on
the right changes. You can then make changes to meet your needs.

Click each field, one
at a time, and make the changes listed below.

Every table requires a Primary key field. (What this field does will be explained later.)
We will use this field to number our entries and want that number to automatically
Database list, or use .The three tasks that
In this step you give the fields their properties. When you click a field, the information on
Click each field, one

Then field the space of
Field type

S
sn

Fname

Middlename

Surname

Phonenumber

Postcode

City

Street

Country

Result



After observation the table displayed like this after filling all field type and format type

7

Then field the space of
field name and field type

Formats

(Integer[INTEGER] )
(Text [VARCHAR] )
(Text [VARCHAR] )
(Text [VARCHAR] )
(Integer[INTEGER] )
(Integer[INTEGER] )
(Text [VARCHAR] )
(Text
[VARCHAR] )
(Text [VARCHAR] )
After observation the table displayed like this after filling all field type and format type
(Integer[INTEGER] )

(Text [VARCHAR] )

(Text [VARCHAR] )

(Text [VARCHAR] )

(Integer[INTEGER] )

(Integer[INTEGER] )

(Text [VARCHAR] )

[VARCHAR] )

(Text [VARCHAR] )

After observation the table displayed like this after filling all field type and format type

Song

Require of this table



Procedure



Observation



Result

Procedure



Click Table and select Using

Using the Wizard to create a table


Every table requires a Primary key field. (What this field does will be explained later.)
We will use this field to number our entries and want that number to automatically
increase as we add each entry.


To work with tables, click the Tables icon in the
you can perform on a table are in the Task

Set field types and formats

Observation



In this step you give the fields their properties. When you click a field, the information on
the right changes. You can then m
at a time, and make the changes listed below.
8

Click Table and select Using
the Wizard to create a table

Using the Wizard to create a table

Every table requires a Primary key field. (What this field does will be explained later.)
We will use this field to number our entries and want that number to automatically
increase as we add each entry.

To work with tables, click the Tables icon in the
Database list, or use .The three tasks that
you can perform on a table are in the Task

In this step you give the fields their properties. When you click a field, the information on
the right changes. You can then m
ake changes to meet your needs.

Click each field, one
at a time, and make the changes listed below.

Every table requires a Primary key field. (What this field does will be explained later.)
We will use this field to number our entries and want that number to automatically
Database list, or use .The three tasks that
In this step you give the fields their properties. When you click a field, the information on
Click each field, one

Then field the space of field name and field type
Field type

Song_id

Title

Author

Ssn(FK)

Album_identifier (FK)

Result



After observation the table displayed like this after filling all field type and format type

Designs Album Query

Require of this Query



Procedure



Observation



Result

9

Then field the space of field name and field type

Formats

(Integer[INTEGER] )
(Text [VARCHAR] )
(Text [VARCHAR] )
(Integer[INTEGER] )
Album_identifier (FK)

(Text [VARCHAR] )
After observation the table displayed like this after filling all field type and format type
(Integer[INTEGER] )

(Text [VARCHAR] )

(Text [VARCHAR] )

(Integer[INTEGER] )

(Text [VARCHAR] )

After observation the table displayed like this after filling all field type and format type

Procedure



Click
Queries
and select Us

Using the Wizard to create
Query of Album


Queries created by the wizard provide a list or lists of information based upon what one
wants to know
. ( upon that table of
create)

10

and select Us
ing the Wizard to create a query

Query of Album

Queries created by the wizard provide a list or lists of information based upon what one
. ( upon that table of
Album and copied and appear to the Query want to

Queries created by the wizard provide a list or lists of information based upon what one
Album and copied and appear to the Query want to

Then use that direction of greater than to select all field selection of the Query album
press
Finish

and Query its create and use it

Observation



Queries are used to get specific information from a
created

Result



After sorting a data to the database the output it’s become like this

11

Then use that direction of greater than to select all field selection of the Query album
and Query its create and use it

Queries are used to get specific information from a
database
,

comes

from a Table to
After sorting a data to the database the output it’s become like this

in the

Then use that direction of greater than to select all field selection of the Query album

and then
from a Table to
be
in the
Album
Query
.

Designs Instrument Query

Require of this Query



Procedure



Observation



Result

Procedure



Click
Queries
and select Us

Using the Wizard to create
Query of Album


Queries created by the wizard provide a list or lists of information based upon what one
wants to know
.

( upon that table of Album and copied and appear to the Query want to
create)

12

and select Us
ing the Wizard to create a query

Query of Album

Queries created by the wizard provide a list or lists of information based upon what one
( upon that table of Album and copied and appear to the Query want to

Queries created by the wizard provide a list or lists of information based upon what one
( upon that table of Album and copied and appear to the Query want to

Then use that direction of greater than to select all field selection of the Query album and then
press
Finish

and Query its create and use it

Observation



Queries are used to get specific information from a database
created

Result



After sorting a data to the database the output it’s become like this one in the Query

13

Then use that direction of greater than to select all field selection of the Query album and then
and Query its create and use it

Queries are used to get specific information from a database
,

comes from a Table to
After sorting a data to the database the output it’s become like this one in the Query
Then use that direction of greater than to select all field selection of the Query album and then
comes from a Table to
be
After sorting a data to the database the output it’s become like this one in the Query
.

How

to create
form in L
ibre Base
There are two ways to create LibreOffice Base forms:


Form Wizard



Design View.

Design view



I
s a versatile drag and drop form creator that is quite powerful and allows you to add
elements and assign those elements to database tables.
The Form Wizard



I
s a very simple step
–
by
–
step wizard that walks the user through the process of creati
form. Although the Wizard isn’t nearly a
done quickly and doesn’t require any form design experience
Required as followed during the creating form in Database


Procedure



Observation



Result

Procedure

1
st
–
step



To create a new form for your existing database you have to click on the Form button in
the Datab
ase panel on the left of the interface

14

ibre Base

There are two ways to create LibreOffice Base forms:

s a versatile drag and drop form creator that is quite powerful and allows you to add
elements and assign those elements to database tables.

step wizard that walks the user through the process of creati
form. Although the Wizard isn’t nearly a
s powerful as the Design View
it will get the job
done quickly and doesn’t require any form design experience
.

Required as followed during the creating form in Database

To create a new form for your existing database you have to click on the Form button in
ase panel on the left of the interface
.

s a versatile drag and drop form creator that is quite powerful and allows you to add
step wizard that walks the user through the process of creati
ng a
it will get the job
To create a new form for your existing database you have to click on the Form button in

2
nd
–
step



From the Tasks select Use Wizard to Create Form
.

3
rd
–

step



The Form Wizard will appear and in the left panel you can see a numbered list of the
tasks you have to go through to get your form created

15

From the Tasks select Use Wizard to Create Form

The Form Wizard will appear and in the left panel you can see a numbered list of the
tasks you have to go through to get your form created
.

The Form Wizard will appear and in the left panel you can see a numbered list of the

4
th
–
step



Start by selecting the T
able you want to make a form for. The select the fields you want
your form to contain, for this example I selected all of them


Click Next

or Finish

Observation

Result

16

able you want to make a form for. The select the fields you want
your form to contain, for this example I selected all of them
.

able you want to make a form for. The select the fields you want

Create a new
Report with report wizard


Open the database file where you want to c


In the left pane of the database window, click the


Click

Use Wizard to Create Report

17

Report with report wizard

Open the database file where you want to c
reate the new report.

In the left pane of the database window, click the

Reports

icon.

Use Wizard to Create Report
.