Computer Science Homework Help

Local Physical Therapy Clinic Database Project

 

Problem: As a volunteer project, you and a few friends are creating a database for a local physical therapy clinic that provides therapy to the elderly in their homes. You want to be able to share query results and reports, so you have decided to store the items in the cloud. You are still learning Access, so you are going to create a sample query and the report shown in Figure 1–58, export the results, and save them to a cloud storage location, such as Microsoft OneDrive, Dropbox, or Google Drive. 

Instructions:

1.Open the Support_AC_Physical Therapy database from the Data Files and enable the content. 

2.Use the Simple Query Wizard to create a query that includes the Client Number, First Name, Last Name, and Therapist Number. Save the query as Client Query.

3.Export the Client Query as an XPS document to a cloud-based storage location of your choice.

4.Create the report shown in Figure 1–58. Save the report as Client Therapist Report. 

5.Export the Client Status Report as a PDF document to a cloud-based storage location of your choice. You do not need to change any optimization or export settings. Do not save the export steps.