Cdomin12 Week 4 - Revision history

Cdomin12: /* Datas and Files */ took out the s in datas

2019-09-26T05:51:25Z

‎Datas and Files: took out the s in datas

Cdomin12: deleted purposes

2019-09-26T05:51:09Z

deleted purposes

Cdomin12: invoke template

2019-09-25T03:12:52Z

invoke template

Cdomin12: /* File Download and Decompress */ edit titel

2019-09-25T03:06:24Z

‎File Download and Decompress: edit titel

Cdomin12: /* Methods */ capitalize everything

2019-09-25T03:06:07Z

‎Methods: capitalize everything

Cdomin12: /* Acknowledgments */ add

2019-09-25T03:04:54Z

‎Acknowledgments: add

Cdomin12: /* Results */ delete this section

2019-09-25T03:03:55Z

‎Results: delete this section

Cdomin12: /* Performing Query */ add image

2019-09-25T03:02:14Z

‎Performing Query: add image

Cdomin12: /* Microsoft Access File Upload */ compress

2019-09-25T02:55:30Z

‎Microsoft Access File Upload: compress

Cdomin12: /* File Download and Decompress */ access

2019-09-25T02:46:38Z

‎File Download and Decompress: access

@@ Line 38: / Line 38: @@
 *Click 7zip --> add to archive --> zip --> okay
-==Datas and Files==
+==Data and Files==
 [[File:CdominFDAdatabase.zip]]

@@ Line 4: / Line 4: @@
 [[File:Cdomin12certificate.pdf]]
 ==Methods==
@@ Line 39: / Line 37: @@
 *Go back to the T: drive and right click on your file from Microsoft access
 *Click 7zip --> add to archive --> zip --> okay
 ==Datas and Files==

← Older revision		Revision as of 03:12, 25 September 2019
Line 1:		Line 1:
		+	{{template:cdomin12}}
		+
	==Certificate==		==Certificate==

@@ Line 14: / Line 14: @@
 *Go to settings --> show advanced settings --> downloads --> change to T:drive --> okay
-===File Download and Decompress===
+===File Download and Decompress File===
 *Download file from insert website
 *Open the file in T: drive

@@ Line 8: / Line 8: @@
 ===Turn on File Extension===
-*search "File Explorer Options" --> view --> uncheck "hide extensions for known file types" --> okay
+*Search "File Explorer Options" --> view --> uncheck "hide extensions for known file types" --> okay
 ===Setting Download Options for Chrome===
 *Open Chrome
-*Go to settings --> show advanced settings ==> downloads --> change to T:drive --> okay
+*Go to settings --> show advanced settings --> downloads --> change to T:drive --> okay
 ===File Download and Decompress===
-*download file from insert website
+*Download file from insert website
-*open the file in T: drive
+*Open the file in T: drive
-*right click on file --> 7- zip --> extract files
+*Right click on file --> 7- zip --> extract files
 ===Microsoft Access File Upload===
-*open up Microsoft Access
+*Open up Microsoft Access
-*open blank desktop database and save file as nameFDAdatabase
+*Open blank desktop database and save file as "nameFDAdatabase"
-*click on external data tab --> text file --> choose first file from FDA data --> click ok --> next --> check off first row contains field names --> next --> next --> choose primary key depending on type of data --> next --> finish --> close
+*Click on external data tab --> text file --> choose first file from FDA data --> click ok --> next --> check off first row contains field names --> next --> next --> choose primary key depending on type of data --> next --> finish --> close
 *Repeat this process until all 10 files are uploaded to access
 ===Performing Query===
-*select the create tab
+*Select the create tab
-*click on Query Design
+*Click on Query Design
-*choose tables that you want to be a part of your query ex. Products and ApplicationDocs
+*Choose tables that you want to be a part of your query ex. Products and ApplicationDocs
-*drag each upload into table below
+*Drag each upload into table as shown in image below:
 [[Image:Cdominimage.png||600px]]
-*select run on top left of screen
+*Select run on top left of screen
 *A Query should appear
 ===Compress File===
 *Go back to the T: drive and right click on your file from Microsoft access
-* click 7zip --> add to archive --> zip --> okay
+*Click 7zip --> add to archive --> zip --> okay
 ==Scientific Conclusion==

@@ Line 44: / Line 44: @@
 ==Acknowledgments==
-#I worked with
+#I worked with [[user:Dramir36]] in class when working through uploading the file tables onto Microsoft Access
 #"Except for what is noted above, this individual journal entry was completed by me and not copied from another source."
 [[User:Cdomin12|Cdomin12]] ([[User talk:Cdomin12|talk]]) 11:55, 24 September 2019 (PDT)