Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2004-09-16 : 08:19:02
|
| Rickie Doherty writes "Hi This is I know a very silly question but I have just started reading about SQL because I would love to start using it for databases instead of Access that I currently use.I have looked at the tables section of SQL and it looks very straigtforward but I want to know how the front end screens are made, in access there is a form design view and i take it isn't this way in SQL. Do I have to purchase a VB package or something like this.Also if you have a very good understanding of Access and relationships in general am I being too ambitous to think that I can start building large SQL databases after a weeks training.SQL Virgin.Rickie DohertyIreland" |
|
|
Amethystium
Aged Yak Warrior
701 Posts |
Posted - 2004-09-16 : 08:44:59
|
You will need use different software in order to design your user-interface. Visual Basic is probably one of the easier languages to learn. Connecting to SQL Server is even easier, ADO is quite easy to learn and it's all there for you to use. Of course there are many more programming software, I mean you could get your hands dirty with Delphi (more powerful controls than VB that's for sure).Anyway, providing you have a good understanding of relationships etc and if you're good with Access then learning SQL Server will be easier for you. You will need to get use to the Transact SQL syntax but that shouldn’t be a problem.And as for designing complex databases in a matter of a week... I don't think you can unless you're a genius that is!------------->>> BREAKING NEWS!!! <<<------------- Saddam Hussien has weapons of mass destrcution |
 |
|
|
|
|
|
Front End Screen