I need part 3 of the attached project completed involves ms access and ms excel

Due Date/Time:

· Sunday, Dec. 1, 11:59 pm

· Electronic submission: Submitting on the Blackboard; including the project report (Word file), and the completed Excel file and ACCESS database file.

Project Report Template

Length of the main report: 7 pages (double-spaced)

Outline of the main report

I. Analyzing Information needs (1-2 paragraphs)

Read the boat marina case (posted PDF file, page 74-76) and describe the types of information are important for this business’ operation and decision-making.

II. Design: How will you design information technology applications (ACCESS and EXCEL in this case) to produce the required information?

Explain Your ACCESS Design

1) Only two questions are required (Project Case PDF file, page 81, questions 1, 2);

2) Briefly explain your query design to answer the above questions (e.g., tables used, aggregated functions, etc).

Explain Your EXCEL Design

1) Only two questions are required (Project Case PDF file, page 81, questions 6 and 9);

2) Briefly explain the Excel functions and features you plan to use to answer those questions.

III. Database and Spreadsheet Implementations

a. What queries did you create to answer questions 1 & 2? Copy the query results here.

b. How do you use EXCEL features to address questions 6 & 9 on page 81 in the case description? Copy your results of tables and charts here.

Note: Section “Test Your Design” (page 82) is NOT required.

IV. Conclusion (1-2 paragraphs)

a. How will your ACCESS queries help the owners of the Molly Mackenzie Marina?

b. How will your EXCEL workbook help the owners of the Molly Mackenzie Marina?

c. What additional data (both internal and external) would be useful to the boat marina business?

1