Database: How to apply a Validation Rule

Database: How to apply a Validation Rule

This video tutorial covers two tasks in the database course. 1. How to set the Price field property to 0 decimal place 2. How to set a validation rule on a specific field. (Note: For my night course group: In the…

Database: How do I...

Database: How do I…

1. Switch between Design view and Datasheet view To switch between views you can toggle between the Design view and Datasheet view icon on the Home ribbon. Clicking the Design view icon will switch you to the Design view of…

Queries in database

Using a * (wild card) in a query.

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

Summary Options in a Report

Displaying calculations in a report using Summary Options

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

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.

Creating a query in a database.

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