Doing this project, I've learned so much about all the functions of Microsoft Access and how quickly and simply it can so effectively organize large amounts of data. The query function helps filter select data to better view the data that is needed. Creating a report also helps a user print out what they need from the large database so they can view it without excess, unnecessary data populating it. There are various ways one can use Access and through the project, I was able to just learn the basic functions which are not difficult at all! I was at first worried about how time consuming this project may take me, but I soon realized that everything is really straightforward in Access. Microsoft Access is very user-friendly and the wizards to run functions really help for those who do even have a little trouble. The biggest thing that I have learned through this project is how to run a query will help me remove the data that I do not need to look out so I can focus more on the data that I do need. Within the query, you can also sort data in ascending or descending order and in which field you would like to be sorted first. This function allows users to save a lot of time because the program does almost everything you command it to.
One way that I would enhance the functionality of this database is that I would try to make the appearance of the database more appealing. Depending on their business, users can add clip art or other images onto, for example, the forms layout design so it looks more appealing. The similar formats that can be found across all Microsoft Office programs allows users to easily be able to adjust the designs that they desire into Microsoft Access with no hassle. The program also comes with many other pre-installed color themes that one can choose form. The similarities that are found within Microsoft Office really helped me easily navigate through Access.
To conclude, Microsoft Access is a really great program to use if you have large amounts of data that you would like to organize. Excel does provide similar functions, however, Access is more geared towards large databases, where you are able to create queries to search through them using certain criteria and print out reports to distribute to managers.
No comments:
Post a Comment