Difference between revisions of "LibreOffice Suite Base"

Revision as of 17:30, 10 November 2014

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