Nstojan1 Week 8

Purpose

• The purpose of this assignment is to learn now to enter data sets into Access and practice creating queries similar to the FDA Drug Database

Methods

• Firstly I began by downloading all the files and unzipping them. I then opened the 'new database' in Access and then went to 'external databases' to add the tables that were downloaded from the FDA Drug Database. Once on the 'external database' I selected 'form file' and then 'text file'.

Questions

1. • What are the names of the drug products that are administered in the form INJECTABLE;INTRAVENOUS, SUBCUTANEOUS?
   • Query 1
2. What are the names of the drug products whose active ingredient (activeingred) is ATROPINE?
   • Query 2
3. In what forms and dosages can the drug product named BENADRYL be administered?
   • Query 3
4. Which drug products have a name ending in ESTROL?
   • Query 4
5. Produce a table listing all of the known values for the therapeutic_potential column in the application table and how many application records there are of each. (Side note: The therapeutic_potential codes are explained in the ReviewClass_Lookup.txt file, in case you’re interested.)
   • No content was found when searching the database.
6. Produce a table listing all of the known values for the chemical_type column in the application table and how many application records there are of each. (Side note: The chemical_type codes are explained in the ChemTypeLookup.txt file, in case you’re interested.)
   • No content was found when searching the database.
7. What are the names of the drug products that are sponsored (sponsor applicant column) by MERCK?
   • Query 5
8. Which sponsor applicant companies have the text LABS in their names and have products whose active ingredients (activeingred) include both ASPIRIN and CAFFEINE?
   • Query 6

Also answer, would you have been able to answer these questions using the web interface that the FDA provides to this database (Drugs@FDA?)