Data entry database
Free program that creates a data database (customer lists, suppliers, patients, acquaintances, etc.) in Microsoft Excel – Contains Macro functions
The “Data Entry Database” is a software application designed by Itieffe to allow users to enter information into a database in a structured way. Databases are tools used to store, organize and retrieve data efficiently. Entering data into a database is a common task in many businesses and industries, and often requires an intuitive user interface to assist in the process.
In summary, a "Database Data Entry" program is a tool that simplifies and organizes the process of entering information into a database, helping to maintain data consistency, integrity, and accuracy.
Precautions
Attention: The program is made in Microsoft Excel with Macro function enabled.
For safety, please download the file only from the site: www.itieffe.com
If you are sure the file is safe sblock macros by changing the file properties as follows:
Unlock a single file
In many cases you can unlock macros by changing the file properties as follows:
- Open Windows File Explorer and browse for the folder where you saved the file.
- Right-click the file and choose Properties from the pop-up menu.
- In the lower part of the General tab, select the Unblock checkbox and choose OK (see explanatory example placed in the reserved area)..
Program that creates a data database (customer lists, suppliers, patients, acquaintances, etc.)
By entering the requested data in the "Data entry" screen, and pressing the "Insert" button, they are automatically shown in the "Form" sheet.
The numbering is entered automatically.
Instructions
We insert the data in the initial form (Data entry).
1 – Database name
2 – Identifiers (ID) automatic numbering entry
3 – Database headers modifiable by the compiler
4 – Data to enter
5 – Insert button
6 – Deletion of data entered erroneously on the initial screen
For this example, if we look at the 'Form' screen right now (before we hit 'Insert'), we see this:
The progressive number "ID" is 34.
Indications
1 – Editable table header on home screen (point 3)
2 – Progressive number (automatic)
3 – In the case of colored cells in the form screen, these only give the indication of repeated data (usable only on columns B and C).
Let's press "Enter":
The splash screen clears and the ID increases by one (in this example from 34 to 35).
On the Form screen, a row containing the new data is inserted.
On the Form screen, you can:
1 – change the width of the columns as desired,
2 – modify the entered data
3 – using the function (Filter) [▼] and the "Find" function, go back to any value sought.
Other free programs of the same kind offered by itieffe ▼
Data entry database
To access the free downloadable Microsoft Excel version, you must be registered.
You can register now by clicking HERE