Mavila9 Week 4

From LMU BioDB 2019
Jump to navigation Jump to search

Purpose

The purpose of this investigation was to practice creating a database using Microsoft Access and information provided by the U.S. Food & Drug Administration.

Methods

  1. The Drugs@FDA Download File zip file was downloaded from [[1]].
  2. The zip file was decompressed by right clicking the file and choosing "Extract all..." from the menu.
  3. The decompressed text files titled "ApplicationTypes_Lookup", "ApplicationDocs", and "Products" were imported to Microsoft Access. External Data > New Data Source > From File > Text File > Browse > *desired file* > Okay > Next > First Row Contains Field Names > Next > Choose my own primary key > Next > Finish > Close
  4. The relationships between the three tables were set to match the schema provided by the FDA.
  5. Database file was compressed and uploaded to Wiki.

Results

  • The following database was created:

File:Mavila Week4Database.zip

  • The following certification was acquired:

File:Mavila CertificateOfCompletion Learning Access 2016.pdf

Conclusion

The database of FDA approved drugs was created using Microsoft Access. This helped gain knowledge in using Microsoft Access for creating databases. In a future investigation it would be useful to create another database using different information to get practice defining the proper relationships between each table of information.

Acknowledgements

I would like to thank Dr. Dahlquist for teaching me how to properly upload the tables of information onto Microsoft Access. I would also like to thank my assignment partner John Nimmers-Minor.

References

FDA Data Files accessed September 24, 2019.

LinkedIn Learning accessed September 24, 2019.

Week 4 Assignment Page accessed September 19, 2019.

Except for what is noted above, this individual journal entry was completed by me and not copied from another source.

Mavila9 (talk) 23:08, 25 September 2019 (PDT)