Imacarae Week 4

LinkedIn Learning Certificate

FDA Drug Database

Purpose

• To learn the benefit of using Microsoft Access for data organization as opposed to Excel.
• To learn how to create a database with large amounts of data.
• To create personalized data queries.

Methods

1. Imported Database Data onto Computer
   • Downloaded list of drugs from the [FDA Database]

   - Saved to T-drive

   • Decompressed file:

   - Right-clicked on downloaded zipped file, clicked "7-Zip", clicked "Add to archive"

   - Selected zip format

2. Created Drugs Database in Microsoft Access
   • Opened Microsoft Access 2016
   • Imported Data to MS Access:

   - Selected "External Data" tab, clicked "Text File"

   - Selected "ApplicationTypes_Lookup" text file from computer

   - Ensured first rows contained Field Names, "Data Type" adjusted appropriately, and "Primary Keys" chosen appropriately

   • Repeat steps with "ApplicationDocs" and "Products" text files
3. Created Query
   • Selected "Create" tab
   • Selected "Query Design"
   • Selected ApplicationTypes_Lookup, ApplicationDocs, and Products tables
   • Connected related components
   • Dragged desired components into lower table
   • Ran Query
4. Zipped MS Access file
   • Right-clicked file
   • Clicked "7-zip", clicked "Extract Here"

Scientific Conclusion

The main finding of today's lab was observing the organizational framework of Microsoft Access. The purposes of the lab were all fulfilled because there was hands-on experience with forming a database with a large sample of data. Tables as well as queries were successfully created.

Data and Files

• Text Files Imported into Database:

-ActionTypes Lookup

-ApplicationDocs

-Drug Products

• Imacarae's Zipped Microsoft Access FDA Database
• Written Query

• 

  Query Design

• 

  ApplicationDocs

• 

  ActionTypes

• 

  Products

Acknowledgments

• My partner, Jonar Cowan, and I met during class to talk about the steps needed to complete assignment. We met briefly outside of class to address general questions for the assignment.
• Dr. Dahlquist, for assignment instructions.
• Except with what is noted above, this individual journal entry was completed by me and not copied from another source

Imacarae (talk) 13:36, 25 September 2019 (PDT)

References

• Bullet formatting provided by MediaWiki. Help:Formatting. (2019). Retrieved on September 25, 2019 from [https://www.mediawiki.org/wiki/Help:Formatting].
• Photo gallery formatting provided by WikiHelp. Wikipedia. Help:Gallery tag. (2019). Retrieved on September 2019 from [https://en.wikipedia.org/wiki/Help:Gallery_tag].
• FDA Database provided by U.S. Food & Drug Administration. Drugs@FDA Data Files. (2019). Retrieved on September 25, 2019 from [https://www.fda.gov/drugs/drug-approvals-and-databases/drugsfda-data-files].
• Assignment instructions provided by LMU BioDB 2019. (2019). Week 4. Retrieved September 25, 2019 from [https://xmlpipedb.cs.lmu.edu/biodb/fall2019/index.php/Week_4].

Template

Imacarae's User Page

Assignment	Shared Entries	Individual Entries
Week 1	Class Journal Week 1	----
Week 2	Class Journal Week 2	Imacarae Week 2
Week 3	Class Journal Week 3	HSF1/YGL073W Week 3
Week 4	Class Journal Week 4	Imacarae Week 4
Week 5	Class Journal Week 5	CancerSEA Week 5
Week 6	Class Journal Week 6	Imacarae Week 6
Week 7	Class Journal Week 7	Imacarae Week 7
Week 8	Class Journal Week 8	Imacarae Week 8
Week 9	Class Journal Week 9	Imacarae Week 9
Week 10	Class Journal Week 10	Imacarae Week 10
Week 11	Sulfiknights	Imacarae Week 11
Week 12/13	Sulfiknights	Sulfiknights DA Week 12/13
----	Sulfiknights	Sulfiknights DA Week 14