Name:
[002] Ian Ozsvald
Member:
90 months
Authored:
181 videos
Description:
I am the co-founder of ShowMeDo (see http://showmedo.com/about), author of `The Screencasting Handbook <http://thescreencastinghandbook.com>`_ and the founder of the professional screencast production company `ProCasts <http://procasts.co.uk>`_:
.. image:: http://procasts.co.uk/media/procasts_sma ...
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.
10 votes
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.
5 votes
3. Add Relationships & Data
Next we add a relationship on the patientID field between the two tables.
4 votes
4. Create a Patient Form
We use the Form Wizard to create a simple form to view and edit the Patient data.
3 votes
5. Adding Appointments (1/2)
In this first part we create a form with a sub-form to show appointments and their corresponding patients.
4 votes
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.
3 votes
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.
2 votes
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.
4 votes
Thanks man