Mavila9 Week 4

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

LinkedIn Learning accessed September 24, 2019.

FDA Data Files accessed September 24, 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)