I am looking to create a pretty simple or basic database. Some fields will also be shown in 2 areas, not just one. Here is a PDF of the type of information and rough layout or ideas. Just curious...... Should it be done in SQL or ACCESS or ??
Requirements:
Access from internet VIA login name and password (multiple users)
Ability to edit configuration and move to another server if needed over time.
Ability to easily add field if necessary.
Majority of fields are basic data entry fields but some are drop down menus or check boxes.
Would like for it to have a "memory" of previously entered information to make entry faster.
Cant attach the file because its 142kb and the forum maxes out at 100kb. If youre interested and talk to me I will email you the PDF example I made.