Office Software | The Place For Free Online Training Courses

Working with Databases

Open a database application To start LibreOffice Base, search from the ‘Start’ menu or find the LibreOffice folder and click the LibreOffice Base icon. Open an existing database To open an existing database, choose the option ‘open an existing database file’ from the wizard, which is the first screen you see. Choose a file from…

Understanding Databases

Key Concepts A database is a collection of data stored in tables to be easily accessed, managed, and updated. Examples might be a shop’s stock inventory or airline booking system. Tables are split up into records (rows) and fields (columns) A database offers more complex ways of using data than spreadsheets and data can be…

Math Quiz

This quiz is designed to test your knowledge of the contents of the LibreOffice Math Application, part of the Office Software Suite series. There are twenty questions. The pass mark is 70 out of a potential 100 points, 5 for each question. Once you are satisfied with your answers, complete your name and email address…

Math – Import and Export

Export as PDF In Math, we can export a formula as a PDF document. To export as a PDF, click on ‘File’ from the main menu bar. From the resulting drop-down, click on ‘Export’. This opens the ‘Export’ dialog box. In this dialog box, we can browse to the folder where we want to save…

Math – Customization

Formula editor as a floating window. The formula editor can cover a large part of the Writer window. In Writer, it is possible to turn the formula editor into a floating window. To convert the formula editor into a floating window hover the mouse over the editor frame. Now hold down the ‘Control’ key from…

Using Math With Calc, Impress and Draw

Graphical properties. Formula objects have similar properties in Calc, Impress, and Draw. They are always inserted with a transparent background and without borders. In Draw and Impress, they are assigned the Default graphical style; there is no assigned style for them in Calc and properties need to be specified explicitly. A formula can be positioned…

Using Math With Writer Documents

Numbering equations in Writer We can write numbered equations in Writer. Equation numbering is one of the Writer’s best hidden features. The steps are very simple. Start a new line in Writer. Type ‘fn’ and then press ‘F3’ from the keyboard. The ‘fn’ gets replaced by the numbered formula: E = mc2 (2) Now we…

Math – Changing The Appearance

Adjusting spacing. To increase or decrease the spacing between the different elements of a formula, click on ‘Format’ from the main menu bar and from the resulting menu, click on ‘Spacing’. This will open the ‘Spacing’ dialog box. In this dialog box, under ‘Spacing’, the spacing between different elements of an equation can be selected.…

Math – Appearance of Formulas

Changing the font size. In LibreOffice Math, we can change the font size of the formulas. To change the font size of the formulas, click on ‘Format’ from the main menu bar and from the resulting menu, click on ‘Font Size’. This will open the ‘Font Sizes’ dialog box. In this dialog box, select the…

Math – More Formula Layouts

Adding limits to a sum or an integral. In Math, the ‘sum’ and ‘int’ commands are used for sum and limits respectively. These commands can take the parameters ‘from’ and ‘to’. These are used for lower and upper limits respectively. These parameters can be used singly or together. The usage of these commands and parameters…