Difference between revisions of "Asandle1 Week 6"

From LMU BioDB 2024
Jump to navigation Jump to search
(testing my template to see if it works)
 
(I copied Katie's layout because it looked good, I am removing all her content and replacing it with my own.)
Line 1: Line 1:
 +
==Purpose==
 +
The purpose of this assignment is to
 +
*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==
 +
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.
 +
 +
[[media:MillerCertificate.pdf | Certificate of Completion]]
 +
 +
==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.
 +
 +
==Acknowledgements==
 +
I worked with my homework partner Natalija Stojanovic [[User:Nstojan1]] in class. We worked on the Methods/Results 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:Kmill104|Kmill104]] ([[User talk:Kmill104|talk]]) 19:02, 21 February 2024 (PST)
 +
 +
==References==
 +
*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/
 +
*LMU BioDB 2024. (2024). Week 6. Retrieved February 21, 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
 +
 +
[[Template:Kmill104]]
 +
 +
{{Kmill104}}
 +
 +
 +
 
{{template: Asandle1}}
 
{{template: Asandle1}}

Revision as of 23:55, 21 February 2024

Purpose

The purpose of this assignment is to

  • 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

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.

Certificate of Completion

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.

Acknowledgements

I worked with my homework partner Natalija Stojanovic User:Nstojan1 in class. We worked on the Methods/Results 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.

Kmill104 (talk) 19:02, 21 February 2024 (PST)

References

Template:Kmill104

User Page

User:Kmill104

Assignment Pages

Individual Journal Entry Pages

Shared Journal Entry Pages


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