MSymond1 Week 8
Jump to navigation
Jump to search
Purpose
The purpose of this assignment was to use Microsoft Access to gain experience with creating databases and creating queries in them. In this assignment, a dataset was used from the FDA, which was intended to give insight on how databases tend to be in the real world for all their imperfections.
Methods
This assignment included using a data set from the Food and Drug Administration (FDA) that has all of its public records about all of its drugs and other information regarding them. First, the files were downloaded from the FDA website and uncompressed. The 11 tables were then imported into Microsoft Access and the parameters of them were implemented, including whether they were integers, text, required, or primary keys.
