DBMS ACTIVITY

Hi, OM , it’s nice to be with you all…

Here’s your activity.

Create 2 tables, namely tableInfo and tablewage

Fields are:

TABLEINFO

Field name (data type)

Id (text)

Fname (text)

Lname (text)

Mname (text)

Position (text)

Picture (Ole Object)

Address (text)

TABLEWAGE

Field name (data type)

Id (text)

HoursWorked (number)

RateHour (number)

Basic (number)

Deduction (number)

Grosspay (number)

Out of the TableWage and TableInfo create your Query named QueryWage. The criteria for your query is : Grosspay is greater than 1000.

Lastly Create a form of your QueryWage. Save your work and e-mail a message to me and attached your database.

Good luck..