Difference between revisions of "Mavila9 Week 4"
(upload in methods) |
(results and conclusion & acknowledgments & references) |
||
| Line 13: | Line 13: | ||
# Database file was compressed and uploaded to Wiki. | # Database file was compressed and uploaded to Wiki. | ||
| + | == Results == | ||
| + | * The following database was created: | ||
[[File:Mavila Week4Database.zip]] | [[File:Mavila Week4Database.zip]] | ||
| + | |||
| + | * The following certification was acquired: | ||
[[File:Mavila CertificateOfCompletion Learning Access 2016.pdf]] | [[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 == | ||
| + | |||
| + | [[https://www.linkedin.com/learning/learning-access-2016/next-steps?u=42252777]] accessed September 24, 2019. | ||
| + | |||
| + | Except for what is noted above, this individual journal entry was completed by me and not copied from another source. | ||
| + | |||
| + | [[User:Mavila9|Mavila9]] ([[User talk:Mavila9|talk]]) 23:08, 25 September 2019 (PDT) | ||
Revision as of 23:08, 25 September 2019
Contents
Individual Journal 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
- The Drugs@FDA Download File zip file was downloaded from [[1]].
- The zip file was decompressed by right clicking the file and choosing "Extract all..." from the menu.
- 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
- The relationships between the three tables were set to match the schema provided by the FDA.
- Database file was compressed and uploaded to Wiki.
Results
- The following database was created:
- 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
[[2]] accessed September 24, 2019.
Except for what is noted above, this individual journal entry was completed by me and not copied from another source.
