↓
 

The Place For Free Online Training Courses

Improve Your Career Prospects

  • Home
  • Office Software
    • Understanding Spreadsheets
    • Advanced Spreadsheets
    • Understanding Word Processing
    • Advanced Word Processing
    • Understanding Presentations
    • Advanced Presentations
    • Understanding Databases
    • Advanced Database
    • Math
  • FaQ

Monthly Archives: April 2018

Advanced Database – Import from existing database into a database.

The Place For Free Online Training Courses

Open two separate database files. To import data, you can simply drag and drop between the windows. For example, to copy the Names table from the lower database in the example shown, left click and hold on ‘Names’ in the … Take lesson

Advanced Database – Link external data to a database: existing database

The Place For Free Online Training Courses

To link data from a different database source, open a new LibreOffice Base file. In step 1 of the wizard, choose ‘Connect to an existing database’ and select the format of the database e.g. Microsoft Access 2007. Click Next and … Take lesson

Advanced Database – Link external data to a database: text

The Place For Free Online Training Courses

For this tutorial, we are going to create a text file in LibreOffice Writer. Open LibreOffice Writer. Enter the text shown. The first line designates field names, separated by commas. Each new line represents a new record with fields in … Take lesson

Advanced Database – Link external data to a database: spreadsheet

The Place For Free Online Training Courses

For this tutorial, first we are going to create a LibreOffice Calc spreadsheet. Open a new Calc file. In sheet 1, enter the data shown to the left. Then right click on the tab for the sheet and select ‘Rename … Take lesson

Understanding Databases – Force page breaks for groups in a report

The Place For Free Online Training Courses

Select the Surname group section on the left hand side (in blue) In the properties section on the right hand side, where it says ‘Force New Page’ select ‘Before Section’. This will insert a page break before each new section. … Take lesson

Advanced Databases – Sort, group records in a report by field(s)

The Place For Free Online Training Courses

To change the sorting and grouping in a report, click the sorting and grouping icon. In the window that pops up, you can select the grouped fields and change their properties. You can choose to sort ascending or descending, as … Take lesson

Advanced Databases – Insert, delete a data field in group, page, report headers and footers.

The Place For Free Online Training Courses

Create a report in wizard mode, select the table Car and owner details and add the first 5 fields only. Click Next twice. Add grouping levels for Surname and First Name. Click Next twice. Choose ‘Columnar, two columns’ layout. Click … Take lesson

Advanced Databases – Concatenate fields in a report.

The Place For Free Online Training Courses

Concatenate fields means to merge them together. There is no option to do this automatically in Base, so we first have to create a query in design mode. Add the Car and owner details table. We want to merge First … Take lesson

Advanced Database – Apply a running sum for a group, over all.

The Place For Free Online Training Courses

In Libreoffice Base, there is no automatic option to do this in a report. We must first create a query that we will then use to run a report. Create a new query in design view. Add the table Job … Take lesson

Advanced Database – Format arithmetic calculation controls in a report

The Place For Free Online Training Courses

We are going to use the query that we created in a previous tutorial. The query is shown to the left, it calculates the total hours worked on each job for each member of staff. Then the query calculates and … Take lesson



  • Terms and Conditions
  • Privacy Policy
  • Site Map
©2021 - The Place For Free Online Training Courses Privacy Policy
↑