Microsoft Access is often the desktop solution of choice used by non-programmers to create their own customized database solution. The Access tables are easily customized and can support a variety of field types and indexes. Access also has the ability to enforce referential integrity which prevents the database from accepting ‘orphaned’ records which could corrupt your database. An orphaned record is a record that exists in the database and does not match any other records.
A few more popular features of Access is the ability to include a very intuitive query interface, various customizable data entry forms and unlimited custom reports that can be printed or downloaded. Many non-programmers have been easily able to quickly create simple screens and reports on their own. However, for more advanced solutions or to place a database on a network where multiple users will share and update data, please contact us to see if we can help determine a custom solution for your needs.