Difference between revisions of "Asandle1 Week 6"

From LMU BioDB 2024
Jump to navigation Jump to search
(I copied Katie's layout because it looked good, I am removing all her content and replacing it with my own.)
(Acknowledgements: Added additional acknowledgements)
 
(7 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
==Purpose==
 
==Purpose==
The purpose of this assignment is to  
+
The purpose of this assignment is to learn and become comfortable with using Microsoft Access
*Learn how to use a relational database created in Microsoft Access  
 
*Understand why a database is made and what purpose it might serve for storing information
 
*Manage files in Windows, and setting download options in the Chrome browser
 
  
 
==Methods/Results==
 
==Methods/Results==
The tutorial consisted of three sections, each with video tutorials that I followed along with Microsoft Access. The tutorial explained what an Access database is, and what the advantages of using one are. Access allows for data to be relationally stored, meaning data is connected in order to eliminate data discrepancies and any redundancy. It then showed how to create a database and how the different tools in Access are used. The second section focused on building and refining a database. This involved defining data, entering data into the proper organizational methods, and then establishing relationships between the data. Data from a previously made Excel spreadsheet can also be brought to Access to prevent the need for manual recreation. The third section was about retrieving information from the database, which is done by utilizing the query and report tools.
+
The LinkedIn Learning Tutorial which I followed had an introduction, 3 steps of videos, and a Conclusion. I followed through the course video by video. At the end of each section I took a simple 5 question quiz. I did not download the course files and instead opted to do it from scratch on a blank Access database file. This ended up being extra work because I had to copy data by hand for some exercises to follow along with the tutorial. I didn’t have as large of a database, but the results were the same in terms of what was learned. The result of this was a [[media:SandlerCertificateAccess.pdf | Certificate of Completion]].
 
 
[[media:MillerCertificate.pdf | Certificate of Completion]]
 
  
 
==Conclusion==
 
==Conclusion==
This assignment taught me how to create and edit a database with the Microsoft Access software, as well as showing me why databases might be preferred over other methods for information storage. The tutorial showed me the different tools that can be used when making a database, and I feel confident in the skills that I have learned. I also learned how to manage files within Windows, as well as how to properly download from Chrome.
+
The LinkedIn Learning assignment introduced me to Microsoft Access and how to use it to create and manage relational databases.
  
 
==Acknowledgements==
 
==Acknowledgements==
I worked with my homework partner Natalija Stojanovic [[User:Nstojan1]] in class. We worked on the Methods/Results portion of the assignment together.
+
*Dean and I did not communicate this week about homework.
 +
* I copied Katie's layout because It looked simple and elegant and saved me time. I replaced her content with my own.
 +
* I also looked at all of my classmates Method/Results sections because I did not know the proper scientific way to write a methods/results section at a collegiate level.
 +
* I tried my best to not copy their answer to Method/Results but to see how they did it and think through how I could do the same thing. It ended up similar and I hope that is just because we all did identical assignments. I honestly feel iffy about this section and so I will cite this section as coming from the inspiration of Hailey and Katie's content.
 +
* I copied the sources from Katie's resources since we used the same sources. I changed the dates to reflect when I accessed them.
 +
* 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:Asandle1|Asandle1]] ([[User talk:Asandle1|talk]]) 00:07, 22 February 2024 (PST)
 
 
[[User:Kmill104|Kmill104]] ([[User talk:Kmill104|talk]]) 19:02, 21 February 2024 (PST)
 
  
 
==References==
 
==References==
 
*Conner-Gaten, A. (2019, August 1). Lynda Becomes LinkedIn Learning. LMU Library News. https://librarynews.lmu.edu/2019/08/lynda-becomes-linkedin-learning/
 
*Conner-Gaten, A. (2019, August 1). Lynda Becomes LinkedIn Learning. LMU Library News. https://librarynews.lmu.edu/2019/08/lynda-becomes-linkedin-learning/
 
*Ford, P. (2015, June 11). What Is Code? Bloomberg. https://www.bloomberg.com/graphics/2015-paul-ford-what-is-code/
 
*Ford, P. (2015, June 11). What Is Code? Bloomberg. https://www.bloomberg.com/graphics/2015-paul-ford-what-is-code/
*LMU BioDB 2024. (2024). Week 6. Retrieved February 21, 2024, from https://xmlpipedb.cs.lmu.edu/biodb/spring2024/index.php/Week_6
+
*LMU BioDB 2024. (2024). Week 6. Retrieved February 20, 2024, from https://xmlpipedb.cs.lmu.edu/biodb/spring2024/index.php/Week_6
 
*Wilbert, A. (2016, May 4). Learning Access for Office 365. Linkedin Learning. https://www.linkedin.com/learning/learning-access-for-office-365/welcome
 
*Wilbert, A. (2016, May 4). Learning Access for Office 365. Linkedin Learning. https://www.linkedin.com/learning/learning-access-for-office-365/welcome
 
[[Template:Kmill104]]
 
 
{{Kmill104}}
 
 
  
  
 
{{template: Asandle1}}
 
{{template: Asandle1}}

Latest revision as of 00:10, 22 February 2024

Purpose

The purpose of this assignment is to learn and become comfortable with using Microsoft Access

Methods/Results

The LinkedIn Learning Tutorial which I followed had an introduction, 3 steps of videos, and a Conclusion. I followed through the course video by video. At the end of each section I took a simple 5 question quiz. I did not download the course files and instead opted to do it from scratch on a blank Access database file. This ended up being extra work because I had to copy data by hand for some exercises to follow along with the tutorial. I didn’t have as large of a database, but the results were the same in terms of what was learned. The result of this was a Certificate of Completion.

Conclusion

The LinkedIn Learning assignment introduced me to Microsoft Access and how to use it to create and manage relational databases.

Acknowledgements

  • Dean and I did not communicate this week about homework.
  • I copied Katie's layout because It looked simple and elegant and saved me time. I replaced her content with my own.
  • I also looked at all of my classmates Method/Results sections because I did not know the proper scientific way to write a methods/results section at a collegiate level.
  • I tried my best to not copy their answer to Method/Results but to see how they did it and think through how I could do the same thing. It ended up similar and I hope that is just because we all did identical assignments. I honestly feel iffy about this section and so I will cite this section as coming from the inspiration of Hailey and Katie's content.
  • I copied the sources from Katie's resources since we used the same sources. I changed the dates to reflect when I accessed them.
  • Except for what is noted above, this individual journal entry was completed by me and not copied from another source.

Asandle1 (talk) 00:07, 22 February 2024 (PST)

References


To User Page: User: Asandle1 To Template: Template:Asandle1

Assignment Pages

week 1

week 2

week 3

week 4

week 5

week 6

week 7

week 8

week 9

week 10

week 11

week 12

week 13

week 14

week 15

Journals

Individual

User:Asandle1

Asandle1 Week 2

SIR2 Week 3

Monarch Initiative Week 4

Asandle1 Week 5

Asandle1 Week 6

Asandle1 Week 8

Asandle1 Week 9

Asandle1 Week 10

Asandle1 Week 12

Asandle1 Week 13

Asandle1 Week 14

Asandle1 Week 15

Class Journals

Class Journal Week 1

Class Journal Week 2

Class Journal Week 3

Class Journal Week 4

Class Journal Week 5

Class Journal Week 6

Class Journal Week 8

Class Journal Week 9

Class Journal Week 10

Class Journal Week 12