Week 4 Individual Journal

Purpose

The purpose of the assignment was to familiarize students with utilizing Microsoft Access 2016 so that students could create a model of the FDA Drug Database.

Methods for Creating the Database

1. Loaded Microsoft Access 2016
2. Created a blank database and named the file
3. Downloaded FDA data and decompressed the files
4. Imported the text files into Access
   1. pressed external data tab
   2. import text files
   3. selected the corresponding files to upload
   4. in the Import Text Wizard window
      1. select "delimited"
      2. select "Tab" and check the box labeled "First Row Contains Field Names"
      3. select the data type for the corresponding field
      4. select "No primary key"
      5. select "Finish"

Results

A database was successfully created on Microsoft Access with some of the files downloaded from the FDA Drug Database. The files listed below were compiled into tables on the database and a query was created with field names from each of these tables.

FDA Database

Compressed FDA Database

Data and Files

1. ActionTypes_Lookup
2. ApplicationDocs
3. Products

Query

The first query consisted of the following:

• "AppINo" from the ApplicationDoc Table
• "Submission Type" from the ApplicationDoc Table
• "Product Name" from the Products Table

Conclusion

Ultimately, the assignment introduced me to a more manageable method of organizing and manipulating large stores of data than Microsoft Excel while also helping me comprehend how relevant such databases are to my everyday life.

Ymesfin

Main Page

Ymesfin

Week 1

Week 2

Week 3

Week 4

Week 5

Week 6

Week 7

Week 8

Week 9

Week 10

Week 11

Skinny Genes

Week 12

Week 13

Week 14

Week 15

Acknowledgements

Dr. Dahlquist; Professor

Michael Armas; Homework partner

Except for what is noted above, this individual journal entry was completed by me and not copied from another source. Ymesfin (talk) 11:07, 25 September 2019 (PDT)

References

Microsoft Access 2016.(2016).

Drugs@FDA Data Files.(2019). Retrieved from [| https://www.fda.gov/drugs/drug-approvals-and-databases/drugsfda-data-files]

Instructions for Week 4 assignment provided by LMU BioDB 2019. (2019). Week 4. Retrieved September 25, 2019, from [https://xmlpipedb.cs.lmu.edu/biodb/fall2019/index.php/Week_4]