QuickDBAccess is a configurable program that works as a quick front end for a database.
Download directly from GitHub in the latest release folder:
http://github.com/samuelSVD/QuickDBAccess/releases/latest
This program works as an easily editable front-end application for your database. To start, open the application then press the edit button on the menu bar. This will open up the program editor.
The program editor is made up of three main components: Connections, Data Sources, and Table Views
The Connections tab is used to configure a database connection. Here is where you would configure the connection settings and authentication for connecting to the database. Verify your database is set up for mixed authentication prior to working with this application.
The Data Sources tab contains any queries that are used to get data from the database.
Data sources can be configured as depending on data from one another. A data source configured with parameters will get its data from the input. Parent parameters will grab data from the "parent of the table view". This will be relevant later. This would be configured as follows:
Table views are configured to be a grid view of a data source. Table views can also be configured to have "sub-table views". This means that when a record in the table view is selected, the data for the sub-table views will be refreshed according to the row selected in the parent table.
Table views can also be assigned button actions. These are data sources that will execute when a button action is pressed. In this example, we have assigned the button action for the Employees table view to edit some data. The data source for that button would look as follows:
Once it is all configured and the changes applied, the application will refresh the main screen and show different tabs for all the different table views.
I am open to receiving suggestions for improving Quick DB Access! Have an idea that you think would make this app even more useful for you, let me know by creating an issue!