Difference between revisions of "Imacarae Week 4"
Jump to navigation
Jump to search
(moved certificate position) |
(→Data and Files: credited fda) |
||
| Line 36: | Line 36: | ||
===Data and Files=== | ===Data and Files=== | ||
| − | *Text Files Imported into Database: | + | *Text Files Imported into Database (FDA): |
::-[[Media:Imacarae_ActionTypes_Lookup.txt|ActionTypes Lookup]] | ::-[[Media:Imacarae_ActionTypes_Lookup.txt|ActionTypes Lookup]] | ||
::-[[Media:Imacarae_ApplicationDocs.txt|ApplicationDocs]] | ::-[[Media:Imacarae_ApplicationDocs.txt|ApplicationDocs]] | ||
Revision as of 16:11, 25 September 2019
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
- 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
- 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 (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.
- 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].
