What Does It Mean To Register A Database In Openoffice

Download Article

Download Commodity

Microsoft's Role suite is very expensive for the average user to purchase. The Professional version that includes Microsoft Access (database creation software) is even more expensive. A cheaper or free office suite within the reach of everyone is StarOffice/OpenOffice. Learn how to create a database, a table and create a grade.

Steps

ane

StarOffice is the release version of OpenOffice. There are a few differences but they are mainly cosmetic. The first thing to do is to download and install OpenOffice.org^[1] or StarOffice from Sunday Microsystems.
2

Once it has been downloaded and installed, in Windows XP, go to Beginning -> All Programs -> Star Office 8 -> Star Office Base and then press the Enter primal.

Advertisement
3

A window will pop upward titled 'Database Magician'
four

Accept the default settings and click 'Next'. Registering the database (is washed locally) and makes information technology easier for Writer and Calc to use.
5

Have the default settings on the adjacent window and and so click on 'End'.
6

A 'Save As' window will popular up. It defaults to 'My Documents'. Give your new database a proper noun. For now call it 'MyContacts'. Accept the default settings and click on the 'Save' button.
vii

A new window will pop up titled 'MyContacts' and on the left you lot come across iv items, 'Tables, Queries, Forms and Reports'. 'Forms' will be automatically highlighted. However, we first demand to create a table for our database, and then click on 'Tables'. We will come back to forms afterwards.
8
To the right of the 'Tables' Icon under tasks click on 'Use Wizard To Create Table...'. A window titled 'Tabular array Wizard' will pop up.
1. The sorcerer will footstep y'all through creating your first database. On the correct under Select fields for your table you will come across 'Category'. Click on 'Personal'. Under 'Category' are sample tables, click on the 'down arrow' and highlight 'Addresses'. Under 'Available fields' all the fields for the sample table are displayed. To the right are four buttons. Click on the '>>' button. This will move all the fields under 'Available fields' to 'Selected fields'. Click on the 'Next' button.
9

The Table wizard volition now advance to step ii, Set types and formats. Under 'Selected fields' are all the field that were chosen. To the right of that you will run across 'Field information'. Each field can be individually formatted in the manner you lot want. Click on the various fields to get an idea of what types you have available. For now accept the defaults for each field and so click on the 'Next' button.
10

The Tabular array wizard will at present advance to pace iii, 'Gear up Primary Primal'. As the database grows in size the master key becomes more important. The primary key will speed upwardly queries. For now, have the default values and click on the 'Next' push.
11

The final footstep in creating your first table is 'Create Table'. Have the default value for the tabular array name. In this example it is chosen Addresses. Beneath that you have several choices on what to do next. Click on 'Create a grade based on this table' and then click on the 'Cease' button.
12

Ii windows will pop up. The beginning windows is titled 'Untitled' and on summit of that window is another window titled 'Form Wizard'. We will now create a grade for data entry.
13

Once again the steps for creating a class are displayed on the left. As before take the defaults and click on the '>>' button. This will move all the fields to the other side under 'Fields in the form'. Then click on the 'Next' button.
14

The popular upwardly window is titled 'Gear up up a subform'. Accept the default values. Nosotros will not be creating any subforms for now. Click on the 'Next' button.
15

A new window will pop upwardly titled 'Arrange controls'. On the right, the third button is the default. Click on the second push to the right of that, the 4th button. Click the 'Next' push button.
16

The 'Ready data entry' will pop up. This will set the mode of information entry for your form. Have the defaults and click on the 'Next' push button.
17

The 'Utilize styles' window will pop up. Accept the default values and click on the 'Side by side' button.
xviii

When the pop upward window titled 'Set name' pops up accept the default values. And then click the 'Stop' button.
19

Your form will now pop upward and you are able to enter data. If yous do non like how the form is laid out, y'all can hands change it. Here'southward how to change your form.
twenty
Make certain the 'Forms' icon on the left is highlighted.
1. Click on the 'Edit' menu item and highlight and click on 'Edit'.
21

The Form editor will pop upward displaying your form. Click on any of the fields and then 'drag and drop' them where ever you like. Don't worry about getting your form messed upwards. If yous make also many mistakes and want to offset over then close the form editor, don't salvage your work and offset over over again. It will take a petty practice but once you become the hang of information technology you lot will discover it easier to work with.
22

Congratulations! You have created a Star Office Base database.
23

Savor and have fun.

Advert