Crop Database

Crop Database
This database is designed to store information on vegetable seeds for a local garden center. Two tables are to be
created.
1. Open Access and create a new database called Crop Database_yourname
2. Create the first table called Crop Varieties using the information below
Field Name
Variety
Name
Plant Code
Harvest Time
Data Type
Text
Text
Text
Text
Field Sizes
20
20
4
10
3. Set the primary key for the Plant Code field
4. Close the table
5. Create the second table within the same database using the information below. Name it Crop Prices.
Field Name
Plant Code
Page Ref
Amount Sold
Price
Data Type
Text
Number
Number
Currency
Field Sizes
4
Long Integer
Long Integer
2 decimal places
6. Set Primary Key for Plant Code
7. Close the table
Relationships
8. Create a relationship between the 2 tables by Plant Code.
Forms
9. Create a form based on the Crop Varieties and Crop Prices tables using the Form Wizard
a. Insert the following fields:
i. Plant Code, Varieties, Name, Harvest Time, Page Ref, Amount Sold, and Price.
b. Choose Columnar Style
c. Change the theme to one of your choosing
d. Name the form Crops Form
e. Add buttons to the form that will show the previous record, show the next record, and add a new
record.
Input Data
10. Using the form, enter the following data:
Plant Code
3088
3097
3092
3333
3357
3389
3393
3390
3681
3677
3706
3100
3009
3007
3062
Variety
Dwarf French Beans
Dwarf French Beans
Dwarf French Beans
Cabbage
Cabbage
Carrots
Carrots
Carrots
Lettuce
Lettuce
Lettuce
Lettuce
Peas
Peas
Peas
Name
Annabel
The Prince
Masterpiece
Spring Hero
Casair
Cardinal
Rocket
Campestar
Tom Thumb
Lakeland
Valdor
Ice Berg
Meteor
Little Marvel
Onward
Harvest Time
Summer
Summer
Summer
Spring
Winter
Spring
Spring
Autumn
Summer
Summer
Winter
Summer
Autumn
Spring
Summer
Page Ref
62
63
64
65
68
69
70
71
72
72
74
78
77
77
79
Amount Sold
100
250
200
160
130
255
300
425
120
80
360
350
250
300
120
2. Open both tables to confirm that the information added in the form has been entered.
a. Sort both tables by Plant Code in ascending order.
Price
0.85
1.15
1.02
1.22
1.29
1.39
0.98
0.75
0.52
0.79
0.66
0.89
0.92
1.02
0.89