Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Hello, Please I need help your help with Microsoft Access. Thank you Instructions To complete this activity: add 2 records to the Employee table, add
Hello,
Please I need help your help with Microsoft Access.
Thank you
Instructions To complete this activity: add 2 records to the Employee table, add a query that lists First Name, a Last Name and Salary of all Salaried employees (Salary > 0), add a report that lists First Name, Last Name and Hire Date of all, and sort employees by descending Hire Date (the most recent first). - Hours All Tables Employees Employees : Table State WA 0 WA Employees X Employeeld - LastName - FirstName Davolio Nancy 2 Fuller Andrew 3 Leverling Janet 4 Peacock Margaret 5 Buchanan Steve 6 Syama Michael (New) 40 BirthDate 12/08/1968 02/19/1968 08/30/1963 09/19/1958 04/04/1955 07/02/1978 Zip 98122 98401 98033 HireDate Address - City 05/01/2002 507 - 20th Ave. Seattle 08/14/2006 908 W. Capital Tacoma 04/01/1992 722 Moss Bay B Kirkland 05/03/1993 4110 Old Redm Redmond 10/17/2006 14 Garrett Hill Portland 10/08/2008 Coventry Hous Portlamd WA , HomePhone , Extension - (206) 555-9857 5467 (206) 555-9482 3457 (206) 555-3412 3355 (206) 555-8122 5175 (503)-987-6789 7890 (503) 675-9876 7654 Salary $56,000.00 $0.00 $60,000.00 $0.00 $50,000.00 $0.00 0 rate $0.00 $15.00 $0.00 $9.75 $0.00 $12.00 WA 98052 30 OR 97211 0 OR 97206 12.3
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started