The writer is very fast, professional and responded to the review request fast also. Thank you.
Book/movie review
22/08/2022
(20% of your course grade – 120 points)
·
A sports franchise that would be affordable for all age ranges
1. Create an excel workbook and insert numerical data relating to your project (Please make sure you have at least 10 rows in your worksheet to make the calculations you do useful). The excel worksheet should have the following:
a. Insert your name and date in the Header/Footer region of the workbook – the header/footer should appear in all worksheets in the work book. Please check here
https://excel.tips.net/T002600_Putting_Headers_and_Footers_On_Multiple_Worksheets.html(Links to an external site.) for how to do this or refer to Chapter 1 of your custom Pearson book.
b. Insert numerical data in the workbook to enable you to use at least two of the following functions: sum, min, max and average functions.
c. Use the if function to format at least one column
d. Adjust the width and height of columns and rows to allow display of data correctly.
e. Format the numerical cells so that they display the correct units. For example, if it is a dollar amount you display, it should be formatted accordingly, rounded to 2 decimal places.
f. Insert a title for your worksheet and center it across your data
g. Using formatting features such as Bold to highlight title, column headings, totals etc.
h. Minimize the usage of fonts to only two types and 2 sizes.
i. Create a 3-D column chart on a new sheet (Here again choose data that will lend itself well to be represented in a 3D chart in addition to being relevant to your project).
j. Select the appropriate ranges for the chart.
k. Insert an appropriate title for the chart
l. Rename this sheet to CHART DISPLAY
m. Save the workbook with your last name as the name of your file
2. Create an Access database that stores data about your project topic. Include the following in your Access database:
a. You must have a minimum of 2 tables. The relationships between them should be set up in the relationship window. Please note that you should set the referential integrity and at least the cascade update options between related tables. One table should have at least 10 records and the second table can have between 5 and 10 records. These numbers are provided as a guide for you taking into account that the tables will have a one-to-many relationship. This would ensure that you will have some output when you run your queries or your reports. If your project has more records that is fine.
b. Create at least 2 queries:
i. A query using the criteria and sort feature.
ii. A join query i.e., a query that gets data from at least 2 tables
c. Create at least 2 reports based on queries or tables making sure that the report will be useful to you in making decisions.
d. Create at least two forms for display and data entry based on the tables in your database. The forms should have the same look and feel.
e. Save the database with your last name.
The writer is very fast, professional and responded to the review request fast also. Thank you.
Delivering a high-quality product at a reasonable price is not enough anymore.
That’s why we have developed 5 beneficial guarantees that will make your experience with our service enjoyable, easy, and safe.
You have to be 100% sure of the quality of your product to give a money-back guarantee. This describes us perfectly. Make sure that this guarantee is totally transparent.
Read moreEach paper is composed from scratch, according to your instructions. It is then checked by our plagiarism-detection software. There is no gap where plagiarism could squeeze in.
Read moreThanks to our free revisions, there is no way for you to be unsatisfied. We will work on your paper until you are completely happy with the result.
Read moreYour email is safe, as we store it according to international data protection rules. Your bank details are secure, as we use only reliable payment systems.
Read moreBy sending us your money, you buy the service we provide. Check out our terms and conditions if you prefer business talks to be laid out in official language.
Read more