Difference between revisions of "LibreOffice Suite Base"

Revision as of 12:53, 24 April 2015

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    
   • how to enter data in a form
   • how to 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    
   • how to modify a form using LibreOffice Base.
7. Add Push Button to a form    
   • how to Add a Push Button to a form
8. Enter and update data in a form    
   • 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    
   • how to Create a Subform
3. Create simple queries in SQL View    
   • Create Simple Queries in SQL View,
   • Write simple SQL
   • Use SELECT, FROM , and WHERE clauses
   • choose upper, lower, or mixed cases for naming fields and tables
4. Create simple queries in SQL View II    
   • Write Queries in SQL View
   • Use ORDER BY clause
   • Use JOINS
   • Use Aggregate functions
   • Use the GROUP BY clause
   • Use built in Functions

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    
   • Indexes
   • Table Filter
   • And the SQL Command window

1. Database Design, Purpose, OrganizeTables    
   • Determining the purpose of our database
   • Finding and organizing the information required
   • Dividing the information into tables.
   • What is Database Design
2. Database Design, Primary Key and Relationships    
   • Turn information items into columns
   • Specify primary keys
   • Set up the table relationships
3. Database Design,Refine Database Design and Normalization Rules    
   • Refine the database design
   • Apply the normalization rules
   • Test the database design