Example of the instruction:Homestead Partners is a company that connects independent home owners with long-term renters. You work in the Customer Service Department of Homestead Partners as a data analyst. You are developing an Access database application to help manage and analyze several types of customer service data, including property and property manager effectiveness. In this project, you will improve an existing database by modifying field properties in tables and creating different types of queries. In Design View of the Managers table, below the ReviewDate field, add three new fields. The first field should be named ManagerEmail with a Hyperlink data type. The second should be named Background with a Long Text data type, and the third should be named Resume with an Attachment data type. Change the Append Only property for the Background field to Yes, then save and close the Managers table.In Design View of the Properties table, set the Caption property for the StreetAddress field to Address, change the Field Size property for the StreetAddress field to 30, and apply the Format property for the DepositDate field to Medium Date. Save the Properties table. (Hint: Select Yes in the Microsoft Access window that appears to let you know that the field size has changed.)While still in Design View of the Properties table, change the Required property for the Deposit field to Yes, apply the Validation Rule property for the Deposit field to >=100, enter Deposit must be greater than or equal to $100 for the Validation Text property for the Deposit field, and then save the Properties table. If prompted to test data integrity rules, click Yes.While still in Design View of the Properties table, use the Lookup Wizard to lookup field values for the State field from the StateAbbreviations table. Select both fields from the StateAbbreviations table, and accept the other default settings in the Lookup Wizard. Save the table if prompted, then modify the List Rows Lookup property for the State field to display 30 rows.