The Johnson Insurance Agency is a company with offices located across the country. You are the human resource

QUESTION

InstructionsThe Johnson Insurance Agency is a company with offices located across the country. You are the human resource director for the company. Your office is located in the home office in Miami. Each employee receives an annual performance review. The review determines employee eligibility for salary increases and the performance bonus. The employee data are stored in an Access database. This database is used by the Human Resource department to monitor and maintain employee records.Hint: 1) Create three tables. (Employee, Location and Title)I have provided ten records for each table. You are to create five additional records for each tables. Include your name as one of the records to your database. You will have a total of fifteen records for each tables.Employees TableEmployeeIDLastNameFirstNameGenderSalaryEvaluationStartDateShift001HillTomM$31,200Excellent3/3/2005F043WilliamsSusieF35,3200Excellent10/8/1099S767SuttonMaryF39,540Good5/21/2001F888RayJerryM36,767Poor3/22/2012S145MadisonWhitneyF50,198Excellent10/6/1998F203JacksonHarryM55,000Good11/2/9881F545RobertsGlenM46,980Excellent3/13/1980F322NortonBobbyM61,439Poor4/6/1979S654HendersonCarolynF71,000Excellent6/2/1977F989PineFrankM44,232Good9/3/1978SField Name Data TypeEmployee IDTextLastNameTextFirstNameTextGenderTextSalaryCurrencyEvaluationTextStartDateDate/TimeShiftTextLocation TableEmployeeIDLocationIDAddressCityStateZip CodeOfficePhone001001Atlanta450 Peachtree RoadLos AngelesCA30316404) 333-5555043002Miami3 Mills AvenueChesterfieldCA55555(222) 111-4444767003Chicago54 Lemon DriveLaurelMD20614(111) 230-3444888005California3 Mills AvenueMinneapolisMN92122(345) 222-5555145006Washington333 Plains FieldIrvingtonNJ44444(999) 234-2222203007NewYork76 Taylor RoadChesterVA75454(323) 432-5454545001Atlanta90 Knox CourtWilmingtonNC22222(111) 777-9999322002Miami10 Marlboro RoadWilsonNC88888(333) 545-9854654005California55 Brooks DriveChesterfieldCA43211(326) 065-1223989001Atlanta700 Mega LaneHartfordCO33434(976) 222-1111Field Name Data TypeEmployee IDTextLocation IDTextAddressTextCityTextStateTextZip CodeNumberOffice PhoneNumberTitlesTableEmployeeIDTitleMinimumSalaryMaximumSalary2014Increase001Account Rep$25,000$75,0003.00%043Human Resourced40,00090,0002.5%767Sales/Marketing30,00077.0001.5%888Marketing Director40,00080.0005%145Executive Administration30,00060,0002%203Claims50,0080,0004.0%545Agent40,00075,003.3%322Customer Service55,98978,9870%654Accounting60,00090,0003.0%989Education Training35,0067,9085.0%Field Name Data TypeEmployee IDTextTitleTextMinimum SalaryCurrencyMaximum SalaryCurrency2014 IncreaseNumberInstructions1) Sort the Employee Table alphabetically by the employee’s last name.2) Create a query is to identify the employees who have an Evaluation rating of Excellent for the year. Include the fields from following table in the Query. Name the query Excellent.First NameEmployee TableLast NameEmployee TableEvaluationEmployee TableAddressLocation TableCityLocation TableZipLocation TableCreate a query is to identify the employees whose salary is under $40,000 per year. The query should include Last Name, First Name and Salary. Name the query Salary.In the Employee Table under Field Properties add an appropriate field size for Shift since values used will be either F or S (for First or Second Shift). Format the field so that even if the user enters the letter in lowercase that it will be converted to uppercase.In the Employee Table under Field Properties add an appropriate field size for Gender since values used will be either M or F (Male or Female). Format the field so that even if the user enters the letter in lowercase that it will be converted to uppercase.Create a Form from the Employees table. Name the form Employees. Include all the fields from the table. Format the table properly so that all the fields on the page will show and it will show one record per page.Employee IDEmployee TableLast NameEmployee TableFirst NameEmployee TableGenderEmployee TableSalaryEmployee TableEvaluationEmployee TableStart DateEmployee TableShiftEmployee Table8) Create a report and add the following fields from the tables below: Name the Report 2014 Increase. Format the table properly and all the information shows in full and is on one page.First NameEmployee TableLast NameEmployee TableGenderEmployee TableStart DateEmployee TableTitleTitlesTable2014 IncreaseTitlesTable

ANSWER:

REQUEST HELP FROM A TUTOR