...New Perspectives Access 2013 Tutorial 3: SAM Project 1a PHYSICAL THERAPY SPECIALISTS, P.C. USING QUERIES TO UPDATE AND RETRIEVE INFORMATIONName New Perspectives Access 2013 Tutorial 3: SAM Project 1a PHYSICAL THERAPY SPECIALISTS, P.C. USING QUERIES TO UPDATE AND RETRIEVE INFORMATIONName PROJECT DESCRIPTION Jennifer Christie needs to update some of the data in the Therapist and Location tables to reflect a contract change and the closure of a business location for Physical Therapy Specialists. She also needs to view specific data about patients, therapists, and billing. She asks you to help her maintain the data in the database and to create query objects to view the data she needs to review. GETTING STARTED * Download the following file from the SAM website: * NP_Access2013_T3_P1a_FirstLastName_1.accdb * Open the file you just downloaded and save it with the name: * NP_Access2013_T3_P1a_FirstLastName_2.accdb * Hint: If you do not see the .accdb file extension in the Save file dialog box, do not type it. Access will add the file extension for you automatically. * Open the _GradingInfoTable table and ensure that your first and last name is displayed as the first record in the table. If the table does not contain your name, delete the file and download a new copy from the SAM website. * PROJECT STEPS Open the Therapist table in Datasheet view. Display the subdatasheet for the record with Therapist ID 699...
Words: 1127 - Pages: 5
...New Perspectives Access 2013 Tutorial 3: SAM Project 1a Physical Therapy Specialists, P.C. USING QUERIES TO UPDATE AND RETRIEVE INFORMATIONName New Perspectives Access 2013 Tutorial 3: SAM Project 1a Physical Therapy Specialists, P.C. USING QUERIES TO UPDATE AND RETRIEVE INFORMATIONName PROJECT DESCRIPTION Jennifer Christie needs to update some of the data in the Therapist and Location tables to reflect a contract change and the closure of a business location for Physical Therapy Specialists. She also needs to view specific data about patients, therapists, and billing. She asks you to help her maintain the data in the database and to create query objects to view the data she needs to review. GETTING STARTED * Download the following file from the SAM website: * NP_Access2013_T3_P1a_FirstLastName_1.accdb * Open the file you just downloaded and save it with the name: * NP_Access2013_T3_P1a_FirstLastName_2.accdb * Hint: If you do not see the .accdb file extension in the Save file dialog box, do not type it. Access will add the file extension for you automatically. * Open the _GradingInfoTable table and ensure that your first and last name is displayed as the first record in the table. If the table does not contain your name, delete the file and download a new copy from the SAM website. * PROJECT STEPS Open the Therapist table in Datasheet View. Display the subdatasheet for the record with Therapist ID 699...
Words: 1167 - Pages: 5