USA: +1(669)289-8683 
Sign in
- Open the start file AC2021-FixIt-2-6.
- If the database opens in Protected View, click the Enable Content button in the Message Bar at the top of the database so you can modify it.
- The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor.
- Fix the Pets table as follows:In this store, there are only two types of pets: cats and dogs. Edit the AnimalType field so users select Cat or Dog as the entry for this field. Do not allow any other type of animal to be entered.The pets aren’t really sold; they are adopted. Please change the name of the Price field to: AdoptionFeeThe store realizes it rarely types in the cage number for each animal it receives. Therefore, remove the CageNum field from the table. Click Yes to confirm that the index on this field will also be removed.Modify the AgeInMonths field so the field caption is: Age (Months)Add another new field that can store photographs and insert the Newfoundland.jpg image for the record with the Newfoundland breed.Save and close the table.
- Fix the Adoptions table as follows:The dates in the Adoptions table should look like this: 30-Jun-19The pets aren’t really sold; they are adopted. Please change the name of the SaleDate field to: AdoptionDateAdd the Caption Adoption Date to the AdoptionDate field.Add a new field in Datasheet view using the Payment Type Quick Start option.The Payment Type field should be the last field in the table in both Design view and Datasheet view. Move the field if necessary.Save and close the table.
- Fix the Customers table as follows:The Phone field should use the Phone Number input mask to display all phone numbers in the format similar to (202) 555-1212. Store the data without the symbols.The data type for the Newsletter field should be Yes/No, not Short Text. In Datasheet view, the field should display a check box.The default value for the Newsletter field should be Yes so that it appears checked every time you create a new record.Save and close the table.
- Review the table relationships and fix them as follows:Create a new one-to-many relationship between the PetID field in the Pets table and the PetID field in the Adoptions table. Be sure to enforce referential integrity.Check the relationship between the CustomerID field in the Customers table and the CustomerID field in the Adoptions table. If a customer record is deleted, any related records in the Adoptions table should not be deleted. Make any necessary changes to the table relationship.
- Close the database and exit Access.
- Upload and save your project file.
