The Tutorials in this series are created LibreOffice Suite 3.3. on windows. LibreOffice Base is the database front-end of the LibreOffice suite,Base is the equivalent of Microsoft Access. Read more
Foss : LibreOffice Suite Base - English
Outline: Create a query by using the Design View Add tables to the Query Design window Select fields Set up aliases, Set up sorting order Set up visibility of the fields Provide searc..
Outline: Create a Report Select, Label and Sort the report fields Select report layout choose report type: static or dynamic Find Selection Labelling fields Grouping Sorting options..
Outline: Modify a report by customizing the layout Look and feel of the report. Insert Report Header/Footer Use the Text Labels in different styles Use the font size How to use the bac..
Outline: Create view Create a table by copying an existing table. Using copy method How to do the sorting Rename the table
Outline: Create Subforms How to Create a Subform Change the size of font and style Change the background colour
Outline: About SQL Create Simple Queries in SQL View, HSQL Tips and Notes Write simple SQL Use SELECT, FROM , and WHERE clauses Choose upper, lower, or mixed cases for naming fie..
Outline: Create simple queries in SQL View II Write Queries in SQL View Use ORDER BY clause Use JOINS Use Aggregate functions Use the GROUP BY c..
Outline: Access a data source Register *.odb databases. View data sources. Use data sources in Writer Interst the table
Outline: Modify data structures. Database Maintenance De-fragment database. CHECKPOINT DEFRAG SHUTDOWN COMPACT. Backups How to take Backups
Outline: Indexes Table Filter SQL Command window How to open index window Firing query of mysql insert,update,delete Firing query of mysql create table,drop table and alter statem..
Outline: What is Database Design Process of database design Dividing the information into tables. Determining the purpose of our database Finding and organizing the information require..
Outline: Turn information items into columns What is primary keys ? How to setup Primary keys What is Foreign Keys Set up the table relationships - One-to-One Relationship - One-t..
Outline: Refine the database design Apply the normalization rules First Normal Form Second Normal Form Third Normal Form Test the database design
Foss : LibreOffice Suite Base - Gujarati
Outline: Introduction What is LibreOffice Base? What can you do with Base? Prerequisites for using Base Relational Database basics Create a new database
Outline: Tables and Relationships Adding data to a table. Define and create relationships.
Outline: Create a simple form What is a form? Create a form using the Wizard.
Outline: Modify a simple form
Outline: Build a complex form with form controls Ungroup form elements. Rename labels. Change fonts and sizes. Change location of the form elements.
Outline: Add List Box form control to a form
Outline: Add Push Button to a form