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: 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..
Outline: 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 - Marathi
Outline: Introduction (परिचय ) LibreOffice Base म्हणजे काय? आपण बेस सह काय करू शकता? बेस वापरण्यासाठी पूर्वतयारी. Relational डेटाबेसचे मूलतत्त्वे. एक नवीन डेटाबेस तयार करणे. एक टेबल त..
Outline: Tables and Relationships टेबल मध्ये डेटा जोडणे. रीलेशनशिप्स ( संबंध ) तयार करणे आणि परिभाषित करणे.
Outline: एक साधा फॉर्म तयार करणे. फॉर्म म्हणजे काय? फॉर्म तयार करण्यासाठी स्टेप्स एका रेकॉर्ड मधून अन्य रेकॉर्ड वर जाणे विज़ार्ड वापरुन फॉर्म तयार करणे.