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: 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
Outline: Enter and update data in a form
Outline: Create queries using Query Wizard
Outline: Create reports
Outline: Modify a Report