Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

For your final project you will be creating an Excel workbook and an Access database using your own data. You will be taking skills learned

image text in transcribed

For your final project you will be creating an Excel workbook and an Access database using your own data. You will be taking skills learned from each of the labs and applying them to each of the files. There should be an element from each lab (with the exception of the what if analysis) to include in your files. That means there should be pivot charts, formulas and functions, charts and more in your Excel file. For your Access file there should be tables, queries, forms and reports. Having an element from each of the labs will be scored on a scale of 1-10 points leading to a total of 80 points. The other 20 will be the overall organization, formatting, effort, and thoughtfulness/usefulness of the files. The data will not be provided by me, but rather you will come up with it yourself. It can be on just about anything from sports, to video games, the stock or real estate market and anything in between. you may use made up data, but will need to put effort into creating something that is useful in both Excel and Access and lends itself to creating charts, reports, and queries. If you have a specific topic you are interested in the easiest way to find it is google the topic followed by "data sets". i.e. - housing market data sets. For your final project you will be creating an Excel workbook and an Access database using your own data. You will be taking skills learned from each of the labs and applying them to each of the files. There should be an element from each lab (with the exception of the what if analysis) to include in your files. That means there should be pivot charts, formulas and functions, charts and more in your Excel file. For your Access file there should be tables, queries, forms and reports. Having an element from each of the labs will be scored on a scale of 1-10 points leading to a total of 80 points. The other 20 will be the overall organization, formatting, effort, and thoughtfulness/usefulness of the files. The data will not be provided by me, but rather you will come up with it yourself. It can be on just about anything from sports, to video games, the stock or real estate market and anything in between. you may use made up data, but will need to put effort into creating something that is useful in both Excel and Access and lends itself to creating charts, reports, and queries. If you have a specific topic you are interested in the easiest way to find it is google the topic followed by "data sets". i.e. - housing market data sets

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 Principles And Issues

Authors: Michael H. Granof, Philip W. Bell

4th Edition

013321852X, 978-0133218527

More Books

Students also viewed these Accounting questions

Question

Question 1 (a2) What is the reaction force Dx in [N]?

Answered: 1 week ago

Question

List the five steps in the message-sending process.

Answered: 1 week ago

Question

List and explain the four steps in the communication process.

Answered: 1 week ago

Question

Describe how communication flows through organizations.

Answered: 1 week ago