Shelly Cashman Access 2019 | Module 1: End of Module Project 2 - Rural Health Associates

Rural Health Associates
BUILDING AN ACCESS DATABASE TO MANAGE PATIENT INFORMATION

GETTING STARTED
• Open the file SC_AC19_EOM1-2_FirstLastName_1.accdb, available for download from the SAM website.
• Save the file as SC_AC19_EOM1-2_FirstLastName_2.accdb by changing the “1” to a “2”.
o If you do not see the .accdb file extension in the Save As dialog box, do not type it. The program 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
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. In this project you will improve an existing database by creating and modifying fields and tables, queries, forms, and reports.

In the Navigation Pane, rename the Patients form using PatientEntry as the new form name.
2. Use the Simple Query Wizard to create a new query. Choose the PatientID, FirstName, and LastName fields from the Patients table. Use PatientListing as the name of the new query, open the query to view information, a portion of which is shown in Figure 1, and then close it.
Figure 1: PatientListing Query

3. Create a new form based on the Family table using the Form tool. Rename the form, using FamilyInfo as the name, confirm that the form matches Figure 2, and then close it.
Figure 2: FamilyInfo Form

4. Use the Report Wizard to create a new report. Choose the FamilyID, LastName, City, and State fields from the Family table. Do not add any grouping levels. Sort the records in ascending order by LastName. Use a Tabular layout and a Portrait orientation. Title the report FamilyListing, preview the report, a portion of which is shown in Figure 3, and then close it.
Figure 3: FamilyListing Report

5. Create a table in Design View. Add a field named ServiceCode with an AutoNumber data type and a field named Description with a Short Text data type. Define ServiceCode as the primary key. Save the table with the name HealthServices, and close the table.
6. Open the ProfessionalStaff table in Datasheet View and add a new record with a StaffID value of 112, FirstName value of Kendra, LastName value of Lister, Position value of Doctor, and ClinicID value of 3.
7. With the ProfessionalStaff table still open in Datasheet View, delete the record for StaffID 100 (Adam Mendoza), modify the FirstName value for the record with StaffID 110 (Rebecca Roderick), using Becky as the new value, and close the ProfessionalStaff table.
8. Open the Patients table in Design View. Add a field named DateOfBirth with a Date/Time data type, add a field named Gender with a Short Text data type, and a field named FamilyID with a Short Text data type. Save and close the Patients 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 SAM website to submit your completed project.

#MicrosoftAccess
#Microsoft
#MicrosoftOffice
#ShellyCashmanAccess
#ShellyCashman
#EndofModule
#RuralHealthAssociates