Advanced Database – bound controls: text box

Create, modify, delete bound controls: text box We are going to use the form ‘Jobs Entry’ that we created in an earlier lesson. Right click on Jobs Entry form and select ‘Edit’ to open design view. Hold CTRL and right click on the box next to Staff Number, then select ‘Replace with’ and click ‘Text…

Read More

Advanced Database – Use wildcards in a query

We have already used the asterisk wildcard * in queries to display all fields. The other most common wildcard is ‘?’ which was covered in module 1 and replaces exactly one character. For instance if we run a query to find Car Reg No with the Criterion LIKE ‘RS?’ it will return any car reg…

Read More

Create, run a query to show duplicated records within a table.

There is no easy way to do this in LibreOffice Base. We have to use a roundabout solution. First create a duplicated record by adding a record to the Mechanics table, repeating the first name and grade under a different staff number. This could happen in real-life as an admin error. Close the table. Create…

Read More

Advanced Database – Create, run a crosstab query

A crosstab query involves creating a cross join between two tables, where every record of the left table is combined with every record in the right-hand table. Create a new query in design mode and add the tables Orders and Parts. Select to display all fields from both tables. Create a Cross join by dragging…

Read More