Hi every body i am very new in the field of creating SQL database. i am creating a programme in access 2007. my database is quite large. i learnt big database better works in SQL. but i have no idea how start with. i need help in this field. i will be very much thankful if any body help me in designing SQL database. what are the basic requirements. if any body have samples then please give it to me. i hope a positive response from you all. thank you
You have your work cut out for you! Sounds like someone has already done the database design and creation and all you need to do is write the queries? Older versions of Access came with a query builder - I'm sure its still there in 2007 - find it, play with it and learn how to make it work for you. You'll learn alot about sql queries that way. I'd start by creating a sample database and creating a sample application. A bit like people do when they learn any new "craft", they create small works before tackling the big ones. Search in google for tutorials. I'm sure there are lots out there. If you find a site that looks good but you have to pay to get to the good stuff, then pay - its worth it to fast track your learning.