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