Difference between revisions of "Imacarae Week 4"
Jump to navigation
Jump to search
(→Data and Files: added zipped database file) |
(→Data and Files: added action types lookup) |
||
Line 24: | Line 24: | ||
===Scientific Conclusion=== | ===Scientific Conclusion=== | ||
===Data and Files=== | ===Data and Files=== | ||
− | *Text Files Imported into Database: | + | *Text Files Imported into Database: |
− | + | ::-[[Media:Imacarae_ActionTypes_Lookup.txt|ActionTypes Lookup]] | |
+ | ::- | ||
*[[Media:Imacarae_FDA_Database.zip|Zipped Microsoft Access FDA Database]] | *[[Media:Imacarae_FDA_Database.zip|Zipped Microsoft Access FDA Database]] | ||
Revision as of 15:27, 25 September 2019
Contents
LinkedIn Learning
- Learning Access 2016 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
- Import of Data onto Computer
- Download list of drugs from the [FDA Database]
- - Save to T-drive
- Unzip file:
- - Right-click on downloaded zipped file, click "7-Zip", click "Allow Access Here"
- Create Drugs Database in Microsoft Access
- Open Microsoft Access 2016
- Import Data:
- - Click file
- - Open Wizard
- Create Query
Scientific Conclusion
Data and Files
- Text Files Imported into Database:
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 discuss general directions 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].
- 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].