Difference between revisions of "User:Nnino/Drafts/Tutorial: Working with OOo Base"

From Apache OpenOffice Wiki
Jump to: navigation, search
(first draft)
 
m
Line 1: Line 1:
 +
draft! feel free to edit and correct.
 +
 
The following tutorial aims to make you familiar using OOo Base. You will create a scheduling database. You will
 
The following tutorial aims to make you familiar using OOo Base. You will create a scheduling database. You will
 
* create a new database
 
* create a new database
* create tables which contain the appointment information
+
* create tables which will contain the appointments information
 
* create forms to enter/edit the appointments
 
* create forms to enter/edit the appointments
* create queries to generate a filtered view of your appointments
+
* create queries to generate filtered vieww of your appointments
 
* create reports of your appointments  
 
* create reports of your appointments  
 +
  
 
== Creating the database ==
 
== Creating the database ==
Click on '''File > New > Database''' to launch the database wizard.
+
{{/Creating the database}}
 
+
In the first step activate '''Create new database''' and click '''Continue'''.
+
 
+
In the second step mark '''Yes, register data base''' and '''Open database for editing'''. Then click '''Finish'''.
+
 
+
Choose a name for your database like ''SchedulingDB'' and a place to save it. Click '''OK'''.
+
  
The following window will open:
+
== Creating appointments table ==
 +
{{/Creating appointments table}}
  
Now, we will create the elements of our database.
+
----
 +
Todo:
 +
* Befehle und Icons mit der englischen OOo Version abgleichen
 +
* Bilder

Revision as of 13:33, 6 February 2009

draft! feel free to edit and correct.

The following tutorial aims to make you familiar using OOo Base. You will create a scheduling database. You will

  • create a new database
  • create tables which will contain the appointments information
  • create forms to enter/edit the appointments
  • create queries to generate filtered vieww of your appointments
  • create reports of your appointments


Creating the database

Click on File > New > Database to launch the database wizard.

In the first step activate Create new database and click Continue.

In the second step mark Yes, register data base and Open database for editing. Then click Finish.

Choose a name for your database like SchedulingDB and a place to save it. Click OK.

The following window will open:

Now, we will create the elements of our database.

Creating appointments table

Click on the Tables icon File:BaseTablesIcon.png on the left.

Clicking the option Create new table in draft view File:BaseCreateTableDraftIcon.png will open the Table draft window. File:BaseTutSchedTableDraft1.png


Todo:

  • Befehle und Icons mit der englischen OOo Version abgleichen
  • Bilder
Personal tools