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.

FDA Database

Compressed FDA 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"

Imported Tables

1. ActionType_Lookup 1
2. ApplicationDocs 2
3. Products 3

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

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]