MS Access to SQL Server - Newbie needing advice/direction

Question

So I have been working with multiple different MS Access apps at work (about 8) for different departments. And it looks as though there are going to stand up a SQL Server at work, which makes sense from a capacity/integrations standpoint.

Soooo......I have experience with Access, SQL and VBA, but having never used any of it in a SQL Server capacity, are there any resources for learning, books, websites, etc where I can start? Can you "face plate" (yeah sorry that is my term I suppose, and may sound ridiculous) access applications on the SQL Server app so that I can continue to develop, utilize and have end users utilize SQL Server through these access applications?

Thanks

Answer 1

As for SQL Server sites, I'm favoring Simple Talk these days. I think it has something for everybody, newbies and seasoned professionals.

I like their "cribsheets", with the facts on most SQL Server resources (Reporting Services, Security, OLAP, pivot, regex,...).

Answer 2

W3schools.com has good tutorials and quizzes in many fields including SQL and ASP.NET.

You can find articles about using SQL server on SQLserverCentral.com.

Answer 3

Lots of foilks have successfuly upsized their Access apps to SQL Server with a minimm of trouble. There will be some tweaking required and some areas which were slow in Access that you can speed up. Do ensure the users do lots of testing of course. For now avoid merge replication on SQL Server as that and Access seems to have some troubles.

See my Random Thoughts on SQL Server Upsizing from Microsoft Access Tips page

There is a tool from the SQL Server group which is better than the Upsizing Wizard that comes with Access SQL Server Migration Assistant for Access (SSMA Access)