New Perspective Access 2013 Tutorial 1 NP_Access2013_T1_P1a_FirstnameLastname_2
PROJECT DESCRIPTION
Jennifer Christie, a licensed physical therapist, opened the Physical Therapy Specialists clinic in 2009. Over time, Jennifer has expanded her business to include a staff of therapists with different specialties to treat patients who are referred to her clinic for physical therapy from a nearby medical center. The recent expansion of Jennifer's business to include a second location and several new employees has necessitated a change in how she manages the clinic's operations. She has selected Access 2013 to manage her business data. You'll help Jennifer create and maintain an Access database to store data about therapists, patients, and billing.
GETTING STARTED
Download the following file from the SAM website:
· NP_Access2013_T1_P1a_FirstLastName_1.accdb
Open the file you just downloaded and save it with the name:
· NP_Access2013_T1_P1a_FirstLastName_2.accdb
· Hint:If you do not see the .accdbfile extension in the Save file dialog box, do not type it. Access will add the file extension for you automatically.
To complete this Project, you will also need to download and save the following support file from the SAM website:
· support_NP_A13_T1_P1a_staff.accdb
Open the _GradingInfoTabletable 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
1. Create a new table in Datasheet view. Save the table as Patient.
2. Change the name of the ID field in the Patient table to PatientID.
3. Change the data type of the PatientID field to Short Text.
4. Create the following fields in the Patient table, using the Short Text data type: FirstName, LastName, Address, City, State, and Zip.
5. Enter the records shown in Table 1 below in the Patient table.
Table 1: Patient Table
PatientID
FirstName
LastName
Address
City
State
Zip
A10026
Al
Pandola
45 South Main St
Akron
OH
44307
B19356
Linda
Francis
235 Hwy 5
Akron
OH
44308
6. Resize the Address field to best fit the data it contains. Save and close the Patient table.
7. Open the Therapist table in Datasheet view, and then change the name of the ID field to TherapistID.
8. Change the data type of the TherapistID field to Short Text.
9. Change the data type of the HireDate field to Date/Time, and then save the table.
10. Enter the records shown in Table 2 into the Therapist table.
Table 2: Therapist Table
TherapistID
FirstName
LastName
Specialty
Certification
HireDate
501
Jacob
Steinley
Post-surgical rehab
DPT
5/2/2016
508
Belinda
Roberts
Running-related
DPT
1/5/2015
11. Jennifer created a database named support_NP_A13_T1_P1a_staff that contains a table with additional therapist data. The Therapist table you just edited has the same design as the Employee table in the support_NP_A13_T1_P1a_staff database. Copy all the records from the Employee table in the support_NP_A13_T1_P1a_staff database and paste them at the end of the Therapist table in the current database. (The file support_NP_A13_T1_P1a_staff.accdb is available from the SAM Web site.)
12. Resize the Specialty column in the Therapist datasheet to best fit the data it contains. Save the table, and then close it.
13. Use the Simple Query Wizard to create a query based on the Therapist table. Include the FirstName, LastName, and Specialty fields from the Therapist table in the query, in that order. Name the query Specialties, and then close the query.
14. Use the Form tool to create a form based on the Therapist table. Save the form as TherapistInfo.
15. In Form view, use the navigation buttons for the TherapistInfo form to navigate to the third record (for TherapistID 409), and then change the Certification field value to DPT.
16. Navigate to the last record (for TherapistID 702) in the TherapistInfo form, and then change the Specialty field value to Running-related. Navigate back to the first record in the Therapist table, and then close the form.
17. Use the Report tool to create a report based on the Therapist table. Save the report as TherapistList.
18. In Layout view for the TherapistList report, use the mouse to reduce the width of the TherapistID column so it is approximately as wide as the text "TherapistID" in the column heading.
19. Select the text box that appears below the TherapistID column (and contains the number 11) in the TherapistList report. Then use the mouse to resize the height of the text box slightly (by approximately 1/16-inch) so that it is tall enough to completely display the value it contains, as shown in Figure 1 on the next page. Save the report.
Figure 1: Therapist Report
20. Close the Navigation pane. Select the text box that appears below the Specialty and Certification columns and that contains the text "Page 1 of 1." Use an arrow key to move the text box to the left so that its left edge vertically aligns with the left edge of the Specialty column above it. View the first page of the report in Print Preview to view the changes you made, and then view the next page of the report in Print Preview. Save and close the report, and then open the Navigation pane.
Close and save any open database objects. Compact and repair your database, then exit Access. Follow the directions on the SAM website to submit your completed project.
Note:
1. Rename the file. At the place of FirstnameLastname, your FirstnameLastname should appear.
2. Replace from your original access database table: _GradingInfoTable to this database. This table contains your name. It is very very important, otherwise your assignment will contain someone else's name.