Access Project

This week our Microsoft Access Project was due. This project was one of the most confusing projects I have ever had to work with due to the date that I have never used Microsoft Access before. I am glad I didn't wait until the very last moment to begin working on this assignment because I had to download Microsoft Access 2007.


Throughout the Access project I learned about creating tables, queries, forms and reports. I learned how to import external data files in multiple formats to one database and organize it. I also learned how to export data from a database in different file formats like .txt which is extremely easy to convert and one of the best formats to send documents in. I also learned that how to relate sets of tabular data and how easy it is to organize massive amounts of data by using Access. The biggest surprise to me was how professional the default tables and reports look without any customization.


The only fall backs to using Microsoft Access is learning how to use the program. I have never used the program before and it was quite hard to catch onto at point. However, once you understand how the program works the possibilities for organizing data are endless. Some of the ways to enhance the functionality of the database would be to increase security, insert user passwords to protect customers and to make better tutorial videos. I thoroughly enjoyed watching the Access lectures, but they were a little dated and it made it harder to learn some of the required techniques to complete the project and scavenger hunt. Increased security is a must for any programs in the world today, especially since these files organize and hold valuable information such as addresses, names, date of birth, etc. The program as of right now is extremely vulnerable to identity theft which spreads through the web like wildfire. 

In the end, I am extremely happy I took this course just because I got to learn the aspects of a program I have never used. Even though the project is over I am going to look into Microsoft Access Tutorials and learn all the ways of using the program. I have always enjoyed using excel for organizing data but I cannot wait to explore Access even further. Below I have included a sample of what a Microsoft Access Database looks like.