Expand Your World- Access Module 2- Querying a Database

Problem: You are taking a general science course and the instructor would like you to gather some statistics and query the statistics on the dietary intake from community gardens.

Instructions:

1. Examine a website that contains research data on how individuals and families participate in growing their own food. Select data from both small and large cities near your current location.

2. Create a database containing one table that contains the following fields: Five-year increase in percentage of households gardening, percentage increase in low-income family gardening participants, and percentage increase in home gardens.

3. Create queries that do the following:

a. returns the largest quantity of increases in gardening.

b. Calculate the difference between the largest gardening percentage increase and the lowest gardening percentage increase.

4. Submit the database in the format specified by your instructor.

5. Use an Internet search engine to find the most successful community garden near your location.

Here is a site that may help you - https://www.ncbi.nlm.nih.gov/pmc/articles/PMC3661291/