I am a database manager for a hospital in the UK. My main role is that of a managing the staff, budget etc. But I would like to understand certain capabilities of SQL Server.
We will soon be upgrading a server of ours to SQL Server 2005 to practice and have a 'play' with. I want to learn how to upsize access databases to an SQL backend, and also add a table from SQL server to an access database.
Any help and guidance is appreciated.