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: 10 b. Rename the FlowerColor field to: PrimaryColor c. Set the Default Value property for the PrimaryColor field to white. 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 Wild 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.
Added by Rebecca A.
Close
Step 1
Step 1: Open the Plants table in either Datasheet view or Design view. Show more…
Show all steps
Your feedback will help us improve your experience
Akash M and 51 other AP CS educators are ready to help you.
Ask a new question
Labs
Want to see this concept in action?
Explore this concept interactively to see how it behaves as you change inputs.
Key Concepts
Recommended Videos
Supreeta N.
Apply Your Knowledge Reinforce the skills and apply the concepts you learned in this module. Using Wildcards in a Query, Creating a Parameter Query, Joining Tables, and Creating a Report Instructions: Start Access. Open the Support_AC_Financial Services database from the Data Files. (If you did not previously complete the exercise, see your instructor for a copy of the modified database.) Perform the following tasks: 1. Import the Accounting table from the Support_AC Financial Services – Extra Tables database. 2. Create a query for the Accounting table and add the Client Number, Client Name, Amount Paid, and Advisor fields to the design grid. Sort the records in descending order by Amount Paid. Add a criterion for the Advisor field that allows the user to enter a different advisor each time the query is run. Run the query and enter 114 as the advisor to test the query. Save the query as Apply 2 Step 2 Query. 3. Create a query for the Accounting table and add the Client Number, Client Name, and Current Due fields to the design grid. Add a criterion to find all clients whose current due amount is less than $500. Run the query and then save it as Apply 2 Step 3 Query. 4. Create a query that joins the Advisor and Client tables. Add the Advisor Number, Last Name, and First Name fields from the Advisor table and the Client Number and Client Name fields from the Client table to the design grid. Sort the records in ascending order by Client within Advisor. Run the query and save it as Advisor-Client Query. Note: if any error messages appear, check the field types of the fields in the query tables and make changes as necessary. 5. Create the report shown in Figure 2–87. The report uses the Advisor-Client Query.
Akash M.
PA 13-3 (Algo) Monsanto sells genetically modified seed to farmers. It needs to decide how much seed to put into a warehouse to serve demand for the next growing season. It will make one quantity decision. It costs Montanso $8 to make each kilogram (kg) of seed. It sells each kg for $45. If it has more seed than demanded by the local farmers, the remaining seed is sent overseas. Unfortunately, it only earns $3 per kg from the overseas market (but this is better than destroying the seed because it cannot be stored until next year). If demand exceeds its quantity, then the sales are lost—the farmers go to another supplier. As a forecast for demand, it will use a normal distribution with a mean of 325,000 and a standard deviation of 150,000. Use Table 13.4. a. How many kilograms should Montanso place in the warehouse before the growing season? Use Table 13.4 and round-up rule. b. If Montanso put 375000 kgs in the warehouse, what is its expected revenue (include both domestic revenue and overseas revenue)? Use Table 13.4 and round-up rule. c. How many kilograms should Montanso place in the warehouse to minimize inventory while ensuring that the stockout probability is no greater than 10%? Use Table 13.4 and round-up rule. d. What is maximum profit for this seed?
Adi S.
Recommended Textbooks
Computer Science and Information Technology
Introduction to Programming Using Python
Computer Science - An Overview
Transcript
18,000,000+
Students on Numerade
Trusted by students at 8,000+ universities
Watch the video solution with this free unlock.
EMAIL
PASSWORD