Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribed
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

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

Students also viewed these Accounting questions