I usually work with mdb, but I was planning on building a more secure and larger online database. So I guess SQL is the choice.

My question is, how do you create the tables and fields? Is it simple like opening Microsoft Access to crete the database or do I have to do it through a server?

 

i assume you mean sql server? sql is just a language to interrogate the database

you need to install sql server
and then use sql CREATE TABLE statements to... well do just that, create your tables.

 

If you use SQL Server you will use enterprise manager which is fairly similar to what you have seen in access to create tables which behind the scenes is issuing CREATE TABLE statements like Chef says. You can get hold of SQL Server 2005 express for free and management studio express which will do all you need.

Gary

 

Ingres?

 

Oracle?

 

Well if cost and ease of use are prime factors then surely its sql server, many dbs which have solid engines are let down by poor management tools.

 

Thats why I use Toad