I Need help with a database project

[Marlita Hill-Campbell]

Hello everyone. I am new to this group and very excited about learning more. I have built a database to compile services for individual artists. I need help with the next phase of my project because it is way out of my realm of knowledge. Here is my issue:

I have a database in Access (that will probably have to be moved to MySql). I want to create a web-based multi-user database where I can have people assist me in entering data into my permanent database. I want the users to have a user name and password to access the database.
I want to be able to approve the information the users submit, and then once approved, I want the information to go into the fields of my existing database.

I have tried to look up tutorials on-line but I don't even know what to look for. Is this something that anyone might be able to assist me with. I know its an undertaking and i will do the work...I just don't know what the work is. LOL

I appreciate any assistance you can offer.


Thank you!!!! I hope you can help!

Marlita

[Barry Williams]

Hi Marlita,

Welcome to the Community ;)
I hope you find your membership interesting and worthwhile. If you have any questions at any time, just let me know.
In the meantime, I have drafted a very simple Data Model that can provide a vehicle of communication for us :-
http://www.databaseanswers.org/data_models/user_submitted_material/...

The logic behind the Model says :-
"Users can submit Material, which is stored in a Staging Table called Material"
"After it has been approved by the Moderator (you ;)) it can be entered into the permanent Database"
"It can then be deleted from the Material Table."
"Material can be in one of a number of Categories, such a General or Travel Writing".

I look forward to your comments.

HTH

Barry