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    
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    
7. Add Push Button to a form    
8. Enter and update data in a form    
9. Create queries using Query Wizard    
10. Create queries using Design View    
11. Create reports    
12. Modify a 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