Nstojan1 Week 6

Purpose

• The purpose of this assignment was to learn how to effectively use Microsoft Access in Office 360 in order to get familiar with a regional database and learn how to input, analyze and edit data.

Methods/Results

The video firstly introduced us to Access where I learned the basics of Access such as how to store and track information and why Access was a better option than a spreadsheet such as Excel. The video then walked us through all the different templates that Access has a why they would be used. Then, I began entering information on a preset template and learned how to create "tasks" and edit and add entries. The tutorial then went into showing me how to create a new database where I learned how to enter and organize data from Excel. Lastly I learned the different methods of retrieving data and why this is important when there are multiple datasets.

Conclusion

In conclusion the tutorial taught me the advantages of Access over spreadsheets and why such a database would be used through using the different templates and applying them to specific cases such as the one for the Landon Hotel. In addition to this, through the different exercises I gained hands on experience that taught me how to enter, edit, organize data utilizing the different types of features.

Acknowledgments

• I worked with User:kdahlquist on this assignment in order to troubleshoot some issues with the tutorial I was having and receiving the certificate.
• Except for what is noted above, this individual journal entry was completed by me and not copied from another source.
• Nstojan1-new (talk) 21:42, 21 February 2024 (PST)

References

• LMU BioDB 2024. (2024). Week 6. Retrieved February 21, 2024, from https://xmlpipedb.cs.lmu.edu/biodb/spring2024/index.php/Week_6