↓
 

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

Monthly Archives: November 2017

Advanced Database – Apply automatic update or deletion of related fields.

The Place For Free Online Training Courses

Open the Relation Design window again, this time change both Update options to ‘Update cascade’ for both lines. Update cascade – automatically updates any related foreign keys to match the primary key. Also set the Delete options to ‘Delete cascade’. … Take lesson

Advanced Database – Apply referential integrity between tables

The Place For Free Online Training Courses

Referential integrity means controlling how records are altered or deleted in a relational database (i.e. one with links/relationships between fields in different tables). To define the rules of how records are altered across relationships, you must right click on the … Take lesson

Advanced Database – Create, modify a many-to-many relationship using a junction table.

The Place For Free Online Training Courses

For this example, create 3 new tables with the designs shown. Note the Order Details table has 2 fields combined to create the primary key. To do this, hold down Ctrl key, click in the grey area to the left … Take lesson

Advanced Database – Create, modify, delete a one-to-many relationship

The Place For Free Online Training Courses

A one-to-many relationship links the primary key to a field in a second table that may have more than one records (row). Click Tools – Relationships from the main window ribbon. The Relation Design window opens. Click ‘Insert’ – Add … Take lesson

Advanced Database – Create, modify, delete a one-to-one relationship between tables

The Place For Free Online Training Courses

For this section we need to create a new table. Create a new table in design mode, with the two fields shown for the cost of repair jobs. For the Cost field, select Decimal data type, set decimal places to … Take lesson

Advanced Database – Set data entry for a field/column: required, not required

The Place For Free Online Training Courses

Open the ‘Jobs’ table in design mode. If we want to ensure that data is always entered for a certain field, click on the relevant field. In the Field Properties box at the bottom of the screen, select ‘Yes’ from … Take lesson

Advanced Database – Create, modify, delete an input mask in a field

The Place For Free Online Training Courses

In Base you can only create input masks in a form (not a table as in MS Access). We are going to edit the date field to only allow dates to be inputted in the format DD** MMM YY (e.g. … Take lesson

Advanced Database – Create, modify or delete a lookup in a field

The Place For Free Online Training Courses

Libreoffice Base doesn’t allow you to create a ‘lookup’ list in a table in the way it does in MS Access. We will have to use a form to do the same thing. Right click on the Jobs Entry form … Take lesson

Advanced Database – Form

The Place For Free Online Training Courses

Create a form for inputting jobs. Go to forms in the main window, then click on ‘Use wizard to create form’. Select all of the fields from the ‘Jobs’ table, select the arrangement you prefer. Name the form ‘Jobs Entry’ … Take lesson

Advanced Database – Tables

The Place For Free Online Training Courses

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


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
↑