I am currently in the process of converting our company's database from a proprietary software to PostgreSQL, and would like a form-based front-end that is simple for computer laymen to use.
Most people in our office (7-10 users) use the current software to insert/update/delete records, as well as generate reports and other documents. Our largest table contains about ~13,000 records. Stability on a local network is a must. The ideal software would have the following:
- Allows for creation of custom forms and reports
- Simple for the end-user to navigate
- Easy to deploy updates to the client over a local network.
I'm considering using Access as many of our employees are very familiar with Office software and it seems simple to get off the ground, but I have also heard it can struggle with large datasets, and VBA seems somewhat limited. I am largely unfamiliar with webapps, but would be willing to invest the time to learn if the benefits outweigh the costs.