Difference between revisions of "MSymond1 Week 6"
(→Methods and Results: continued through chapter 2) |
(→Methods and Results: continued the section) |
||
| 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. | 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== | ==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. | + | 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. |
Revision as of 11:08, 21 February 2024
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. 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.
