Database Project

The database project using Microsoft Access was a challenging, yet interesting, project. While completing this project I learned how to successfully create a database by either manually inputing data or by importing external data. Once my database was created I learned how to change the format to fit my purpose and desire. Now that I had my data just they way I wanted it, I learned how to complete queries and present my queried data in a report or form view. By completing this project I feel that I have learned the necessary skills to work with Access in the future.

If I were given the option to modify this database, I would set the membership type to auto fill when you begin typing. Since you only have two options, Individual and Family, this would save a great deal of extra typing. This would be accomplished by setting up a combobox and adding a dropdown list which contained your default values. In addition to this I would setup the gender field to only allow Male or Female. This would be accompished by setting up a validation rule in the design view. I would also add validation text to pop up if any other data was input. This would let the user know what error was being made.