Shelly Cashman Access 365/2021 | Module 3: End of Module Project 2 | Rural Health Associates (2025)

Rural Health Associates
MAINTAINING A DATABASE

GETTING STARTED
• Open the file SC_AC365_2021_EOM3-2_FirstLastName_1.accdb, available for download.
• Save the file SC_AC365_2021_EOM3-2_FirstLastName_1.accdb as SC_AC365_2021_EOM3-2_FirstLastName_2.accdb
o Edit the file name by changing “1” to “2”.
o If you do not see the .accdb file extension, do not type it. The file extension will be added for you automatically.
• With the file SC_AC365_2021_EOM3-2_FirstLastName_2.accdb open, ensure that your first and last name is displayed as the first record in the _GradingInfoTable table.
o If the table does not display your name, delete the file and download a new copy.

PROJECT STEPS
1. Rural Health Associates is a healthcare company that manages rural health clinics in underserved areas of the country. You work in the Patient Services Department as an information specialist.
The records in the AdditionalStaff table need to be appended to the ProfessionalStaff table. Create an append query to append the records. Save the query using AppendStaff as the query name, then run and view it.
2. Open the Family table in Design View and delete the County field. Change the data type for the Income field to Currency with 0 decimal places. Save the changes to the table.
3. Using a query, delete records in the Family table where the Income field value is greater than 55000. Save the query using DeleteHighIncome as the query name, then run and view it.
4. Open the Clinics table in Design View. Create a validation rule for the State field that ensures only the values ID, MT, OR, or WA are entered in the field. Enter Must be ID, MT, OR, or WA as the validation text. Save the changes to the table.
5. Create a one-to-many relationship between the Family table and the Patients table. FamilyID is the matching field in each table. Make the relationship enforce referential integrity. Save the relationship.
6. Open the HealthServices table in Design View and make the ServiceCode field the primary key for the table. Ensure that any letters entered in the ServiceCode field display in uppercase. Save the changes to the table.
7. Using an update query, update the field values in the StateMinInc field in the IncomeLevels table to 16780 for all records where the value in the County field is Twin Falls. Save the query using UpdateStateMinInc as the query name, then run and view it.
8. Open the IncomeLevels table in Design View. Add a calculated field named IncDifference to the end of the table. The field is the result of subtracting StateMinInc from Income. Save the changes to the table.
9. Switch the IncomeLevels table to Datasheet View. Add the caption TaxIncome to the Income field. Add a Total row to the table and calculate the maximum for Income field and the average for the StateMinInc field. Save the changes to the table.
Save and close any open objects in your database. Compact and repair your database, close it, and then exit Access. Follow the directions on the website to submit your completed project.

#MicrosoftAccess
#Access
#Microsoft
#SAMProject
#ShellyCashmanAccess
#ShellyCashman
#Module