You have been asked to create a table for job applicants. You are to do this without the benefit of the Table Wizard. The database should be entitled, “Claude's Roofing.”
a. Click the tables button in the database window and click the option to create a
new Table in the Design view.
b. Required fields include:
ii. years in roofing business
iii. prior employers
iv. desired wage
v. phone number
vi. home address.
viii. prior employer phone number
ix. reason for leaving
c. Set appropriate sizes for all fields.
d. Enter in the following employees:
5 years in roofing business
We Do Roofs, Inc –Prior Employer
We Do Roofs, Inc- 657-833-9439
Reason for Leaving—Desired Higher Salary
Desired wage: $12/hour
Phone Number: 657-857-3033
Home Address: 431 Googligoogle Ln., College Park, MD
Name: Jean Marie Mugatu
Years in Roofing Business: 3
Prior Employer: Roofs R Us
Prior Employer Phone: 343-329-2829
Reason for Leaving— Fell off roof, Injured Pelvis
Desired wage: $10/hr
Phone Number: 657-384-9999
Home Address: 471 GobbleBobble Rd.
Name: Zeo Mutombo
Years in Roofing Business: 5
Prior Employer: Ruffed Up Roofing
Prior Employer Phone: 333-757-6969
Reason for Leaving: Inconvenient Work Hours
Desired wage: $13/hr
Phone Number: 545-990-3333
Home Address: 326 EI Ln. Nellyville, USA
Enter in fields in the design view. Set name, home address, prior employer, prior employer address, reason for leaving as text.
Set birth date, home phone number, years of experience, and desired wage as number.
Enter in applicant data
Back to Solutions Page