Imacarae Week 4

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

1. 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

2. 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

3. 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

Data and Files

• Text Files Imported into Database:

-ActionTypes Lookup

-ApplicationDocs

-Drug Products

• 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].

Template

Imacarae's User Page

Assignment	Shared Entries	Individual Entries
Week 1	Class Journal Week 1	----
Week 2	Class Journal Week 2	Imacarae Week 2
Week 3	Class Journal Week 3	HSF1/YGL073W Week 3
Week 4	Class Journal Week 4	Imacarae Week 4
Week 5	Class Journal Week 5	CancerSEA Week 5
Week 6	Class Journal Week 6	Imacarae Week 6
Week 7	Class Journal Week 7	Imacarae Week 7
Week 8	Class Journal Week 8	Imacarae Week 8
Week 9	Class Journal Week 9	Imacarae Week 9
Week 10	Class Journal Week 10	Imacarae Week 10
Week 11	Sulfiknights	Imacarae Week 11
Week 12/13	Sulfiknights	Sulfiknights DA Week 12/13
----	Sulfiknights	Sulfiknights DA Week 14