Has anyone created an employee database on access?
Do this project right. If you’re going to do it yourself, invest in some training on database principles. If you create a sloppy database, you will cause yourself a lot of problems down the road. Any decent book on data normalization (like – ahem – one of mine) would be a good start. Make sure you understand how to break data into tables to avoid the most common problems: * duplicated data * listed fields * abbreviation * update problems Then be sure to understand how joins can be used to put these tables back together to solve your problems. You will need a normalized database. You can learn to do it yourself, or you can hire somebody to do it for you, but if you try to do something too simplistic (with only one table, for example) you’ll end up regretting that decision. BTW, the database software itself isn’t that important. Access is fine for a small business app (less than a thousand records, not used on a web site) but it’s not reliable with heavier loads. MySQL is far more powerf
