The database project i did through this class taught me an amazing number of things. Most importantly it opened my eyes to having a database construction tool that was easily accessible to me and that i can learn to use versus paying someone to construct a database for my business one day. This course taught me that Microsoft access is a great tool to help construct a database which can track inventory, create invoice forms, and even create an interface to communicate all the data seamlessly with one another plus much much more. I have already begun building a database for my company GatorComps which i will link below as soon as i find out how in case any one is interested in helping me build it or put any input in to it so far. Constructive criticism welcome and appreciated!
This project may have been improved by adding a drop down box for some information entry fields like gender to reduce the risk of error when being entered by a user. Although this was not covered i believe this has to do with relationship tables where one would have had to create a new table with male and female in a column and have the field linked to the gender field in a form or report.This is one concept i am trying to learn how to use because in terms of my business it would be much more efficient to use a drop down box to select a model and make of a device rather than typing it in and it would decrease the time it would take bringing in devices so as to not hold up and make customers impatient, thus, improving customer service.
Here is the link to my gatorcomps database file which is free to be edited in case anyone wants to incorporate anything.
Any help appreciated and Thanks!
https://docs.google.com/open?id=0B22B348ZyC7jeGZZUERWNWJTV3kzX1FjaGo4MERKUQ
No comments:
Post a Comment