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.