Fertid

A Skills Approach: Access 2013 Chapter 2: Working with Tables

1 | Page challenge yourself 2.3 Last Updated 4/3/15

challenge yourself 2.3 In this project you will continue working with the greenhouse database from Chapter 1, Challenge Yourself 1.3. You add a table to keep track of the fertilizers used in the greenhouse and the plants that use them.

Skills needed to complete this project:

 Designing a Table  Creating and Saving a Table in Datasheet View  Renaming Fields  Adding Fields in Datasheet View  Changing Data Type  Deleting Fields  Inserting Fields in Design View  Setting the Primary Key  Adding a Lookup Field from a List  Adding a Total Row to a Table  Adding a Lookup Field from Another Table  Adjusting Table Column Widths  Using Quick Start to Add Related Fields  Working with Attachment Fields  Formatting Fields  Modifying Field Properties  Creating Relationships

Important: Download the resource file(s) needed for this project from the Resources link. Make sure to extract the file(s) after downloading the resources zipped folder. Visit the SIMnet instant help for step- by-step instruction.

1. Open the start file AC2013-ChallengeYourself-2-3.

2. If necessary, enable active content by clicking the Enable Content button in the Message Bar.

3. The file will be renamed automatically to include your name. Change the project file name if directed to do so by your instructor, and save it.

4. Create a new table in Datasheet view using the following data. Allow Access to create the AutoNumber ID field for now.

e. Name the table: Fertilizers

5. Change the Data Type of the Price field to use the Currency format.

6. Delete the ID field that Access created and add a new primary key field. Switch back and forth between Datasheet view and Design view as necessary, saving the table when prompted to do so by Access.

Step 1

Download start file

a. A

b. B

c. C

d. d

A Skills Approach: Access 2013 Chapter 2: Working with Tables

2 | Page challenge yourself 2.3 Last Updated 4/3/15

a. Delete the ID field.

b. Insert a new field at the beginning of the table. Name the field: FertID c. Set the Data Type to Short Text.

d. Enter the following three values (in the appropriate record) under the FertID field: MAP1, PCU1, NSO1

e. Make the FertID field the Primary Key.

7. Add a new lookup field. You can use Datasheet view or Design view, whichever you prefer.

a. Name the new field: Form

b. The lookup field should display the following four values: Granule, Liquid, Slow-Release, Organic

c. Limit data entry to the values in the list.

d. Test this field by choosing any form for the three plants. Save the changes to the table.

8. Add a Total row in Datasheet view that sums up all the fertilizer prices.

9. Save and close the Fertilizers table.

10. Open the Plants table and make the following changes:

a. Add a lookup field named PreferredFertilizer to the Plants table to reference the FertilizerName field in the Fertilizers table. The lookup list should be sorted alphabetically by the FertilizerName data. It is not necessary to limit values to the list.

b. Test this field by choosing any fertilizer for the first three plants.

c. Resize all the columns in the table to best fit the data.

d. Add an Attachment field. Add the image geranium.jpg to the record for the spotted geranium.

e. Change the Format property of the DatePlanted field to Medium Date.

f. Set the Default Value property for the FlowerColor field to white and add a Description for this field that reads: Main color only. Do not enter multiple colors.

g. Save and close the table.

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

a. Show all the tables in the Relationships window.

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

c. Modify the relationship between the FertID field in the Fertilizers table and the PreferredFertilizer field in the Plants table to enforce referential integrity.

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

12. Save and close the database. Exit Access.

13. Upload and save your project file.

14. Submit project for grading.

Step 2

Upload & Save

Step 3

Grade my Project

Download Resources

Applied Sciences

Architecture and Design

Biology

Business & Finance

Chemistry

Computer Science

Geography

Geology

Education

Engineering

English

Environmental science

Spanish

Government

History

Human Resource Management

Information Systems

Law

Literature

Mathematics

Nursing

Physics

Political Science

Psychology

Reading

Science

Social Science

Home

Blog

Archive

Contact

google+twitterfacebook

Copyright © 2019 HomeworkMarket.com