With MonoBase you are eble to easily create your own personalized databases.
Monobase is not able to create forms for data input. Instead you use grids for data edit or insertion. There is no helpfile for the application as it is a freeware application.
When creating a database, table, or field, please use the following naming conventions: "Table_Name", "My_New_Database", "Field_Name". The database does not work well with spaces between names.
Here is a few steps to help you get started:
· Click on the "New Database" button
· Enter the Database name you want to create e.g. "Address_Book"
· Select the folder where you want your database stored
· Click on the "Create" button to create your database.
Creating Tables and Fields:
· Click on the "New Table" button
· Enter the name of your table to create e.g. "Friends_Family"
· On each line enter the field names and field type that you want to save in you new table:
· "Name" - String - 25
· "Surname" - String - 25
· "Notes_Comments" - Memo - 200
· "Personal_Image" - Graphic Bitmap - 240
· Click on the "Create" button to create your table
· Click on the Drop-Down ComboBox on the main form to select your newly created table
· Your table and data fields will now be displayed
· On the bottom of the grid-table you will see a navigation bar. To edit, delete or add any data, click on any of the appropriate buttons first.
Click on the "+" button to enter a new record. For easier data entry or data viewing, simply double-click on the table cell to enter your data after you have clicked on the "Edit ^ " or "Add +" button. Remember to click on the "Post" button after you have entered or added a new record. Each button will give you a hint as to what each of them do.
That is basically the whole process you need to follow in creating, editing, and viewing your database and tables.
If you wish to create reports on your data, see the helpfile in the report writer or in the menu next to the Monobase shortcut.
Here are some key features of "MonoBase":
· Create unlimited databases with unlimited tables, fields, and rows
· Access any ODBC compatible database of any size, from 1 Kilobyte to 1 Terabyte
· Filter tables instantly
· Run SQL statements with the SQL query engine
· Create custom reports for all your databases
· Full help file to assist you in creating custom database reports
· Full administration capabilities of any ODBC compatible database through our SQL engine
· Supports any SQL standard that your ODBC compatible database requires
· Export your data to comma separated files
· Print tables and queries straight from your data grid
· Ultra simple graphical-user-interface
Requirements:
· 8 MB RAM
· 5 MB Hard drive space
· 16 bit Screen Colour
· 1024 x 768 Screen Size
What's New in This Release: [ read full changelog ]
· Tables now have referential integrity with primary and secondary keys
· Master / Detail view on linked tables
· Added 2D/3D charting on custom SQL Queries
· Enhanced data handling for edit/insert and viewing of data
· Export data in CSV or XML format
· Insert or paste Images with unlimited size for archiving