BIS 155 Lab 7 of 7: Access Database

BIS 155 Lab 7 of 7: Access Database in $9 Only

your friends and family that you are now a database designer. You will walk through the steps of creating and populating an Access database to keep a record of items in your home. The database will have a table, a form, a query, and a report.

Turn in one database named Lab7_yourlastname.accdb to the DropBox. When submitting the database, provide a comment in the Dropbox comments area explaining what you learned from completing this lab activity.

Price of Answer: Just US$9 onlyBuy Now

Need Assistance…??  email us at [email protected].

If you need any type of help regarding Homework, Assignments, Projects, Case study, Essay writing or anything else then just email us at [email protected]solvemyquestion.com.  We will get back to you ASAP. Do not forget to maintain the time frame you need you work to be done.

BIS 155 Lab 5 of 7: Bruno’s Pizza Analysis

BIS 155 Lab 5 of 7: Bruno’s Pizza Analysis in $9 Only

The owner of Bruno’s Pizza, Joe Bruno, wants to evaluate the profitability of his three restaurants before he expands further. He is particularly interested in the comparative results of three dining categories, dine-in, pickup, and delivery. Joe has asked for your help in doing this analysis in return for a small stipend and all the pizza you can eat. You have already prepared a template and distributed it to each restaurant manager, who has entered the sales data for last year. Your next task is to consolidate the data into a single workbook that shows the total sales for each quarter and each dining category. The information should be shown in tabular, as well as graphical formats. You will also create a documentation sheet so that Joe will know exactly what you have created.

Price of Answer: Just US$9 only

Buy Now

Need Assistance…??  email us at [email protected].

If you need any type of help regarding Homework, Assignments, Projects, Case study, Essay writing or anything else then just email us at [email protected]solvemyquestion.com.  We will get back to you ASAP. Do not forget to maintain the time frame you need you work to be done.

BIS 155 Lab 4 of 7: Create Address Labels

BIS 155 Lab 4 of 7: Create Address Labels in $9 Only

Create labels for the letters. The XYZ Corporation wishes to use mailing labels to address the envelopes. They own 8 1/2 x 11″ sheets of label paper with 1″ by 4″ labels, which they purchased from Office Depot.

Download the Lab 4, Step 3 Instructions.

A. Create a new file for printing labels.

B. Merge data from your Excel spreadsheet into the new label document.

Submit your completed workbook and the two Word documents (merged letters and merged labels) to the Dropbox. Make sure you post a comment about what you learned when submitting the files.

3: Create Address Labels (15 points)

Create labels for the letters. The XYZ Corporation wishes to use mailing labels to address the envelopes. They own 8 1/2 x 11″ sheets of label paper with 1″ by 4″ labels, which they purchased from Office Depot.

Download the Lab 4, Step 3 Instructions.

A. Create a new file for printing labels.

B. Merge data from your Excel spreadsheet into the new label document.

Submit your completed workbook and the two Word documents (merged letters and merged labels) to the Dropbox. Make sure you post a comment about what you learned when submitting the files.

Scenario/Summary

You work with the XYZ Corporation Charitable Trust allows you to demonstrate your expertise with Excel. The trust is sponsoring an auction, and you have received a list of all donors who have contributed to this auction. The
list was pulled from the Corporation’s database as a comma separated text file.

You have been asked to create a letter that will go out to each of the contributors that will accept their donation. Tickets to the event will be enclosed. The letter requires that you provide the following pieces of information:

Full Name and Address First Name Donated Item Value Number of tickets requested Deliverables

You will turn in one spreadsheet and two Word documents. You will locate the following files in DocSharing (Lab Materials folder):
wk4_trust.txt and wk4_trust_letter.docx. You will submit the following three items: one Excel spreadsheet (Lab4_yourlastname.xlsx), one letter (Lab4_yourlastname.docx), and one sheet of labels (Lab4_yourlastname_labels.docx). When submitting the workbook and Word documents, provide a comment in the Dropbox comments area explaining what you learned from completing this lab activity.

B S T E P S

STEP 1: Import text file into a spreadsheet and clean up data (20 points)

Download the Lab 4, Step 1 Instructions.

A. Import the text file into Excel and save as lab4_yourlastname.xlsx. Import only the data you will need for your
letter.

B. Separate the first and last names into two columns so that you may use the first name in a Mail Merge. Make sure the fields are named LastName and FirstName.

C. Check the accuracy of all data by using the Spelling tool in the Proofing group.

STEP 2: Create Merge Document (15 points)

Download the Lab 4, Step 2 Instructions.

A. Open the wk4_trust_letter document in Word. Make sure that the document is in the same folder as the Excel spreadsheet. This will make it easier to work with the two documents during the Merge process.

B. Merge information from your Excel spreadsheet into the Word document. Your completed Merge will look like the following when complete:

9/27/2007
XYZ Corporation Charitable Trust
123 Adams
Street
Pittsburgh, PA 15697

Shelly Martin
123 North
Street
Pittsburgh, PA 15697

Dear Shelly,

Thank you for
your generous donation to the XYZ Corporation Charitable Trust Fundraiser. We are delighted to accept the following donation:

Item: Massage

Item Value: $50.00

Enclosed you will find the 2 tickets you requested for this Fundraising event, which will take place on Friday, October 24, 2007. We will be looking forward to seeing you and giving your personal thanks.

Thank
you again for you support of the fund. The proceeds will support international annual rescue efforts.

With Special thanks,

Jeoffrey
McMillan
Charitable Trust President
XYZ Corporation

3: Create Address Labels (15 points)

Create labels for the letters. The XYZ Corporation wishes to use mailing labels to address the envelopes. They own 8 1/2 x 11″ sheets of label paper with 1″ by 4″ labels, which they purchased from Office Depot.

Download the Lab 4, Step 3 Instructions.

A. Create a new file for printing labels.

B. Merge data from your Excel spreadsheet into the new label document.

Submit your completed workbook and the two Word documents (merged letters and merged labels) to the Dropbox. Make sure you post a comment about what you learned when submitting the files.

Price of Answer: Just US$9 only

Buy Now

Need Assistance…??  email us at [email protected].

If you need any type of help regarding Homework, Assignments, Projects, Case study, Essay writing or anything else then just email us at [email protected]solvemyquestion.com.  We will get back to you ASAP. Do not forget to maintain the time frame you need you work to be done.

BIS 155 Lab 2 of 7: Excel’s Advanced Formulas & Functions

BIS155 Lab 2 of 7: Excel’s Advanced Formulas & Functions in $9 OnlyBIS 155 Lab 2

BIS155 Lab 2: You are an intern at First National Bank working in the loan department, and your boss has asked you to prepare the monthly “New Loan Report” for the Board of Directors. This analysis report will clearly list and summarize all new loans for residential housing in the past month. The summary area includes the loan statistics as labeled data in the data file. The format of the report is appropriate for the Board of Directors for the First National Bank.

This is the quality answer at discounted price. We are also given the money back guarantee with this answer.

Price of Answer: Just US$9 only

Buy Now

Need Assistance…??  email us at [email protected].

If you need any type of help regarding Homework, Assignments, Projects, Case study, Essay writing or anything else then just email us at [email protected]solvemyquestion.com.  We will get back to you ASAP. Do not forget to maintain the time frame you need you work to be done.

BIS 155 Final Exam 1

BIS 155 Final Exam 1

  1. (TCO 1) You work for a local construction firm, “DeVry Engineering Group” and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate weekly payroll for “15” employees with the following assumptions:
    • Each employee could have a standard hourly rate between $10.00 and $30.00 per hour.
    • Each employee qualifies to earn overtime at a rate of 1.5 of his or her hourly rate for every hour greater than 40 hours. 
    • Each employee will have a standard 7.65% deduction for social security
    • Each employee will have a standard 14.00% deduction for Federal Taxes
    • Each employee will have a standard 5.33% deduction for State Taxes

Explain how you will structure and format your worksheet, including titles, column headings, and formulas to calculate payroll variables for each employee to determine “Net Pay” including and not limited to Total Hours, Gross Pay, Social Security Tax, Federal Withholding Tax, and Sate Withholding Tax.  In addition, determine how you would extract overtime hours from a calculated value of “Total Hours” using a conditional formula. 

BIS 155 Final Exam

BIS 155 Final Exam in just $17 Only

BIS 155 Final Exam

1. (TCO 1) You work for a local construction firm, “DeVry Engineering Group” and your supervisor wants to test your knowledge and skills with Microsoft Excel and has instructed you to develop a spreadsheet to calculate weekly payroll for “15” employees with the following assumptions:

• Each employee could have a standard hourly rate between $10.00 and $30.00 per hour.
• Each employee qualifies to earn overtime at a rate of 1.5 of his or her hourly rate for every hour greater than 40 hours. 
• Each employee will have a standard 7.65% deduction for social security
• Each employee will have a standard 14.00% deduction for Federal Taxes
• Each employee will have a standard 5.33% deduction for State Taxes

Explain how you will structure and format your worksheet, including titles, column headings, and formulas to calculate payroll variables for each employee to determine “Net Pay” including and not limited to Total Hours, Gross Pay, Social Security Tax, Federal Withholding Tax, and Sate Withholding Tax.  In addition, determine how you would extract overtime hours from a calculated value of “Total Hours” using a conditional formula. 

In addition, your supervisor will need this weekly payroll report on a weekly basis and instructed you to keep the payroll history of all weeks within “1” workbook but has allowed you to decide if you would rather keep the payroll running on one worksheet or by assigning a new worksheet for each week.  Using your knowledge learned in this class, descriptively explain whether you would keep all weekly payrolls in one worksheet or assigned to new worksheets by week.  Defend your reasoning’s on the approach your take based on what you have learned in this course.(Points : 40)

BIS 155 Final Exam

You will get high quality answer of BIS 155 Final Examination. We assure you A grade. 

BIS155 Final Exam 

BIS/ 155 Final Exam 

BIS/ 155 Final Exam 

Price of Answer: Just US$ 19 only 

Buy Now

Need Assistance…??  email us at [email protected].

If you need any type of help regarding Homework, Assignments, Projects,  Case study, Essay writing or any thing else then just email us at [email protected]solvemyquestion.com.  We will get back to you ASAP. Do not forget to maintain the time frame you need you work to be done.