ACCESS SKILLS 2.6

Fix It 2.6In this project, you will continue working with the pet store database from Chapter 1 Fix It 1.6. Once again, one of the employees has messed up the database, and it’s up to you to fix it. This time, you’ll implement a few changes to make it harder for employees to make data entry errors.Skills needed to complete this project:Adding a Lookup Field from a List (Skill 2.17)Renaming Fields and Changing the Field Caption (Skill 2.3)Deleting Fields in Datasheet View (Skill 2.6)Inserting, Deleting, and Moving Fields in Design View (Skill 2.9)Adding Fields in Datasheet View (Skill 2.4)Working with Attachment Fields (Skill 2.15)Formatting Fields in Tables (Skill 2.11)Using Quick Start to Add Related Fields (Skill 2.5)Applying an Input Mask (Skill 2.14)Changing Data Type (Skill 2.10)Setting the Default Value Property (Skill 2.12)Creating Relationships (Skill 2.18)Enforcing Deletions and Updates in Relationships (Skill 2.19)Important: Download the resource files needed for this project from the Resources link. If they download in a zipped folder, make sure to extract the files after downloading the resources zipped folder. Visit the SIMnet instant help for step-by-step instruction.Steps to complete this project:Mark the steps as checked when you complete them.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.Submit project for grading.Reset Progress Back to top