Difference between revisions of "LibreOffice Suite Base"

From Script | Spoken-Tutorial
Jump to: navigation, search
Line 18: Line 18:
 
#* Relational Database basics.
 
#* Relational Database basics.
 
#* Create a new database   
 
#* Create a new database   
 +
#*Create a table
 
# Tables and Relationships      
 
# Tables and Relationships      
 
#* Adding data to a table.
 
#* Adding data to a table.
Line 25: Line 26:
 
#* Create a form using the Wizard.
 
#* Create a form using the Wizard.
 
# Modify a simple form       
 
# Modify a simple form       
#* how to enter data in a form
+
#* How to enter data in a form
#*how to Modify a form  
+
#*How to Modify a form  
 
# Build a complex form with form controls       
 
# Build a complex form with form controls       
 
#* Ungroup form elements.
 
#* Ungroup form elements.
Line 33: Line 34:
 
#* Change location of the form elements.
 
#* Change location of the form elements.
 
# Add List Box form control to a form     
 
# Add List Box form control to a form     
#*how to modify a form using LibreOffice Base.
+
#*How to modify a form using LibreOffice Base.
 
# Add Push Button to a form     
 
# Add Push Button to a form     
#*how to Add a Push Button to a form
+
#*How to Add a Push Button to a form
 
# Enter and update data in a form     
 
# Enter and update data in a form     
#*how to enter data and update data using a form.  
+
#*How to enter data and update data using a form.  
 
# Create queries using Query Wizard     
 
# Create queries using Query Wizard     
 
#*Create simple queries using,the Query wizard Select fields
 
#*Create simple queries using,the Query wizard Select fields
 
#*Set the sorting order of the fields,
 
#*Set the sorting order of the fields,
 
#*And provide search criteria or conditions for a query.  
 
#*And provide search criteria or conditions for a query.  
#* what a query is.   
+
#*What a query is.   
 
# Create queries using Design View       
 
# Create queries using Design View       
 
#*Create a query by using the Design View.
 
#*Create a query by using the Design View.
Line 55: Line 56:
 
# Modify a Report     
 
# Modify a Report     
 
#*Modify a report by customizing the layout
 
#*Modify a report by customizing the layout
#*look and feel of the report.  
+
#*Look and feel of the report.  
 
=== Intermediate Level ===
 
=== Intermediate Level ===
  
Line 62: Line 63:
 
#* Create a table by copying an existing table.
 
#* Create a table by copying an existing table.
 
# Create Subforms     
 
# Create Subforms     
#*how to Create a Subform   
+
#*How to Create a Subform   
 
# Create simple queries in SQL View       
 
# Create simple queries in SQL View       
 
#*Create Simple Queries in SQL View,  
 
#*Create Simple Queries in SQL View,  
 
#*Write simple SQL
 
#*Write simple SQL
 
#*Use SELECT, FROM , and WHERE clauses  
 
#*Use SELECT, FROM , and WHERE clauses  
#*choose upper, lower, or mixed cases for naming fields and tables
+
#*Choose upper, lower, or mixed cases for naming fields and tables
 
# Create simple queries in SQL View II       
 
# Create simple queries in SQL View II       
 
#*Write Queries in SQL View  
 
#*Write Queries in SQL View  

Revision as of 12:03, 11 May 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
    • 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. Database 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