Using Access for Sql Front End

[jmccon]

I want to use access 2007 as a front end for Sql Server DB. I want to create a basic input form, a serach and display facility, and have some reports generated out of the application.
Does anyone know if this would be possible to do using Access in 20 days?

Does anyone have any good tutorials/resources to get me started?

[CJ_London]

it is certainly possible - within 20 days? depends on your skill levels

the easiest way is simply to link to the tables in sql server. Click on the external data tab, select ODBC database and follow the prompts. You'll need appropriate access rights to sql server. Once linked, you just develop as per an 'ordinary' front end.

[jmccon]

Thanks for the reply Ajax.
I want to calculate some fields also like adding 3 fields and the sum of those would be added to another field e.g. FieldA + FieldB + FieldC = FieldD
How can I do this in access?

[CJ_London]

first, sql server does not support calculated fields - you should calculate them as and when required in a query.

In a query in access it would be written something like

SELECT *, FieldA + FieldB + FieldC AS FieldD
FROM sqlserverTable

[ItsMe]

Yup, create an alias in a query.

SELECT *, FieldA + FieldB + FieldC AS FieldD
 FROM sqlserverTable

[jmccon]

Will this query above add FieldA + FieldB + FieldC into FieldD
When would you kick off this query, on form load?

[CJ_London]

Sounds like you need to learn what access is about.

neither query will add the data into field - it displays it

the query would be (or could be) the recordsource to your form - all depends on the detail of what you are trying to acheive