NEED A PERFECT PAPER? PLACE YOUR FIRST ORDER AND SAVE 15% USING COUPON:

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

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

Click here to Order a Custom answer to this Question from our writers. It’s fast and plagiarism-free.

Microsoft Access Intro Worksheet 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

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.

Place your order now for a similar assignment and have exceptional work written by one of our experts, guaranteeing you an A result.

Need an Essay Written?

This sample is available to anyone. If you want a unique paper order it from one of our professional writers.

Get help with your academic paper right away

Quality & Timely Delivery

Free Editing & Plagiarism Check

Security, Privacy & Confidentiality