| klste@hotmail.de |
Create database program in Excel with flexible mask
Here, anyone can create this program themselves.
The header Create database program in Excel with flexible mask and image are two links to the homepage page with List of 47 links to YouTube movies.
The 47 YouTube movies describe how to create the program. All VBA code is on this page, and if there is a code in the description, simply select the code, copy (strg + C) it, and paste it into Excel file in the correct place. Before you insert the code, you should make the line spacing as small as possible in a Word document.
With the flexible input mask You can edit all worksheets in Excel file. It does not matter in which column the data types are to be entered (in the range from column B to column N). From the flexible input mask You can assign a data type to all 13 columns. The program works with 4 common data types: text, number, date and time. The assignment scheme for each worksheet is saved and automatically recognized when the sheet is activated. The input mask contains no superfluous control elements, which makes the very compact, clear and not very large, which allows this program to be used in small notebooks.
The flexible input mask also has a search mode. From the search mode you can evaluate each active sheet according to different keywords, and it does not matter in which column (from column b to column n) the searched term is located.
Create databases in Excel from a flexible input mask with assignment of data types.
Customer list
A user has created a "Customer list" sheet in its database to Excel file. Following headings are in row 7: A - ID no, B - Company name, C - Second name, D - Zip/postal code, E - Place, F - Street, G - Country, H - Contact person, I - Working day of , J - Working day until, K - Phone, L - E-Mail, M - As a customer since, N - Total turnover.
Supplier list
A user has created a "Supplier list" sheet in its database to Excel file. Following headings are in row 7: A - ID no, B - Company name, C - Second name, D - Zip/postal code, E - Place, F - Street, G - Country, H - Contact person, I - Working day of , J - Working day until, K - Phone, L - E-Mail, M - As a supplier since, N - Total turnover.
Staff list
A user has created a spreadsheet "Staff list" in its database to Excel file. Following headings are in row 7: A - Personnel number, B – Name, C First name, D - Sex, E – Admission, F - Limited to, G - 1 Extension, H - Beginning of the working day, I - Clearance certificates, J - Valid until, K - Phone, L - Postcode, M – City, N – Street.
Product range
A user has created a spreadsheet "Product range" in its database to Excel file. Following headings are in row 7: A - ID no., B – Article number, C Description, D - Unit, E – Subscription price, F - Sale price to, G - 1 Inventory, H - Storage bin, I - Storage unit, J - Date of delivery, K - Delivery time, L - Expiration date, M – Order number, N – Supplier.
Inventory list
A user has created a spreadsheet "Product range" in its database to Excel file. Following headings are in row 7: A - ID no., B – Inventory number, C Room, D - Subject, E – Category, F - Purchase price, G - 1 Date of purchase, H - Document, I - Warranty, J - Insured, K - State, L - State tested the, M – State tested to, N – Has tested.
A user has created a spreadsheet "Inventory stocks" in its database to Excel file. Following headings are in row 7: A - ID no., B – Article number, C Description, D - Unit, E – Storage bin, F - Storage unit number, G - Was set, H - Is stock, I - Average value of the article, J - Stock value, K - Stock value difference value, L - Inventory date, M – Inventory time, N – Has tested.
Vehicle list
A user has created a spreadsheet "Vehicle list" in its database to Excel file. Following headings are in row 7: A - ID no., B – Manufacturer, C - Model, D - Car license plates, E – Year of manufacture, F - Initial registration, G - Fuel, H - Engine performance/HP, I - Mileage, J - Insurance, K – MOT until, L - Place to stay, M – Return the, N – Return to.
Shift schedule
A user has created a spreadsheet "Shift schedule" in its database to Excel file. Following headings are in row 7: A - ID no., B – Month, C - Month day, D - Day of the week, E – Holiday, F - Calendar week, G - Work shift, H - Beginning, I - End.
Accident statistics
A user has created a spreadsheet "Accident statistics" in its database to Excel file. Following headings are in row 7: A - ID no., B – Department/area, C - Staff, D - Almost accident, E – Not reportable, F - Date, G - Time, H - Lost working days, I - Staff, J - Accident, K - Reportable, L - Date, M – Time, N – Lost working days.