Practical+Tasks+-+Reports+Forms+and+Calculated+Fields

Forrester Mobiles sells the latest mobile phones and contracts. They have a team of 10 people in their store in Edinburgh and three departments ( Sales, Technical and customer service). Forrester Mobile has come to you with the task of creating the database that will store their employees details.

Complete the data dictionary below and create your database with data of your choice. Your database must have at least 10 entries.
 * Task 1**



The admin team at the company have various levels of user experience. To make it easier, the management team has asked you to create an accessible user interface as well as reflecting the companies brand using a form. Their design for this form is shown below (Annotations are in red):
 * Task 2**

**Task 3** The owner of Forrester Mobile would like a report each week showing how much pay each person has received. Create a query with a calculated field and produce your findings in a report. The owners have only requested the fields: First Name, Surname and Gross Pay.