Introduction

Foss: LibreOffice Suite Base - English

Outline: 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

Basic

Tables and Relationships

Foss: LibreOffice Suite Base - English

Outline: Tables and Relationships Adding data to a table. Define and create relationships.

Basic

Create a simple form

Foss: LibreOffice Suite Base - English

Outline: Create a simple form What is a form? Create a form using the Wizard.

Basic

Modify a simple form

Foss: LibreOffice Suite Base - English

Outline: Modify a simple form How to enter data in a form How to Modify a form

Basic

Build a complex form with form controls

Foss: LibreOffice Suite Base - English

Outline: Build a complex form with form controls Ungroup form elements. Rename labels. Change fonts and sizes. Change location of the form elements.

Basic

Add List Box form control to a form

Foss: LibreOffice Suite Base - English

Outline: Add List Box form control to a form How to modify a form using LibreOffice Base.

Basic

Add Push Button to a form

Foss: LibreOffice Suite Base - English

Outline: Add Push Button to a form How to Add a Push Button to a form

Basic

Enter and update data in a form

Foss: LibreOffice Suite Base - English

Outline: Enter and update data in a form How to enter data and update data using a form.

Basic

Create queries using Query Wizard

Foss: LibreOffice Suite Base - English

Outline: 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. ..

Basic

Create queries using Design View

Foss: LibreOffice Suite Base - English

Outline: 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 ..

Basic

Create reports

Foss: LibreOffice Suite Base - English

Outline: Create reports Create a Report Select, Label and Sort the report fields Select report layout choose report type: static or dynamic

Basic

Modify a Report

Foss: LibreOffice Suite Base - English

Outline: Modify a Report Modify a report by customizing the layout Look and feel of the report.

Basic

Create tables

Foss: LibreOffice Suite Base - English

Outline: Create tables Create view. Create a table by copying an existing table.

Intermediate

Create Subforms

Foss: LibreOffice Suite Base - English

Outline: Create Subforms How to Create a Subform

Intermediate

Create simple queries in SQL View

Foss: LibreOffice Suite Base - English

Outline: 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..

Intermediate

Create simple queries in SQL View II

Foss: LibreOffice Suite Base - English

Outline: 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 b..

Intermediate

Access data sources

Foss: LibreOffice Suite Base - English

Outline: Access data sources Access a data source Register *.odb databases. View data sources. Use data sources in Writer

Advanced

Database Maintenance

Foss: LibreOffice Suite Base - English

Outline: Database Maintenance Modify data structures. De-fragment database. Backups.

Advanced

Indexes Table Filter SQL Command window

Foss: LibreOffice Suite Base - English

Outline: Indexes, Table Filter, SQL Command window

Advanced

Database Design Purpose OrganizeTables

Foss: LibreOffice Suite Base - English

Outline: Database Design, Purpose, OrganizeTables Determining the purpose of our database Finding and organizing the information required Dividing the information into tables. What is Datab..

Advanced

Database Design Primary Key and Relationships

Foss: LibreOffice Suite Base - English

Outline: Database Design, Primary Key and Relationships Turn information items into columns Specify primary keys Set up the table relationships

Advanced

Design Refine Database Design and Normalization Rules

Foss: LibreOffice Suite Base - English

Outline: Database Design,Refine Database Design and Normalization Rules Refine the database design Apply the normalization rules Test the database design

Advanced