Difference between revisions of "Imacarae Week 4"
Jump to navigation
Jump to search
(acknowledgments edited) |
(→Acknowledgments: expanded dr d) |
||
| (9 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | + | [[Image:Imacarae certificate.jpg|thumb|400px|LinkedIn Learning Certificate]] | |
| − | [[Image:Imacarae certificate.jpg| | ||
==FDA Drug Database== | ==FDA Drug Database== | ||
| Line 9: | Line 8: | ||
===Methods=== | ===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 | #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]] | #*Downloaded list of drugs from the [[https://www.fda.gov/drugs/drug-approvals-and-databases/drugsfda-data-files FDA Database]] | ||
| Line 29: | Line 29: | ||
#*Dragged desired components into lower table | #*Dragged desired components into lower table | ||
#*Ran Query | #*Ran Query | ||
| − | # | + | #Compressed MS Access file |
#*Right-clicked file | #*Right-clicked file | ||
#*Clicked "7-zip", clicked "Extract Here" | #*Clicked "7-zip", clicked "Extract Here" | ||
| Line 37: | Line 37: | ||
===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]] | ||
::-[[Media:Imacarae_Products.txt|Drug Products]] | ::-[[Media:Imacarae_Products.txt|Drug Products]] | ||
| − | *[[Media:Imacarae_FDA_Database.zip|Zipped Microsoft Access FDA Database]] | + | *[[Media:Imacarae_FDA_Database.zip|Imacarae's Zipped Microsoft Access FDA Database]] |
| − | *Written Query | + | *Written Query: |
<gallery mode=packed heights=250px> | <gallery mode=packed heights=250px> | ||
File:Imacaraeg_querydesign2.png||Query Design | File:Imacaraeg_querydesign2.png||Query Design | ||
| Line 52: | Line 52: | ||
==Acknowledgments== | ==Acknowledgments== | ||
*My partner, [[User: Jcowan4|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. | *My partner, [[User: Jcowan4|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. | ||
| − | *[[User:Kdahlquist|Dr. Dahlquist]] | + | *To [[User:Kdahlquist|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 | + | *Except with what is noted above, this individual journal entry was completed by me and not copied from another source. |
[[User:Imacarae|Imacarae]] ([[User talk:Imacarae|talk]]) 13:36, 25 September 2019 (PDT) | [[User:Imacarae|Imacarae]] ([[User talk:Imacarae|talk]]) 13:36, 25 September 2019 (PDT) | ||
| Line 59: | Line 59: | ||
==References== | ==References== | ||
*Bullet formatting provided by MediaWiki. Help:Formatting. (2019). Retrieved on September 25, 2019 from [[https://www.mediawiki.org/wiki/Help:Formatting https://www.mediawiki.org/wiki/Help:Formatting]]. | *Bullet formatting provided by MediaWiki. Help:Formatting. (2019). Retrieved on September 25, 2019 from [[https://www.mediawiki.org/wiki/Help:Formatting https://www.mediawiki.org/wiki/Help:Formatting]]. | ||
| − | *Photo gallery formatting provided by | + | *Photo gallery formatting provided by Wikipedia. Help:Gallery tag. (2019). Retrieved on September 2019 from [[https://en.wikipedia.org/wiki/Help:Gallery_tag 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 https://www.fda.gov/drugs/drug-approvals-and-databases/drugsfda-data-files]]. | *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 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 https://xmlpipedb.cs.lmu.edu/biodb/fall2019/index.php/Week_4]]. | *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 https://xmlpipedb.cs.lmu.edu/biodb/fall2019/index.php/Week_4]]. | ||
Latest revision as of 16:18, 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
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].
