LibreOffice Base - Overview

Group 1 - Create a Database Create a Table

• Video 1 - Create a Database, Create a Table
  Create a new database , then create a table in that database
  - Download file(s) to accompany Video 1
  
  Click here to Download: odb01-Employees.odb
  

• Video 2 - Create a Table using the Table Wizard
  Use the Table Wizard to create the save table we created in video #1
  - Download file(s) to accompany Video 2
  
  Click here to Download: odb02-Employees.odb
  

Group 2 - Copy from a Calc File

• Video 3 - Import Data from a Calc File
  Fill the table created in video #2 with data from the calc file using cut and paste. Also shows how to cut and paste when fields are in different order.
  - Download file(s) to accompany Video 3
  
  Click here to Download: odb03a-Employees.odb
  
  Click here to Download: odb03b-Employee-calc-table.ods
  

• Video 4 - Create a Table Using a Calc File
  Instead of importing the data into a table that is already created, this time we look at two ways to create a LibreOffice Base table using a LibreOffice Calc file.
  - Download file(s) to accompany Video 4
  
  Click here to Download: odb04a-Employees.odb
  
  Click here to Download: odb04b-Employee-calc-table.ods
  

Group 3 - Registry and Export to a Calc File

• Video 5 - Registry and Export to a Calc File
  A hands on explanation of the registry and exporting data from a LibreOffice Base table into a LibreOffice Calc spreadsheet.
  

Group 4 - Creating a Form

• Video 6 - Creating a Form
  Create a form for our employee table to view each employee individually, and how to quickly find a record you are looking for.
  See Full Description here
  
  

• Video 7 - Design Mode Basics
  Design Mode on/off, Selecting objects, group edit, moving fields, and adding a Label.
  See Full Description here
  
  - Download file(s) to accompany Video 7
  
  Click here to Download: odb07-Design-Mode.odb
  

• Video 8 - Add Delete Fields and Tab Order
  We will delete some fields off our form, then add them back and reformat them to match the fields already on the form – Then fix the tab order.
  See Full Description here
  
  - Download file(s) to accompany Video 8
  
  Click here to Download: odb08-DeleteAdd Fields and TabOrder.odb
  

Group 5 - Forms Part 2

• Video 9 - Protect a Field, Sort, Add Buttons
  We will protect our employee-ID field, then then change the sort order of our table to sort the records by last name (instead of employe-ID), then add some buttons to our form to allow us to select the next and previous records.
  See Full Description here
  
  - Download file(s) to accompany Video 9
  
  Click here to Download: odb09-ProtectAField Add Buttons.odb
  

• Video 10 - Filter and Background
  An introduction to the filter on the navitgation toolbar, how to change the background color/insert a background graphic also adding a logo on your form.
  See Full Description here
  
  - Download file(s) to accompany Video 10
  
  Click here to Download: odb10-Filter Background.odb
  
  Click here to Download: odb10-Gender-Text-VarChar.odb
  

• Video 11 - Radio Buttons
  Add a radio button to replace the Gender Textbox on an updated version of odb10, then we take the original odb10 output change the Gender field type from Fixed Character to VarChar, then we need to update the data in that field, then we can add the radio buttons and check out the data source.
  See Full Description here
  
  - Download file(s) to accompany Video 11
  
  Click here to Download: odb11a-Radio-Button.odb
  
  Click here to Download: odb11b-Gender-Text-VarChar.odb
  

Group 6 - Forms Part 3

• Video 12 - Dates and Dollar Signs
  First we show how to do a date drop down down box, then we format a date on our table and show how to get the date formatting from the table, then we will create a new field (on our table) with a dollar value and have it show on our form with a dollar sign.
  See Full Description here
  
  - Download file(s) to accompany Video 12
  
  Click here to Download: odb12-Dates and Dollar Signs.odb
  

• Video 13 - Pattern Field
  We will change the phone number field to a Pattern Field to only allow numbers to be entered into our phone number field.
  See Full Description here
  
  - Download file(s) to accompany Video 13
  
  Click here to Download: odb13a-Edit Mask.txt
  
  Click here to Download: odb13b-Pattern Field.odb
  

• Video 14 - Form Properties
  We will change the phone number field to a Pattern Field to only allow numbers to be entered into our phone number field.
  See Full Description here
  
  - Download file(s) to accompany Video 14
  
  Click here to Download: odb14-Form Properties.odb
  

Group 7 - Adding a Picture

• Video 15 - Embedding a Picture
  We add the employee pictures to our form, the pictures will be embedded into our table – meaning the pictures themselves will be added to the table (Next video will show how to link a picture).
  See Full Description here
  
  - Download file(s) to accompany Video 15
  
  Click here to Download: odb15a-Embedding Picutres.odb
  
  Click here to Download: odb15b-Pictures.zip
  
  Click here to Download: odb15c-Embedding Picutres-300px.odb
  
  Click here to Download: odb15d-Pictures-300px pics.zip
  

• Video 16 - Linking a Picture
  We add the employee pictures to our form with a link, keeping the location of the picture on the table, instead of the picture itself.
  See Full Description here
  
  - Download file(s) to accompany Video 16
  
  Click here to Download: odb16-LibreOffice-Draw.jpg
  

Group 8 - Intro to Queries

• Video 17 - Intro to Queries
  We will create simple query and learn some basic information about Sequel/SQL is and how SQL view is different from Design View also known as QBE or Query By Example.
  See Full Description here
  
  - Download file(s) to accompany Video 17
  
  Click here to Download: odb17-Intro to Queries.odb
  

• Video 18 - Intro to SQL Debugging
  We look at some errors and error messages that a newbie might encounter; and some possible solutions.
  See Full Description here
  
  

• Video 19 - Alias and Sort
  We first see that I reduced all my pics to 300px tall and embedded them, then see what an Alias is and how to use it in Design view as well as Sequel view, then we see that Sort in Design view changes to Order By in SQL view.
  See Full Description here
  
  - Download file(s) to accompany Video 19
  
  Click here to Download: odb19-AliasAndSort.odb
  

Group 9 - Queries Part 2

• Video 20 - Query Where clause
  How to use the Where clause to filter down our queries in design view as well as SQL view.
  See Full Description here
  
  - Download file(s) to accompany Video 20
  
  Click here to Download: odb20-Qry-Where.odb
  

• Video 21 - Where Part 2
  Using the where clause with numeric values and dates.
  See Full Description here
  
  - Download file(s) to accompany Video 21
  
  Click here to Download: odb21-Qry-Where-Part2.odb
  

• Video 22 - Wildcards
  Using wildcards and single character wild cards to filter the result set.
  See Full Description here
  
  - Download file(s) to accompany Video 22
  
  Click here to Download: odb22-Qry-Wildcards.odb
  

Group 10 - Queries Part 3

• Video 23 - NULLs
  We look at what Nulls are (The value in a field before anything is assigned to it) and the difference between Nulls and Empty (or no value ').
  See Full Description here
  
  - Download file(s) to accompany Video 23
  
  Click here to Download: odb23a-Nulls-Before.odb
  
  Click here to Download: odb23b-Nulls-After.odb
  

• Video 24 - Query Between
  Instead of using Less Than and Greater Than we show how to use Between or NOT Between to create a selection filter range.
  See Full Description here
  
  - Download file(s) to accompany Video 24
  
  Click here to Download: odb24-Between.odb
  

• Video 25 - Query IN
  How to use IN and NOT IN to filter down our result set - Instead of Less Than and Greater Than
  See Full Description here
  
  - Download file(s) to accompany Video 25
  
  Click here to Download: odb25-IN.odb
  

Group 11 - Queries Part 4

• Video 26 - Limit Distinct Calculations and Constants
  We first see how to limit the number of records in our result set, then see the distinct feature, we calculate the weekly and annual salary, then we look at how to create a constant value in our output.
  - Download file(s) to accompany Video 26
  
  Click here to Download: odb26-Limit-Distinct-Calcs-Const.odb
  

• Video 27 - User Parameters Part 1
  We look at how to create a query to search for a specific employee ID. Then we apply the same principles for a date range query.
  - Download file(s) to accompany Video 27
  
  Click here to Download: odb27-User-Parameters-Part1.odb
  

• Video 28 - User Parameters Part 2
  We add wildcards to our user input query and use it to create a simple form with a user input parameter.
  - Download file(s) to accompany Video 28
  
  Click here to Download: odb28-User-Parameters-Part2.odb
  

• Video 29 - Count and Group
  Function in design view - How to count up the number of records on a table or for a result set - We can also group by a field (like department) and count or summarize a numeric field by group.
  - Download file(s) to accompany Video 29
  
  Click here to Download: odb29-Count and Group.odb
  

Group 12 - Multiple Tables

• Video 30 - Why we need multiple tables
  We look at a situation where a single table is just not practical and we describe how a second table will resolve the problem.
  - Download file(s) to accompany Video 30
  
  Click here to Download: odb30-Count and Group.ods
  

• Video 31 - Query Insert
  We create the employee phone number table and populate it using the SQL command INSERT.
  - Download file(s) to accompany Video 31
  
  Click here to Download: odb31a-Insert-PlaceUpNorth.txt
  
  Click here to Download: odb31b-Insert-BrothersHouse.txt
  
  Click here to Download: odb31c-Insert-Cell Phone 2.txt
  
  Click here to Download: odb31d-Insert-Cell Phone.txt
  
  Click here to Download: odb31e-Insert-HomePhone.txt
  
  Click here to Download: odb31f-Insert-From-Select.txt
  
  Click here to Download: odb31g-Query Insert.odb
  

• Video 32 - Query Update Delete
  We look at how to update records on a table using an SQL query. We use wildcards and update for Nulls and empty. Then we delete the records using a delete query.
  - Download file(s) to accompany Video 32
  
  Click here to Download: odb32a-Insert-Records.txt
  
  Click here to Download: odb32b-Call-This-First.txt
  
  Click here to Download: odb32c-Sellect-B4-Update.txt
  
  Click here to Download: odb32d-Update-Wildcard.txt
  
  Click here to Download: odb32e-Update-SingleChar-Wildcard.txt
  
  Click here to Download: odb32f-Null-Blank.txt
  
  Click here to Download: odb32g-Delete-1-Rec.txt
  
  Click here to Download: odb32h-Delete-Employee.txt
  

Group 13 - Creating a Subform

• Video 33 - Create a Subform
  We create a form with a simple subform using the employee table as the main form and the phone number table we created in videos 30 and 31 as our subform.
  - Download file(s) to accompany Video 33
  
  Click here to Download: odb33-Subform.odb
  

• Video 34 - Createing a Relationship
  We create a 1 to many relationship then we add an update cascade and a delete cascade constraint to our forgien key for that relationship, we also look at a common relationship error message and what causes it.
  - Download file(s) to accompany Video 34
  
  Click here to Download: odb34-Relationships.odb
  

• Video 35 - Repositioning Fields on a Form
  We move fields around the old employee form to make room for a sub-form - the background is changed and some columns are aligned too.
  - Download file(s) to accompany Video 35
  
  Click here to Download: odb35-ReAligningTheSingleTableForm.odb
  

• Video 36 - Adding a Subform (to an exiting form)
  We add a subform to our original (single table) Employee form (reformatted in video 35) to make it look and work like video 33s Create a simple subform.
  - Download file(s) to accompany Video 36
  
  Click here to Download: odb36-Adding a Subform.odb
  

Group 14 - Normalizing

• Video 37 - Normalizing - Part 1
  We start off by talking about what is normalizing a database (reducing redundant data) why we should normalize our tables (To have the data in one place and to reduce the file size) Then we create a separate Group table to normalize the Group Data.
  - Download file(s) to accompany Video 37
  
  Click here to Download: odb37a-Add_Group-Table.txt
  
  Click here to Download: odb37b-Insert-From-Select.txt
  
  Click here to Download: odb37c-Normalizing Pt-1.odb
  

• Video 38 - Normalizing - Part 2
  We create a separate department table and we add a contact person to the department (and a relationship for the contact person)
  - Download file(s) to accompany Video 38
  
  Click here to Download: odb38a-Add_Department-Table.txt
  
  Click here to Download: odb38b-Dept-Insert-From-Select.txt
  
  Click here to Download: odb38c-Normalizing Pt-2.odb
  

• Video 39 - Normalizing - Part 3
  We rename the original employees table and copy the information into a new employees table with new constraints then we review and create relationships for the new employee table.
  - Download file(s) to accompany Video 39
  
  Click here to Download: odb39a-Create-Employees-Table.txt
  
  Click here to Download: odb39-Before.odb
  
  Click here to Download: odb39b-Insert-From-Select-with-Case.txt
  
  Click here to Download: odb39c-Normalizing Part 3.odb
  

Group 15 - SQL Join

• Video 40 - SQL Join Part 1
  We see how to create a query to join the department and group tables to the employee table in both design view and SQL view.
  - Download file(s) to accompany Video 40
  
  Click here to Download: odb40-SQL-Join-Part1.odb
  

• Video 41 - SQL Join Part 2
  The difference between an inner and Left (or Right) outer join and how to do them in LibreOffice Base.
  - Download file(s) to accompany Video 41
  
  Click here to Download: odb41a-Before.odb
  
  Click here to Download: odb41b-SQL-Join-Part2.odb
  

• Video 42 - SQL SubQuery
  How to find all the foreign key records that do not have a primary key using a subquery (a query inside a query). Subquerys can produce the same result set as a Join as well the opposite of a join result set
  - Download file(s) to accompany Video 42
  
  Click here to Download: odb42a-Delete.txt
  
  Click here to Download: odb42b-SubQuery.odb
  

Group 16 - View/Edit Constraints

• Video 43 - Edit a Constraint
  We look at a few queries that shows information about the tables and fields we created from the HSQL database . Then we update a CHECK CONSTRAINT.
  - Download file(s) to accompany Video 43
  
  Click here to Download: odb43a-Drop-Constraint.txt
  
  Click here to Download: odb43b-Add-Constraint.txt
  
  Click here to Download: odb43c-Edit-Constraint.odb
  

• Video 44 - Review of Relationships
  We see the Default value does not work properly LibreOffice (v4.2.0.4) GUI screens, then we review how Update Cascade and Delete: Set to Default work.
  - Download file(s) to accompany Video 44
  
  Click here to Download: odb44-Review of Relationships.odb
  

• Video 45 - More about Constraints
  We want to change the Department ID and Group ID fields to not null (set entry required to Yes), but we have to get around the constraint (as well as an issue with LibreOffice 4.2.0.4 gui screens)
  - Download file(s) to accompany Video 45
  
  Click here to Download: odb45a-tbl-Employees-Alter Dept NOT null Default 0.txt
  
  Click here to Download: odb45b-Group-ID-NOT-NULL.txt
  
  Click here to Download: odb45c-More About Constratints.odb
  

Group 17 - Multi-Table Forms

• Video 46 - Form from Queries
  We create queries to capture the data we want to show on an employee view form (with a subform) and see why one query allows updates and the other does not.
  - Download file(s) to accompany Video 46
  
  Click here to Download: odb46-Form from Queries.odb
  

• Video 47 - Edit Form Part 1
  We start creating the Employee Edit form by placing the fields we want to see on the form, we add our sub-form from our existing relations, and re-position our fields. We will change the Department-ID and Group-Id to Department Name and Group Name in part 2.
  - Download file(s) to accompany Video 47
  
  Click here to Download: odb47-Edit-Form-Part 1.odb
  

• Video 48 - Edit Form Part 2(ListBox)
  We use List boxes to edit the Department Name and Group Name and make a few other changes to complete our employee edit form
  - Download file(s) to accompany Video 48
  
  Click here to Download: odb48-Edit-Form-Part 2.odb
  

Group 18 - ListBox

• Video 49 - ListBox No Wizard
  We create another Department ListBox just like the previous video, only this time we dont use the wizard and we get into a little more detail about how the ListBox works.
  - Download file(s) to accompany Video 49
  
  Click here to Download: odb49a-select-department.txt
  
  Click here to Download: odb49b-select-department.txt
  
  Click here to Download: odb49c-ListBox-NoWizard.odb
  

• Video 50 - Single Table ListBox
  We show how to create a ListBox for a Single Table and how to get around some common problems creating a single table ListBox.
  - Download file(s) to accompany Video 50
  
  Click here to Download: odb50-SingleTable-ListBox.odb
  

• Video 51 - ListBox ValueList
  We create a ValueList for a ListBox on a form with a single table ListBox and then for a form with a normalized ListBox.
  - Download file(s) to accompany Video 51
  
  Click here to Download: odb51-ListBox-ValueList.odb
  

• Video 52 - Combo Box
  We create a ValueList for a ListBox on a form with a single table ListBox and then for a form with a normalized ListBox.
  - Download file(s) to accompany Video 52
  
  Click here to Download: odb52-Combo Box.odb
  

Group 19 - Subform Filter

• Video 53 - View by Department part 1
  We complete the form that will show us the employees filtered by a department that we choose from a Listbox dropdown. Part 2 of 2.
  - Download file(s) to accompany Video 53
  
  Click here to Download: odb53-View by Dept - Part 1.odb
  

• Video 54 - View by Department part 2
  We complete the form that will show us the employees filtered by a department that we choose from a Listbox dropdown. (Part 2 of 2)
  - Download file(s) to accompany Video 54
  
  Click here to Download: odb54-View by Dept - Part 2.odb
  

• Video 55 - Add a Wildcard
  We add a wildcard filter for the last name to the department filter created in video 54. This will allow us to filter by all or part of the last name as well as the department filter.
  - Download file(s) to accompany Video 55
  
  Click here to Download: odb55a-Add Wildcard Filter.odb
  
  Click here to Download: odb55b-Before.odb
  
  Click here to Download: odb55c-qry_DPT-LN(wildcard).txt
  

• Video 56 - Employee Search Form pt1
  We add some more fields on to our employee search form (dates) and try to make it look a little nicer - part 1 adds the new fields (dates).
  - Download file(s) to accompany Video 56
  
  Click here to Download: odb56-Employee Search Form - pt1.odb
  

• Video 57 - Employee Search Form pt2
  We complete our Employee Search Form by reformatting our form to look nicer and completing the Less Than and Greater Than Start Date feature.
  - Download file(s) to accompany Video 57
  
  Click here to Download: odb57a-Employee Search Form - pt2.odb
  
  Click here to Download: odb57b-Query.txt
  

Group 20 - Clean up / Add Current Date

• Video 58 - Cleanup and Review part 1
  We clean up the database by removing unused Tables, Queries, and Forms. Then we review how to get the most out of what we've learned so far, using 3 forms. An Insert Form, an Edit Form, and a Search Form.
  - Download file(s) to accompany Video 58
  
  Click here to Download: odb58a-Before.odb
  
  Click here to Download: odb58b-Clean up and Review.odb
  

• Video 59 - Cleanup and Review part 2
  We clean up the Search for Employee Form and Edit Employee Form and talk about how they work together.
  - Download file(s) to accompany Video 59
  
  Click here to Download: odb59-Clean up and Review part 2.odb
  

• Video 60 - Add Current Date
  We add a 'Date Entered' field - To record the current date and time, every time a new employee record is added.
  - Download file(s) to accompany Video 60
  
  Click here to Download: odb60-Add Current Date.odb
  
  Click here to Download: odb60a-SQL Currnet Date 1.txt
  
  Click here to Download: odb60b-SQL Currnet Date 2.txt
  
  Click here to Download: odb60c-ALTER TABLE.txt
  

Group 21 - Standalone Forms

• Video 61 - Standalone Forms
  We learn how to run the forms we created straight from our desktop as a standalone form. Note: Macros will NOT work in standalone forms.
  - Download file(s) to accompany Video 61
  
  Click here to Download: odb61-Standalone Forms.odb
  

• Video 62 - Standalone Switchboard
  We learn how to run the forms we created straight from our desktop as a standalone form. Note: Macros will NOT work in standalone forms.
  

Group 22 - Junction Tables

• Video 63 - Junction Tables - pt1
  We add a new table for training and we want to list the training by employee as well as the employees by the training - this requires a junction table - that we create in this video and show how it works.
  - Download file(s) to accompany Video 63
  
  Click here to Download: odb63-Before.odb
  
  Click here to Download: odb63-Junction Tables pt1.odb
  

• Video 64 - Junction Tables - pt2
  We start the Junction Table Form showing all the training for an employee using the junction table.
  - Download file(s) to accompany Video 64
  
  Click here to Download: odb64-Before.odb
  
  Click here to Download: odb64-Junction Tables pt2.odb
  

• Video 65 - Junction Tables - pt3
  We complete the Junction Table Form by adding a subform to select employees by training.
  - Download file(s) to accompany Video 65
  
  Click here to Download: odb65-Junction Tables pt3.odb
  

Group 23 - Reports 1

• Video 66 - Intro to Reports
  As in introduction to the report builder feature, we build 2 small simple reports.
  - Download file(s) to accompany Video 66
  
  Click here to Download: odb66-Intro to reports.odb
  

• Video 67 - Report Headers
  We add some basic headers and footers to the reports we created in the previous video including current date/time and page numbers.
  - Download file(s) to accompany Video 67
  
  Click here to Download: odb67-Report Headers.odb
  

• Video 68 Reports from Design View
  We create the same reports we created in the previous videos in design view (instead of using the Wizards).
  - Download file(s) to accompany Video 68
  
  Click here to Download: odb68-Reports from Design View.odb
  

Group 24 - Reports 2

• Video 69 - Reports Intro to Grouping
  We look at grouping our report by employee ID - We also add in some space and separator lines.
  - Download file(s) to accompany Video 69
  
  Click here to Download: odb69-Reports Intro to Groups.odb
  

• Video 70 - Reports Conditional
  We create a report from the Employees table and use "IF()" to change the Department ID to a Department Name. Then we use the "ISBLANK()" in an IF to set a value for a field that is NULL. We also highlight values greater than 40 by making them bold and changing the color.
  - Download file(s) to accompany Video 70
  
  Click here to Download: odb70-conditional.txt
  
  Click here to Download: odb70-Reports Conditional.odb
  

• Video 71 - Reports More Grouping pt 1
  We create a report that groups employees by their group, which is also grouped by department with each department on a separate page.
  - Download file(s) to accompany Video 71
  
  Click here to Download: odb71-More Grouping pt1.odb
  

• Video 72 - Reports More Grouping pt 2
  We add a count for the Group and Department groups, we also accumulate the hourly wages by Group and Department.
  - Download file(s) to accompany Video 72
  
  Click here to Download: odb72-More Grouping pt2.odb
  

Group 25 - Home Invoice

• Video 73 - Home Invoice pt 1 - Tables
  We want to manage and create invoices (similar to the sample invoice we created using LibreOffice Draw). In this video, we look at the data on the sample invoice and create tables to hold the information that we want on our invoice.
  - Download file(s) to accompany Video 73
  
  Click here to Download: odb73-Invoice Design.odg
  
  Click here to Download: odb73-Invoice-pt1-tables.odb
  

• Video 74 - Home Invoice pt 2 - Forms
  We add the Customer Form and an Invoice Form to our database.
  - Download file(s) to accompany Video 74
  
  Click here to Download: odb74-Invoice-pt2-Forms.odb
  

• Video 75 - Home Invoice pt 3 - Add Data
  We add some data to our tables and fix a couple of issued with our forms.
  - Download file(s) to accompany Video 75
  
  Click here to Download: odb75-Invoice-pt3-Add Data.odb
  

• Video 76 - Home Invoice pt 4a - The Invoice
  We start the report that will create the actual invoices (The invoices that will look like the LibreOffice Draw Invoice we saw in part 1)
  - Download file(s) to accompany Video 76
  
  Click here to Download: odb76-Invoice-pt4a-TheInvoice.odb
  

• Video 77 - Home Invoice pt 4b - The Invoice
  We continue working the form making the address, state, and zip code look nice (in a single field) and we start adding in the box outlines.
  - Download file(s) to accompany Video 77
  
  Click here to Download: odb77-Invoice-pt4b-TheInvoice.odb
  

• Video 78 - Home Invoice pt4c - The Invoice
  We complete our invoice report.
  
  Working on the invoice report, I try to re-size a label by using the handles and LibreOffice crashes. I restore from my backup, and I am able to complete the report. We finish by comparing the LibreOffice Draw sample invoice to the completed invoice.
  - Download file(s) to accompany Video 78
  
  Click here to Download: odb78-Invoice-pt4c-TheInvoice.odb
  

Group 26 - Email from LibreOffice

• Video 79 - E-mail from LibreOffice
  We look at the possibilities of sending an e-mail from LibreOffice. (The idea of e-mailing the invoices completed in the previous tutorial)
  
  At this moment, LibreOffice cannot e-mail a document out by itself, it can open Thunderbird and set a LibreOffice document up as an e-mail or as an attachment(in various formats). LibreOffice has started an e-mail feature; this can be seen by clicking on the "Mail Merge Wizard..." feature in LibreOffice Writer. This functionality is not (yet) working
  

Group 27 - MySQL

• Video 80 - Install MySQL
  In this video we see how to install MySQL...
  See Full Description here
  
  

• Video 81 - Connect with ODBC
  We see how to use the ODBC connector to connect LibreOffice Base to a MySQL Database...
  See Full Description here
  
  

• Video 82 - Connect Directly with problem
  We create another MySQL database...
  See Full Description here
  
  

• Video 83 - Connect Directly
  On a different computer, I connect...
  See Full Description here
  
  

• Video 84 - Connect with JDBC
  We see how to connect LibreOffice Base to a MySQL database using JDBC...
  See Full Description here
  
  

• Video 85 - Multiple MySQL Users
  We add Multiple users to MySQL and...
  See Full Description here
  
  

Group 28 - MySQL Workbench

• Video 86 - MySQL Workbench (1)
  We take a first look at MySQL Workbench...
  See Full Description here
  
  

• Video 87 - MySQL Workbench (2)
  We learn how to reverse engineer a MySQL Database using MySQL Workbench...
  See Full Description here
  
  

• Video 88 - mysql_searchform (1)
  We create a new MySQL database called mysql_searchform...
  See Full Description here
  
  

• Video 89 - Create .csv files
  We create .CSV backup files from...
  See Full Description here
  
  

• Video 90 - Upload .csv files
  We update MySQL tables with the .csv files we created in..
  See Full Description here
  
  

• Video 91 - MySQL Relationships
  We create some relationships for the MySQL tables using MySQL Workbench...
  See Full Description here
  
  

• Video 92 - MySQL Pictures
  We add pictures into the MySQL employee table...
  See Full Description here
  
  

• Video 93 - MySQL Searchform
  We start to create the LibreOffice Base form to search...
  See Full Description here
  
  

• Video 94 - MySQL Searchform
  We complete the LibreOffice Base form, that searches for...
  See Full Description here