LibreOffice Suite Base

From Script | Spoken-Tutorial
Jump to: navigation, search

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
    • Create a table
  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
  4. 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
  5. Database Design, Primary Key and Relationships    
    • Turn information items into columns
    • Specify primary keys
    • Set up the table relationships
  6. Design Refine Database Design and Normalization Rules    
    • Refine the database design
    • Apply the normalization rules
    • Test the database design

Contributors and Content Editors

Minal, Nancyvarkey, Pratik kamble