Application of Microsoft Access Relational Database for Pesticide Decision Taking and Selection

Donyo Ganchev, Aneliya Kutseva


The relational database system with Microsoft Access was created in order to correct and quick pesticide selection and decision taking on the basis of approved plant protection products list (catalogues) in the Republic of Bulgaria, issued by Bulgarian Food Safety Agency. The information for approved plant protection products was complemented with classification according to the mode of action of the active substances and their chemical groups for the proper integrated resistance management, easy and correct selection of the pesticides in accordance with their properties and target pests. Such kind easy to be created and managed relational database can be in aid of different agricultural specialist (agronomist, agro-scientists, plant protection distributors and sellers, international and national pesticide regulation experts and etc.)

Full Text:



Bulgarian Food Safety Agency. (2017). Lists (catalogues) of approved for marketing and use plant protection products in Republic of Bulgaria. Available:Растителна

N.N. Melʹnikov, Chemistry of pesticides. Springer Science & Business Media, 2012.

Bulgarian Plant Protection Act. (2016). Available:

A. J. Hruska, and M. Corriols, " The impact of training in integrated pest management among Nicaraguan maize farmers: increased net returns and reduced health risk," International Journal of Occupational and Environmental Health, 8(3), 2002, pp.191-200.

Microsoft Access 2007. (2007). Available:

A D. Mumford, Decision tools for pest management. CAB International, 1993.

M.E. Whalon, D. Mota-Sanchez, and R.M. Hollingworth, Global pesticide resistance in arthropods, Cabi, 2008.

J.Kovach, C. Petzoldt, J. Degni, and J. Tette, A method to measure the environmental impact of pesticides, 1992.

F.R. Hall, and J.J Menn, Biopesticides: use and delivery (Vol. 5). ^ eNueva Jersey Nueva Jersey, Humana Press, 1999.

W.I. Bajwa, M. Kogan, and P.P. Center, “Database Management System for Internet 1PM Information,” 1PM in Oregon: Achievements and Future Directions, 205, 2000.

J. Green, “Adjuvant outlook for pesticides,” Pesticide Outlook, 11(5), 2000, pp.196-199.

J. Broome, and K. Warner, “Agro-environmental partnerships facilitate sustainable wine-grape production and assessment,” California Agriculture, 62(4), 2008, pp.133-141.

K. Fenner, S. Canonica, L.P. Wackett, and M. Elsner, “Evaluating pesticide degradation in the environment: blind spots and emerging opportunities,” Science, 341(6147), 2013, pp. 752-758.

E. J. Muturi, K. Costanzo, B. Kesavaraju, R. Lampman, and B.W. Alto, “Interaction of a pesticide and larval competition on life history traits of Culex pipiens,” Acta tropica, 116(2), 2010, pp. 141-146.

M. Bundschuh, W. Goedkoop, and J. Kreuger, “Evaluation of pesticide monitoring strategies in agricultural streams based on the toxic-unit concept—experiences from long-term measurements,” Science of the Total Environment, 484, 2014, pp.84-91.

J. Stenersen, Chemical pesticides mode of action and toxicology, CRC press, 2004.

N. Kaur, C. S. Alderman, D. L. Walenta, K. E. Frost, J. K. Dung and P. B. Hamm, "Evaluation of new fungicide chemistries and application strategies to reduce ergot in grass seed production systems," Seed Production Research Report, 152, 2015.

Ohp Chemical Class Cart (2016). Available at: http://

BASF Corporation, Pest Management Guide (2012). Available:

University of Wisconsin-Extension,College of Agricultural and Life Sciences. Corn and Soybean Herbicide Chart (2013). Available:

Fungicide Resistance Action Committee. (2014). Available:

Insecticide Resistance Action Committee. (2016). Available:

Herbicide Resistance Action Committee. (2017). Available:

C. J. Lagerkvist, M. Ngigi, J.J. Okello, and N. Karanja, “ Means-End Chain approach to understanding farmers' motivations for pesticide use in leafy vegetables: The case of kale in peri-urban Nairobi, Kenya,” Crop protection, 39, 2012. pp. 72-80.

M. Barzman, P. Bàrberi, N. Birch, P. Boonekamp, S. Dachbrodt-Saaydeh, B. Graf and J.R. Lamichhane, “Eight principles of integrated pest management,” Agronomy for sustainable development, 35(4), 2015.

J. L. Harrington, Relational database design and implementation, Morgan Kaufmann, 2016.

N. F. Angel, N. Young and A. Dollman, “Creating a database from scratch: Smarter solutions, inc. case study: nifty assignment,” Journal of Computing Sciences in Colleges, 31(2), 2015, pp. 185-187.

C. Coronel and S. Morris, Database systems: design, implementation, & management, Cengage Learning, 2016.

R. C. Groom, I. J. Bruno, M. P. Lightfoot and S. C. Ward, “The Cambridge structural database,” Acta Crystallographica Section B: Structural Science, Crystal Engineering and Materials, 72(2), 2016. pp. 171-179.

M. Lewenstein, J. I. Munro, V. Raman and S. V. Thankachan, “Less space: Indexing for queries with wildcards,” Theoretical Computer Science, 557, 2014, pp. 120-127.


  • There are currently no refbacks.

MAYFEB Journal of Agricultural Science
Toronto, Ontario, Canada
ISSN 2371-512X