Access $2021$ Skills Approach $-$

Access $2021$ Skills Approach $-$ Ch

$($sp$/$assignments$/$projects$/$details$/9461257$

Steps to complete this project:

Mark the steps as checked when you complete them.

Open the start file AC$2021-$Fixlt$-5-6.$

$$ If the database opens in Protected View, click the Enable Editing 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, and save it$.$

In the Adoptions table, the PetID field is a lookup field displaying values from the Pets table. Someone altered the lookup list to include additional fields from the Pets table but forgot to modify other lookup field properties.

a$.$ Modify the Column Count property so all three fields are shown.

b$.$ Do not allow users to enter an adoption record for a pet unless that pet is listed in the lookup list.

$$ The organization recently adopted a new policy to require a home visit within $21$ days of the adoption. In the Adoptions table, add a new Date$/$Time calculated field named HomeVisitDate between the AdoptionDate and HomeVisitCompleted fields to calculate the date of the home visit. Use this expression to calculate the adoption date:

$[$AdoptionDate$]+21$

In the Friends table, someone tried to use the field Format property and an input mask to ensure that the records are entered correctly. Please fix the mistakes:

a$.$ In the CustomerID field, the input mask is set to allow two optional letters followed by two optional numbers. The format should require two letters followed by two required numb