Pin Me

How to Create a Database in OpenOffice 3.0

written by: JMendes•edited by: Michele McDonough•updated: 1/29/2009

Learn how to create an OpenOffice database with this easy step-by-step tutorial.

  • slide 1 of 13

    OpenOffice Base is the integrated database application in the free, opensource OpenOffice 3.0 suite, a cross-platform application system that is available for users running Windows, Mac, Linux and other operating systems. Base is similar to Microsoft's Access; its layout and tools are comparable and the program can open some types of Access tables.

  • slide 2 of 13

    Creating a Database

    Double-click the OpenOffice icon on your desktop and choose OpenOffice Base or access the program through the Start menu, Start > All Programs > OpenOffice > OpenOffice Base. This will open the Database Wizard.

  • slide 3 of 13
    OpenOffice Database Wizard
  • slide 4 of 13

    The wizard will give will next give you the option to register the database with OpenOffice.

  • slide 5 of 13
    Registering the database
  • slide 6 of 13

    Registering the database allows you to access the database when you are using other OpenOffice applications. For instance, if you wish to access the database information while working in a Writer document, you can press the F4 key and open the database from the drop down menu. The database will open in a split screen over the document with a hierarchal information tree on the left.

  • slide 7 of 13
    Example of split screen
  • slide 8 of 13

    Choose whether or not you wish to register the database for future use and click “Next.”

    Choose the option to open the database for editing after it is created. Click “Finish.” A dialog box will open, title the database and chose a destination for the file. Click “Save.”

    Choose the type of database object that you wish to create. The options are located in the left-hand panel and include Tables, Queries, Forms and Reports. After highlighting the type of database object, a set of options will appear in the Tasks Panel.

  • slide 9 of 13
    Database options
  • slide 10 of 13

    Depending on the database object chosen, you will have the option to either access a creation wizard or create the database manually in Design View. The database creation wizard will walk you through the placement of the database elements. In Design View, a dialog box will allow you to add or delete database features.

  • slide 11 of 13
    Example of table creation wizard
  • slide 12 of 13
    Example of Design View
  • slide 13 of 13

    After the database elements have been added, you can begin adding the data. When you are finished, save the database through the File menu located on the tool bar.

    To download OpenOffice 3.0 and find more information on the Base application, visit OpenOffice.org.