Access and Excel

User Generated

6ezon

Computer Science

Description

Hello i have an access and excel assignment. attached you will find the instructions needed to finish the task.

I will provide more very few more information to help you finish the assignment once assigned.

......................................................................................................

Unformatted Attachment Preview

Expense Spreadsheet (Excel) (20 points) Create a spreadsheet with the information for all your employees. You need at least 10 employees (enter any fictitious data). Your spreadsheet should include the following: TITLE • • • A title for your worksheet beginning in the A1 cell and it should be merged and centered on all the cells to make a consistent looking title. On your title you should have a thick box border Format the worksheet title with a background color (you can use any color) DATA Add the following fields to your worksheet for your employees: • Last Name • First Name • Title • Location of Store o (Address, City, State, and Zip Code) o You must have at least 2 separate locations and at least 2 separate states.) • Time In • Time Out • Total Hours Worked (make it vary for different people) • Pay Rate (make it vary for different people) • • Total PaySave as LastName-Expense Sheet Create a formula that will calculate the Total Pay from the hours worked and pay rate. • Submit to blackboard Database (ACCESS) (20 points) Create a blank database using following categories: 1. 2. 3. 4. 5. 6. 7. Create a table and name it Employees Import the excel LastName-Expense Sheet Create a form and include all the fields from the Employees table in the form. Create a report from the Employees table with all the company employees Last & First name only Create a report from the Employees table with the Employees Last Name, First, Name, & Salary Create a query of all employees that live in the Same State Save as LastName –Access
Purchase answer to see full attachment
User generated content is uploaded by users for the purposes of learning and should be used following Studypool's honor code & terms of service.

Explanation & Answer

Hello, here is the final version...


Anonymous
Goes above and beyond expectations!

Studypool
4.7
Trustpilot
4.5
Sitejabber
4.4

Similar Content

Related Tags