Name: [1922] Dai
Member: 103 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 ...

Creating the DataBase [ID:333] (1/15)

in series: OpenOffice Base

video tutorial by Dai, added 08/07

(Showmedo is undergoing major changes. To report any problems viewing the videos please email us and include browser and OS specifics. Cheers - Kyran.)

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.

Got any questions?

Get answers in the ShowMeDo Learners Google Group.

Video statistics:

  • Video's rank shown in the most popular listing
  • Video plays: 367 (since July 30th)
  • Plays in last week: 42
  • Published: 103 months ago

Thank-yous, questions and comments

If this video tutorial was helpful please take some time to say thank-you to the authors for their hard work. Feel free to ask questions. Let the author know why their video tutorial was useful - what are you learning about? Did the video tutorial save you time? Would you like to see more?

You may also want to see our ShowMeDo Google Group to speak to our active users and authors.

Your email address will not be published.

Show some quick comments >>

All comments excluding tick-boxed quick-comments

146. Anonymous Fri, 15 Oct 2010 13:44


145. Anonymous Tue, 28 Sep 2010 20:22

Thanks for your time and effort. It's a help so far.

144. Anonymous Mon, 27 Sep 2010 04:07

Thanks alot for the good demonstrations

143. Anonymous Fri, 10 Sep 2010 07:04

thanks for your usefull vedio

142. Anonymous Tue, 07 Sep 2010 10:33

i would like to know if there is a way to get help on a data base directly from you on our sales force. we love linyx but hard to get thru some times if can call me i would apriciate it it is a simple datat base just need help. the presintation was a little short but very goos in its exicution

141. Anonymous Thu, 02 Sep 2010 07:13

Thanks Dai for these videos, I've been tasked with crating the database for our company and they insist on using openoffice which I have never used before so your videos are going to be very worthwhile.

Thanks for doing them

140. Anonymous Thu, 19 Aug 2010 10:32


139. Anonymous Wed, 18 Aug 2010 16:37

Thanks--will check on next step

138. Anonymous Tue, 17 Aug 2010 08:56

so great man!! I appreciate it real coz it helped me so much

137. Anonymous Sat, 14 Aug 2010 12:17

So far so good!

136. Anonymous Fri, 13 Aug 2010 18:31

Small steps are good. Where do I find the next lesson?

The first part of the example showed an existing database named "calendar" which could have been opened. Why did OO not object when you named the new database "calendar" too? Shouldn't it make you choose a unique name?

135. Anonymous Fri, 13 Aug 2010 16:18

Hi Dai, I'm very new at this and trying to learn all I can.

Thanks for posting these how to videos.

134. Anonymous Fri, 13 Aug 2010 15:25

Hi Dai,

Thanks for the video tutorials. They are helpful to me getting started with Open Office.

133. Anonymous Fri, 13 Aug 2010 14:27

Very helpful in getting started using databases.

I would like to see a video on using Writer mail merge to make a list of mailing labels from a data file. It's a very confusing process.

Thanks ..... Richard Chabot

132. RobertPeni Wed, 04 Aug 2010 17:12

Thanks for your time to do this video, go ahead with your work.

131. cartier bracelet clou faux Wed, 28 Jul 2010 13:03

Very helpful

130. Kennethpa Mon, 26 Jul 2010 13:20

Great work, the vedio teaching really helps. I'm just starting to learn OOo Base and this will be my first choice for tutorial.

129. emayufo Sat, 24 Jul 2010 16:51

Clear and concise. good job.

128. Tue, 20 Jul 2010 07:04

Great videos.


Erhard Lettner

127. Celine Orange Navy Red 2015 Thu, 03 Jun 2010 13:01

Nice tutorial. Thanks for the time you took to put it together!

126. seo plugin Wed, 02 Jun 2010 04:28

Just getting started with Base tutorial. Looks good so far.

125. Mac Amazon Makeup Mon, 31 May 2010 22:33

Looks good so far. please e-mail me so I can e-mail you back.

124. 最新激安発売店 即日出荷 Wed, 26 May 2010 01:30

It a good video

123. ibvoteweo Wed, 19 May 2010 20:09

I've watching the introductory videos for Scribus, which I find very didactic and clearly exposed (the volumen is a little low, though). The experience of Dai and knowledge of the topics is obvious. I'm very grateful for all the efforts and time he has dedicated to recording these videos, and his willingness to share his expertise. This material has reduced considerably the time required to learn these topics. Once again, many thanks.

122. MelvinaKal Mon, 10 May 2010 12:44

A pleasant yet informative style helpful to a person with basic skills in using a database.

121. cheap oakley sunglasses Sat, 24 Apr 2010 01:52

Clear, but very short!

120. birkenstock sale australia Thu, 22 Apr 2010 22:15

So far its by far the most concise tutorial on the open office database program. Thank you very much!

119. tomas plekanec jersey Thu, 22 Apr 2010 04:28

Very good.....much appreciated

118. cheap ray ban sunglasses Tue, 20 Apr 2010 02:02

Im new to ubuntu....and in creating database... im looking forward to create my own database..

117. Sat, 17 Apr 2010 09:02

This is very helpful in learning this open office base. Clear and concise in its presentation. Thank you and I highly recommend this tutorial to others.

Great concept for anybody to take the time and learn what

they need to learn. I am a shift worker so 24/7 learning is


115. jasa SEO, Backlink, Blogwalking murah Sat, 03 Apr 2010 05:18

thanks - good to have someone talk you through things

114. jasa SEO, Backlink, Blogwalking murah Thu, 01 Apr 2010 18:04

This series was a great learning tool.

113. jasa SEO, Backlink, Blogwalking murah Thu, 18 Mar 2010 14:18

This is great. Very informative.


112. jasa SEO, Backlink, Blogwalking murah Thu, 18 Mar 2010 07:53

Looks easy to follow

111. ThomasSn Sun, 28 Feb 2010 08:01

I am glad that there is something on the internet that can show me how to use this program. I was so lost. Thanks

110. vrouwen parajumpers winterjas italiaans Wed, 24 Feb 2010 07:44

Great Job. I have found your instructions easy to follow.

Thank you!

109. best mac products makeup Enjoy 75% Discount BRn4iGMCBY Fri, 19 Feb 2010 07:20

Very useful. The database portion of OO has below average documentation, so this helps. Thanks!

108. IT-Consultant - Christian Gnoth Fri, 19 Feb 2010 06:31

good work, little short. keep it up.

107. ladainian tomlinson jersey Wed, 17 Feb 2010 01:27

the video have show the detail to using the open office

106. fuck Wed, 17 Feb 2010 01:25

only seen one video, looks helpful, but I'll reserve judgement until I've seen a few more then hopefully re-submit some useful feedback

105. moncler winterjas dames goedkoop Tue, 16 Feb 2010 09:58

Good Lesson to start. Keep up the good work!

104. mac swiss chocolate eyeshadow New XZCX7 439 Thu, 11 Feb 2010 15:06

Thank You very helpful.My first time trying to create a database.

good, I like it

102. mbt tembea amazon Sun, 31 Jan 2010 12:58

just looking to learn about Open Office base to show studetns how it works. Thanks

101. marinir seo Mon, 18 Jan 2010 13:18

Very helpful tutorial for a computer illiterate like myself.Of course it will require my going over it several times,just to get it right.Thank you for your help Dai.

100. Woolrich Womens Comfortable Mon, 18 Jan 2010 03:33

Looks like a very good introduction of the program to a newbie like me. Thanks!

99. Sat, 16 Jan 2010 05:48

so far, so good

Earlier user of Superbase. Now forced to find a simple solution for relation-database.

97. anonymous Wed, 30 Dec 2009 19:43


96. anonymous Sat, 26 Dec 2009 11:58

ok so far, only saw the beginning

Glad to get Base videos. Thanks


94. anonymous Tue, 08 Dec 2009 03:14

How do you resize the window screen again?

I created the database on a 19" screen.

When I open it on a 13.3" laptop i have to keep moving the scrolling bars, vertically and horizontally.

If there is a way then great, if not then its ok.

93. anonymous Sun, 06 Dec 2009 13:49

its great, thanks it helps me a lot

92. anonymous Sun, 22 Nov 2009 00:59

hey. can you teach me the creatin database? i need it. it's our final exam.

91. anonymous Wed, 18 Nov 2009 12:12

Thanks for this. I've only looked at vid 1 so far but looks like it will be a very useful series.

90. anonymous Fri, 13 Nov 2009 04:36

Excellent stuff, nice easy to use bite sized chunks, Thanks

89. anonymous Fri, 13 Nov 2009 00:41

i want to know how to make database

88. anonymous Tue, 03 Nov 2009 16:11

I found explanations of the options to be useful. Thanks for your efforts to make this accessible!

87. anonymous Tue, 27 Oct 2009 09:26

very helpful thanks

86. anonymous Sun, 25 Oct 2009 18:13

Perfect so far

85. anonymous Sun, 25 Oct 2009 15:51

Thank you for the video.

84. anonymous Mon, 19 Oct 2009 21:26

Nice video little short

83. anonymous Fri, 16 Oct 2009 18:33

Good stuff!! Thank-you my friend!

82. anonymous Fri, 16 Oct 2009 08:34

Good job on your videos so far, Tempo could use some work. I'm getting use to the term"OKee Dokee". All together very useful.


81. anonymous Mon, 05 Oct 2009 19:46

Thanks tons! I was beating my brains out trying to figure out from the help files and OOo forums about how to create a simple combo box on my form and got nowhere till I watched your tutorial... if only I had found you tutorial first, it would have saved me a lot of frustration. Thanks man, I'll be sure to check out your videos next time. Peace!

80. anonymous Mon, 21 Sep 2009 15:03

Clear visual. Just began. So far so good.

79. anonymous Wed, 16 Sep 2009 22:04

this is good stuff! keep up the good work.

78. anonymous Wed, 26 Aug 2009 13:19

Looking for some video tutorials on OOo Base and your series is about the only one I've found so far.

I've only watched the first video so far and it was good.

77. anonymous Tue, 25 Aug 2009 18:19

Need to know how to mail merge, I keep getting an error

76. anonymous Fri, 21 Aug 2009 15:10

Good so far! oobase has had me, as a basic user, completely baffled. I use PCLinuxOS and kept getting a runtime java error. I think I finally got that figured out - only needed to fill in a selection bubble! At any rate, on to figure out... what "registering" a database means, where the heck to save it to... etc. Love the verbal and video walk through, but will still take me a while. I used to use MSWorks years ago and it was so simple... I'll have to adapt! Thanks

75. anonymous Thu, 13 Aug 2009 23:51

please release video for how export a .csv file into open office base

74. anonymous Mon, 10 Aug 2009 00:35

want downloadable copy

73. anonymous Fri, 07 Aug 2009 13:42

clear but in too small pieces perhaps...

72. anonymous Thu, 06 Aug 2009 23:44

Muchas gracias por los videos, justamente lo que estaba buscando.

71. anonymous Thu, 06 Aug 2009 23:44

Muchas gracias por los videos, justamente lo que estaba buscando.

70. anonymous Sat, 01 Aug 2009 04:08

Thanks for your efforts. Easy to follow instructions for us novices.



69. anonymous Sat, 01 Aug 2009 04:06

Thanks for your efforts. Easy to follow instructions for us novices.



68. anonymous Thu, 30 Jul 2009 14:55

Good job with your video, I learned a lot

67. anonymous Mon, 27 Jul 2009 18:29

it's great

66. anonymous Mon, 20 Jul 2009 09:11

Interesting to me.

65. anonymous Tue, 14 Jul 2009 17:37

Excellent, keep up the good work. There are not a lot of people out there who are willing to teach anybody the steps in navigating their way through this software.

64. anonymous Sat, 11 Jul 2009 22:51

good vedio

63. anonymous Sat, 11 Jul 2009 06:49

I had a course in MS access yeeaarrs ago. I now try to learn something again. Ive always said to my children how important it is to learn db:s. Thank you for your giving lessons. Maybe my stonagebrain could still learn something once more. :)) Greetings

62. anonymous Wed, 08 Jul 2009 11:57

I loved your video, is helping me a lot.

thank god for your work.


bye bye

61. anonymous Tue, 07 Jul 2009 11:00

would have liked to have had more information on why you should register your database

Down to earth knowledge share that can help me to create database. Direct to the point teaching minimizes learning time. Thanks a lot.

59. anonymous Thu, 25 Jun 2009 17:54

good so far

58. anonymous Thu, 25 Jun 2009 04:11

Good but short

57. anonymous Wed, 17 Jun 2009 21:51

Very Helpful sir

56. anonymous Wed, 17 Jun 2009 03:07

Very Good

55. anonymous Fri, 12 Jun 2009 12:54

Thanks for doing this

54. anonymous Fri, 12 Jun 2009 09:54

This is a great help.

53. anonymous Thu, 11 Jun 2009 20:05

Very nicely made

52. anonymous Sun, 07 Jun 2009 19:59

Helpful to this newbie.

51. anonymous Sat, 06 Jun 2009 15:30

Thanks Dai, you're a great guy to do this for us. Brian

50. anonymous Sun, 24 May 2009 14:27

This is exactly what beginners need. Whaat I have seen so far - the first bit of creating a database [the blurb calls it a "databse"! ] takes one step at a time, which every beginner needs. IT is far better than a book to follow - and I have used books in the past because I did not know that Showmedo existed until I met it in Linux Format magazine.

49. anonymous Wed, 13 May 2009 07:25

Too slow and pedestrian for such a small topic. Speed it up so we can reach the meat, please.

48. anonymous Tue, 12 May 2009 21:25

I want to see the rest of it but so far so good. sometimes I need to be shown what to do. thanks for it.

47. anonymous Tue, 12 May 2009 13:48

Excellent. This site is what I've been looking for. Dai is an exceptional author

46. anonymous Mon, 11 May 2009 21:27

i found your video helpful

45. anonymous Mon, 04 May 2009 12:27

Good video - clear and easy to follow

44. anonymous Wed, 29 Apr 2009 04:40


43. anonymous Mon, 27 Apr 2009 06:53

Great videos

i want to lern oobase, and i found here, thanks for help me... great job.

Low key, to the point...a nicely done tutorial. I feel fortunate to have stumbled across this site since good database tutorials are hard to come by.

40. anonymous Sun, 19 Apr 2009 20:03

thanks a lot!!!

certanly, only a good guy, computer fan, take his time to do this usefull things.

There are some pretty 'high powered' lessons here on 'Showmedo' and I want those. However, I think that there is great value in also looking at videos made by ordinary computer users.

I want to thank Dai for taking the trouble to share his usage of Open Office. No matter how 'expert' one may become (or think you do) it can still take time to familiarize yourself with a given application. It saves a tremendous amount of time if you can just sit back and watch someone taking you through it.

So thanks a lot Dai - I found it very useful and on a non-computing note, I love that Welsh accent! You have a very 'laid back' way of presentation which I liked very much.

37. anonymous Fri, 17 Apr 2009 21:58

I found the video very helpful.

34. anonymous Mon, 13 Apr 2009 14:09

I did the first tutorial far so good

33. anonymous Sun, 12 Apr 2009 02:07

good start I will follow the guides and see how far it takes me

very helpful

31. anonymous Thu, 09 Apr 2009 14:01

Thanks for the excellent tutorial.

30. anonymous Thu, 02 Apr 2009 05:04

i like this because it is very good

29. anonymous Wed, 01 Apr 2009 13:30

OK so far just started viewing them, I am moving on to the next one so that's a vote :-)

28. anonymous Wed, 01 Apr 2009 12:26

i am just a to openoffice and want to know if i can manage a MySQL from forms created in OOo-base and make all controls on users. Will it help?

I am sorry it isnot a comment i will leave a comment after i see what is there


Menus (Mr)

25. anonymous Tue, 31 Mar 2009 21:39

i have been puzzled by how to use the data base. you seem to have a handle on it and are providing a path for learning. thanks

24. anonymous Mon, 30 Mar 2009 06:00

Hi there!

I looked for a little e-learning. I'm interested at open source and I found your site, I think, open sources and Open Office is the best choise!;) I like the part of this public value. Only valuable people can create real values! Who can believe what he do! I wish many goods for your likes! Thanx for All!

László from Hungary

23. anonymous Mon, 30 Mar 2009 02:23


21. anonymous Sat, 28 Mar 2009 17:25

I was hopeing for more meat but I guess if you don't even know what a database is then that little video might show you how you make one.

If you join showmedo you can right click on the download button and save the .flv files to play on your computer.

I also have a cd menu system of these tutorials but I would have to figure a way of getting them to you. If you prefer this then contact by email :

18. anonymous Thu, 26 Mar 2009 05:14

I find the tutorials for the Open Office Data Base excellent. I would like to download these tutorials to my PC so I can call them up easily while constructing my data base. Is this possible ??

Thansk for your advise. Walter

16. anonymous Sat, 28 Feb 2009 23:54

click on "GO" button screen goes dark gray.

Nothing happens.

Using Ubuntu Intrepid Linux, latsest

Looks good please help.

15. anonymous Fri, 06 Feb 2009 03:40

A really nice pace in contrast to all the US tutorials I've seen on line which are way too slow and wordy

14. anonymous Wed, 14 Jan 2009 18:12

I've watched through them all and they are very helpful for taking away my database phobias

13. anonymous Wed, 03 Dec 2008 09:25

ok, i've just seen the 1st one and I'm going to see the next one. 'By now it's easy to follow...

Thank you

Thumbs up dude. You got my 5 star vote.


Bujang Redzuan Mohammed

Kuching Sarawak Malaysia

thank you for this very interesting and useful video! I would be very interested to see how to call python macros, db stored procedures from ooo base.

once again, thank you

Thanks I like it very much.

Thanks so much Dai for doing these tutorials. They've really helped cut down the learning curve.

8. anonymous Sat, 25 Aug 2007 12:13

I liked it

Steve, good idea with, I've added that as a section to our Publicity page:


Good stuff: most people only look at Writer, Calc and Impress but Base is a very usable component. I've put this on the web for others to see at

A very worthwhile effort. I hope it does well!



Hi Dai - so nice to see some OpenOffice videos!

Just to let you know - we're working to display the number of times that a video gets viewed, we started to track this information in our db a few weeks back. I imagine that this series could be rather popular.

If you (and other users) would like some ideas on how to publicise the videos, I've created a wiki page with some ideas:

and I'm open to suggestions for expanding the page.



Very nice, we've needed an OpenOffice series here for a while. Good job.

Really nice to see an Open-Office series! Clean and succinct. I'm curious to see how the database management works; am currently swimming in the deeper end, coding SQL with Python and SQLAlchemy but there are many instances where that approach is top heavy and of course for the non-programmer this stuff is a boon.

Fantastic stuff Dai, not pleased with newer versions of well established office suites and having viewed this screencast I've downloaded OpenOffice. Its the highest compliment I can think of.

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



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.