-
How to Create a Database Using LibreOffice Base
Type Video Recording Director Sean Johnson Abstract Libre office base (similar to Open Office) is a free database for mac OS X, linux and pc. Date 2017 Language English URL https://www.youtube.com/watch?v=MR1yEicq_bM&list=PLQORZjfSPqSkhPbBrwfLOkd_BthVsRqpM&index=4 Running Time 6:19 -
How to Create a LibreOffice Base Form with Sub Form
Type Video Recording Director Sean Johnson Abstract How to build a form and subform in LibreOffice base without needing any code. Date 2020 Language English URL https://www.youtube.com/watch?v=e4rAHshAEj8&list=PLQORZjfSPqSkhPbBrwfLOkd_BthVsRqpM&index=8 Running Time 18:36 -
How to Create a LibreOffice Base Split Database
Type Video Recording Director Sean Johnson Abstract In this tutorial, I show you how to set up a split database version of the LibreOffice base database. Date 2017 Language English URL https://www.youtube.com/watch?v=XQtKXPvckOg&list=PLQORZjfSPqSkhPbBrwfLOkd_BthVsRqpM&index=5 Running Time 7:35 -
How to Export Data from a LibreOffice Base Database Table
Type Video Recording Director Sean Johnson Abstract How to export data from a LibreOffice (libre office) or open office base database table using sql and text tables to create a csv file on the Apple Mac file system, the process is similar for windows. Date 2016 Language English URL https://www.youtube.com/watch?v=SSqm519j-_0&list=PLQORZjfSPqSkFSFHR32WlfXhen0C2HyAi&index=5 Running Time 6:53 -
How to Install Libreoffice Base on Windows 10
Type Video Recording Director Sean Johnson Abstract How to install LibreOffice Base database on Windows 10 and get it working. Date 2020 Language English URL https://www.youtube.com/watch?v=LSjzIwDo0nU&list=PLQORZjfSPqSkhPbBrwfLOkd_BthVsRqpM&index=10 Running Time 8:26 -
LibreOffice Base – Change Date Format
Type Video Recording Director OS College Abstract This video demonstrates changing the date and time format for a variable in LibreOffice Base. This video was shot in Windows for Windows Wednesday. Date 2020 Language English URL https://www.youtube.com/watch?v=g6h_jpPANP8&list=PLK_xio5V3ieNWcu6HWemor5CAmq5DU5MG&index=16 Running Time 1:33 -
LibreOffice Base – Create a Simple Form
Type Video Recording Director Sean Johnson Abstract Learn how to program a form in LibreOffice (open office) base. Date 2020 Language English URL https://www.youtube.com/watch?v=R1sc8cfpqGI&list=PLQORZjfSPqSkhPbBrwfLOkd_BthVsRqpM&index=9 Running Time 22:20 -
LibreOffice Base – Database Tutorial
Type Video Recording Director Sean Johnson Abstract Full LibreOffice base database example (same as open office base) to demonstrate how to create a personal training database with very little code. Date 2021 Language English URL https://www.youtube.com/watch?v=Du1WjROQBpE&list=PLQORZjfSPqSkhPbBrwfLOkd_BthVsRqpM&index=13 Running Time 25:31 -
LibreOffice Base – Database Tutorial (No Code Required)
Type Video Recording Director Sean Johnson Abstract How to create a relational database using forms and subforms without using macro code. In this tutorial, I walk you through the creation of a useful database that manages courses and the students enrolled in these courses. Date 2021 Language English URL https://www.youtube.com/watch?v=PJQPzVvZg7I&list=PLQORZjfSPqSkFSFHR32WlfXhen0C2HyAi&index=14 Running Time 32:03 -
LibreOffice Base – Email
Type Video Recording Director OS College Abstract The video demonstrates the email item in LibreOffice Base. Date 2020 Language English URL https://www.youtube.com/watch?v=E_rXkEb0Pj0&list=PLK_xio5V3ieNWcu6HWemor5CAmq5DU5MG&index=26 Running Time 2:45 -
LibreOffice Base – How to Create a Database Table
Type Video Recording Director Sean Johnson Abstract This Open office database tutorial (In this case I use LibreOffice which is essentially the same – only a little better) explains how to make a table that will be used to import text file data into a database for further processing and normalization. Date 2016 Language English URL https://www.youtube.com/watch?v=JNgr2Wf4wtE&list=PLQORZjfSPqSkFSFHR32WlfXhen0C2HyAi&index=6&t=55s Running Time 6:59 -
LibreOffice Base – Insert Dynamic Image
Type Video Recording Director Sean Johnson Abstract How to Add Images Dynamically To a LibreOffice base database form. Date 2020 Language English URL https://www.youtube.com/watch?v=am4zY7Fzcrs&list=PLQORZjfSPqSkFSFHR32WlfXhen0C2HyAi&index=10&t=9s Running Time 38:32 -
LibreOffice Base – Inserting Special Characters
Type Video Recording Director OS College Abstract This video demonstrates how to insert special characters in a table in a LibreOffice Base database. Date 2020 Language English URL https://www.youtube.com/watch?v=GNZ4F9wEvys&list=PLK_xio5V3ieNWcu6HWemor5CAmq5DU5MG&index=11 Running Time 1:15 -
LibreOffice Base – Introduction to Form and Report Wizards
Type Video Recording Director OS College Abstract This video gives a brief overview of the Form wizard in LibreOffice Base. There is also a Report wizard that is similar. Date 2020 Language English URL https://www.youtube.com/watch?v=s7annXtjxCs&list=PLK_xio5V3ieNWcu6HWemor5CAmq5DU5MG&index=21 Running Time 1:59 -
LibreOffice Base – Primary Key
Type Video Recording Director OS College Abstract This video demonstrates how to set a field as the primary key in a table in LibreOffice Base. Date 2020 Language English URL https://www.youtube.com/watch?v=SBigLYkZ5YI&list=PLK_xio5V3ieNWcu6HWemor5CAmq5DU5MG&index=34 Running Time 1:21 Date Added 1/9/2022, 9:16:29 PM Modified 1/22/2022, 3:04:18 PM -
LibreOffice Base – Split Database Tutorial
Type Video Recording Director Sean Johnson Abstract Here I explain a real world data processing example using a LibreOffice base split database with Sql and Text Tables to import and transform an Excel File containing 104,916 rows of data to 365 rows without using programming code. Date 2021 Language English URL https://www.youtube.com/watch?v=BwrWoP0Wr7w&list=PLQORZjfSPqSkhPbBrwfLOkd_BthVsRqpM&index=14 Running Time 18:07 -
LibreOffice Base – Starting Database Design with a Table Wizard
Type Video Recording Director OS College Abstract The foundation to any database is its data tables. In LibreOffice Base you can start creating the database by launching a table wizard when the project is created. This video demonstrates this. Date 2020 Language English URL https://www.youtube.com/watch?v=ZfuZjuQ_now&list=PLK_xio5V3ieNWcu6HWemor5CAmq5DU5MG&index=6 Running Time 1:34 -
LibreOffice Base (01) Create a Database, Create a Table
Type Video Recording Director The Frugal Computer Guy Abstract Create a new database, then create a table in that database, then enter some data into the table. Date 2013 Language English URL https://www.youtube.com/watch?v=jWU0WdMJ2Kw&list=PL0pdzjvYW9RFPzoPkYdd-cmOGhIFl84_n&index=1 Running Time 10:56 -
LibreOffice Base (02) Create a Table with the Table Wizard
Type Video Recording Director The Frugal Computer Guy Abstract Use the Table Wizard to create the same table we created in video #1. Date 2013 Language English URL https://www.youtube.com/watch?v=I45YJdW9GI0&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=3 Running Time 8:49 -
LibreOffice Base (03) Import Data from a Calc File
Type Video Recording Director The Frugal Computer Guy Abstract 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. Date 2013 Language English URL https://www.youtube.com/watch?v=D_W-FAT3XE4&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=4 Running Time 10:28 -
LibreOffice Base (04) Create a Table Using a Calc File
Type Video Recording Director The Frugal Computer Guy Abstract 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 Calc file. Date 2013 Language English URL https://www.youtube.com/watch?v=5N3fJLdp3xk&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=5 Running Time 6:38 -
LibreOffice Base (05) Registry and Export Data to a Calc File
Type Video Recording Director The Frugal Computer Guy Abstract A hands on explanation of the registry and exporting data from a LibreOffice Base table into a LibreOffice Calc spreadsheet. Date 2013 Language English URL https://www.youtube.com/watch?v=HbDuEEv3gOk&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=6 Running Time 6:16 -
LibreOffice Base (06) Creating a Form
Type Video Recording Director The Frugal Computer Guy Abstract Create a form for our employee table to view each employee individually, and how to quickly find a record you are looking for. Date 2013 Language English URL https://www.youtube.com/watch?v=GxINtJp0Ig0&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=7 Running Time 10:22 -
LibreOffice Base (07) Design Mode Basics
Type Video Recording Director The Frugal Computer Guy Abstract Design Mode on/off, Selecting objects, group edit, moving fields, and adding a Label. Date 2013 Language English URL https://www.youtube.com/watch?v=hnSouxF6u5M&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=8 Running Time 12:02 -
LibreOffice Base (08) Add Delete Fields and Tab Order
Type Video Recording Director The Frugal Computer Guy Abstract 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. Date 2013 Language English URL https://www.youtube.com/watch?v=CPe10G5LsXk&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=9 Running Time 10:10 -
LibreOffice Base (09) Protect a Field, Sort, Add Buttons
Type Video Recording Director The Frugal Computer Guy Abstract We will protect our employe-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. Date 2013 Language English URL https://www.youtube.com/watch?v=uHQTmc5XDkE&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=10 Running Time 11:44 -
LibreOffice Base (10) Filter and Background
Type Video Recording Director The Frugal Computer Guy Abstract An introduction to the filter on the navitgation toolbar, how to change the background and adding a logo to your form. Date 2013 Language English URL https://www.youtube.com/watch?v=yOP_VM0rDAI&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=11 Running Time 9:43 -
LibreOffice Base (11) Radio Buttons
Type Video Recording Director The Frugal Computer Guy Abstract 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. Date 2013 Language English URL https://www.youtube.com/watch?v=2WLBEjmaOsQ&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=12 Running Time 12:44 -
LibreOffice Base (12) Dates and Dollar Signs
Type Video Recording Director The Frugal Computer Guy Abstract 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 create a new field (on our table) with a dollar value and have it show on our form with a dollar sign. Date 2013 Language English URL https://www.youtube.com/watch?v=wYaH_FAolX4&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=13 Running Time 11:35 -
LibreOffice Base (13) Pattern Field
Type Video Recording Director The Frugal Computer Guy Abstract We will change the phone number field to a Pattern Field to only allow numbers to be entered into our phone number field. (This same method could be used for letters only as well). Date 2013 Language English URL https://www.youtube.com/watch?v=xysSjJQjcZE&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=14 Running Time 7:55 -
LibreOffice Base (14) Form Properties
Type Video Recording Director The Frugal Computer Guy Abstract We will rename our table to tbl-employees, then we will look at the form properties to point to the updated table-name. We also get introduced to the form navigator. Date 2013 Language English URL https://www.youtube.com/watch?v=Lxz-kfDhsB0&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=15 Running Time 6:38 -
LibreOffice Base (15) Embedding a Picture
Type Video Recording Director The Frugal Computer Guy Abstract 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). Date 2013 Language English URL https://www.youtube.com/watch?v=rM18Ghf-rSg&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=16 Running Time 9:11 -
LibreOffice Base (16) Linking a Picture
Type Video Recording Director The Frugal Computer Guy Abstract 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. Date 2013 Language English URL https://www.youtube.com/watch?v=-tlGsxopTsM&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=17 Running Time 5:25 -
LibreOffice Base (17) Intro to Queries
Type Video Recording Director The Frugal Computer Guy Abstract 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 View). Date 2013 Language English URL https://www.youtube.com/watch?v=O0YaVgJ6_fg&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=18 Running Time 7:57 -
LibreOffice Base (18) Intro to SQL Debugging
Type Video Recording Director The Frugal Computer Guy Abstract We look at some errors and error messages that a newbie might encounter; and some possible solutions. Date 2013 Language English URL https://www.youtube.com/watch?v=bEUe6mTjkTI&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=19 Running Time 10:35 -
LibreOffice Base (19) Alias and Sort
Type Video Recording Director The Frugal Computer Guy Date 2013 Language English URL https://www.youtube.com/watch?v=o-R6FpZufJQ&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=20 Running Time 8:12 -
LibreOffice Base (20) SQL Where Part 1
Type Video Recording Director The Frugal Computer Guy Abstract How to use the Where clause to filter down our queries in design view as well as SQL view. Date 2013 Language English URL https://www.youtube.com/watch?v=GAu3zxlu34k&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=21 Running Time 9:40 -
LibreOffice Base (21) SQL Where Part 2
Type Video Recording Director The Frugal Computer Guy Abstract Using the where clause with numeric values and dates. Date 2013 Language English URL https://www.youtube.com/watch?v=Kn-ptRwThIo&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=22 Running Time 11:30 -
LibreOffice Base (22) SQL Wildcards
Type Video Recording Director The Frugal Computer Guy Abstract Using wildcards and single character wild cards to filter the result set. Date 2013 Language English URL https://www.youtube.com/watch?v=JsHegDc2-iA&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=23 Running Time 8:36 -
LibreOffice Base (23) Nulls
Type Video Recording Director The Frugal Computer Guy Abstract We look at what Nulls are (The value in a field before anything is assigned to it) and the difference between Nulls and Empty (no value ”). Date 2013 Language English URL https://www.youtube.com/watch?v=Bx-YlmDGUC4&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=24 Running Time 8:30 -
LibreOffice Base (24) Query Between
Type Video Recording Director The Frugal Computer Guy Abstract Instead of using Less Than and Greater Than we show how to use Between and NOT Between to create a selection filter range. Date 2013 Language English URL https://www.youtube.com/watch?v=gSxTb68LewU&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=25 Running Time 6:52 -
LibreOffice Base (25) Query IN
Type Video Recording Director The Frugal Computer Guy Abstract How to use IN and NOT IN to filter down our result set – Instead of Less Than and Greater Than Date 2013 Language English URL https://www.youtube.com/watch?v=h1hwDlM653w&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=26 Running Time 6:29 -
LibreOffice Base (26) Limit Distinct Calculations and Constants
Type Video Recording Director The Frugal Computer Guy Abstract 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. Date 2013 Language English URL https://www.youtube.com/watch?v=NxYFbNDgxQg&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=27 Running Time 7:13 -
LibreOffice Base (27) User Parameters Part 1
Type Video Recording Director The Frugal Computer Guy Abstract 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. Date 2013 Language English URL https://www.youtube.com/watch?v=Ct5Nc6K_Jak&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=28 Running Time 8:23 -
LibreOffice Base (28) User Parameters Part 2
Type Video Recording Director The Frugal Computer Guy Abstract We add wildcards to our user input query and use it to create a simple form with a user input parameter. Date 2013 Language English URL https://www.youtube.com/watch?v=lPZrFaVyvxc&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=29 Running Time 9:10 -
LibreOffice Base (29) Count and Group
Type Video Recording Director The Frugal Computer Guy Abstract 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. Date 2013 Language English URL https://www.youtube.com/watch?v=-JC8sr1pQQw&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=30 Running Time 7:13 -
LibreOffice Base (30) Why we Need Multiple Tables
Type Video Recording Director The Frugal Computer Guy Abstract We look at a situation where a single table is just not practical and we describe how a second table will resolve the problem. Date 2013 Language English URL https://www.youtube.com/watch?v=rEWfn5VedvU&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=31 Running Time 4:50 -
LibreOffice Base (31) Query Insert
Type Video Recording Director The Frugal Computer Guy Abstract We create the employee phone number table (described in video 30) and populate it using the SQL command INSERT. Date 2013 Language English URL https://www.youtube.com/watch?v=p_Rnj-9RWfg&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=32 Running Time 9:46 -
LibreOffice Base (32) Query Update Delete
Type Video Recording Director The Frugal Computer Guy Abstract 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. Date 2014 Language English URL https://www.youtube.com/watch?v=2d82wbmJqYo&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=33 Running Time 7:19 -
LibreOffice Base (33) Creating a Simple Subform
Type Video Recording Director The Frugal Computer Guy Abstract 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. Date 2014 Language English URL https://www.youtube.com/watch?v=PEqOdVjab8I&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=34 Running Time 7:20 -
LibreOffice Base (34) Creating a Relationship
Type Video Recording Director The Frugal Computer Guy Abstract We create a 1 to many relationship then we add an update cascade and a delete cascade constraint to our foreign key for that relationship, we also look at a common relationship error message and what causes it. Date 2014 Language English URL https://www.youtube.com/watch?v=UHkCbQL51r4&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=35 Running Time 9:15 -
LibreOffice Base (35) Repostioning Fields on a Form
Type Video Recording Director The Frugal Computer Guy Abstract We move fields around the old employee form to make room for a subform – the background is changed and some columns are aligned too. Date 2014 Language English URL https://www.youtube.com/watch?v=hg8frJumHXU&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=36 Running Time 4:53 -
LibreOffice Base (36) Adding a Subform (to an existing form)
Type Video Recording Director The Frugal Computer Guy Abstract We add a subform to our original (single table) Employee form (reformatted in video 35) to make it look and work like video 33’s Create a simple subform. Date 2014 Language English URL https://www.youtube.com/watch?v=x7i6Z1RIkAw&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=37 Running Time 7:18 -
LibreOffice Base (37) Normalizing Part 1
Type Video Recording Director The Frugal Computer Guy Abstract We start off by talking about what is normalizing a database is (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. Date 2014 Language English URL https://www.youtube.com/watch?v=tZIsqzCutHI&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=38 Running Time 6:34 -
LibreOffice Base (38) Normalizing Part 2
Type Video Recording Director The Frugal Computer Guy Abstract We create a separate department table and we add a contact person to the department table (and a relationship for the contact person) Date 2014 Language English URL https://www.youtube.com/watch?v=9_xprEMotWY&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=39 Running Time 7:33 -
LibreOffice Base (39) Normalizing Part 3
Type Video Recording Director The Frugal Computer Guy Abstract 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. Date 2014 Language English URL https://www.youtube.com/watch?v=UPtgMsNNHOc&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=40 Running Time 10:20 -
LibreOffice Base (40) SQL Join Tables part 1
Type Video Recording Director The Frugal Computer Guy Abstract 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. Date 2014 Language English URL https://www.youtube.com/watch?v=lfofWfyXyn4&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=41 Running Time 12:13 -
LibreOffice Base (41) SQL Join Tables Part 2
Type Video Recording Director The Frugal Computer Guy Abstract The difference between an inner and Left (or Right) outer join and how to do one using LibreOffice Base Date 2014 Language English URL https://www.youtube.com/watch?v=KAVvOf2fVlM&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=42 Running Time 8:18 -
LibreOffice Base (42) SQL SubQuery
Type Video Recording Director The Frugal Computer Guy Abstract How to find all the foreign key records that do not have a primary key using a sub-query (a query inside a query). Subquerys can produce the same result set as a Join as well the opposite of a join result set Date 2014 Language English URL https://www.youtube.com/watch?v=X87P7ADNF_4&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=43 Running Time 6:18 -
LibreOffice Base (43) Edit a Constraint
Type Video Recording Director The Frugal Computer Guy Abstract 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. Date 2014 Language English URL https://www.youtube.com/watch?v=-_oP3EUbs4k&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=44 Running Time 6:40 -
LibreOffice Base (44) Review of Relationships
Type Video Recording Director The Frugal Computer Guy Abstract 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. Date 2014 Language English URL https://www.youtube.com/watch?v=Oxhq0ExsrtI&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=45 Running Time 5:42 -
LibreOffice Base (45) More about Constraints
Type Video Recording Director The Frugal Computer Guy Abstract 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.02 gui screens) Date 2014 Language English URL https://www.youtube.com/watch?v=E2JVEfS1c1g&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=46 Running Time 9:19 -
LibreOffice Base (46) Form from Query
Type Video Recording Director The Frugal Computer Guy Abstract 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. Date 2014 Language English URL https://www.youtube.com/watch?v=uM1gnAvpjRs&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=47 Running Time 10:43 -
LibreOffice Base (47) Edit Form Part 1
Type Video Recording Director The Frugal Computer Guy Abstract 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’ll change the Department-ID and Group-Id to Department and Group Name in part 2. Date 2014 Language English URL https://www.youtube.com/watch?v=6cOboNBaXBk&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=48 Running Time 9:22 -
LibreOffice Base (48) Edit Form Part 2 (List Box)
Type Video Recording Director The Frugal Computer Guy Abstract We use List boxes to edit the Department Name and Group Name and make a few other changes to complete our employee edit form Date 2014 Language English URL https://www.youtube.com/watch?v=XGWhHzyVXAA&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=49 Running Time 10:31 -
LibreOffice Base (49) ListBox No Wizard
Type Video Recording Director The Frugal Computer Guy Abstract We create another Department ListBox just like the previous video, only this time we don’t use the wizard and we get into a little more detail about how the ListBox works. Date 2014 Language English URL https://www.youtube.com/watch?v=SMuZBNTrBSs&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=50 Running Time 7:15 -
LibreOffice Base (50) Single Table ListBox
Type Video Recording Director The Frugal Computer Guy Abstract We show how to create a ListBox for a Single Table and how to get around some common problems creating a single table ListBox. Date 2014 Language English URL https://www.youtube.com/watch?v=hj5qJER6wH4&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=51 Running Time 6:59 -
LibreOffice Base (51) ListBox ValueList
Type Video Recording Director The Frugal Computer Guy Abstract We create a ValueList for a ListBox on a form with a single table ListBox and then for a form with a normalized ListBox Date 2014 Language English URL https://www.youtube.com/watch?v=sOoCupMpr7I&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=52 Running Time 7:23 -
LibreOffice Base (52) Combo Box
Type Video Recording Director The Frugal Computer Guy Abstract We look at how to create a Combo Box and then how it is different than a List Box. Date 2014 Language English URL https://www.youtube.com/watch?v=KM40XuuZ1w8&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=53 Running Time 7:48 -
LibreOffice Base (53) View by Department Part 1
Type Video Recording Director The Frugal Computer Guy Abstract We use design view to start to create a form that will show our employees list, in a subform, filtered by a department that we choose from a dropdown list (part 1 of 2). Date 2014 Language English URL https://www.youtube.com/watch?v=Jm_53SfeC5o&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=54 Running Time 7:28 -
LibreOffice Base (54) View by Department Part 2
Type Video Recording Director The Frugal Computer Guy Abstract We complete the form that will show us the employees filtered by a department that we choose from a Listbox dropdown Date 2014 Language English URL https://www.youtube.com/watch?v=Edv0lKWrxh8&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=55 Running Time 10:16 -
LibreOffice Base (55) Add Wildcard Filter
Type Video Recording Director The Frugal Computer Guy Abstract 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. Date 2014 Language English URL https://www.youtube.com/watch?v=LsAeuNzPj70&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=56 Running Time 6:48 -
LibreOffice Base (56) Employee Search Form Part 1
Type Video Recording Director The Frugal Computer Guy Abstract 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). Date 2014 Language English URL https://www.youtube.com/watch?v=7009jEba_7M&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=57 Running Time 7:40 -
LibreOffice Base (57) Employee Search Form Part 2
Type Video Recording Director The Frugal Computer Guy Abstract We complete our Employee Search Form by reformatting our form to look nicer and completing the Less Than and Greater Than Start Date feature. Date 2014 Language English URL https://www.youtube.com/watch?v=CzYGaVyyqaE&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=58 Running Time 10:05 -
LibreOffice Base (58) Clean-Up and Review Part 1
Type Video Recording Director The Frugal Computer Guy Abstract 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, by using 3 forms. An Insert Form, an Edit Form, and a Search Form. Date 2014 Language English URL https://www.youtube.com/watch?v=cc5mSKYtop8&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=59 Running Time 7:02 -
LibreOffice Base (59) Clean-Up and Review Part 2
Type Video Recording Director The Frugal Computer Guy Abstract We clean up the Search for Employee Form and Edit Employee Form and talk about how they work together. Date 2014 Language English URL https://www.youtube.com/watch?v=ry7xn4VG0S4&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=60 Running Time 10:10 -
LibreOffice Base (60) Add Current Date
Type Video Recording Director The Frugal Computer Guy Abstract We add a ‘Date Entered’ field – To record the current date and time, every time a new employee record is added. Date 2014 Language English URL https://www.youtube.com/watch?v=OBtxupBSN6A&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=61 Running Time 7:06 -
LibreOffice Base (61) Standalone Forms
Type Video Recording Director The Frugal Computer Guy Abstract 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 Date 2014 Language English URL https://www.youtube.com/watch?v=gPANWdBiKqo&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=62 Running Time 11:06 -
LibreOffice Base (62) Standalone Switchboard
Type Video Recording Director The Frugal Computer Guy Abstract We look at how to open our standalone forms from a button from the database as well as from a standalone form. Date 2014 Language English URL https://www.youtube.com/watch?v=U4cIpMxklhA&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=63 Running Time 8:06 -
LibreOffice Base (63) Junction Tables Part 1
Type Video Recording Director The Frugal Computer Guy Abstract 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. Date 2014 Language English URL https://www.youtube.com/watch?v=JsN3lwvHjzs&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=64 Running Time 8:12 -
LibreOffice Base (64) Junction Tables Part 2
Type Video Recording Director The Frugal Computer Guy Abstract We start the Junction Table Form showing all the training for an employee using the junction table. Date 2014 Language English URL https://www.youtube.com/watch?v=GKCXg2ZktYQ&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=65 Running Time 11:20 -
LibreOffice Base (65) Junction Tables Part 3
Type Video Recording Director The Frugal Computer Guy Abstract We complete the Junction Table Form by adding a subform to select employees by training. Date 2014 Language English URL https://www.youtube.com/watch?v=KcHrKUTYDhA&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=66 Running Time 10:32 -
LibreOffice Base (66) Intro to Reports
Type Video Recording Director The Frugal Computer Guy Abstract As in introduction to the report builder feature, we build 2 small simple reports. Date 2014 Language English URL https://www.youtube.com/watch?v=cxlMyNtKoHQ&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=67 Running Time 7:04 -
LibreOffice Base (67) Report Headers-Footers
Type Video Recording Director The Frugal Computer Guy Abstract We add some basic headers and footers to the reports we created in the previous video including current date/time and page numbers Date 2014 Language English URL https://www.youtube.com/watch?v=_7ZHRIQfV-s&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=68 Running Time 12:53 -
LibreOffice Base (68) Reports from Design View
Type Video Recording Director The Frugal Computer Guy Abstract We create the same reports we created in the previous videos in design view (instead of using the Wizards) Date 2014 Language English URL https://www.youtube.com/watch?v=Ky5_o-XCYAM&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=69 Running Time 11:11 -
LibreOffice Base (69) Reports – Intro to Groups
Type Video Recording Director The Frugal Computer Guy Abstract We look at grouping our report by employee ID – We also add in some space and separator lines. Date 2014 Language English URL https://www.youtube.com/watch?v=tuqM0_0hXdw&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=70 Running Time 15:02 -
LibreOffice Base (70) Reports – Conditional
Type Video Recording Director The Frugal Computer Guy Abstract 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. Date 2014 Language English URL https://www.youtube.com/watch?v=XJdRKr8MkC8&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=71 Running Time 13:30 -
LibreOffice Base (71) Reports – More Grouping Part 1
Type Video Recording Director The Frugal Computer Guy Abstract We create a report that groups employees by their group, which is also grouped by department with each department on a separate page Date 2014 Language English URL https://www.youtube.com/watch?v=R_0dXjydfL4&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=72 Running Time 10:29 -
LibreOffice Base (72) Reports – More Grouping Part 2
Type Video Recording Director The Frugal Computer Guy Abstract We add a count for the Group and Department groups, we also accumulate the hourly wages by Group and Department. Date 2014 Language English URL https://www.youtube.com/watch?v=lhrdNqUQ1XQ&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=73 Running Time 12:48 -
LibreOffice Base (73) Home Invoice Part 1 Tables
Type Video Recording Director The Frugal Computer Guy Abstract 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. Date 2014 Language English URL https://www.youtube.com/watch?v=zD19RfSPAaY&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=74 Running Time 8:33 -
LibreOffice Base (74) Home Invoice Part 2 Forms
Type Video Recording Director The Frugal Computer Guy Abstract We add the Customer Form and the Invoice Form to our database. Date 2014 Language English URL https://www.youtube.com/watch?v=qsYdu8Mn5_M&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=75 Running Time 7:53 -
LibreOffice Base (75) Home Invoice Part 3 Add Data
Type Video Recording Director The Frugal Computer Guy Abstract We add some data to our tables and fix a couple of issued with our forms. Date 2014 Language English URL https://www.youtube.com/watch?v=7QPBk0nnvYM&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=76 Running Time 13:08 -
LibreOffice Base (76) Home Invoice Part 4a The Invoice
Type Video Recording Director The Frugal Computer Guy Abstract 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) Date 2014 Language English URL https://www.youtube.com/watch?v=BsVkWX-EVm0&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=77 Running Time 9:38 -
LibreOffice Base (77) Home Invoice Part 4b The Invoice
Type Video Recording Director The Frugal Computer Guy Abstract 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. Date 2014 Language English URL https://www.youtube.com/watch?v=2S5cKFgWC_E&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=78 Running Time 9:47 -
LibreOffice Base (78) Home Invoice Part 4c The Invoice
Type Video Recording Director The Frugal Computer Guy Abstract We complete our invoice report. Date 2014 Language English URL https://www.youtube.com/watch?v=PPaZiBUAG1c&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=79 Running Time 9:27 -
LibreOffice Base (79) Email from LibreOffice
Type Video Recording Director The Frugal Computer Guy Abstract We look at the possibilities of sending an e-mail from LibreOffice. (The idea of e-mailing the invoices completed in the previous tutorial) Date 2014 Language English URL https://www.youtube.com/watch?v=WVYBQZeW5l0&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=80 Running Time 9:16 -
LibreOffice Base (80) Install MySQL
Type Video Recording Director The Frugal Computer Guy Abstract In this video we see how to install MySQL. Date 2014 Language English URL https://www.youtube.com/watch?v=BdF7HUmuU-s&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=81 Running Time 6:45 -
LibreOffice Base (81) Connect with ODBC
Type Video Recording Director The Frugal Computer Guy Abstract We see how to use the ODBC connector to connect LibreOffice Base to a MySQL Database Date 2014 Language English URL https://www.youtube.com/watch?v=0G7L_Nl3Azg&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=82 Running Time 13:17 -
LibreOffice Base (82) Connect Directly with problem
Type Video Recording Director The Frugal Computer Guy Abstract We create another MySQL database and connect directly to the database. We are able to successfully create tables for this database, proving LibreOffice is connecting properly, but we can’t view the tables, so we can’t create any data for the tables or create any forms using LibreOffice. In the past, I have gotten this to work properly, on this computer, but for some reason, right now, I cannot view my tables. Date 2014 Language English URL https://www.youtube.com/watch?v=05PSACUfTK0&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=83 Running Time 5:44 -
LibreOffice Base (83) Connect Directly
Type Video Recording Director The Frugal Computer Guy Abstract On a different computer, I connect directly to MySQL and we see how to create tables, add data, and create a form (with a subform) by connecting to MySQL directly Date 2014 Language English URL https://www.youtube.com/watch?v=HDCmmxvEAcs&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=84 Running Time 10:17 -
LibreOffice Base (84) Connect with JDBC
Type Video Recording Director The Frugal Computer Guy Abstract We see how to connect LibreOffice Base to a MySQL database using JDBC (Java Database Connectivity) Date 2014 Language English URL https://www.youtube.com/watch?v=aP5wXmnWxGE&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=85 Running Time 10:03 -
LibreOffice Base (85) Multiple MySQL Users
Type Video Recording Director The Frugal Computer Guy Abstract We add Multiple users to MySQL and give different authority to each user. Date 2015 Language English URL https://www.youtube.com/watch?v=32edV5lHGb8&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=86 Running Time 7:33 -
LibreOffice Base (86) MySQL Workbench (1)
Type Video Recording Director The Frugal Computer Guy Abstract We take a first look at MySQL Workbench a tool that can help us manage our LibreOffice Base MySQL databases. Date 2015 Language English URL https://www.youtube.com/watch?v=e7dV0-VlDnU&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=87 Running Time 7:59 -
LibreOffice Base (87) MySQL Workbench (2)
Type Video Recording Director The Frugal Computer Guy Abstract We learn how to reverse engineer a MySQL Database using MySQL Workbench. Date 2015 Language English URL https://www.youtube.com/watch?v=cQrfdmbs4OU&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=88 Running Time 9:14 -
LibreOffice Base (88) MySQL SearchForm (1)
Type Video Recording Director The Frugal Computer Guy Abstract We create a new MySQL database called mysql_searchform and all the tables for it. Date 2015 Language English URL https://www.youtube.com/watch?v=YVDi_aPaE6A&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=89 Running Time 10:33 -
LibreOffice Base (89) Create CSV files
Type Video Recording Director The Frugal Computer Guy Abstract We create .CSV backup files from the odb57 LibreOffce Base tables to upload into the new MySQL tables. Date 2015 Language English URL https://www.youtube.com/watch?v=NEdSfz6bslU&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=90 Running Time 6:57 -
LibreOffice Base (90) Upload CSV files
Type Video Recording Director The Frugal Computer Guy Abstract We update MySQL tables from the .csv files we created in the last video. Date 2015 Language English URL https://www.youtube.com/watch?v=ymMaMJ_UXEg&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=91 Running Time 8:43 -
LibreOffice Base (91) MySQL Relationships
Type Video Recording Director The Frugal Computer Guy Abstract We create some relationsips for the MySQL tables using MySQL Workbench. Date 2015 Language English URL https://www.youtube.com/watch?v=KW8hun6OQlM&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=92 Running Time 10:38 -
LibreOffice Base (92) MySQL Pictures
Type Video Recording Director The Frugal Computer Guy Abstract We add pictures into the MySQL employee table. Date 2015 Language English URL https://www.youtube.com/watch?v=tZ5ovJRpDlA&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=93 Running Time 8:09 -
LibreOffice Base (93) MySQL SearchForm (2)
Type Video Recording Director The Frugal Computer Guy Abstract We start to create the LibreOffice Base form to search the for employees on the MySQL database. Date 2015 Language English URL https://www.youtube.com/watch?v=hI19jDFhn_c&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=94 Running Time 10:30 -
LibreOffice Base (94) MySQL Searchform (3)
Type Video Recording Director The Frugal Computer Guy Abstract We complete the LibreOffice Base form, that searches for employees on a MySQL database, that we started in the previous video. Date 2015 Language English URL https://www.youtube.com/watch?v=I8OY5OWUKZE&list=PLy7Kah3WzqrEerJ0VPNWVaR4CYHMr4wmV&index=95 Running Time 10:42