Introduction to LibreOffice Base (LOB)-1
Tables & Fields
Robin Beaumont
Date: Saturday, 07 April 2012 e-mail: robin@organplayers.co.uk
1. Learning outcomes check list .............................................................................................................................2
2. Introduction ......................................................................................................................................................3
3. The consultations database ...............................................................................................................................3
4. Installing and Starting LibreOffice Base (LOB) ....................................................................................................3
5. How to create a Database in LibreOffice Base (LOB) ..........................................................................................4
6. How to create a new table and fields in Libreoffice Base (LOB) ..........................................................................5
7. Adding fields - creating the unique index...........................................................................................................5
8. Saving your work...............................................................................................................................................6
9. Input masks.......................................................................................................................................................7
10. Moving between edit (design) and open (datasheet) view ............................................................................8
11. Working with records in open table view ......................................................................................................9
12. Deleting records .......................................................................................................................................... 10
13. Required field values................................................................................................................................... 10
14. Creating Key Fields in LibreOffice Base ........................................................................................................ 10
15. Closing an existing database ....................................................................................................................... 10
16. Opening an existing database ..................................................................................................................... 11
17. Renaming or copying tables ........................................................................................................................ 11
18. Resumé ....................................................................................................................................................... 11
19. References .................................................................................................................................................. 13
This handout is part of a series.
Please see section 7.1 at:
www.robin-beaumont.co.uk/virtualclassroom/contents.html
Please note that before you start this practical chapter you should have completed
database concepts (1) available at the above link