Database Project

In this project I learned how to effectively use the program Microsoft Access. I had never used the program before this. Access is used for managing databases. Large tables of information can be easily sorted, grouped, and edited in many ways. Microsoft Access is a relational database system so information can be connected based on common data. In this project I was keeping a database on the members of a gym. I created a table that contained the fields of relevant information like names, addresses, and other descriptional information. Using this core database of information, I then sorted the info to show me just the members that had left the gym in the past 6 months. I then created forms that showed the information I chose about each customer. Finally, I created a report on the data I had pin pointed in the table. I am fortunate to have learned how to use the Microsoft Access program.

There are many advanced features in Microsoft Access. One of those features is the ability to establish a relationship between common fields. Information can be grouped into different sections but say there is a common field in multiple groups. For example, there might be a group with employee sales info and a group with employee contact info. Microsoft Access can relate the info because it recognizes that the employee names are the same in both groups. This leads to another great Access feature which is the ability to easily edit large amounts of information. If the name of a product changes ,for instance, I would have to make the change only once, and Access would apply the change to all relevant data. Normalization is the ability to not have redundant info and this feature of Access helps with that.