Name: [002] Ian Ozsvald
Member: 128 months
Authored: 181 videos
Description: I am the co-founder of ShowMeDo (see, author of `The Screencasting Handbook <>`_ and the founder of the professional screencast production company `ProCasts <>`_: .. image:: ...

OpenOffice 3.1 Base Introduction [ID:891]

a series of video-tutorials by Ian Ozsvald

Create a simple database using OpenOffice's Base, based on a physiotherapy patient database designed by Ian in the past.

Video Tutorials

1. Series Overview in 3 minutes (OpenOffice 3.1 Base)

In 3 minutes we look at the complete database that you can build. It will have two tables, two forms (one of which has a subform), a query and we also look at deleting data.

2. Make Database and Tables

First we create our database and then we use Design View to create two tables (Patient and Appointment). They include a key field controlled by an AutoValue.

3. Add Relationships & Data

Next we add a relationship on the patientID field between the two tables.

4. Create a Patient Form

We use the Form Wizard to create a simple form to view and edit the Patient data.

5. Adding Appointments (1/2)

In this first part we create a form with a sub-form to show appointments and their corresponding patients.

6. Adding Appointments (2/2)

Next we replace the Patient subform with just a listbox that contains the Patient's name, we can use this for viewing the data and for selecting a new Patient.

7. Deleting Data

You can only delete data if not other table has a dependent record. Here I show you what happens if you do have a dependent record and how to delete all the data.

8. Querying Data

Queries let us drill into our data to answer questions. Here we build a query where the user can specify a date, we then pull out all of the patients with appointments after that date.

Showmedo is a peer-produced video-tutorials and screencasts site for free and open-source software (FOSS)- with the exception of some club videos, the large majority are free to watch and download.

how to help » about » faq »

Educating the Open-source Community With Showmedo

Although as important as the software it supports, education and documentation are relatively neglected in the Open-source world. Coders love to code, and explaining how best to use or improve the software tends to be deferred or even sidelined.

At Showmedo we believe the community can play a vital role here and also say thanks for the tools and software that make our lives easier. If you have a piece of software you love or a programming langugage you are enthusiastic about, why not make a screencast showing others how to use it? All the stuff you wish you'd been told, the tips, tricks, insights that would have saved you time and frustration.

Screencasting is easier than you think, and we're happy to help you. You can emailus for advice or just use some of the how-to screencasts on the site. This screencasting learning-pathis a good place to start.

Kudos and Thanks for Ian

3 Minute Oveview (What Does Python Look Like?)

simple and informative. you draw me in
70 months ago


Showmedo's development is fairly rapid and bugs will inevitably creep in. If you have any problems please drop us a line using the contact address below. Likewise, any suggestions for improvements to the site are gratefully received.