Queries in database

The following video tutorial demonstrates how to use a * (wild card) in a query.

Summary Options in a Report

Create a report on the table or query using the wizard. In step 2 of the report wizard, group the report according to one of the fields e.g. ID Number or Category. In step 3 of the report wizard, click…

Setting a default value for a record

If you want the same text to appear in a particular field you can set a default value. For example, you may want the county name ‘Limerick’ to be set as a default value in each record in an employee…

Creating a query in a database.

The following video tutorial demonstrates how to create a query in a database file.