Difference between revisions of "LibreOffice Suite Base"

From Script | Spoken-Tutorial
Jump to: navigation, search
m (Nancyvarkey moved page /Base to LibreOffice Suite Base without leaving a redirect)
 
(4 intermediate revisions by the same user not shown)
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 Modify a form
 
# Build a complex form with form controls       
 
# Build a complex form with form controls       
 
#* Ungroup form elements.
 
#* Ungroup form elements.
Line 30: Line 33:
 
#* Change fonts and sizes.
 
#* Change fonts and sizes.
 
#* 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     
−
# Add Push Button to a form       
+
#*How to modify a form using LibreOffice Base.
−
# Enter and update data in a form       
+
# Add Push Button to a form     
−
# Create queries using Query Wizard       
+
#*How to Add a Push Button to a form
 +
# Enter and update data in a form     
 +
#*How to enter data and update data using a form.
 +
# 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. 
 
# Create queries using Design View       
 
# 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.
 
# Create reports       
 
# Create reports       
−
# Modify a Report       
+
#*Create a Report
 +
#*Select, Label and Sort the report fields
 +
#*Select report layout
 +
#*choose report type: static or dynamic
 +
# Modify a Report     
 +
#*Modify a report by customizing the layout
 +
#*Look and feel of the report.
 
=== Intermediate Level ===
 
=== Intermediate Level ===
  
Line 42: Line 62:
 
#* Create view.
 
#* Create view.
 
#* 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 
 
# Create simple queries in SQL View       
 
# 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
 
# Create simple queries in SQL View II       
 
# 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 ===
 
=== Advanced Level ===
Line 57: Line 88:
 
#* Backups.
 
#* Backups.
 
# Indexes, Table Filter, SQL Command window       
 
# Indexes, Table Filter, SQL Command window       
 +
#*Indexes
 +
#*Table Filter
 +
#*And the SQL Command window
 
# Database Design, Purpose, OrganizeTables       
 
# 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
 
# Database Design, Primary Key and Relationships       
 
# Database Design, Primary Key and Relationships       
−
# Database Design,Refine Database Design and Normalization Rules     
+
#*Turn information items into columns
 +
#*Specify primary keys
 +
#*Set up the table relationships
 +
#Design Refine Database Design and Normalization Rules     
 +
#*Refine the database design
 +
#*Apply the normalization rules
 +
#*Test the database design

Latest revision as of 12:05, 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. 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

Retrieved from "https://script.spoken-tutorial.org/index.php?title=LibreOffice_Suite_Base&oldid=21911"