Difference between revisions of "Marmas Week 4"
Jump to navigation
Jump to search
(changed alignment to right for room for description) |
(added template) |
||
| (14 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
| − | + | [[Category:Journal Entry]] | |
| + | {{marmas}} | ||
| + | ==Certificate== | ||
[[Image:Marmas_CertificateImage.png|thumb|right|500px|Certificate of Completion]] | [[Image:Marmas_CertificateImage.png|thumb|right|500px|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== | ||
| + | #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. | ||
| + | #Microsoft Access was opened and a blank database was used as a starting template. | ||
| + | #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." | ||
| + | #A new query was created using the three data sets. Three windows appeared in the query manager. | ||
| + | #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. | ||
| + | #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. | ||
| + | #Finally, the entire data base, including the three data sets and the query, were exported and zipped up. | ||
| + | ==Files== | ||
| + | [[Media:Marmas_FDADatabase.zip| .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.<br> | ||
| + | '''Except for what is noted above, this individual journal entry was completed by me and not copied from another source.'''<br> | ||
| + | [[User:Marmas|Marmas]] ([[User talk:Marmas|talk]]) 22:31, 24 September 2019 (PDT) | ||
Latest revision as of 20:11, 25 September 2019
Certificate
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
- 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.
- Microsoft Access was opened and a blank database was used as a starting template.
- 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."
- A new query was created using the three data sets. Three windows appeared in the query manager.
- 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.
- 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.
- 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)
