Explain the differences between Excel and Access and the advantage of Access.

/in /by

12/6/16 @12:00 p.m. 750-850 words 100 percent original with at least 2 references APA format

 

As the project manager of the newly designed system for the oncology department, you are asked to provide a memo for the upcoming meeting with the chief executive officer (CEO) and a few senior managers. They are unaware of the features that have been designed and need a quick refresher prior to implementation. Therefore, you will provide and explain the details of the following:

 

  • Explain the differences between Excel and Access and the advantage of Access.
  • Outline the purpose of data analysis, data transformation, and visualization.
  • Give an overview of business intelligence and data warehousing.
  • Explain the basics of building tables.
  • Evaluate the use of pivot tables.
  • Identify the database to be used.
  • Explain the concept of functions and expressions.

 

The use of APA style is expected.