Eyoung20 journal week 4 - Revision history

Eyoung20: /* References */ added references

2019-09-26T06:33:47Z

‎References: added references

2019-09-26T06:33:06Z

‎References: added references

2019-09-26T06:31:15Z

‎References: added acknowl

2019-09-26T06:30:42Z

‎Acknowledgements: added statement and signature

2019-09-26T06:29:13Z

‎Acknowledgements: added to acknowledgements

2019-09-26T06:21:48Z

‎Conclusion: added conclusion

2019-09-26T06:18:50Z

‎Started a Query in Microsoft Access: added steps and results to this section

2019-09-26T06:07:28Z

‎Uploaded Files to Microsoft Access: added steps and results

2019-09-26T05:46:11Z

‎Tested File in Excel: added information to section including steps and text

2019-09-26T05:38:22Z

‎Unzipped FDA File: added rest of the results

← Older revision		Revision as of 06:33, 26 September 2019
Line 56:		Line 56:
	*"Learning Access 2016" by Adam Wilbert (Released on May 4, 2016)		*"Learning Access 2016" by Adam Wilbert (Released on May 4, 2016)
	*The FDA site for approved drug data http://www.fda.gov/Drugs/InformationOnDrugs/ucm079750.htm		*The FDA site for approved drug data http://www.fda.gov/Drugs/InformationOnDrugs/ucm079750.htm
		+	*The [[Week 4]] instructions

← Older revision		Revision as of 06:33, 26 September 2019
Line 54:		Line 54:
	==References==		==References==
	*Microsoft Access		*Microsoft Access
		+	*"Learning Access 2016" by Adam Wilbert (Released on May 4, 2016)
		+	*The FDA site for approved drug data http://www.fda.gov/Drugs/InformationOnDrugs/ucm079750.htm

@@ Line 50: / Line 50: @@
 I would Like to acknowledge my homework partner Iliana Crespin [[User:Icrespin]] and the help she gave me with this assignment, which included helping me with figuring out how to unzip a file and how to use small things in Microsoft Access during class.
 I would also like to acknowledge Dr. Dahlquist [[User:Kdahlquist]] for her instruction on how to complete this exercise.
 ==References==

@@ Line 48: / Line 48: @@
 [[file:Eyoung_FDA_Database.zip]]
 ==Acknowledgements==
 ==References==

@@ Line 40: / Line 40: @@
 ==Conclusion==
 ==Data and Files==
 ===Certificate of Completion of Learning Access 2016===

← Older revision		Revision as of 06:18, 26 September 2019
Line 29:		Line 29:

	===Started a Query in Microsoft Access===		===Started a Query in Microsoft Access===
		+	*The next step was to create a Query.
		+	*The first step was to select the create tab, then to select Query Design.
		+	*This opened a new page for Query design.
		+	*Then you dragged the tables you wanted to run a query on from the side bar into the open top window.
		+	*This was done with ActionTypes_Lookup table, ApplicationDocs table, and Products table.
		+	*The ApplNo in ApplicationDocs and then in Products table were then linked, do to the fact that they were the same data.
		+	*Then the ApplNo from table ApplicationDocs was dragged down to the first spot in the bottom lined half of the page. This was followed by SubmissionType from ApplicationDocs in the second spot and DrugName from products in the third spot.
		+	*The run option was then selected to run the query.
		+	*The query then created a comparison of these three data forms from these tables.

	==Conclusion==		==Conclusion==

← Older revision		Revision as of 06:07, 26 September 2019
Line 21:		Line 21:

	===Uploaded Files to Microsoft Access===		===Uploaded Files to Microsoft Access===
		+	*After seeing the format in Excel Microsoft Access was found and opened.
		+	*A layout of a new Blank Desktop Database was selected and the file was named eyoung_FDA_Database.accdb
		+	*The access layout was then explained by Dr. Dahlquist.
		+	*Then a new table was formed under the instruction of Dr. Dahlquist by clicking the tab at the top labeled "External Data" then hitting the browse button. That then opened a window for searching though the computers files that ThawSpace(T:) drive was selected, The Folder FDW Drug Data was then opened and the file ActionTypes_Lookup.txt from the unzipped FDA file was selected. The first and default option on where and how to store the data was used. This then opened a wizard. In the first window the delimited format was chosen. Next the tab delimiter was selected as what separates the files. The field integers were then confirmed. The option used for the key was to select one manually, The ActionTypes_LookupID was selected. The table was then formed.
		+	* This was then repeated for ApplicationDocs.txt and Products.txt, except these did not have a key selected.
		+	*The result was three suctioning tables of data and a familiarity with adding tables to Microsoft Access.
		+
	===Started a Query in Microsoft Access===		===Started a Query in Microsoft Access===

@@ Line 16: / Line 16: @@
 ===Tested File in Excel===
 ===Uploaded Files to Microsoft Access===
 ===Started a Query in Microsoft Access===

@@ Line 13: / Line 13: @@
 *The file was then unzipped in order to change it to an accessible version of the data
 *Unzipping the file was done by right clicking the file then using the 7zip from the selection menu and then using the "Add to Archive function to unzip the file
-*The results were 11 now accesable files titled: ActionTypes_lookup.txt, ApplicationDocs.txt
+*The results were 11 now accesable files titled: ActionTypes_lookup.txt, ApplicationDocs.txt, Applications.txt, ApplicationsDocsType_Lookup.txt, MarketingStatus.txt, Marketingstatus_lookup.txt, Product.txt, SubmissionClass_Lookup.txt, SubmissionPropertyType.txt, submissions.txt, and TE.txt.
 ===Tested File in Excel===