Marmas Week 4

Michael Armas' User Page
Weekly Pages	Individual Journals	Shared Journals
Week 1	Individual Journal Week 1	Class Journal Week 1
Week 2	Individual Journal Week 2	Class Journal Week 2
Week 3	Individual Journal Week 3	Class Journal Week 3
Week 4	Individual Journal Week 4	Class Journal Week 4
Week 5	Individual Journal Week 5	Class Journal Week 5
Week 6	Individual Journal Week 6	Class Journal Week 6
Week 7	Individual Journal Week 7	Class Journal Week 7
Week 8	Individual Journal Week 8	Class Journal Week 8
Week 9	Individual Journal Week 9	Class Journal Week 9
Week 10	Individual Journal Week 10	Class Journal Week 10
Week 11	Individual Journal Week 11	Class Journal Week 11
Week 12/13	Individual Journal Week 12/13	Class Journal Week 12/13
Week 15	Individual Journal Week 15	Class Journal Week 15

Certificate

Certificate of Completion

A Linkedin Learning module was Was completed on September 24th, 2019. The module is titled "Learning Access 2016" and was an informative session regarding Microsoft Access that proved helpful to complete this weeks individual journal assignment. The certificate of completion is pictured to the right

Purpose

This week, substance data from the FDA Drug Database was used to practice working with Microsoft Access. Navigation through the MS Access is crucial for the completion of this course.

Methods for Creating a Database

1. The FDA Drug Database was downloaded from the FDA's website. This data was received as a .zip file and was decompressed for use of its contents.
2. Microsoft Access was opened and a blank database was used as a starting template.
3. Plain text files (.txt) were uploaded to MS Access. For this assignment, three files were used: ActionTypes_Lookup.txt, ApplicationDocs.txt, and Products.txt.
   • Field names were detected, and no primary key was used.
   • For each file, come fields produced errors. As a temporary fix, the data types for these fields were changed to "short text."
4. A new query was created using the three data sets. Three windows appeared in the query manager.
5. To link two databases, two congruent fields, one from The ApplicationDocs.txt data set and one from the Products.txt data set, were linked. This was performed by dragging the field name of either data set onto the other data set.
6. A query was made by dragging the desired field from each of the data sets into the query organizer at the bottom of the page. The "Run" button was used to create the query.
7. Finally, the entire data base, including the three data sets and the query, were exported and zipped up.

Files

.zip File of Completed Database

Acknowledgements

I would like to thank Dr. Dahlquist for a walkthrough tutorial of MS Access and aiding in the completion of this assignment.
Except for what is noted above, this individual journal entry was completed by me and not copied from another source.
Marmas (talk) 22:31, 24 September 2019 (PDT)