LibreOffice Suite Base - Revision history

Pratik kamble at 06:35, 11 May 2015

2015-05-11T06:35:21Z

Pratik kamble at 06:33, 11 May 2015

2015-05-11T06:33:35Z

Pratik kamble at 08:57, 24 April 2015

2015-04-24T08:57:09Z

Pratik kamble at 07:23, 24 April 2015

2015-04-24T07:23:21Z

Pratik kamble at 07:00, 24 April 2015

2015-04-24T07:00:11Z

Nancyvarkey: Nancyvarkey moved page /Base to LibreOffice Suite Base without leaving a redirect

2014-11-10T12:00:22Z

Nancyvarkey moved page /Base to LibreOffice Suite Base without leaving a redirect

Minal: Created page with '=== 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…'

2012-12-10T11:30:28Z

Created page with '=== 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…'

New page

=== 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.

__TOC__

=== Basic Level ===
# Introduction    
#* What is LibreOffice Base?
#* What can you do with Base?
#* Prerequisites for using Base
#* Relational Database basics.
#* Create a new database
# Tables and Relationships    
#* Adding data to a table.
#* Define and create relationships.
# Create a simple form    
#* What is a form?
#* Create a form using the Wizard.
# Modify a simple form    
# Build a complex form with form controls    
#* Ungroup form elements.
#* Rename labels.
#* Change fonts and sizes.
#* Change location of the form elements.
# Add List Box form control to a form    
# Add Push Button to a form    
# Enter and update data in a form    
# Create queries using Query Wizard    
# Create queries using Design View    
# Create reports    
# Modify a Report    
=== Intermediate Level ===

# Create tables    
#* Create view.
#* Create a table by copying an existing table.
# Create Subforms    
# Create simple queries in SQL View    
# Create simple queries in SQL View II    

=== Advanced Level ===
# Access data sources    
#* Access a data source
#* Register *.odb databases.
#* View data sources.
#* Use data sources in Writer
# Database Maintenance    
#* Modify data structures.
#* De-fragment database.
#* Backups.
# Indexes, Table Filter, SQL Command window    
# Database Design, Purpose, OrganizeTables    
# Database Design, Primary Key and Relationships    
# Database Design,Refine Database Design and Normalization Rules    

@@ Line 100: / Line 100: @@
 #*Specify primary keys
 #*Set up the table relationships
-# Database Design,Refine Database Design and Normalization Rules  &nbsp; &nbsp;
+#Design Refine Database Design and Normalization Rules  &nbsp; &nbsp;
 #*Refine the database design
 #*Apply the normalization rules
 #*Test the database design

@@ Line 18: / Line 18: @@
 #* Relational Database basics.
 #* Create a new database
 # Tables and Relationships &nbsp; &nbsp;
 #* Adding data to a table.
@@ Line 25: / Line 26: @@
 #* Create a form using the Wizard.
 # Modify a simple form  &nbsp; &nbsp;
-#* 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  &nbsp; &nbsp;
 #* Ungroup form elements.
@@ Line 33: / Line 34: @@
 #* Change location of the form elements.
 # Add List Box form control to a form  &nbsp; &nbsp;
-#*how to modify a form using LibreOffice Base.
+#*How to modify a form using LibreOffice Base.
 # Add Push Button to a form  &nbsp; &nbsp;
-#*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  &nbsp; &nbsp;
-#*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  &nbsp; &nbsp;
 #*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.
+#*What a query is.
 # Create queries using Design View  &nbsp; &nbsp;
 #*Create a query by using the Design View.
@@ Line 55: / Line 56: @@
 # Modify a Report  &nbsp; &nbsp;
 #*Modify a report by customizing the layout
-#*look and feel of the report.
+#*Look and feel of the report.
 === Intermediate Level ===
@@ Line 62: / Line 63: @@
 #* Create a table by copying an existing table.
 # Create Subforms  &nbsp; &nbsp;
-#*how to Create a Subform
+#*How to Create a Subform
 # Create simple queries in SQL View  &nbsp; &nbsp;
 #*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
+#*Choose upper, lower, or mixed cases for naming fields and tables
 # Create simple queries in SQL View II  &nbsp; &nbsp;
 #*Write Queries in SQL View

@@ Line 90: / Line 90: @@
 #*Table Filter
 #*And the SQL Command window
 # Database Design, Purpose, OrganizeTables  &nbsp; &nbsp;
 #*Determining the purpose of our database

@@ Line 25: / Line 25: @@
 #* Create a form using the Wizard.
 # Modify a simple form  &nbsp; &nbsp;
-#*learn how to Enter data in a form, Modify a form
+#* how to enter data in a form
 # Build a complex form with form controls  &nbsp; &nbsp;
 #* Ungroup form elements.
@@ Line 32: / Line 33: @@
 #* Change location of the form elements.
 # Add List Box form control to a form  &nbsp; &nbsp;
-#* learn how to modify a form using LibreOffice Base.
+#*how to modify a form using LibreOffice Base.
 # Add Push Button to a form  &nbsp; &nbsp;
-#*learn 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  &nbsp; &nbsp;
-#*learn 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  &nbsp; &nbsp;
 #*Create simple queries using,the Query wizard Select fields
@@ Line 60: / Line 61: @@
 #* Create view.
 #* Create a table by copying an existing table.
 # Create Subforms  &nbsp; &nbsp;
 # Create simple queries in SQL View  &nbsp; &nbsp;
 # Create simple queries in SQL View II  &nbsp; &nbsp;
 === Advanced Level ===
@@ Line 75: / Line 87: @@
 #* Backups.
 # Indexes, Table Filter, SQL Command window  &nbsp; &nbsp;
 # Database Design, Purpose, OrganizeTables  &nbsp; &nbsp;
 # Database Design, Primary Key and Relationships  &nbsp; &nbsp;
 # Database Design,Refine Database Design and Normalization Rules  &nbsp; &nbsp;

@@ Line 25: / Line 25: @@
 #* Create a form using the Wizard.
 # Modify a simple form  &nbsp; &nbsp;
 # Build a complex form with form controls  &nbsp; &nbsp;
 #* Ungroup form elements.
@@ Line 30: / Line 31: @@
 #* Change fonts and sizes.
 #* Change location of the form elements.
 # Add List Box form control to a form  &nbsp; &nbsp;
-# Add Push Button to a form  &nbsp; &nbsp;
+#* learn how to modify a form using LibreOffice Base.
-# Enter and update data in a form  &nbsp; &nbsp;
+# Add Push Button to a form  &nbsp; &nbsp;
-# Create queries using Query Wizard  &nbsp; &nbsp;
+#*learn how to Add a Push Button to a form
 # Create queries using Design View  &nbsp; &nbsp;
 # Create reports  &nbsp; &nbsp;
-# Modify a Report  &nbsp; &nbsp;
+#*Create a Report
 === Intermediate Level ===

← Older revision	Revision as of 12:00, 10 November 2014
(No difference)