Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Accounting And Reporting

Authors: Mr Barry Elliott, Jamie Elliott

10th Edition

0273703641, 978-0273703648

More Books

Students also viewed these Accounting questions

Question

=+Explain the key responsibilities of each social media role

Answered: 1 week ago