My current summer employer wants me to design a stand-alone application that connects to an Access database and displays several fields which the user can change to alter the state of the data retrieved. The retrieved data will be in a simple form that a non-database user could easily understand.
In addition to data retrieval, one portion of the program is required to be able to enter data into the database without actually opening Access. Once again, it must be relatively easy to use.
My major is computing science, however, we do not study VB/VBA at University, so I am wondering what would be the best way to accomplish this task.
Is it necessary to purchase Visual Studio, or is it possible to use the VBA built into Office to make such a program?
Basically, I need a good starting point, any locations of similar programs/source code would be greatly appreciated.
Thanks in advance.
