Name: [1922] Dai
Member: 85 months
Authored: 131 videos
Description: Hi I'm Dai Just an ordinary guy with an interest in computers who likes making how to videos for others to get the best out of there computers. I ounce did a course on web-design to further my interest in the subject. Got a HNC out of to boot but, lately my interest has turned to doing howto vide ...

OpenOffice Base [ID:112]

a series of video-tutorials by Dai

This series of tutorials is based on chapter 7 of the user guide for creating a database using base from OpenOffice.

http://documentation.openoffice.org/manuals/

OpenOffice.org2.x User Guide

Video Tutorials

1. Creating the DataBase

This tutorial shows you how to create a database. A populated databse for learning can be had from the files section of the learners showmedo group. http://groups.google.com/group/showmedo-learners

2. Creating Tables

In this tutorial you will learn how to create a table in OpenOffice Base

3. Creating Relationships

This tutorial will show you how to create a relationship between 2 tables

4. Create a Form

creating a form for inputing data into the database

5. Make Data Entry Easy

Modifying a form to enter data

6. Add a List Box

Adding a list box to the form. The database for this tutorial can be found in the learners forum: http://groups.google.com/group/showmedo-learners

7. Adding a Combo Box

adding a combobox to a form

8. Changing the Tab Order

Changing the tab order of a form

9. Viewing Data

Creating a form to view the data

10. Change the form sort order

Changing the forms sort order so it is easier to use

11. Creating a Query

Creating a query using OpenOffice Base

12. Changing The Join Type

How to change from an Inner join to a left join in Base

13. Creating a Report

Creating reports in Base and writer

14. Tab Order & Focus

This is just to clarify how to use the tab order and focus for the forms you pruduce in Base

15. Form Design

How to create a form in OpenOffice Writer. In this tutorial we will be using check boxes, group boxes, labels, and text boxes,to create a simple form.

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 Dai

Learning Paths

This series lies on the following learning-paths. Learning-paths are a new initiative at Showmedo, to start structuring our content better. You can find out more here.

Content

Feedback

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.

feedback@showmedo.com