LibreOffice Suite Base

Introduction

LibreOffice Base is the database front-end of the LibreOffice suite. Base is the equivalent of Microsoft Access. Base is free and open source software, free of cost and free to use and distribute. With Base,

• We can store organized data.
• Perform data entries and view data using forms.
• Retrieve information using queries.
• Design and generate reports.

Basic Level

1. Introduction    
   • What is LibreOffice Base?
   • What can you do with Base?
   • Prerequisites for using Base
   • Relational Database basics.
   • Create a new database
2. Tables and Relationships    
   • Adding data to a table.
   • Define and create relationships.
3. Create a simple form    
   • What is a form?
   • Create a form using the Wizard.
4. Modify a simple form    
   • learn how to Enter data in a form, Modify a form
5. Build a complex form with form controls    
   • Ungroup form elements.
   • Rename labels.
   • Change fonts and sizes.
   • Change location of the form elements.
6. Add List Box form control to a form    
   • learn how to modify a form using LibreOffice Base.
7. Add Push Button to a form    
   • learn how to Add a Push Button to a form
8. Enter and update data in a form    
   • learn how to enter data and update data using a form.
9. Create queries using Query Wizard    
   • Create simple queries using,the Query wizard Select fields
   • Set the sorting order of the fields,
   • And provide search criteria or conditions for a query.
   • what a query is.
10. Create queries using Design View    
    • Create a query by using the Design View.
    • Add tables to the Query Design window Select fields
    • Set up aliases,
    • Set up sorting order And provide search criteria for a query.
11. Create reports    
    • Create a Report
    • Select, Label and Sort the report fields
    • Select report layout
    • choose report type: static or dynamic
12. Modify a Report    
    • Modify a report by customizing the layout
    • look and feel of the report.

Intermediate Level

1. Create tables    
   • Create view.
   • Create a table by copying an existing table.
2. Create Subforms    
3. Create simple queries in SQL View    
4. Create simple queries in SQL View II    

Advanced Level

1. Access data sources    
   • Access a data source
   • Register *.odb databases.
   • View data sources.
   • Use data sources in Writer
2. Database Maintenance    
   • Modify data structures.
   • De-fragment database.
   • Backups.
3. Indexes, Table Filter, SQL Command window    
4. Database Design, Purpose, OrganizeTables    
5. Database Design, Primary Key and Relationships    
6. Database Design,Refine Database Design and Normalization Rules    

Contributors and Content Editors

Minal, Nancyvarkey, Pratik kamble