REP008 - Virtual Columns

A virtual column is a field which appears as part of a table but does not actually exist in the physical database table. Its value is dynamically derived based on the fields in the table. Virtual fields provide flexibility, since you can combine or extract data from fields in a table and extend the information already contained in the table.


To achieve these objectives, you will complete the following:

Step 1. Add Virtual Columns to Employee Table

Step 2. Calculation Virtual Column

Step 3. Concatenation Virtual Column

Step 4. Virtual Column for Note Length

Step 5. Virtual Column for Years Employed

Step 6. Create Test Form


Before you Begin

To complete this exercise, you must have completed the previous exercises.