Database Project

            In this project, I learned some of the basics of using Microsoft Access. I had never used Microsoft Access before and had absolutely no idea what it was even used for. I learned that Microsoft Access was a database program used to create database solutions using tables, queries, forms, or reports for printing. In this project, I learned how to create a new table, add fields to the table, create keys, add descriptions to table fields, enter data into a field, import data into a table, create a query, use the query to add fields and criteria, create and edit a form, work with a form in design view, navigate through records, add new records, create a report, modify a report in design view, use grouping and sorting in a report, and add or modify a heading and footer of a report. Having never used Microsoft Access before, I was unaware of the capabilities of the program or how it differed from Microsoft Excel. From this project, I learned the enormous capabilities of Microsoft Access and the basics of working with a table, form, query, and report. I really enjoyed this project because I know it will be useful in the future. I plan on working in the business world, and I will likely be assigned many projects where this program will be of great use.

          Some of the ways to enhance the functionality of this database are to use the advanced features of Microsoft Access to create a more complex, detailed database. One way that is discussed in last week's database lecture is through working with external data. This might include linking tables, migrating to an SQL server, using an external collection with forms and email, using Web support, or using Microsoft Access as the back-end database for another information system. Implementing a complete information system includes using forms for input and outfut, pulling data from external sources like email, reports for output, support for multiple users, and scalability (how to deal with a database that is too big). Relationships are another one of the big features of Microsoft Access that brings information together. For the most part, relationships match primary keys from one table with an entry in the foreign key of a different table. Relationships prevent redundant data and can be used as a one-to-many relationship, a many-to-many relationship, or a one-to-one relationship. All of these different advanced features of Microsoft Access would increase the functionality of this database.