Problem: As a volunteer project, you and a few friends are creating a database f

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.6.If requested to do so by your instructor, open the Therapist table and change the last name and first name for Therapist 203 to your last name and your first name. (My name is Shelva Cox)
Requirements: Answer 1-6

Leave a comment

Your email address will not be published. Required fields are marked *