Office Software
Advanced Databases – Insert, delete a data field in group, page, report headers and footers.
Create a report in wizard mode, select the table Car and owner details and add the first 5 fields only. Click Next twice. Add grouping levels for Surname and First Name. Click Next twice. Choose ‘Columnar, two columns’ layout. Click Next. Name the report. Select Dynamic report Select ‘Modify report layout’ Click Finish. Notice the…
Read MoreAdvanced Databases – Concatenate fields in a report.
Concatenate fields means to merge them together. There is no option to do this automatically in Base, so we first have to create a query in design mode. Add the Car and owner details table. We want to merge First Name and Surname fields. In the Field column type: “First Name” || ‘ ‘ ||…
Read MoreAdvanced Database – Apply a running sum for a group, over all.
In Libreoffice Base, there is no automatic option to do this in a report. We must first create a query that we will then use to run a report. Create a new query in design view. Add the table Job Costs twice, the reason for this will be explained shortly. Creating a query that gives…
Read MoreAdvanced Database – Format arithmetic calculation controls in a report
We are going to use the query that we created in a previous tutorial. The query is shown to the left, it calculates the total hours worked on each job for each member of staff. Then the query calculates and displays the average number of hours worked for each staff member. We are going to…
Read MoreAdvanced Database – linked subform
Create, delete a linked subform. A subform allows you to display associated data from a different table within a form. Create a new form using the wizard. On the first step, add all of the fields from the table ‘Jobs’, then click next. On the second step, we can add a subform based on the…
Read MoreAdvanced Database – sequential tab order
Modify sequential tab order of controls on a form. You may need to change the tab order of a form, for instance if you add a new response box or want to give certain fields priority over others. Right click the Jobs Entry form and select edit. If we want to change the order of…
Read MoreAdvanced Database – bound controls: option group
Create, modify, delete bound controls: option group Open the car and owner detail form in design mode. We are going to create options for the title field to save time typing them out. The options are going to be Mr, Mrs and other. Start by making the text box next to ‘Title’ smaller by dragging…
Read MoreAdvanced Database – bound controls: check box
Create, modify, delete bound controls: check box For this example, we need to set up a new form. Start the wizard and create a form from ‘Car and owner details’ including all the fields. Then open this in design mode by right clicking and selecting ‘edit Notice that the ‘Account settled?’ field is a check…
Read MoreAdvanced Database – bound controls: list box
Create, modify, delete bound controls: list box A list box is similar to a combo box, but you cannot enter values manually. They are a good option if you want to tightly control which values can be entered for a certain field. Open the Jobs Entry form in design mode by right clicking and selecting…
Read MoreAdvanced Database – bound controls: combo box
Create, modify, delete bound controls: combo box Replace the Staff Number entry box with a Combo Box. A combo box allows you to select from a list or manually enter data. Right click and select ‘Control’ You have the options to change the empty string result or set input required, but with a combo box…
Read More