Hello all,
my situation is the following: I conceptualized a Database for a certain process of a company.
Basically, the workflow that is to be implemented is:
1) Create users
2) Select an intended qualification which consists of two aspects
3) Insert evidence of the user for the approval of the intended qualification
4) Select necessary criteria that are needed now based on the selected intended qualification (depending on the special intended qualification aspects, there are different criteria that are now relevant: this is some regulatory stuff that is given).
The now relevant necessary criteria (these are questions) are to be assigned to a specific user.
This combination of criteria and user is to be evaluated (passed/not passed) based on the evidence that is given in Step 3. My idea is to implement an automation that inserts this combination of criteria and user (called question in tbl_question) is now connected/concatenated with the evidence the user has submitted in step 3 (a table called tbl_QuestionEvidence) and stored.
I have also implemented a Mockup without any functionality but only to have an orientation for the interface of the DB that is to be developed.
My question is: Since I am a newbie in Access and VBA, when do I need to implement code and how can I find out if I can also use some functionalities in Access itself. Because it is quite hard for me to figure out what Access can do "automatically" and when code is mandatory. Because I want to go the most-easiest way of course in order to build the DB as quickly as possible but with some certain automation features such as buttons (e.g. do I only need Code for Event-procedures such as Drop-Down-Menus or Buttons?).
Do you guys also have other tips how to implement a Database that is already conceptualized (model is approved, workflow is approved, requirements are approved).
Greetings,
FinisherProgrammer21