Advanced 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 More

Advanced 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 More

Advanced 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 More

Advanced 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 More

Advanced 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 More

Advanced 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 More

Advanced 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