MSymond1 Week 6

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.