Ckaplan Week 8

File:Database Ckapla12.accdb.zip

• Procedure:

For practice with Microsoft Access and querying skills, we obtained the FDA drug dataset and imported it into Access and practiced creating queries to extract specific information from the dataset, providing practical experience in database management and analysis.

• Methods:

Data Acquisition and Preparation: The drug dataset was acquired from the FDA website, consisting of 11 tables with diverse drug-related information. These files were downloaded and extracted.

Database Design and Implementation: Microsoft Access was used for managing the database. The files were imported into Access, ensuring that the data structure was correctly interpreted by specifying the file format and field names. During the import, the FDA's data types were matched with appropriate

Access data types: Char -> Short Text (Character count set in design mode) Varchar -> Long Text Text -> Long Text Int -> Number (Size set in design mode) The FDA's "Required" attribute was translated to Access's "Required" property, with "Not Null" set as "Required = Yes" and "Null" set as "Required = No".

Table Relationships: Table relationships were established based on common field names and logical connections, referencing the visual representations provided by the FDA.

Query Development: Queries were created to search for specific drugs based on various criteria such as drug names.

• Results:

Through creating the queries, the software located the information we needed regarding drug names, manufacturers, and other relevant attributes within the FDA drug dataset,teaching us the effectiveness of our database management and querying techniques in automating data retrieval for analysis.

• Conclusion:

In conclusion, our work with Microsoft Access on the FDA drug dataset was successful. We were able to extract important information like drug names and manufacturers efficiently. Although this was a tough assignment, I learned a lot about how to use Access.

What are the names of the drug products that are administered in the form INJECTABLE;INTRAVENOUS, SUBCUTANEOUS?

DrugName LOVENOX VELCADE APIDRA APIDRA ENOXAPARIN SODIUM ACTEMRA BORTEZOMIB BORTEZOMIB BORTEZOMIB BORTEZOMIB BORTEZOMIB BORTEZOMIB BORTEZOMIB BORTEZOMIB ENOXAPARIN SODIUM BORTEZOMIB BORTEZOMIB BORTEZOMIB BORTEZOMIB BORTEZOMIB BORTEZOMIB BORTEZOMIB BORTEZOMIB ENOXAPARIN SODIUM BORTEZOMIB BORTEZOMIB WEZLANA WEZLANA WEZLANA WEZLANA WEZLANA WEZLANA

What are the names of the drug products whose active ingredient (activeingredient) is ATROPINE?

DrugName ATROPEN ATROPEN ATROPEN ATROPEN ATROPINE ATROPINE (AUTOINJECTOR)

In what forms and strengths can the drug product named BENADRYL be administered?

Form Strength CAPSULE;ORAL 50MG ELIXIR;ORAL 12.5MG/5ML CAPSULE;ORAL 25MG INJECTABLE;INJECTION 10MG/ML INJECTABLE;INJECTION 50MG/ML **Federal Register determination that product was not discontinued or withdrawn for safety or effectiveness reasons**

Which drug products have a name ending in ESTROL?

DrugName DIETHYLSTILBESTROL DIETHYLSTILBESTROL DIETHYLSTILBESTROL DIETHYLSTILBESTROL DIETHYLSTILBESTROL DIETHYLSTILBESTROL DIETHYLSTILBESTROL DIETHYLSTILBESTROL DIETHYLSTILBESTROL DIETHYLSTILBESTROL DIETHYLSTILBESTROL STILBESTROL STILBESTROL STILBESTROL STILBESTROL STILBESTROL STILBESTROL DIENESTROL STILBESTROL STILBESTROL STILBESTROL STILBESTROL STILBESTROL STILBESTROL

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.)

I couldn't complete this column because the data was outdated and deleted.

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.)

I couldn't complete this column because the data was outdated and deleted.

What are the names of the drug products that are sponsored (sponsorname column) by MERCK?

DrugName HYDRODIURIL HUMORSOL HUMORSOL HYDROPRES 25 HYDROPRES 50 DECADRON DECADRON DECADRON HYDROCORTONE DECADRON DECADRON DECADRON COLBENEMID PERIACTIN DECASPRAY PERIACTIN DECADRON W/ XYLOCAINE ALDOMET ALDOMET ALDOMET ALDOMET ALDORIL 15 ALDORIL 25 ALDORIL D30 ALDORIL D50 DECADERM ALDOCLOR-150 ALDOCLOR-250 DECADRON-LA CLINORIL CLINORIL BLOCADREN BLOCADREN BLOCADREN TIMOLIDE 10-25 MODURETIC 5-50 ALDOMET DOLOBID DOLOBID NOROXIN PEPCID PEPCID PRESERVATIVE FREE PRINIVIL PRINIVIL PRINIVIL PRINIVIL PRINIVIL MEVACOR MEVACOR MEVACOR CHIBROXIN PRINZIDE PRINZIDE PRINZIDE TIAMATE TIAMATE TIAMATE PEPCID RPD PEPCID RPD VIOXX VIOXX VIOXX VIOXX VIOXX CANCIDAS CANCIDAS EMEND EMEND EMEND FOSAMAX VIOXX VIOXX VIOXX NEODECADRON NEODECADRON NEO-HYDELTRASOL MEFOXIN IN SODIUM CHLORIDE 0.9% IN PLASTIC CONTAINER MEFOXIN IN SODIUM CHLORIDE 0.9% IN PLASTIC CONTAINER MEFOXIN IN DEXTROSE 5% IN PLASTIC CONTAINER MEFOXIN IN DEXTROSE 5% IN PLASTIC CONTAINER PRIMAXIN PRIMAXIN PRIMAXIN PRIMAXIN PRIMAXIN PRIMAXIN ALPHAREDISOL ELSPAR

Which sponsorname companies have the text LABS in their names and have products whose active ingredients (activeingred) include both ASPIRIN and CAFFEINE?

SponsorName WATSON LABS NOSTRUM LABS INC WATSON LABS WATSON LABS WATSON LABS DR REDDYS LABS SA

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

I would not have been able to answer these questions by just using the FDA website.

References

Week 8 https://edu.gcfglobal.org/en/access2016/designing-a-simple-query/1/ https://support.microsoft.com/en-us/office/create-edit-or-delete-a-relationship-dfa453a7-0b6d-4c34-a128-fdebc7e686af#:~:text=On%20the%20Database%20Tools%20tab,Relationships%20document%20tab%2C%20click%20Close. http://www.fda.gov/Drugs/InformationOnDrugs/ucm079750.htm

Acknowledgments

Dr. Dionisio helped in class. On 3/12/23 Dr. Dahlquist assisted me over Zoom, along with my classmates. Hailey Ivanson helped me zip my file to upload. Natalija Stojanovic helped me in class with my queries.

Except for what is noted above, this individual journal entry was completed by me and not copied from another source. Ckapla12 (talk) 21:24, 13 March 2024 (PDT)

Assignment Pages

• Week 1
• Week 2
• Week 3
• Week 4
• Week 5
• Week 6
• Week 8
• Week 9
• Week 10
• Week 11
• Week 12
• Week 13
• Week 14
• Week 15

Individual Journal Entry Pages

• ckaplan Week 1
• ckaplan Week 2
• SIR2 Week 3
• AgeAnnoMO Week 4
• ckaplan Week 5
• ckaplan Week 6
• ckaplan Week 8
• ckaplan Week 9
• ckaplan Week 10
• ckaplan Week 11
• ckaplan Week 12
• ckaplan Week 13
• ckaplan Week 14
• ckaplan Week 15

Shared Journal Entry Pages

• Class Journal Week 1
• Class Journal Week 2
• Class Journal Week 3
• Class Journal Week 4
• Class Journal Week 5
• Class Journal Week 6
• Class Journal Week 8
• Class Journal Week 9
• Class Journal Week 10