Answer the question
In order to leave comments, you need to log in
What would you advise with Choosing a database designer (for a beginner)?
I want to create a database (contains numbers, text, dates). As I see it (I immediately apologize for the terminology - not an expert).
The basis consists of several "working" tables + "directories".
1. Table1 contains a number of columns with numbers, labels. It would be interesting to fill in not manually, but copy some of the columns from Excel (several dozen rows at once) and fill in the rest manually (with a choice from directories). The date is autofilled.
2. For each of the newly created rows of Table1, rows of Table2 are created (automatically, by "pressing a button") with autocomplete fields (from directories), with the ability to edit these fields.
3. Formation of Reports from the data of Tables 1 and 2 in tabular form, all kinds of processing, filtering and calculations. With the ability to edit data and save them to the database.
4. Ability to display Reports in Excel.
5. The possibility of a multi-window mode is desirable.
This is what I see as a non-specialist. Thanks for the help.
Answer the question
In order to leave comments, you need to log in
from simple to complex
1) MS Access - everything can be done by mastering VBA or even Python , and it will be in one program (if you have Access on your computer, of course)
2) Python + WEB interface, for example, on Django - it's easier to do, a lot of documentation + Python will come in handy more than VBA
3) PyQT
in 2 and 3 cases you can get by with SQLite
Didn't find what you were looking for?
Ask your questionAsk a Question
731 491 924 answers to any question