The Sports Physical Therapy clinic has an Access database for patients, therapists, and appointments. The clinic also has other systems that record information such as insurance details, accounting of payments, and miscellaneous employee data. The IT manager at the organization wants to consolidate and summarize the data from these systems to produce management reports. What type of system is needed to accomplish this?

a. Data warehouse

b. PivotTables

c. Client/server

d. Split database