Jnimmers Week 4 - Revision history

Jnimmers: Invoke template

2019-09-26T02:54:41Z

Invoke template

Jnimmers: Add query steps

2019-09-26T02:54:08Z

Add query steps

Jnimmers: Another bullet

2019-09-26T02:47:15Z

Another bullet

Jnimmers: Bullet

2019-09-26T02:47:01Z

Bullet

Jnimmers: fixed photo

2019-09-26T02:46:00Z

fixed photo

Jnimmers: Fixed formatting

2019-09-26T02:45:11Z

Fixed formatting

Jnimmers: References

2019-09-26T02:42:15Z

References

Jnimmers: update acknowledgements

2019-09-26T02:40:42Z

update acknowledgements

Jnimmers: Updates pictures, acknowledgement section

2019-09-26T02:39:01Z

Updates pictures, acknowledgement section

Jnimmers: Data and Files

2019-09-26T02:25:50Z

Data and Files

← Older revision		Revision as of 02:54, 26 September 2019
Line 43:		Line 43:
	=== References ===		=== References ===
	*Week 4 Assignment Page: LMU BioDB 2019. (2019). Week 4. Retrieved September 5th, 2019, from https://xmlpipedb.cs.lmu.edu/biodb/fall2019/index.php/Week_4		*Week 4 Assignment Page: LMU BioDB 2019. (2019). Week 4. Retrieved September 5th, 2019, from https://xmlpipedb.cs.lmu.edu/biodb/fall2019/index.php/Week_4
		+
		+	{{Jnimmers}}

@@ Line 15: / Line 15: @@
 *Once my database was formatted correctly, I created relationships among my tables to show how each table corresponded with the other tables in the database. To do this,I clicked on the "Database Tools" tab and and selected "Relationships". This will open up a new page with a list of your current tables. From here, you can select all of your relevant tables by pressing Control on your keyboard while clicking on each individual table that you want to make a relationship for another table. The tables will pop up and the menu will disappear, giving you each table' field headers. From here, you want to connect tables by clicking and dragging on a field header from one box and overlapping it with another field header with the same name in a different table box. This pulls up a menu for you to confirm that you're making the right connection, if the field headers are identical then you can confirm the relationship and do the same process for the other fields that have relationships in separate tables. These relationships establish a connection between categories in one table and confirming that they're the same categories in a separate table. [[File:JnimmersDatabaseinstruction2.png|thumb| Example of Relationships Tab and Confirmation of Relationship Creation]].
 *From here, you should be done! Your tables are now relationship verified, formatted, and contain all necessary data provided by the FDA in a neat compilation. Be sure to Save your work under the "File" tab. Select "Save as", put it in a safe and simple place to find, name it appropriately, and do any last minute edits that you may like to spruce up your database and make it unique.
 ===Scientific Conclusion===

@@ Line 13: / Line 13: @@
 *In order to make sure that all Field Names and product names/ingredients are visible, hover your mouse over the right edge of the column you want to edit. A two sided arrow should appear,  indicating you can now edit the column length. Click and hold down at that point and drag you mouse left or right to adjust the size of your column in order to allow for all words to be properly viewed, including the field header.
 '''Task 4'''
-Once my database was formatted correctly, I created relationships among my tables to show how each table corresponded with the other tables in the database. To do this,I clicked on the "Database Tools" tab and and selected "Relationships". This will open up a new page with a list of your current tables. From here, you can select all of your relevant tables by pressing Control on your keyboard while clicking on each individual table that you want to make a relationship for another table. The tables will pop up and the menu will disappear, giving you each table' field headers. From here, you want to connect tables by clicking and dragging on a field header from one box and overlapping it with another field header with the same name in a different table box. This pulls up a menu for you to confirm that you're making the right connection, if the field headers are identical then you can confirm the relationship and do the same process for the other fields that have relationships in separate tables. These relationships establish a connection between categories in one table and confirming that they're the same categories in a separate table. [[File:JnimmersDatabaseinstruction2.png|thumb| Example of Relationships Tab and Confirmation of Relationship Creation]].
+*Once my database was formatted correctly, I created relationships among my tables to show how each table corresponded with the other tables in the database. To do this,I clicked on the "Database Tools" tab and and selected "Relationships". This will open up a new page with a list of your current tables. From here, you can select all of your relevant tables by pressing Control on your keyboard while clicking on each individual table that you want to make a relationship for another table. The tables will pop up and the menu will disappear, giving you each table' field headers. From here, you want to connect tables by clicking and dragging on a field header from one box and overlapping it with another field header with the same name in a different table box. This pulls up a menu for you to confirm that you're making the right connection, if the field headers are identical then you can confirm the relationship and do the same process for the other fields that have relationships in separate tables. These relationships establish a connection between categories in one table and confirming that they're the same categories in a separate table. [[File:JnimmersDatabaseinstruction2.png|thumb| Example of Relationships Tab and Confirmation of Relationship Creation]].
 *From here, you should be done! Your tables are now relationship verified, formatted, and contain all necessary data provided by the FDA in a neat compilation. Be sure to Save your work under the "File" tab. Select "Save as", put it in a safe and simple place to find, name it appropriately, and do any last minute edits that you may like to spruce up your database and make it unique.
 ===Scientific Conclusion===
 *This project was given in order to learn the basic structure and function of the Microsoft Access program. It is meant to equip  me with the skill and knowledge of how to operate the system and sue it to create a database of my own using pre-made data fro the FDA. In terms of learning, I feel that I learned a lot from this program, and I think it can be a useful asset for anyone in the working world; it allows for organization at a level that can't be done with pen and paper, and it can store far more information than Excel, making it more optimal for a work or company setting, which can be useful for almost anyone.

@@ Line 16: / Line 16: @@
 *From here, you should be done! Your tables are now relationship verified, formatted, and contain all necessary data provided by the FDA in a neat compilation. Be sure to Save your work under the "File" tab. Select "Save as", put it in a safe and simple place to find, name it appropriately, and do any last minute edits that you may like to spruce up your database and make it unique.
 ===Scientific Conclusion===
-This project was given in order to learn the basic structure and function of the Microsoft Access program. It is meant to equip  me with the skill and knowledge of how to operate the system and sue it to create a database of my own using pre-made data fro the FDA. In terms of learning, I feel that I learned a lot from this program, and I think it can be a useful asset for anyone in the working world; it allows for organization at a level that can't be done with pen and paper, and it can store far more information than Excel, making it more optimal for a work or company setting, which can be useful for almost anyone.
+*This project was given in order to learn the basic structure and function of the Microsoft Access program. It is meant to equip  me with the skill and knowledge of how to operate the system and sue it to create a database of my own using pre-made data fro the FDA. In terms of learning, I feel that I learned a lot from this program, and I think it can be a useful asset for anyone in the working world; it allows for organization at a level that can't be done with pen and paper, and it can store far more information than Excel, making it more optimal for a work or company setting, which can be useful for almost anyone.
 ===Data and Files===
 *File:Jnimmers Certificate.png|thumb| Certificate of Completion from LinkedIn Learning

@@ Line 13: / Line 13: @@
 *In order to make sure that all Field Names and product names/ingredients are visible, hover your mouse over the right edge of the column you want to edit. A two sided arrow should appear,  indicating you can now edit the column length. Click and hold down at that point and drag you mouse left or right to adjust the size of your column in order to allow for all words to be properly viewed, including the field header.
 '''Task 4'''
-Once my database was formatted correctly, I created relationships among my tables to show how each table corresponded with the other tables in the database. To do this,I clicked on the "Database Tools" tab and and selected "Relationships". This will open up a new page with a list of your current tables. From here, you can select all of your relevant tables by pressing Control on your keyboard while clicking on each individual table that you want to make a relationship for another table. The tables will pop up and the menu will disappear, giving you each table' field headers. From here, you want to connect tables by clicking and dragging on a field header from one box and overlapping it with another field header with the same name in a different table box. This pulls up a menu for you to confirm that you're making the right connection, if the field headers are identical then you can confirm the relationship and do the same process for the other fields that have relationships in separate tables. These relationships establish a connection between categories in one table and confirming that they're the same categories in a separate table. [[File:JnimmersDatabaseinstruction1.png|thumb| Example of Relationships Tab and Confirmation of Relationship Creation]].
+Once my database was formatted correctly, I created relationships among my tables to show how each table corresponded with the other tables in the database. To do this,I clicked on the "Database Tools" tab and and selected "Relationships". This will open up a new page with a list of your current tables. From here, you can select all of your relevant tables by pressing Control on your keyboard while clicking on each individual table that you want to make a relationship for another table. The tables will pop up and the menu will disappear, giving you each table' field headers. From here, you want to connect tables by clicking and dragging on a field header from one box and overlapping it with another field header with the same name in a different table box. This pulls up a menu for you to confirm that you're making the right connection, if the field headers are identical then you can confirm the relationship and do the same process for the other fields that have relationships in separate tables. These relationships establish a connection between categories in one table and confirming that they're the same categories in a separate table. [[File:JnimmersDatabaseinstruction2.png|thumb| Example of Relationships Tab and Confirmation of Relationship Creation]].
 *From here, you should be done! Your tables are now relationship verified, formatted, and contain all necessary data provided by the FDA in a neat compilation. Be sure to Save your work under the "File" tab. Select "Save as", put it in a safe and simple place to find, name it appropriately, and do any last minute edits that you may like to spruce up your database and make it unique.
 ===Scientific Conclusion===

@@ Line 15: / Line 15: @@
 Once my database was formatted correctly, I created relationships among my tables to show how each table corresponded with the other tables in the database. To do this,I clicked on the "Database Tools" tab and and selected "Relationships". This will open up a new page with a list of your current tables. From here, you can select all of your relevant tables by pressing Control on your keyboard while clicking on each individual table that you want to make a relationship for another table. The tables will pop up and the menu will disappear, giving you each table' field headers. From here, you want to connect tables by clicking and dragging on a field header from one box and overlapping it with another field header with the same name in a different table box. This pulls up a menu for you to confirm that you're making the right connection, if the field headers are identical then you can confirm the relationship and do the same process for the other fields that have relationships in separate tables. These relationships establish a connection between categories in one table and confirming that they're the same categories in a separate table. [[File:JnimmersDatabaseinstruction1.png|thumb| Example of Relationships Tab and Confirmation of Relationship Creation]].
 *From here, you should be done! Your tables are now relationship verified, formatted, and contain all necessary data provided by the FDA in a neat compilation. Be sure to Save your work under the "File" tab. Select "Save as", put it in a safe and simple place to find, name it appropriately, and do any last minute edits that you may like to spruce up your database and make it unique.
+===Scientific Conclusion===
 This project was given in order to learn the basic structure and function of the Microsoft Access program. It is meant to equip  me with the skill and knowledge of how to operate the system and sue it to create a database of my own using pre-made data fro the FDA. In terms of learning, I feel that I learned a lot from this program, and I think it can be a useful asset for anyone in the working world; it allows for organization at a level that can't be done with pen and paper, and it can store far more information than Excel, making it more optimal for a work or company setting, which can be useful for almost anyone.
 ===Data and Files===
 *File:Jnimmers Certificate.png|thumb| Certificate of Completion from LinkedIn Learning
 *File:JnimmersFDAProducts.zip |FDA Database
@@ Line 26: / Line 24: @@
 *http://www.fda.gov/Drugs/InformationOnDrugs/ucm079750.htm | FDA Drug Information Website
-==== Acknowledgments ====
+===Acknowledgements===
 * I would like to thank Dr. Kam Dahlquist for her introduction of the Microsoft Access Software as well as instruction on how to access it and information on learning the database system as well
 * Thank you to LinkedIn Learning for assisting and teaching how to create a successful database [[https://www.linkedin.com/learning/me?u=42252777]]
@@ Line 33: / Line 31: @@
 "Except for what is noted above, this individual journal entry was completed by me and not copied from another source." [[User:Jnimmers|Jnimmers]] ([[User talk:Jnimmers|talk]]) 19:39, 25 September 2019 (PDT)
-==== References ====
+=== References ===
 *Week 4 Assignment Page: LMU BioDB 2019. (2019). Week 4. Retrieved September 5th, 2019, from https://xmlpipedb.cs.lmu.edu/biodb/fall2019/index.php/Week_4

← Older revision		Revision as of 02:42, 26 September 2019
Line 34:		Line 34:

	==== References ====		==== References ====
−		+	*Week 4 Assignment Page: LMU BioDB 2019. (2019). Week 4. Retrieved September 5th, 2019, from https://xmlpipedb.cs.lmu.edu/biodb/fall2019/index.php/Week_4
−	*~~In this section, you need to provide properly formatted citations to any '''''content''''' that was not entirely of your own devising. This includes, but is not limited to:~~
−	** methods
−	** data
−	** facts
−	** images
−	** documents, including the scientific literature
−	* Do not include extraneous references that you do not cite or use on your page.
−	* The references in this section should be accompanied by ''in text citations'' on your page that refer to these references.
−	* The references should be formatted according to the [https://owl.purdue.edu/owl/research_and_citation/using_research/documents/20180719CitationChart.pdf APA guidelines].
−	* For more detailed guidelines, please see the document [[Media:BIOL367_Fall2019_GuidelinesforLiteratureCitations.pdf \| Guidelines for Literature Citations in a Scientific Paper]] that you were given on the first day of class.
−	* Cite the appropriate weekly Assignment page. For example, the citation for the [[Week ~~1]]~~ Assignment ~~page is~~: LMU BioDB 2019. (2019). Week 1. Retrieved ~~August 27~~, 2019, from https://xmlpipedb.cs.lmu.edu/biodb/fall2019/index.php/~~Week_1~~
−	* Even if you have nothing else to cite, the References section must be present and include the citation to the appropriate weekly assignment page.

@@ Line 9: / Line 9: @@
 *From there, I found the files that contained relative data and extracted them from their .zip folder by finding a simple area to extract, right-clicking the folder, and selecting "Extract All" from the drop-down menu.
 '''Task 2'''
-*Once the Text documents had been downloaded, I went into Microsoft (MS) Access and, under the "External Data" tab, I selected the "Import Text File" option and found the files that needed to be imported from the FDA folder. Each file imported will create a new table. The list of these tables can be found on the left side of the screen in MS Access. Most formatting was done automatically by Access, however, make sure to check the box that says "First Row Contains Field Names", it will allow for the automatic formatting of your column names. This makes the inclusion of IDs easier because if you delete an ID row, it forces you to start the process of importing over so that your first row doesn't start as ID:2. [[File:Database instruction1.png|thumb| Example of Access and highlighting of Text File Importing Button]]
+*Once the Text documents had been downloaded, I went into Microsoft (MS) Access and, under the "External Data" tab, I selected the "Import Text File" option and found the files that needed to be imported from the FDA folder. Each file imported will create a new table. The list of these tables can be found on the left side of the screen in MS Access. Most formatting was done automatically by Access, however, make sure to check the box that says "First Row Contains Field Names", it will allow for the automatic formatting of your column names. This makes the inclusion of IDs easier because if you delete an ID row, it forces you to start the process of importing over so that your first row doesn't start as ID:2. [[File:JnimmersDatabaseinstruction1.png|thumb| Example of Access and highlighting of Text File Importing Button]]
 '''Task 3'''
 *In order to make sure that all Field Names and product names/ingredients are visible, hover your mouse over the right edge of the column you want to edit. A two sided arrow should appear,  indicating you can now edit the column length. Click and hold down at that point and drag you mouse left or right to adjust the size of your column in order to allow for all words to be properly viewed, including the field header.
 '''Task 4'''
-Once my database was formatted correctly, I created relationships among my tables to show how each table corresponded with the other tables in the database. To do this,I clicked on the "Database Tools" tab and and selected "Relationships". This will open up a new page with a list of your current tables. From here, you can select all of your relevant tables by pressing Control on your keyboard while clicking on each individual table that you want to make a relationship for another table. The tables will pop up and the menu will disappear, giving you each table' field headers. From here, you want to connect tables by clicking and dragging on a field header from one box and overlapping it with another field header with the same name in a different table box. This pulls up a menu for you to confirm that you're making the right connection, if the field headers are identical then you can confirm the relationship and do the same process for the other fields that have relationships in separate tables. These relationships establish a connection between categories in one table and confirming that they're the same categories in a separate table. [[File:Database instruction2.png|thumb| Example of Relationships Tab and Confirmation of Relationship Creation]].
+Once my database was formatted correctly, I created relationships among my tables to show how each table corresponded with the other tables in the database. To do this,I clicked on the "Database Tools" tab and and selected "Relationships". This will open up a new page with a list of your current tables. From here, you can select all of your relevant tables by pressing Control on your keyboard while clicking on each individual table that you want to make a relationship for another table. The tables will pop up and the menu will disappear, giving you each table' field headers. From here, you want to connect tables by clicking and dragging on a field header from one box and overlapping it with another field header with the same name in a different table box. This pulls up a menu for you to confirm that you're making the right connection, if the field headers are identical then you can confirm the relationship and do the same process for the other fields that have relationships in separate tables. These relationships establish a connection between categories in one table and confirming that they're the same categories in a separate table. [[File:JnimmersDatabaseinstruction1.png|thumb| Example of Relationships Tab and Confirmation of Relationship Creation]].
 *From here, you should be done! Your tables are now relationship verified, formatted, and contain all necessary data provided by the FDA in a neat compilation. Be sure to Save your work under the "File" tab. Select "Save as", put it in a safe and simple place to find, name it appropriately, and do any last minute edits that you may like to spruce up your database and make it unique.
@@ Line 20: / Line 20: @@
 ==== Data and Files ====
-* [[File:Jnimmers Certificate.png|thumb| Certificate of Completion from LinkedIn Learning ]]
+*File:Jnimmers Certificate.png|thumb| Certificate of Completion from LinkedIn Learning
-*[[File:JnimmersFDAProducts.zip |FDA Database]]
+*File:JnimmersFDAProducts.zip |FDA Database
-*[[File:Database instruction1.png|thumb| Example of Access and highlighting of Text File Importing Button]]
+*File:Database File:JnimmersDatabaseinstruction1.png|thumb| Example of Access and highlighting of Text File Importing Button
-*[[File:Database instruction2.png|thumb| Example of Relationships Tab and Confirmation of Relationship Creation]]
+*File:Database File:JnimmersDatabaseinstruction2.png|thumb| Example of Relationships Tab and Confirmation of Relationship Creation
-*[[http://www.fda.gov/Drugs/InformationOnDrugs/ucm079750.htm | FDA Drug Information Website]]
+*http://www.fda.gov/Drugs/InformationOnDrugs/ucm079750.htm | FDA Drug Information Website
 ==== Acknowledgments ====
+* I would like to thank Dr. Kam Dahlquist for her introduction of the Microsoft Access Software as well as instruction on how to access it and information on learning the database system as well
-In this section, you need to acknowledge anyone who assisted you with your assignment, either in person, electronically, or even anonymously without their knowledge.
+* Thank you to my homework partner [[User:Mavila9| Marcus Avila]]. We met in person and he assited me in formatting issues, learing to zip my file correctly and gave information on how to correctly update my database in Access.
-# You '''''must''''' acknowledge your homework partner or team members with whom you worked, giving details of the nature of the collaboration.  You should include when and how you met and what content you worked on together.  An appropriate statement could be (but is not limited to) the following:
-#* I worked with my homework partner (give name and link name to their user page) in class.  We met face-to-face one time outside of class.  We texted/e-mailed/chatted online three times.  We worked on the <details> portion of the assignment together.
+"Except for what is noted above, this individual journal entry was completed by me and not copied from another source." [[User:Jnimmers|Jnimmers]] ([[User talk:Jnimmers|talk]]) 19:39, 25 September 2019 (PDT)
 ==== References ====

@@ Line 18: / Line 18: @@
 ===Scientific conclusion===
 This project was given in order to learn the basic structure and function of the Microsoft Access program. It is meant to equip  me with the skill and knowledge of how to operate the system and sue it to create a database of my own using pre-made data fro the FDA. In terms of learning, I feel that I learned a lot from this program, and I think it can be a useful asset for anyone in the working world; it allows for organization at a level that can't be done with pen and paper, and it can store far more information than Excel, making it more optimal for a work or company setting, which can be useful for almost anyone.
 ==== Data and Files ====
 * References to data and files should be made within the methods and results section of your notebook.