+1 (208) 254-6996 [email protected]
  

I need help filling in this information on a Microsoft access spreadsheet. The steps are listed in a word file that is given.

MIS 140 Problem Set 2

Don't use plagiarized sources. Get Your Custom Essay on
Microsoft Access Intro Worksheet
Just from $13/Page
Order Essay

Microsoft Access: Employee database – Creating Database Tables, Queries and Reports

In Appendix_ Access power-point slide in D2L, there are four tables, such as Employee, Job,

Department, and Job Assignment. Make the same four tables with the same data using MS Access program. You need to include your personal data in the table, i.e., your last four digits of social security number and your last name as a sixth data in the Employee table. Your department is “Commercial” and your job is “Acct”. You are working “8” hours in a “Job Assignment” column.

Click “Queries” menu in Access and click “Create Queries in Design view”. Use all of four tables in the query and show the following four fields in the query; Department Name, Employee Name, Job Assignment Hours, and Job Name.

Make criteria, which is more than 4 (>4) in Job Assignment Hours column. And run this query and save it as a query table.

Click “Create” and “Report by Wizard”. Use all of four fields in a query table to make a Report with Department Name, Employee Name, Job Assignment Hours, and Job Name information, who has more than 4 hours of job assignment including your personal data (8 hours). Upload completed Access file or screen shot file of Report (with your last name as an employee name in the Report) to Submission menu in D2L.

Order your essay today and save 10% with the discount code ESSAYHELP