↓
 

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
  • Learn Computer Skills
    • Basic Computer Skills
    • Common Tasks
    • Intermediate Computer Skills
  • Website Building
    • Web Building Lessons
    • Using WordPress
  • Business Tutorials
    • Management
    • Career Tutor
  • FaQ
1 2 >>

Monthly Archives: September 2017

Post navigation

← Previous Post

Understanding Databases Quiz

The Place For Free Online Training Courses

… Take lesson

Understanding Databases – Printing

The Place For Free Online Training Courses

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 … Take lesson

Understanding Databases – Export to Spreadsheet or Text

The Place For Free Online Training Courses

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 … Take lesson

Understanding Databases – Report Headers and Footers

The Place For Free Online Training Courses

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 … Take lesson

Understanding Databases – Present Fields by Average and Count

The Place For Free Online Training Courses

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 … Take lesson

Understanding Databases – Present Fields By Minimum or Maximum

The Place For Free Online Training Courses

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 … Take lesson

Understanding Databases – Present Fields By Sum

The Place For Free Online Training Courses

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 … Take lesson

Understanding Databases – Present Specific Fields

The Place For Free Online Training Courses

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, … Take lesson

Understanding Databases – Grouped Reports

The Place For Free Online Training Courses

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 … Take lesson

Understanding Databases – Create a Report

The Place For Free Online Training Courses

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 … Take lesson

Post navigation

← Previous Post

Latest Lessons

  • Advanced Database Quiz
  • Advanced Database – Assign/attach a macro to a control
  • Advanced Database – Assign/attach a macro to a command button
  • Advanced Database – Create a simple macro
  • Advanced Database – Import from existing database into a database.

Available Courses

  • Customising Your PC (5)
  • IT Training (12)
  • Learn Computer Skills (25)
    • Basic Computer Skills (12)
    • Common Tasks (8)
    • Intermediate Computer Skills (5)
  • Microsoft Certified Professional (79)
    • Disaster Recovery (5)
    • Hardware (5)
    • Installations (1)
    • Interoperability (3)
    • Introduction To Networking (25)
      • Managing Disks (9)
      • Windows Quickstart (8)
      • Windows XP Server 2003 (8)
    • Local Security (6)
    • Local Users and Groups (4)
    • Monitoring and Optimisation (5)
    • NTFS (4)
    • Printing (3)
    • Remote Desktop and Terminal Services (6)
    • Shared Folders (5)
    • TCP/IP (7)
  • Microsoft Certified Systems Engineer (86)
    • Active Directory Overview (8)
    • Active Directory Sites And Replication (5)
    • Active Directory Trusts (2)
    • Active Directory Users and Groups (4)
    • Certificate Services (6)
    • Deploying Applications (3)
    • DFS (5)
    • DHCP (5)
    • DNS (8)
    • Group Policy (5)
    • IIS (5)
    • IPsec (3)
    • Remote Access (6)
    • RIS (7)
    • Routing (6)
    • SUS (3)
    • WINS (6)
  • Microsoft Certified Technology Specialist (129)
    • Windows Server 2008 Active Directory, Configuring (78)
      • Active Directory Federation Services (3)
      • Active Directory Rights Management (3)
      • Active Directory Sites And Replication (3)
      • Active Directory Trusts (2)
      • Administration (5)
      • Authentication (5)
      • Certificate Services (9)
      • Computers (4)
      • Directory Business Continuity (5)
      • Domain Controllers (4)
      • Group Policy (4)
      • Groups (6)
      • Installation (5)
      • Integrating Domain Name System (6)
      • Lightweight Directory Services (2)
      • Users (9)
    • Windows Server 2008 Network Infrastructure, Configuring (59)
      • Configuring IP Routing (4)
      • Configuring Name Resolution (8)
      • Configuring Windows Firewall and Network Access Protection (4)
      • Connect To A Network (6)
      • Creating a DHCP Infrastructure (5)
      • Managing Files (11)
      • Managing Printers (3)
      • Managing Software Updates (4)
      • Monitoring Computers (4)
      • Protecting Network traffic with IPSec (3)
      • TCP/IP (7)
  • Office Software (287)
    • LibreOffice (285)
      • Advanced Database (54)
      • Advanced Presentations (25)
      • Advanced Spreadsheets (47)
      • Advanced Word Processing (38)
      • Base (29)
      • Calc (20)
      • Math (16)
      • Presentations (33)
      • Writer (22)
        • Mail Merge (3)
  • Uncategorized (1)
  • Website Design (22)
    • Creating websites with HTML (9)
    • CSS (6)
    • Extras (3)
    • What is the internet (4)
  • Windows Maintenance (9)
  • Wordpress (12)
  • Terms and Conditions
  • Privacy Policy
  • Site Map
©2019 - The Place For Free Online Training Courses Privacy Policy
↑