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 - Manipuri
Outline: Outline: Introduction What is LibreOffice Base? What can you do with Base? Prerequisites for using Base Relational Database basics Create a new database Create a table S..
Outline: Outline: Tables and Relationships Adding data to a table. Define and create relationships.
Outline: Create a simple form What is a form? Steps to create form Navigating from one record to other record Create a form using the Wizard.
Outline: Outline: Modify a simple form How to Traverse the records Adding a new record in a form How to Modify a form Ungroup the labels and text boxes Adding a tool tip to the Titl..
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 a List Box form control to a form How to remove text box Form Controls toolbar List Box Wizard Connecting the related tables and fields.
Outline: Adding a List Box Add a Push Button to a form How to label Push button Defining specific actions to the Push buttons Examples - Save, Undo, Delete, New Record
Outline: Outline: Enter and update data in a form Decreasing the height and length of form window Changing the font of the heading of form. Activation order Tab Order of the form con..
Outline: What is Query Create simple queries using the Query wizard Select fields Set the sorting order of the fields Provide search criteria or conditions for a query Setting aliase..
Outline: 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 Pro..
Outline: 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 Sorti..
Outline: 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 u..
Outline: Outline: Create view Create a table by copying an existing table. Using copy method How to do the sorting Rename the table
Outline: Outline: Create Subforms How to Create a Subform Change the size of font and style Change the background colour
Outline: 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 ..
Outline: Outline: Create simple queries in SQL View II Write Queries in SQL View Use ORDER BY clause Use JOINS Use Aggregate functions Use the ..
Outline: Outline: Access a data source Register *.odb databases. View data sources. Use data sources in Writer Interst the table
Outline: Outline: Modify data structures. Database Maintenance De-fragment database. CHECKPOINT DEFRAG SHUTDOWN COMPACT. Backups How to take Backups
Outline: 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 al..
Outline: Outline: What is Database Design Process of database design Dividing the information into tables. Determining the purpose of our database Finding and organizing the informati..