Gentlemen, we've been discussing moving our departmental Access database to a managed instance of Sql Server where my department would own the tables. I know some query SQL and am learning the language. I downloaded Sql Server Express to my PC at home.
1. Can you point me to a tutorial as to how to connect to my SQL server instance from Access?
2. I want to learn how to use SSMS and continue my path to learning the query language and how to create and manage sql databases. I've always learned from books but today people seem to like online resources. Ive been considering a subscription to Safari so I can just browse many books to find ones i like? What would you suggest? Thanks!