Imacarae Week 4
Jump to navigation
Jump to search
Contents
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
The steps in which the data was obtained, decompressed, created into a MS Access Database, and compressed are shown below.
- 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
- 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
- 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
- Compressed 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 (FDA):
- 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.
- To Dr. Dahlquist for assignment instructions as well as walking us through MS Access technicalities.
- 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 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].
