Difference between revisions of "Imacarae Week 4"
Jump to navigation
Jump to search
(→Data and Files: added screenshots) |
(→Methods: updated methods) |
||
| Line 10: | Line 10: | ||
===Methods=== | ===Methods=== | ||
| − | # | + | #Imported Database Data onto Computer |
| − | #* | + | #*Downloaded list of drugs from the [[https://www.fda.gov/drugs/drug-approvals-and-databases/drugsfda-data-files FDA Database]] |
| − | #::- | + | #::- Saved to T-drive |
| − | #* | + | #*Decompressed file: |
| − | #::- Right- | + | #::- 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: | ||
#::- Click file | #::- Click file | ||
#::- Open Wizard | #::- Open Wizard | ||
Revision as of 15:47, 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
- 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:
- - Click file
- - Open Wizard
- Create Query
Scientific Conclusion
Data and Files
- Text Files Imported into Database:
- 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 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].
