I am running Windows XP Pro. I am a web designer (stress the designer, not the programmer!) for fun and occasionally for a little money. I would consider myself pretty good at HTML programming using Dreamweaver (which some disdain because it's a WYSWIG editor).
I am working on a project for a non-profit of which I am a member. We can't afford to pay a lot of money, we aren't on a time crunch, and I want to learn how to do this, so I'm using this as an opportunity to learn.
We need to create a web site/portal where several of us can go (password-protected, which I know how to do) and update records in a database. What we're doing now is just emailing an Excel spreadsheet to each other, and obviously you can imagine the tedium and potential for mistakes that this can cause. So we want to each take our stack of stuff that needs to be entered, go home, log in and update an online database as we have the time.
The more I read, I feel that SQL is the way to go; it seems to be the most flexible. Currently I'm hosted on a server (www.websitesource.com
) that will support pretty much anything--PHP, ASP, whatever. However, if we need to change hosts, that is not a problem; I can do that.
I realize this is going to be a big learning curve. I do own MS Access, but it seems like that is just not the best way to go; Access is more user-friendly, it seems, but MySQL seems more versatile.
I have tried going through a tutorial and installing MySQL on my machine, but I am so stuck it's not even funny. I need to know where to start.
This may be way too wide-ranging for help here...I may be too far gone! But if you could give me some advice and pointers, I'd be so grateful. I want to learn this, and I think it's a good opportunity.