Shelly Cashman Access 365 | Module 3: End of Module Project 2 скачать в хорошем качестве

Shelly Cashman Access 365 | Module 3: End of Module Project 2

Please contact us if you need this project or any other projects in any subject to be completed. WhatsApp: +1-343-321-3276 Email: essayserviceusa@gmail.com WhatsApp Link: https://wa.me/13433213276 Shelly Cashman Access 365 | Module 3: End of Module Project 2 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 as an information specialist and are developing an Access database to track alumni data for all four campuses. Open the Families table in Design View and delete the State field since all the alumni families live in Wisconsin. Change the data type for the Income field to Currency with 0 decimal places to show that the field contains dollar amounts. Change the Field Size property for the LevelID field to 3 to match the field size of the same field in the DonorLevels table. Save the changes to the table, selecting Yes when notified that some data may be lost. Do not close the table. 2. Switch the Families table to Datasheet View. Add the caption Tax Income to the Income field. Add a Total row to the table and calculate the average for the Income field. Resize the Income field to its best fit. Save the changes to the table. 3. Open the Staff table in Design View. Create a validation rule for the CampusID field that ensures only the values 1, 2, 3, 4, or 5 are entered in the field. Enter Must be 1, 2, 3, 4, or 5 as the validation text. Save the changes to the table. 4. Open the Programs table in Design View and make the ProgramCode field the primary key for the table. Change the format of the MinParticipants field to display a general number with 0 decimal places since the number of participants will always be a whole number. Save the table, but do not close it. 5. Switch the Programs table to Datasheet View. The alumni association sometimes provides the Programs datasheet to donors and wants to format it more attractively. Display only horizontal gridlines on the datasheet, and then resize the MinParticipants field to its best fit. Apply an alternate row color of Blue, Accent 1, Lighter 80% (5th column, 2nd row in the Theme Colors palette). Save the changes to the table. 6. Open the Alumni table in Design View and make the FamilyID field a required field since FamilyID is a foreign key field needed to link the Alumni table and the Families table. Select Yes when notified about data integrity rules. 7. Open the DonorLevels table in Design View. The alumni association requests only a maximum of five percent of a donor's top income according to their donor level. Add a calculated field named MaxRequest to the end of the table. The field contains the result of multiplying the MaxIncome field by 0.05. Save the changes to the table. 8. The alumni association recently hired six new staff members. The new staff records are stored in the NewStaff table, but need to be appended to the Staff table. Create an append query to append the records. Save the query using AppendStaff as the query name, and then run the query and view the Staff table, which should contain 18 records. 9. The college recently closed two campuses in Minnesota and Illinois. Using a query, delete records in the Campuses table where the State field value is MN or IL. Save the query using DeleteMNIL as the query name, and then run the query and view the Campuses table, which should contain records only with State field values of WI. 10. The alumni association changed a job title for its staff. Using an update query, update the field values in the Position field in the Staff table to Associate Director for all records where the value in the Position field value is Fundraiser. Save the query using UpdatePosition as the query name, and then run the query and view the Staff table to verify the position name was updated. 11. Create a one-to-many relationship between the Families table and the Alumni table. FamilyID is the matching field in each table. Make the relationship enforce referential integrity. Save the relationship. 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.