how to convert access code to Sql server 2005

[blyssz]

I am an intermediate level access programmer, I have been using MS Access from the past few year and very new to SQL Server and now we are moving on to SQL Server 2005. I am trying to produce some reports in SQL Server 2005 but I have a very fundamental question.
As we design forms and create tables, queries in access and write programming code in access, how can we achieve similar task in SQL server??
I migrated database from Access to SQL Server using SSMA but could not get the queries in SQL server and do not know where to write the code.
Any suggestion would be appreciated.
Thanks,
Blyssz

 

[markros]

When you start SSMS and connect to your database, click on New Query button. Make sure your database is selected in the top combobox (bellow the New Query button). Now you can write your queries.

SQL Server doesn't have ability to create forms like Access, since it's database language. You need another front-end application for this, such as VB.NET, for example.

 

[genomon]

You need another front-end application for this, such as VB.NET, for example.

Or you can link the SQL Server tables into Access and use the forms and reports like you always have (your Access queries will work just fine as is on linked tables as well).

Illegitimi non carborundum.

 

[blyssz]

Thank you markros and genomon for your response.

Does that means we can produce basic reports directly from relational tables and OLAP cube but need to use a front end application for complex reports??

Thanks,
Blyssz

 

[SQLSister]

You need a front end period, under no circumstances should you give users access to SSMS. That is for developers and database admins only.

SQL Server does have a reporting application (Similar in functionality to Crystal Reports) called SSRS. You might look into that for serving up your reports. But it isn't for data entry for instance.

"NOTHING is more important in a database than integrity." ESquared