Archive for February 2018
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 MoreAdvanced Database – Create, modify, run a two variable parameter query.
To add a second variable, open up the same query as we used in the last example. In the third column, choose Staff Number field and type :Staff into the Criterion section. This will set up a second parameter for the staff number. Notice that Visible is unchecked for both the Car Reg No and…
Read MoreAdvanced Database – Create, modify, run a one variable parameter query.
A parameter is a value for a certain field, often used as a query selection, that can be changed each time the query is run. Start by creating a new query in design mode and adding the ‘Jobs’ table. Select to display all fields from Jobs using the * wildcard in the first query column.…
Read More