todd.ayers (4/8/2013)
So this is what the user sees on the front end? This is the actual window they would be working in to retrieve information and so forth? It is very different than the forms and reports you create in Access.
It is a powerful tool, what a user can do depends upon the user's role and permissions.
Before you switch to using SQL server I suggest that you download and become acquainted with the strengths and weakness of allowing users direct access to database information (displaying / adding new data/modifying existing data, etc., etc.)
There is a free version of SQL Server known as SQL Server Express available at
http://www.microsoft.com/en-us/download/details.aspx?id=29062
you can import existing ACCESS tables, queries, etc. into the express version, and experiment with same. If in so doing you have any additional questions post them and many others will be willing to assist your.