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 find certain information from the tables imported from the FDA database.

Methods

• Firstly I began by downloading all the files from the FDA database 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'. When importing the files, I made sure that the fields matched up correctly with the schema. However, there were instances where the FDA database listed certain fields as keys but since they contained duplicate information, Access presented me with an error and didn't allow them to be primary keys. Lastly, I created relationships with the imported tables to match the FDA database table.

Results

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
9. Also answer, would you have been able to answer these questions using the web interface that the FDA provides to this database (Drugs@FDA?)