Shelly Cashman Access 365 | Module 5: End of Module Project 2 Dairy State Community College

GETTING STARTED

1. Save the file SC_AC365_EOM5-2_FirstLastName_1.accdb as SC_AC365_EOM5-2_FirstLastName_2.accdb

a. Edit the file name by changing “1” to “2”.

b. If you do not see the .accdb file extension, do not type it. The file extension will be added for you automatically.

2. With the file SC_AC365_EOM5-2_FirstLastName_2.accdb open, ensure that your first and last name is displayed as the first record in the _GradingInfoTable table.

a. If the table does not display your name, delete the file and download a new copy.

PROJECT STEPS

1. Dairy State Community College has four locations in the state of Wisconsin, and each campus has an alumni association, which serves as a center for fundraising and promotion of the college. You work in the main alumni association office as an information specialist and are developing an Access database to track alumni data for all four campuses. You want to standardize the appearance of phone numbers in the database. Open the Staff table in Design View. Use the Input Mask Wizard to create an input mask for the Phone field. Store the data without symbols in the mask. Save the change to the Staff table but do not close it.

2. Association directors have asked you to add a field where they can store notes about staff positions. Switch the Staff table to Datasheet View, and then add a new field at the end of the table. Assign the Long Text data type and use PositionNotes as the field name. Save the change to the table.

3. With the Staff table still open in Datasheet View, update the record for Tyrell Lowe (StaffID of 303). Use the input mask to enter (715) 555-4322 in the Phone field and then enter the text Manages outreach in the PositionNotes field. Close the table.

4. The four alumni associations have asked you to provide more detailed information on family donor levels. Open the FamilyDonorLevels form in Design View and add a subform based on the Families table. Include the FamilyID, LastName, County, and Income fields in the subform. Link the main form to the subform using LevelID as the common field (the first option) and save the subform as Families subform, which is the default name. If necessary, reposition the subform so that the top-left edge of the subform is at the 1" mark on the vertical ruler and the 1" mark on the horizontal ruler. The bottom-right edge of the subform control is at 3" mark on the vertical ruler and 8.5" mark on the horizontal ruler. Confirm that the form matches Figure 1 and then save and close the form.

Figure 1: FamilyDonorLevels Form in Design View

5. The appearance of the AlumniEntry form needs to be improved. Open the AlumniEntry form in Design View. Select and align the AlumniID and FamilyID labels and controls to the top. Select and align the FirstName, LastName, DateOfBirth, and Gender text box controls to the left. Save the form. Change the background color of the form to Light Blue 1 (5th column, 2nd row in the Standard Colors palette). Add a title to the form using Alumni Entry as the title text. Bold the form title and change the font size to 20 point to make it stand out. Confirm that the form matches Figure 2 and then save and close the form.

Figure 2: AlumniEntry Form in Design View

6. The association directors often need your help in answering specific questions about alumni. Open the AlumniList query in Design View. Modify the query to find all alumni born before January 1, 1990 who are also the family representative. Run the query, confirm that it returns seven records, and then save and close the query.

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.