Here are five things I think beginners would really want to see: 1. SQL Server as a new tool. Big-picture explanation, how it compares to Access, and when it makes sense to move to it. 2.Getting SQL Server up and running Installing it, setting it up correctly, and understanding the basic tools without getting overwhelmed. 3.Core SQL skills that actually matter Writing queries, joins, filtering, grouping—enough to be productive without assuming prior experience. 4.How people really use SQL Server in the real world Common patterns, basic security concepts, and how data is typically organized and maintained. 5.Working with other tools (especially Access) How SQL Server fits into an existing setup and how people commonly use it as a backend.
I think a beginner-friendly, practical approach would be really valuable, especially for people coming from Access or small-business environments.
Raymond Spornhauer
@Reply 8 months ago
Good comments from Tony.
I would ask for the following:
1. Using SQL Server with direct link to Access
2. Using SQL Server with ODBC or other connection methods. (using pass-thru queries)
3. Setting up Read/Write permissions to tables or queries
4. Using SQL Server to create 'Views' then connecting that to your Access Database.
5. Left or Right Join Queries with more than 1 Table on SQL Server
Richard I would like to see how to transition current Access dbs from a local or BE setup, to use on a SQL Server. As a SQL Server Noob, my first thoughts are how to get "stuff" from where it is now to SQL Server.
Sorry, only students may add comments.
Click here for more
information on how you can set up an account.
If you are a Visitor, go ahead and post your reply as a
new comment, and we'll move it here for you
once it's approved. Be sure to use the same name and email address.
This thread is now CLOSED. If you wish to comment, start a NEW discussion in
Beginner Level 1.
