Transcript Basics_of_OOBase

Introducing Impress
AOSS _ Course material
AOSS Master training workshop Singapore
2007
Content






What is ooBase aka Base?
Database Wizard
Saving Database
Table Design
Form Wizard
Report Wizard
What is ooBase?




OpenOffice.org Base is the database application
of OpenOffice.org, similar to Microsoft Access.
Base allows the creation and manipulation of
databases and the building of forms and reports
to provide easy access to data for end-users.
Base was not available in the 1.x versions of
OpenOffice.org, becoming part of the suite
starting with version 2.0.
Base offers a choice of using Wizards, Design
Views, or SQL Views for beginners, intermediate,
and advanced users.
Database Wizard
1. Choose Create New
2. Click Next
Let’s Create a Sample Data
Participa
Participant_Name
nt_Id
Country
1
Muazzam Ali
Pakistan
2
Trianggoro Wiradinata
Indonesia
3
Kasturi Dewi Varathan
Malaysia
Saving Database
1. Click Finish and
2. Type your database name:
Participants
Main Panel of Database Participants
2. Choose Create Table
in Design View
1. Choose Tables
Table Design
2. Save created table by
clicking Save Button
3. Type “Participants” as
Table Name
1. Right Click participant_id
and set as primary key
Inserting Data Manually
1. Double Click
Participants Table
Inserting Data Manually (cont’d)
1. Directly type in the data
2. Don’t forget to save by
clicking Save Toolbar
Using Form Wizard
2. Select Use Wizard to Create
Form
1. Select Forms
Using Form Wizard (cont’d)
1. Select Table: Participants
2. Select All Available Fields
by clicking >> button
3. Click Next, and skip
subform since we are not
using any subform
Using Form Wizard (cont’d)
1. Select the second:
Columnar – Labels on Top
2. Click Next
Using Form Wizard (cont’d)
1. Click Next, no change on
this dialog
Using Form Wizard (cont’d)
1. Select the style for your
form
2. Click Next
Using Form Wizard (cont’d)
1. Type the form name
Participants
2. Click Finish
Using Form Wizard (cont’d)
Adding New Record
2. Type the new Data
3. Click the Save Record
button to save your data
1. Click the New Record
button to add data
Any Detail is missing?

We have recorded the simple tutorial using
open source application called:



CamStudio from RenderSoft
Download URL: http://camstudio.org/
File Name: intro_to_base.avi