Dramir36 Week 4 - Revision history

Dramir36: references added

2019-09-26T03:49:26Z

references added

2019-09-26T03:47:29Z

‎Acknowledgments: signed

2019-09-26T03:47:11Z

‎Acknowledgments: added another Acknow.

2019-09-26T03:46:11Z

added Acknow.

2019-09-26T03:41:51Z

added resuts

2019-09-26T03:37:56Z

‎Methods: added more methods for ralationships

2019-09-26T03:25:56Z

Added all steps

2019-09-26T03:10:42Z

added purpose and developing methods

2019-09-19T22:07:49Z

added template

New page

← Older revision		Revision as of 03:49, 26 September 2019
Line 29:		Line 29:
	*Except for what is noted above, this individual journal entry was completed by me and not copied from another source.		*Except for what is noted above, this individual journal entry was completed by me and not copied from another source.
	[[User:Dramir36\|Dramir36]] ([[User talk:Dramir36\|talk]]) 20:47, 25 September 2019 (PDT)		[[User:Dramir36\|Dramir36]] ([[User talk:Dramir36\|talk]]) 20:47, 25 September 2019 (PDT)
		+
		+	==References==
		+	*LMU BioDB 2019. (2019). Week 4. Retrieved September 25, 2019, from https://xmlpipedb.cs.lmu.edu/biodb/fall2019/index.php/Week_4

← Older revision		Revision as of 03:47, 26 September 2019
Line 28:		Line 28:
	*I worked with my homework partner [[User:Cdomin12]] in class. We did not meet outside of class for the reason that we were able to complete our own individual journals outside of class.		*I worked with my homework partner [[User:Cdomin12]] in class. We did not meet outside of class for the reason that we were able to complete our own individual journals outside of class.
	*Except for what is noted above, this individual journal entry was completed by me and not copied from another source.		*Except for what is noted above, this individual journal entry was completed by me and not copied from another source.
		+	[[User:Dramir36\|Dramir36]] ([[User talk:Dramir36\|talk]]) 20:47, 25 September 2019 (PDT)

← Older revision		Revision as of 03:47, 26 September 2019
Line 26:		Line 26:

	==Acknowledgments==		==Acknowledgments==
−	I worked with my homework partner [[User:Cdomin12]] in class. We did not meet outside of class for the reason that we were able to complete our own individual journals outside of class.	+	*I worked with my homework partner [[User:Cdomin12]] in class. We did not meet outside of class for the reason that we were able to complete our own individual journals outside of class.
		+	*Except for what is noted above, this individual journal entry was completed by me and not copied from another source.

← Older revision		Revision as of 03:46, 26 September 2019
Line 24:		Line 24:
	==Results==		==Results==
	Zipped Microsoft Access FDA file can be found in the [[User:Dramir36]] page, under "Data and Files"		Zipped Microsoft Access FDA file can be found in the [[User:Dramir36]] page, under "Data and Files"
		+
		+	==Acknowledgments==
		+	I worked with my homework partner [[User:Cdomin12]] in class. We did not meet outside of class for the reason that we were able to complete our own individual journals outside of class.

← Older revision		Revision as of 03:41, 26 September 2019
Line 21:		Line 21:
	::*A pop-up window will appear, and there, the Tables that will be compared are chosen.		::*A pop-up window will appear, and there, the Tables that will be compared are chosen.
	::*Once the tables have been chosen, there will be lines connecting certain data information which means that the data is the same for that section of the table.		::*Once the tables have been chosen, there will be lines connecting certain data information which means that the data is the same for that section of the table.
		+
		+	==Results==
		+	Zipped Microsoft Access FDA file can be found in the [[User:Dramir36]] page, under "Data and Files"

← Older revision		Revision as of 03:37, 26 September 2019
Line 17:		Line 17:
	::*For the next page, if the data file already contains an unique ID for each row, then select "Choose my own primary key", if not, leave as is, and click "Next".		::*For the next page, if the data file already contains an unique ID for each row, then select "Choose my own primary key", if not, leave as is, and click "Next".
	::*Click on "Finish" to end the Import Text Wizard, and close the pop up window that follows.		::*Click on "Finish" to end the Import Text Wizard, and close the pop up window that follows.
		+	:3. Set the relationships between your tables to match the schema provided by the FDA.
		+	::*Under the "Tables" ribbon, click on "Relationships"
		+	::*A pop-up window will appear, and there, the Tables that will be compared are chosen.
		+	::*Once the tables have been chosen, there will be lines connecting certain data information which means that the data is the same for that section of the table.

← Older revision		Revision as of 03:25, 26 September 2019
Line 10:		Line 10:
	#Download and decompress the files.		#Download and decompress the files.
	#Import the data files into a Microsoft Access database that is to be created.		#Import the data files into a Microsoft Access database that is to be created.
		+	::*Click on the "External Data" ribbon, and in the "Import & Link category, click on "Text File"
		+	::*Browse the file that will be imported to the Access database
		+	::*Once file is chosen, click "Ok"
		+	::*For the first portion, default setting are fine, so click "Next". In the next portion, check the box stating "First Row Contains Field Names" since the FDA data files already contain the names. Click "Next"
		+	::*Default settings are ok for the next page. Click "Next"
		+	::*For the next page, if the data file already contains an unique ID for each row, then select "Choose my own primary key", if not, leave as is, and click "Next".
		+	::*Click on "Finish" to end the Import Text Wizard, and close the pop up window that follows.

← Older revision		Revision as of 03:10, 26 September 2019
Line 1:		Line 1:
	{{template:Dramir36}}		{{template:Dramir36}}
		+
		+
		+	==Purpose==
		+	*understand how to use the Microsoft Access software
		+	*use data from the FDA to find how data analysis is conducted using Microsoft Access
		+	*gain experience with database queries using Microsoft Access
		+
		+	==Methods==
		+	#Download and decompress the files.
		+	#Import the data files into a Microsoft Access database that is to be created.