Base
Understanding 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 MoreUnderstanding Databases – Present Fields By Sum
Present specific fields in a grouped report by sum The ‘sum’ function will add together all the records in a specified field. Therefore, the sum function can only be applied to numerical fields. Reports allow you to present fields as a sum without having to create a query to include the function. An accounts database…
Read MoreUnderstanding Databases – Present Specific Fields
Present specific fields in a grouped report For this section, create a new table to display salary and another to display bonuses. This data will require a grouped report to display correctly as there are multiple entries for employee-ID. Next, we need to create a relationship, in the main window, click ‘Relationships’ from the ‘Tools’…
Read MoreUnderstanding Databases – Grouped Reports
Either create a new report through the wizard or edit an existing report in Report Design View. To group fields, click on the ‘Sorting and Grouping’ icon on the toolbar. Grouping fields will stop information from being duplicated, for instance if the same person has a home and mobile number stored in the database. Select…
Read MoreUnderstanding Databases – Create a Report
Create and name a report based on a table or query Begin by clicking ‘Reports’ in the Database area of the main window, then click ‘Use Wizard to Create Report’ from the Tasks area. In the Report Wizard window, select the desired table or query from the drop down menu. Select the fields that you…
Read More