Difference between revisions of "User:Nnino/Drafts/Tutorial: Working with OOo Base"
(first draft) |
m (minor changes) |
||
| (3 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | The following tutorial | + | {| style="border: 1px black solid;" | cellspacing=0 cellpadding=7 |
| + | | width="90%" bgcolor=#eee |'''Translation draft!''' Feel free to edit and correct. <br>Original: [http://de.openoffice.org/doc/oooauthors/base_entwurf_einer_datenbank.pdf Base Entwurf einer Datenbank (German PDF)] | ||
| + | |- | ||
| + | | Todo: | ||
| + | * Befehle und Icons mit der englischen OOo Version abgleichen | ||
| + | * Englisch aufpolieren | ||
| + | * Bilder | ||
| + | |} | ||
| + | |||
| + | |||
| + | The following tutorial intends to make you familiar with using OOo Base. By creating a scheduling database, you will learn how to | ||
* create a new database | * create a new database | ||
| − | * create tables | + | * create tables containing the appointments information |
| + | * create relations between tables | ||
* create forms to enter/edit the appointments | * create forms to enter/edit the appointments | ||
| − | * create queries to generate | + | * create queries to generate filtered views of your appointments |
* create reports of your appointments | * create reports of your appointments | ||
== Creating the database == | == Creating the database == | ||
| − | + | {{/Creating the database}} | |
| + | |||
| + | == Creating appointments table == | ||
| + | {{/Creating appointments table}} | ||
| + | |||
| + | == Creating types table == | ||
| + | {{/Creating types table}} | ||
| + | |||
| + | == Establishing a relation between the tables == | ||
| + | {{/Establishing a relation between the tables}} | ||
| + | |||
| + | == Creating types form == | ||
| + | {{/Creating types form}} | ||
| + | |||
| + | == Entering data into the form == | ||
| + | {{/Entering data into the form}} | ||
| + | |||
| + | == Creating New Appointment form == | ||
| + | {{/Creating New Appointment form}} | ||
| + | |||
| + | == Customizing New Appointment form == | ||
| + | {{/Customizing New Appointment form}} | ||
| + | |||
| + | == Simplifying data entry == | ||
| + | {{/Simplifying data entry}} | ||
| + | |||
| + | == Adding a listbox to the form == | ||
| + | {{/Adding a listbox to the form}} | ||
| + | |||
| + | == Adding a combobox to the form == | ||
| + | {{/Adding a combobox to the form}} | ||
| + | |||
| + | == Testing the form == | ||
| + | {{/Testing the form}} | ||
| + | |||
| + | == Defining tab order == | ||
| + | {{/Defining tab order}} | ||
| + | |||
| + | == Creating a form showing all appointments == | ||
| + | {{/Creating a form showing all appointments}} | ||
| + | |||
| + | == Copying a form == | ||
| + | {{/Copying a form}} | ||
| + | |||
| + | == Customizing a form == | ||
| + | {{/Customizing a form}} | ||
| + | |||
| + | == Adding sorting to the form == | ||
| + | {{/Adding sorting to the form}} | ||
| + | |||
| + | == Creating a form which lists appointments == | ||
| + | {{/Creating a form which lists appointments}} | ||
| + | |||
| + | == Defining sort order == | ||
| + | {{/Defining sort order}} | ||
| + | |||
| + | == Changing form basis == | ||
| + | {{/Changing form basis}} | ||
| + | |||
| + | == Changing join settings == | ||
| + | {{/Changing join settings}} | ||
| + | |||
| + | == Changing control settings == | ||
| + | {{/Changing control settings}} | ||
| + | |||
| + | == Creating a query == | ||
| + | {{/Creating a query}} | ||
| + | |||
| + | == Sorting a query == | ||
| + | {{/Sorting a query}} | ||
| + | |||
| + | === Changing join type in the query === | ||
| + | {{/Changing join type in the query}} | ||
| + | |||
| + | == Creating a form based on a query == | ||
| + | {{/Creating a form based on a query}} | ||
| − | + | === Copying a form === | |
| + | {{/Copying a form}} | ||
| − | + | === Changing the query behind a form === | |
| + | {{/Changing the query behind a form}} | ||
| − | + | == Creating a report == | |
| + | {{/Creating a report}} | ||
| − | + | == Customizing the report == | |
| + | {{/Customizing the report}} | ||
| − | + | == Tips for database usage == | |
| + | === Adding a new type in the form === | ||
| + | === Adding a new type in the database object window === | ||
| + | === Refreshing the form === | ||
| + | === Data filtering === | ||
Latest revision as of 18:57, 6 February 2009
| Translation draft! Feel free to edit and correct. Original: Base Entwurf einer Datenbank (German PDF) |
Todo:
|
The following tutorial intends to make you familiar with using OOo Base. By creating a scheduling database, you will learn how to
- create a new database
- create tables containing the appointments information
- create relations between tables
- create forms to enter/edit the appointments
- create queries to generate filtered views of your appointments
- create reports of your appointments
Contents
- 1 Creating the database
- 2 Creating appointments table
- 3 Creating types table
- 4 Establishing a relation between the tables
- 5 Creating types form
- 6 Entering data into the form
- 7 Creating New Appointment form
- 8 Customizing New Appointment form
- 9 Simplifying data entry
- 10 Adding a listbox to the form
- 11 Adding a combobox to the form
- 12 Testing the form
- 13 Defining tab order
- 14 Creating a form showing all appointments
- 15 Copying a form
- 16 Customizing a form
- 17 Adding sorting to the form
- 18 Creating a form which lists appointments
- 19 Defining sort order
- 20 Changing form basis
- 21 Changing join settings
- 22 Changing control settings
- 23 Creating a query
- 24 Sorting a query
- 25 Creating a form based on a query
- 26 Creating a report
- 27 Customizing the report
- 28 Tips for database usage
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
Creating types table
User:Nnino/Drafts/Tutorial: Working with OOo Base/Creating types table
Establishing a relation between the tables
User:Nnino/Drafts/Tutorial: Working with OOo Base/Establishing a relation between the tables
Creating types form
User:Nnino/Drafts/Tutorial: Working with OOo Base/Creating types form
Entering data into the form
User:Nnino/Drafts/Tutorial: Working with OOo Base/Entering data into the form
Creating New Appointment form
User:Nnino/Drafts/Tutorial: Working with OOo Base/Creating New Appointment form
Customizing New Appointment form
User:Nnino/Drafts/Tutorial: Working with OOo Base/Customizing New Appointment form
Simplifying data entry
User:Nnino/Drafts/Tutorial: Working with OOo Base/Simplifying data entry
Adding a listbox to the form
User:Nnino/Drafts/Tutorial: Working with OOo Base/Adding a listbox to the form
Adding a combobox to the form
User:Nnino/Drafts/Tutorial: Working with OOo Base/Adding a combobox to the form
Testing the form
User:Nnino/Drafts/Tutorial: Working with OOo Base/Testing the form
Defining tab order
User:Nnino/Drafts/Tutorial: Working with OOo Base/Defining tab order
Creating a form showing all appointments
User:Nnino/Drafts/Tutorial: Working with OOo Base/Creating a form showing all appointments
Copying a form
User:Nnino/Drafts/Tutorial: Working with OOo Base/Copying a form
Customizing a form
User:Nnino/Drafts/Tutorial: Working with OOo Base/Customizing a form
Adding sorting to the form
User:Nnino/Drafts/Tutorial: Working with OOo Base/Adding sorting to the form
Creating a form which lists appointments
User:Nnino/Drafts/Tutorial: Working with OOo Base/Creating a form which lists appointments
Defining sort order
User:Nnino/Drafts/Tutorial: Working with OOo Base/Defining sort order
Changing form basis
User:Nnino/Drafts/Tutorial: Working with OOo Base/Changing form basis
Changing join settings
User:Nnino/Drafts/Tutorial: Working with OOo Base/Changing join settings
Changing control settings
User:Nnino/Drafts/Tutorial: Working with OOo Base/Changing control settings
Creating a query
User:Nnino/Drafts/Tutorial: Working with OOo Base/Creating a query
Sorting a query
User:Nnino/Drafts/Tutorial: Working with OOo Base/Sorting a query
Changing join type in the query
User:Nnino/Drafts/Tutorial: Working with OOo Base/Changing join type in the query
Creating a form based on a query
User:Nnino/Drafts/Tutorial: Working with OOo Base/Creating a form based on a query
Copying a form
User:Nnino/Drafts/Tutorial: Working with OOo Base/Copying a form
Changing the query behind a form
User:Nnino/Drafts/Tutorial: Working with OOo Base/Changing the query behind a form
Creating a report
User:Nnino/Drafts/Tutorial: Working with OOo Base/Creating a report
Customizing the report
User:Nnino/Drafts/Tutorial: Working with OOo Base/Customizing the report
