Answered step by step
Verified Expert Solution
Question
1 Approved Answer
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
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. O 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.A Halun.Harris-AC2019-ChallengeYourself-2-3-ALT (1) : Database- C:\\Users\\OWNER\\OneDrive\\Documents\\Halun.Harris-AC2019-ChallengeYourself-2-3-ALT (1).accdb (Access 2007 - 2016 file format) - Access Halun Harris X File Home Create External Data Database Tools Help Table Design Tell me what you want to do X Cut 2 1 Ascending Selection New Z Totals O S'c Replace [A Copy A J Descending Advanced Spelling Refresh Save Paste Filter Find GO TO View Format Painter Remove Sort Toggle Filter All X Delete More Select v Undo Views Clipboard Sort & Filter Lookup Wizard Text Formatting IS X All Access Objects O Finish Field Properties General Lookup Display Control List Box Row Source Type Table/Query Row Source Bound Column Column Count Column Heads No The data type determines the kind of values that Column Widths users can store in the field. Press F1 for help on data types. Allow Multiple Values No Allow Value List Edits Yes List Items Edit Form Show Only Row Source Valu No Lookup Wizard Num Lock n P 12:47 PM 92 F W
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started