Creating Calculated Fields -Exercise Result

Clients Table: Fields: Company FirstName LastName Address City
Projects Table: Fields: Project ID Company Project Description Start Date Due Date
Hours Table: Fields: HoursID ProjectID Date Hours worked

You entered:

Add Calculated Field in Table of Microsoft Access

This figure shows the Design view of your query.

Here is the breakdown of the tables and relationships in the Microsoft Access query design:
**Tables:**

**Clients Table**:

Fields:

`Company`

`FirstName`

`LastName`

`Address`

`City`

**Projects Table**:

Fields:

`Project ID`

`Company`

`Project Description`

`Start Date`

`Due Date`

**Hours Table**:

Fields:

`HoursID`

`ProjectID`

`Date`

`Hours worked`

**Relationships:**

**Clients** table is indirectly related to the **Hours** table through the **Projects** table.

**Projects** table has a foreign key relationship:

`ProjectID` (Primary Key in Projects) connects to `ProjectID` (Foreign Key in Hours).

**Clients** and **Projects** are related via the `Company` field.

**Query Details:**

**Query Name**: `Project Hours - Select Query`

**Fields in Query**:

`Hours worked` (from the Hours table).

Calculated field: `Billable: [Hours worked]*50` (calculated as hours worked multiplied by 50).

Calculation Exercise

Your expression should look like this:
Billable: [Hours worked] * 50
Since Hours Worked is a field name, in must be enclosed in square brackets.
The results of the query look like this: