Office Software
Advanced Database – Tables
For this module we are going to create a database for a car repairs garage. We are going to set up some tables and a form in this section to demonstrate the principles. First, create a new database in LibreOffice Base called ‘Car Garage’. Then select tables and click create table in design view. Add…
Read MoreAdvanced Database – Structured Query Language (SQL)
Structured Query Language (SQL) is used to manage data within a database. It uses relational algebra to create commands that retrieve or maintain the data. Some examples of commands are CREATE – to create tables, RENAME – to rename tables, SELECT – to select data records, INSERT – to insert data records and DELETE –…
Read MoreAdvanced Database – The ‘life cycle’ of a database
Logical Design – must be carefully designed to incorporate all the data and applications needed, including possible future changes and developments. Define the output(s) required, then work backwards to include all the elements needed. Database Creation – set up tables, relationships, forms for inputting data, queries and reports. This needs someone with good technical understanding…
Read MoreAdvanced Database – Database Development and Use
Databases are systems used for the storage, maintenance and retrieval of data. In the modern ‘internet age’, databases are used widely to power ‘dynamic websites’, meaning prices, product details, mailing lists and other large groups of data can be easily updated and searched. Website content management and customer relationship managements (CRM) systems use databases to…
Read MoreUnderstanding Databases Quiz
Understanding Databases – Printing
Change the orientation and paper size Orientation is the format in which the page displays, either in portrait mode where the page is displayed with the long edge vertical, or landscape, where the longer edge is horizontal. To change the orientation, select either Portrait or Landscape. To change the orientation, select either Portrait or Landscape.…
Read MoreUnderstanding Databases – Export to Spreadsheet or Text
Export a table, query output in spreadsheet or text Open a table or query by double clicking from the main window. Select File -> New -> Spreadsheet to open a new Libreoffice Calc spreadsheet. Minimize the spreadsheet for now. To export all records, left click the grey box in the top left corner of the…
Read MoreUnderstanding Databases – Report Headers and Footers
Add, modify text in headers, footers in a report. Open a report in design view, by right clicking the report in the main window and selecting edit. To add text to a header or footer, first click ‘Label Field’ from the toolbar. Click and drag where you want to place the text. With the label…
Read MoreUnderstanding Databases – Present Fields by Average and Count
In LibreOffice Base, the simplest way to present specific fields using average or count functions is to create a query first. Average will return the mean average of the field, therefore it requires numerical data. Mean average is calculated by finding the sum total of all the records, divided by the count (the number of…
Read MoreUnderstanding Databases – Present Fields By Minimum or Maximum
Present specific fields by maximum or minimum You can present fields in a report using maximum or minimum functions, again without the need for a query. The function is applied directly to the field to either display the minimum or maximum value from the records. Therefore, it can only be used on numerical values. An…
Read More