Answered step by step
Verified Expert Solution
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
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started