Dmadere Week 4 - Revision history

Dmadere: /* References */ linked to template page

2019-09-26T06:00:13Z

‎References: linked to template page

2019-09-26T05:57:56Z

‎Acknowledgements: added references section

2019-09-26T05:56:06Z

‎Microsoft Access Protocol: added acknowledgements

2019-09-26T05:49:32Z

‎Loading Data Tables: added to instructions

2019-09-26T05:48:14Z

‎Certificate: removed space

2019-09-26T05:48:04Z

switched around zip file

2019-09-26T05:47:38Z

‎Microsoft Access Protocol: added zip file to this section

2019-09-26T05:47:22Z

‎Certificate: removed zip from this section

2019-09-26T05:47:05Z

‎Creating A Database: added steps to creating a database

2019-09-26T05:45:44Z

‎Writing A Query: added more protocol

← Older revision		Revision as of 06:00, 26 September 2019
Line 47:		Line 47:
	== References ==		== References ==
	* Assignment protocol as listed by LMU BioDB 2019. (2019). Week 4. Retrieved September 25, 2019, from https://xmlpipedb.cs.lmu.edu/biodb/fall2019/index.php/Week_4		* Assignment protocol as listed by LMU BioDB 2019. (2019). Week 4. Retrieved September 25, 2019, from https://xmlpipedb.cs.lmu.edu/biodb/fall2019/index.php/Week_4
		+
		+	{{Template:Dmadere}}

← Older revision		Revision as of 05:57, 26 September 2019
Line 44:		Line 44:
	* I also worked on this project in class with [[User:kdahlquist\|Dr. Dahlquist]] where she provided us the knowledge we needed to complete the assignment.		* I also worked on this project in class with [[User:kdahlquist\|Dr. Dahlquist]] where she provided us the knowledge we needed to complete the assignment.
	* '''"Except for what is noted above, this individual journal entry was completed by me and not copied from another source."''' [[User:Dmadere\|Dmadere]] ([[User talk:Dmadere\|talk]]) 22:56, 25 September 2019 (PDT)		* '''"Except for what is noted above, this individual journal entry was completed by me and not copied from another source."''' [[User:Dmadere\|Dmadere]] ([[User talk:Dmadere\|talk]]) 22:56, 25 September 2019 (PDT)
		+
		+	== References ==
		+	* Assignment protocol as listed by 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 05:56, 26 September 2019
Line 38:		Line 38:
	# Drag specific items from the chart to the bottom of the Design Query page to add it to the field		# Drag specific items from the chart to the bottom of the Design Query page to add it to the field
	#* Do this for each linked item to see the resulting query		#* Do this for each linked item to see the resulting query
		+
		+	== Acknowledgements ==
		+	* I worked with my homework partner [[User:Ntesfaio\|Naomi]] this week in class to complete this assignment. We talked about the assignment in class and texted about it as well if anyone needed help.
		+	* I also consulted the LinkedIn learning page for any help with learning the Microsoft Access protocol. [[http://linkedin.com/learning/learning-access-2016/edit-queries-in-design-view?u=42252777 LinkedIn Learning]]
		+	* I also worked on this project in class with [[User:kdahlquist\|Dr. Dahlquist]] where she provided us the knowledge we needed to complete the assignment.
		+	* '''"Except for what is noted above, this individual journal entry was completed by me and not copied from another source."''' [[User:Dmadere\|Dmadere]] ([[User talk:Dmadere\|talk]]) 22:56, 25 September 2019 (PDT)

@@ Line 13: / Line 13: @@
 # Open Microsoft Access
 # Under the "External Data" tab at the top, select "Text file"
-# Browse and select the data to enter in the database
+# Browse and select the data to enter in the database (in this case, ActionTypes_Lookup)
 #* Make sure "Import the source data into a new table in the current database" is selected if there is not a table created yet in the database
 #* Select "Delimited", then "Next"
@@ Line 25: / Line 25: @@
 # Select "Finish", and then "Close"
 # Repeat steps listed above to load all FDA data
 === Writing A Query ===

@@ Line 1: / Line 1: @@
 == Certificate ==
 [[File:dmadere certificate.PDF|frameless|Certificate of Completion from the LinkedIn Learning Video about Microsoft Access]]
 == Microsoft Access Protocol ==

@@ Line 4: / Line 4: @@
 [[File:dmadere certificate.PDF|frameless|Certificate of Completion from the LinkedIn Learning Video about Microsoft Access]]
 [[File:Dmadere_FDA_database.zip]]
 === Creating A Database===
 # Open Microsoft Access

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

	[[File:dmadere certificate.PDF\|frameless\|Certificate of Completion from the LinkedIn Learning Video about Microsoft Access]]		[[File:dmadere certificate.PDF\|frameless\|Certificate of Completion from the LinkedIn Learning Video about Microsoft Access]]
−
−	~~[[File:Dmadere_FDA_database.zip]]~~

	== Microsoft Access Protocol ==		== Microsoft Access Protocol ==

@@ Line 33: / Line 33: @@
 #* Drag the "ApplicationDocsTypeID" title to the "ApplNo" title in the Products box to link those data sets
 #** The data will now show a connection between the linked sets
-# Drag the "ActionTypes_LookupID" to the chart at the bottom of the Design Query page to add it to the field
+# Drag specific items from the chart to the bottom of the Design Query page to add it to the field
-#* Do this for each linked item
+#* Do this for each linked item to see the resulting query