The project is essentially the conversion of an existing multi-user access database, with some further development, into a cross-platform distributable application. It does not matter whether it's built as a web app or a native app, provided that it is secure, supports multiple users (with password access), and can be deployed over a network.
The underlying schema for the database already exists (in MySQL). There are 15 tables, and ~88 junction tables. I expect there will be ~45 forms (of which 10% are read-only) - the functionality of many is largely the same, and the existing database demonstrates that functionality. To the extent it can be adapted for this use, all existing functions have been written in VBA (and the queries are in SQL, though the naming conventions have changed and so they cannot be directly copied).
At a high level, the application serves as a means of storing documents (mainly PDF and email files) and concepts, and linking those files / concepts to one another (broadly similar to a many-to-many database that you could use for a library - linking titles, authors, subject matter, fiction/non-fiction, call numbers, similar books etc.). Reports of the relationships can be generated (e.g, the user can generate a report which shows all documents related to a given issue), and documents can be arranged and batch-exported and indexed. Ideally files loaded into the database will be accessible through explorer / finder in an intuitive file structure that mirrors the document type, such that someone not wanting to use the app can still access the files.
UI design is incredibly straightforward and can be modelled on existing DB, and all icon graphics will be provided.
Later builds will allow remote access on mobile devices