Question: Create a table, which includes the following fields ( Select the proper data type for each field ) a . EmployeeID b . FirstName c
Create a table, which includes the following fields Select the proper data type for each field
a EmployeeID
b FirstName
c LastName
d Address
e City
f Province
g PostalCode
h HomePhone
i SIN
j DateHired
k Salary
EmailAddress
Assign EmployeeID as the primary key
Save your table as tblEmployees.
Limit the Field sizes as follows
a FirstName
b LastName
c City
d Province
e PostalCode
Enter at least eight records, make sure to include a couple of records for employees with
salaries under and above $
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
