Scribd Logo
Upload

Welcome to Scribd!

  • 53 views

    Challenge Yourself 23

    Uploaded by

    Keii blackhood
    This document provides instructions to modify several tables in a database: 1. Create a new Fertilizers table with specified fields. 2. Modify the Plants table by changing field sizes and names, adding a lookup field, and deleting a field. 3. Modify the Employees table by reordering fields and adding lookup fields. 4. Modify the MaintenanceLog table by changing several field data types. 5. Update relationships between tables to enforce referential integrity.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Challenge Yourself 23

    Uploaded by

    Keii blackhood
    53 views3 pages
    This document provides instructions to modify several tables in a database: 1. Create a new Fertilizers table with specified fields. 2. Modify the Plants table by changing field sizes and names, adding a lookup field, and deleting a field. 3. Modify the Employees table by reordering fields and adding lookup fields. 4. Modify the MaintenanceLog table by changing several field data types. 5. Update relationships between tables to enforce referential integrity.

    Original Description:

    For this assignment you need the following:

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    This document provides instructions to modify several tables in a database: 1. Create a new Fertilizers table with specified fields. 2. Modify the Plants table by changing field sizes and names, adding a lookup field, and deleting a field. 3. Modify the Employees table by reordering fields and adding lookup fields. 4. Modify the MaintenanceLog table by changing several field data types. 5. Update relationships between tables to enforce referential integrity.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    53 views3 pages

    Challenge Yourself 23

    Uploaded by

    Keii blackhood
    This document provides instructions to modify several tables in a database: 1. Create a new Fertilizers table with specified fields. 2. Modify the Plants table by changing field sizes and names, adding a lookup field, and deleting a field. 3. Modify the Employees table by reordering fields and adding lookup fields. 4. Modify the MaintenanceLog table by changing several field data types. 5. Update relationships between tables to enforce referential integrity.

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    You are on page 1of 3

    1.

    Open the start file AC2019-ChallengeYourself-2-3-ALT.

    2. 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.

    3. The file will be renamed automatically to include your name. Change the project
    file name if directed to do so by your instructor.
    4. Create a new table in Design view using the following information.

    Table AC 2.5 displays the field name, datatype, and caption


    information for the Fertilizers Table.

    Field Name Data Type Caption

    FertID Short Text

    FertilizerNam Fertilizer
    Short Text
    e Name

    Nutrient
    NutrientRatio Short Text
    Ratio

    FertilizerFor Fertilizer
    Short Text
    m Form

    Price Currency

    a. Set the FertID field as the primary key.

    b. Save the table with the name: Fertilizers

    c. Close the table.


    5. Open the Plants table and make the following changes. You may work in Datasheet
    view or Design view as appropriate.

    a. Set the field size for the PlantID field to: 12

    b. Rename the FlowerColor field to: BloomColor


    c. Set the Default Value property for the BloomColor field to red.

    d. Add a lookup field named PreferredFertilizer to the


    end of the Plants table to reference the FertilizerName field in
    the Fertilizers table. The lookup list should be sorted alphabetically by
    the FertilizerName data. The primary key field should be hidden. Enforce
    referential integrity.

    e. Add an Attachment field after the PreferredFertilizer field. Add the


    image azaleas.jpg to the record for the Mountain azalea.

    f. Delete the MaxHeightFeet field.

    g. Save and close the table.


    6. Open the Employees table and make the following changes. You may work in
    Datasheet view or Design view as appropriate.

    a. Move the LastName field so it appears before


    the FirstName field. Hint: Make the change in Design view so the change is
    applied to the underlying structure of the table.

    b. Add the Phone Quick Start fields between


    the FirstName and Position fields.

    c. Modify the Position field to use a lookup list limited to the following


    values: Supervisor, Greenhouse
    Developer, Greenhouse Design Tech, and Garden
    Advisor. Hint:  Use the Lookup Wizard to create the lookup list and
    enter the values yourself. Double-click the right border of the Col1 column
    in the wizard to AutoFit the column to the data. Don't forget to limit data
    entries to the value in the list.

    d. Save and close the table.


    7. Open the MaintenanceLog table and make the following changes:

    a. Change the data type for the Watered field from Short Text to Yes/No.

    b. Change the data type for the Inspected field from Short Text to Yes/No.


    c. Change the data type for the Pruned field from Short Text to Yes/No.

    d. Change the format for the MaintenanceDate field to Long Date.

    e. Save and close the table.


    8. Review the table relationships and make the following changes.

    a. Create a one-to-many relationship between the PlantID field in


    the Plants table and the PlantID field in the MaintenanceLog table.
    Enforce referential integrity.

    b. Modify the relationship between the EmployeeID field in


    the Employees table and the EmployeeID field in
    the MaintenanceLog table so any deletions or changes to
    the EmployeeID in the Employees table will be carried through to
    the EmployeeID field in the MaintenanceLog table.

    c. Close the Relationships window, saving the layout changes.


    9.

    You might also like