Hi everyone
Before I ask the question, I just want to say that I am very new to MS Access and I only know how to create tables and queries. I do not know anything about creating a nice front end but I'm willing to learn.
I am using MS Office 365.
I want to create a website which has lots of questions in there. At first, they will be only multiple choice questions but later I want to include different types of questions. I want to use a MS Access database to store all the questions and answers.
The user will be required to login on the web front end and then he/she will have access to the questions.
The questions belong to different CATEGORIES e.g. questions about mathematics, English, chemistry, etc...
Each category will have multiple SUB-CATEGORIES
Each SUB-CATEGORY will have multiple SUBJECTS.
Each SUBJECT will have multiple questions.
I want to limit access to CATEGORIES, SUB-CATEGORIES and SUBJECTS for each user.
Is this too much for MS Access to handle? Should I consider another database?
If not, any suggestions on where to start would be greatly appreciated.
Any help would be appreciated.
Thanks
Ray