Question: Instruction Part 1 : 1 . Create a blank database with the file ( database ) named JMSTechWizard 2 . In this database, create a
Instruction Part:
Create a blank database with the file database named JMSTechWizard
In this database, create a table in which to store the clients information. Use the name Client for the table. The Client table has
fields: Client Number, Client Name, Street, City, State, Postal Code, Telephone Number, Billed, Paid, and Technician
Number. Client Number is the primary key and is text data type. The Billed and Paid fields are currency data type. The
Technician Number field is number data type. All the other fields are text data type.
Add the records in the Table to the Client table.
In the same database, create another table in which to store the technicians information. Use the name Technician for the table.
The Technician table has fields: Technician Number, Last Name, First Name, Street, City, State, Postal Code, Hourly Rate,
and YTD Earnings. Technician Number is the primary key and is number data type. The Hourly Rate and YTD Earnings are
currency data type. All the other fields are text data type.
Add the records in the Table to the Technician table.
Step by Step Solution
There are 3 Steps involved in it
1 Expert Approved Answer
Step: 1 Unlock
Question Has Been Solved by an Expert!
Get step-by-step solutions from verified subject matter experts
Step: 2 Unlock
Step: 3 Unlock
