Project description
Programmer services are required. It is necessary to develop a system of logs on Access + Excell + VBA. We need a multi-user set of accounting logs in the corporate network as an element of building a management accounting system.
It is necessary to make multi-user logs of information accounting on the basis of MS Access (not higher than Ver.2016) using VBA.
The source code of the software complex (PC) should be open to the customer in full
There are many journals and they are different and will eventually connect new ones, which are not even in the project, respectively, the PC needs to be created universal and not tied to the features of information in a particular journal.
► User access system:
The software package (PC) must have a customizable user access system that determines which logs are available to the user and what level of access the user has in the authorized logs, for example, access to read only his (created by the user) records; read the records of all entries in this journal, allow new entries to be added, edit only his entries, edit any entries, delete only his entries, delete any entries of this allowed journal, full access / administrative. I mean. A separate set of permissions for each journal.
Any record is first marked for deletion, but can be seen as a normal record, but with the corresponding flag. Only the administrator from the special interface can finally delete records from the database. Something similar is happening in 1C.
● The PC should at least track the date and author of the record being created, track who and when the latter made changes to a particular database record, who and when the record was marked for removal. Ideally, you need a log of changes in database records - so that you can, if necessary, understand who is in what record and what changed, we hope that the task in such a production is complex and requires a lot of time for development, so it is enough to implement in a simplified version.
● Databases cannot be opened by standard methods in Access – without fanaticism, at the level of ordinary users, although proposals to increase the security and privacy of the database are accepted and discussed, although the task is not a priority.
It is desirable that the administrator can reset the password and the system at the 1st user input (after reset) should ask the user to enter a new password. If it is too time-consuming, you can leave the password task to the administrator when setting up user rights.
► Interface
When you start the program, the user should be able to choose himself from the list, it is desirable that the PC remembers under which user came from this computer (or account) and automatically substitutes this user (as happens when you start 1c).
When entering the primary interface, the user should only see a list of allowed magazines and not see the rest.
The user interface should be made as “intuitively clear” as possible without “lotions” of Access, such as arrows to move to the next base, “hot” keys should be defined and the ability to work with the mouse should be laid down – the interface should be as convenient as possible.
Information with records of a particular journal should be displayed in the form of a table and be able to sort by any column and adjust filters – for example, the range of dates, by the record creator, by the record state (depending on the journal). It is necessary that the system remembers the sorting and filtering settings for each journal and for each specific user.
Make a module for export unloading of sorted and filtered part of the table of the journal being viewed in Excel, it is desirable that the table being unloaded immediately opens and the Excel autofilter is turned on.
● Creating an add-on. Modules upload / download information from / in Word, Excel is welcome.
It is necessary to make multi-user logs of information accounting on the basis of MS Access (not higher than Ver.2016) using VBA.
The source code of the software complex (PC) should be open to the customer in full
There are many journals and they are different and will eventually connect new ones, which are not even in the project, respectively, the PC needs to be created universal and not tied to the features of information in a particular journal.
► User access system:
The software package (PC) must have a customizable user access system that determines which logs are available to the user and what level of access the user has in the authorized logs, for example, access to read only his (created by the user) records; read the records of all entries in this journal, allow new entries to be added, edit only his entries, edit any entries, delete only his entries, delete any entries of this allowed journal, full access / administrative. I mean. A separate set of permissions for each journal.
Any record is first marked for deletion, but can be seen as a normal record, but with the corresponding flag. Only the administrator from the special interface can finally delete records from the database. Something similar is happening in 1C.
● The PC should at least track the date and author of the record being created, track who and when the latter made changes to a particular database record, who and when the record was marked for removal. Ideally, you need a log of changes in database records - so that you can, if necessary, understand who is in what record and what changed, we hope that the task in such a production is complex and requires a lot of time for development, so it is enough to implement in a simplified version.
● Databases cannot be opened by standard methods in Access – without fanaticism, at the level of ordinary users, although proposals to increase the security and privacy of the database are accepted and discussed, although the task is not a priority.
It is desirable that the administrator can reset the password and the system at the 1st user input (after reset) should ask the user to enter a new password. If it is too time-consuming, you can leave the password task to the administrator when setting up user rights.
► Interface
When you start the program, the user should be able to choose himself from the list, it is desirable that the PC remembers under which user came from this computer (or account) and automatically substitutes this user (as happens when you start 1c).
When entering the primary interface, the user should only see a list of allowed magazines and not see the rest.
The user interface should be made as “intuitively clear” as possible without “lotions” of Access, such as arrows to move to the next base, “hot” keys should be defined and the ability to work with the mouse should be laid down – the interface should be as convenient as possible.
Information with records of a particular journal should be displayed in the form of a table and be able to sort by any column and adjust filters – for example, the range of dates, by the record creator, by the record state (depending on the journal). It is necessary that the system remembers the sorting and filtering settings for each journal and for each specific user.
Make a module for export unloading of sorted and filtered part of the table of the journal being viewed in Excel, it is desirable that the table being unloaded immediately opens and the Excel autofilter is turned on.
● Creating an add-on. Modules upload / download information from / in Word, Excel is welcome.
Software development Cash, Bank transfer
