MSymond1 Week 6 - Revision history

Msymond1: /* References */ added template

2024-02-22T03:30:18Z

‎References: added template

Msymond1: /* References */ added references

2024-02-22T03:29:23Z

‎References: added references

Msymond1: finished methods and results

2024-02-22T03:28:06Z

finished methods and results

Msymond1: changed file

2024-02-22T03:23:09Z

changed file

Msymond1: /* Methods and Results */ added code to file

2024-02-22T03:21:23Z

‎Methods and Results: added code to file

Msymond1: /* Methods and Results */ added file

2024-02-22T03:20:19Z

‎Methods and Results: added file

Msymond1: added conclusion, acknowledgements, and references

2024-02-21T19:28:24Z

added conclusion, acknowledgements, and references

Msymond1: /* Methods and Results */ continued the section

2024-02-21T19:08:42Z

‎Methods and Results: continued the section

Msymond1: /* Methods and Results */ continued through chapter 2

2024-02-21T19:00:37Z

‎Methods and Results: continued through chapter 2

Msymond1: added purpose and started methods/results

2024-02-21T18:35:25Z

added purpose and started methods/results

New page

==Purpose==
The purpose of this assignment was to become familiar and comfortable with the software Microsoft access. Microsoft access will lay a foundation for many of the future assignments done in this class because it is very useful with creating databases and managing files.
==Methods and Results==
This assignment consisted of the LinkedIn learning course on Microsoft Access. The course contained 3 main chapters, the first chapter covered basic information about Microsoft access, including what it can do that other softwares cannot, some introductory terms for databases (queries, forms, tables), the advantages of using it over using Microsoft Excel. Chapter 2 was a tutorial on how to build a database in Microsoft access using one of the template files included in the training course. The database created in chapter 2 is about a hotel and it included information about room names, room information, and guests.

← Older revision		Revision as of 03:30, 22 February 2024
Line 15:		Line 15:
	*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 21, 2024, from https://xmlpipedb.cs.lmu.edu/biodb/spring2024/index.php/Week_6
		+	{{Template:MSymond1}}

← Older revision		Revision as of 03:29, 22 February 2024
Line 11:		Line 11:
	[[User:Msymond1\|Msymond1]] ([[User talk:Msymond1\|talk]]) 11:28, 21 February 2024 (PST)		[[User:Msymond1\|Msymond1]] ([[User talk:Msymond1\|talk]]) 11:28, 21 February 2024 (PST)
	==References==		==References==
		+	*Adam Wilbert (Instructor). (2016, May 4). Learning Access for Office 365. Linkedin Learning. https://www.linkedin.com/learning/learning-access-for-office-365/welcome
		+	*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

@@ Line 2: / Line 2: @@
 The purpose of this assignment was to become familiar and comfortable with the software Microsoft access. Microsoft access will lay a foundation for many of the future assignments done in this class because it is very useful with creating databases and managing files.
 ==Methods and Results==
-This assignment consisted of the LinkedIn learning course on Microsoft Access. The course contained 3 main chapters, the first chapter covered basic information about Microsoft access, including what it can do that other softwares cannot, some introductory terms for databases (queries, forms, tables), the advantages of using it over using Microsoft Excel. Chapter 2 was a tutorial on how to build a database in Microsoft access using one of the template files included in the training course. The database created in chapter 2 is about a hotel and it included information about room names, room information, and guests. It included a tutorial on creating a table, importing a table from excel, forming relationships, editing in design views and more. Chapter 3 was focused on retrieving information from the database in the form of queries.
+This assignment consisted of the LinkedIn learning course on Microsoft Access. The course contained 3 main chapters, the first chapter covered basic information about Microsoft access, including what it can do that other softwares cannot, some introductory terms for databases (queries, forms, tables), the advantages of using it over using Microsoft Excel. Chapter 2 was a tutorial on how to build a database in Microsoft access using one of the template files included in the training course. The database created in chapter 2 is about a hotel and it included information about room names, room information, and guests. It included a tutorial on creating a table, importing a table from excel, forming relationships, editing in design views and more. Chapter 3 was focused on retrieving information from the database in the form of queries. It covered how to create a form in access in which it will report certain information that interacts with other information. This required entering syntax that subtracted some values from each other or multiplied others with others to determine values such as the total time stayed in the hotel, or the total amount spent by the guest.
 [[file:Dean Access Certificate.png|500px|thumb|right|certificate]]

@@ Line 3: / Line 3: @@
 ==Methods and Results==
 This assignment consisted of the LinkedIn learning course on Microsoft Access. The course contained 3 main chapters, the first chapter covered basic information about Microsoft access, including what it can do that other softwares cannot, some introductory terms for databases (queries, forms, tables), the advantages of using it over using Microsoft Excel. Chapter 2 was a tutorial on how to build a database in Microsoft access using one of the template files included in the training course. The database created in chapter 2 is about a hotel and it included information about room names, room information, and guests. It included a tutorial on creating a table, importing a table from excel, forming relationships, editing in design views and more. Chapter 3 was focused on retrieving information from the database in the form of queries.
-[[file:Symonds_Access_Certificate.pdf|500px|thumb|right|certificate]]
+[[file:Dean Access Certificate.png|500px|thumb|right|certificate]]
 ==Conclusion==

@@ Line 3: / Line 3: @@
 ==Methods and Results==
 This assignment consisted of the LinkedIn learning course on Microsoft Access. The course contained 3 main chapters, the first chapter covered basic information about Microsoft access, including what it can do that other softwares cannot, some introductory terms for databases (queries, forms, tables), the advantages of using it over using Microsoft Excel. Chapter 2 was a tutorial on how to build a database in Microsoft access using one of the template files included in the training course. The database created in chapter 2 is about a hotel and it included information about room names, room information, and guests. It included a tutorial on creating a table, importing a table from excel, forming relationships, editing in design views and more. Chapter 3 was focused on retrieving information from the database in the form of queries.
-[[file:Symonds_Access_Certificate.pdf]]
+[[file:Symonds_Access_Certificate.pdf|500px|thumb|right|certificate]]
 ==Conclusion==

← Older revision		Revision as of 19:28, 21 February 2024
Line 3:		Line 3:
	==Methods and Results==		==Methods and Results==
	This assignment consisted of the LinkedIn learning course on Microsoft Access. The course contained 3 main chapters, the first chapter covered basic information about Microsoft access, including what it can do that other softwares cannot, some introductory terms for databases (queries, forms, tables), the advantages of using it over using Microsoft Excel. Chapter 2 was a tutorial on how to build a database in Microsoft access using one of the template files included in the training course. The database created in chapter 2 is about a hotel and it included information about room names, room information, and guests. It included a tutorial on creating a table, importing a table from excel, forming relationships, editing in design views and more. Chapter 3 was focused on retrieving information from the database in the form of queries.		This assignment consisted of the LinkedIn learning course on Microsoft Access. The course contained 3 main chapters, the first chapter covered basic information about Microsoft access, including what it can do that other softwares cannot, some introductory terms for databases (queries, forms, tables), the advantages of using it over using Microsoft Excel. Chapter 2 was a tutorial on how to build a database in Microsoft access using one of the template files included in the training course. The database created in chapter 2 is about a hotel and it included information about room names, room information, and guests. It included a tutorial on creating a table, importing a table from excel, forming relationships, editing in design views and more. Chapter 3 was focused on retrieving information from the database in the form of queries.
		+	==Conclusion==
		+	This assignment was successful in showing me how to navigate Microsoft access, I learned a lot about creating these databases as well as how to edit the information in them and represent them in different ways, as well as how to make queries in the databases. The database used in this tutorial did not have anything to do with biology, but I am confident that this will be helpful in creating databases that do relate to biology and genes throughout the rest of the semester.
		+	==Acknowledgements==
		+	My Homework Partner for this week was Andrew Sandler, although we did not meet or text outside of class for the assignment. I did consult Dr. Dahlquist during class once when I was attempting to save my files to box and I was having trouble. Except for what is noted above, this individual journal entry was completed by me and not copied from another source.
		+	[[User:Msymond1\|Msymond1]] ([[User talk:Msymond1\|talk]]) 11:28, 21 February 2024 (PST)
		+	==References==