Week 4 Individual Journal

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"

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