We are working on a project to add questions and answers to a online database (access mdb)
Different people are creating these questions and will have access to the questions they have made, to edit them.
An admin will need to have access to all questions in the mdb
**Part 1**
User will have to login (table users)
if non-admin, the user only has access to his own questions
if admmin, to all questions
if correct login then user gets a list of all questions he made and has the possibility to add, edit or remove questions. The screen is schematicly made in the attached Word-document.
**Part 2**
In the screen with the list of questions a user can add, edit and delete questions. Also it should be possible to search in the records that are connected to the creator (or if admin to all)
if more that f.e. 15 records that there should be a small menu below the list with " <1 2 3 4 >"
Because the fieldnames in the database are in Dutch, I have added a explanation of the Dutch words into English
oefeningen_bron and oefening_afkorting are both 1
The database structure cannot be changed, because its already in use by other components
Attached:
Word-document with schema of the screen
sample database
## Deliverables
1) Complete and fully-functional working program(s) in executable form as well as complete source code of all work done.
2) Deliverables must be in ready-to-run condition, as follows (depending on the nature of the deliverables):
a) For web sites or other server-side deliverables intended to only ever exist in one place in the Buyer's environment--Deliverables must be installed by the Seller in ready-to-run condition in the Buyer's environment.
b) For all others including desktop software or software the buyer intends to distribute: A software installation package that will install the software in ready-to-run condition on the platform(s) specified in this bid request.
3) All deliverables will be considered "work made for hire" under U.S. Copyright law. Buyer will receive exclusive and complete copyrights to all work purchased. (No GPL, GNU, 3rd party components, etc. unless all copyright ramifications are explained AND AGREED TO by the buyer on the site per the coder's Seller Legal Agreement).
## Platform
ACCESS MDB
ASP 3
IE and FIREFOX compatible