Finance and Accounting Access/Excel

profileefstudent19
TigerPawHoldingsLLC-Farley_Elizabeth1.accdb
Home>Business & Finance homework help>Management homework help>Finance and Accounting Access/Excel
Applicant Number Applicant First Name Applicant Last Name Applicant Middle Initial Applicant Home Address Applicant Apartment Number Applicant Home City Applicant Home State Applicant Home Zip Code Applicant Phone Number May we contact your current employer: Highest Degree Awarded Resume Applicant Email Address Code for Job Posting
3 John Doe A 123 Some Street D123 New York NY 10016 2.128941212E9 true Technical Degree I am just a happy go lucky, never employed person trying to fake you all out. Www.fitnyc.edu [email protected]#mailto:[email protected]# 380.0
4 Jane Doe 234 Anywhere Avenue New York NY 10034 2.123454545E9 false High School [email protected]#mailto:[email protected]# 345.0
5 Emilia Smith A 1718 Market Street 501 Philadelphia PA 19103 2.154665782E9 true Bachelor Degree Graduated from The University of Pennsylvania with a Bachelor's Degree in Business Administration. [email protected]#mailto:[email protected]# 385.0
Employee Number Employee First Name Employee Last Name Employee Middle Initial Employee Home Address Employee Apartment Number Employee Home City Employee Home State Employee Home Zip Code Employee Phone Number May we contact your current employer: Highest Degree Awarded Resume Employee Email Address Code for Job Posting Date Hired Date of Birth Current Salary Picture of Employee Married with Dependents Married without Dependents
1 John Doe A 123 Some Street D123 New York NY 10016 2.128941212E9 true Technical Degree I am just a happy go lucky, never employed person trying to fake you all out. Www.fitnyc.edu [email protected]#mailto:[email protected]# 380.0 4/1/18 10/4/92 ¤ 57,000.00 false true
2 Jane Doe C 234 Anywhere Avenue New York NY 10034 2.123454545E9 false High School [email protected]#mailto:[email protected]# 345.0 1/10/18 8/13/85 ¤ 65,000.00 true false
3 Emilia Smith A 2100 Main Street 7B Philadelphia PA 19103 2.15677578E9 true Bachelor Degree Graduated from The University of Pennsylvania with a Bachelor's Degree in Business Administration. [email protected]#mailto:[email protected]# 385.0 5/2/18 7/20/70 ¤ 75,000.00 true false
4 Sarah Kennedy J 1718 Market Street 501 Philadelphia PA 19103 2.154665782E9 true Bachelor Degree Graduated from The University of Pennsylvania with a Bachelor's Degree in Business Administration. [email protected]#mailto:[email protected]# 385.0 5/16/18 10/19/95 ¤ 45,000.00 false false
SELECT Applicant.[Applicant Number], Applicant.[Applicant First Name], Applicant.[Applicant Last Name], Applicant.[Applicant Middle Initial], Applicant.[Applicant Home Address], Applicant.[Applicant Apartment Number], Applicant.[Applicant Home City], Applicant.[Applicant Home State], Applicant.[Applicant Home Zip Code], Applicant.[Applicant Phone Number], Applicant.[May we contact your current employer:], Applicant.[Highest Degree Awarded], Applicant.Resume, Applicant.[Applicant Email Address], Applicant.[Code for Job Posting] FROM Applicant;
SELECT DISTINCTROW * FROM Applicant;
SELECT DISTINCTROW * FROM Employees;
SELECT Applicant.[Applicant Phone Number], Applicant.[Highest Degree Awarded], Applicant.[Applicant First Name], Applicant.[Applicant Last Name], Applicant.[Code for Job Posting] FROM Applicant WHERE (((Applicant.[Applicant Phone Number]) Like "212*") AND ((Applicant.[Highest Degree Awarded]) Like "High School*"));
SELECT Employees.[Code for Job Posting], Employees.[Employee First Name], Employees.[Employee Last Name], Employees.[Current Salary] FROM Employees ORDER BY Employees.[Code for Job Posting] DESC;
SELECT Applicant.[Code for Job Posting], Applicant.[Applicant Last Name], Applicant.[Applicant First Name] FROM Applicant ORDER BY Applicant.[Code for Job Posting] DESC, Applicant.[Applicant Last Name];
SELECT Applicant.[Applicant Phone Number], Applicant.[Highest Degree Awarded], Applicant.[Applicant First Name], Applicant.[Applicant Last Name], Applicant.[Code for Job Posting] FROM Applicant WHERE (((Applicant.[Applicant Phone Number]) Like "212*")) OR (((Applicant.[Highest Degree Awarded]) Like "High School*"));