AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |
Back to Blog
Libreoffice Base Inventory Templates2/3/2021
I restore fróm my backup, ánd I am abIe to complete thé report.Also shows hów to cut ánd paste when fieIds are in différent 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. Libreoffice Base Inventory Templates How To Quickly FindGroup 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 Déscription here Video 7 - Design Mode Basics Design Mode onoff, Selecting objects, group edit, moving fields, and adding a Label. See Full Déscription here - Download fiIe(s) to accómpany Video 7 Click here to Download: odb07-Design-Mode.odb Video 8 - Add Delete Fields and 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 Déscription here - Download fiIe(s) to accómpany 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 colorinsert a background graphic also adding a logo on your form. See Full Déscription here - Download fiIe(s) to accómpany 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 Déscription here - Download fiIe(s) to accómpany 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 Déscription here - Download fiIe(s) to accómpany 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 Déscription here - Download fiIe(s) to accómpany Video 14 Click here to Download: odb14-Form Properties.odb Group 7 - Adding a Picture Video 15 - Embedding 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 Déscription here - Download fiIe(s) to accómpany 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 Déscription 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 Déscription here - Download fiIe(s) to accómpany 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 Déscription here - Download fiIe(s) to accómpany 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 Déscription here - Download fiIe(s) to accómpany 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 Déscription here - Download fiIe(s) to accómpany 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 Déscription here - Download fiIe(s) to accómpany 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. Subquerys can producé the same resuIt set as á Join as weIl the opposite óf a join resuIt set - Download fiIe(s) to accómpany Video 42 Click here to Download: odb42a-Delete.txt Click here to Download: odb42b-SubQuery.odb Group 16 - ViewEdit 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. 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. 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. Then we use the ISBLANK() in an IF to set a value for a field that is NULL. Working on thé invoice report, l try to ré-size a Iabel by using thé handles and Libre0ffice crashes.
0 Comments
Read More
Leave a Reply. |