SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


User interface


User interface

Author
Message
todd.ayers
todd.ayers
Old Hand
Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)

Group: General Forum Members
Points: 353 Visits: 120
I am new to SQL server and currently using Access 2007. I am just wondering could someone attach a screen shot of what the user interface looks like for SQL server 2008?
bitbucket-25253
bitbucket-25253
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16393 Visits: 25280
Use this link to get a small (very small) image of SSMS

http://en.wikipedia.org/wiki/SQL_Server_Management_Studio

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Lowell
Lowell
SSC Guru
SSC Guru (75K reputation)SSC Guru (75K reputation)SSC Guru (75K reputation)SSC Guru (75K reputation)SSC Guru (75K reputation)SSC Guru (75K reputation)SSC Guru (75K reputation)SSC Guru (75K reputation)

Group: General Forum Members
Points: 75749 Visits: 40993
and a bevy of images here:
SSMS 2008 Images/Screenshots

Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
todd.ayers
todd.ayers
Old Hand
Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)

Group: General Forum Members
Points: 353 Visits: 120
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.
bitbucket-25253
bitbucket-25253
SSCoach
SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)SSCoach (16K reputation)

Group: General Forum Members
Points: 16393 Visits: 25280
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.

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read

Before posting a performance problem please read
Lowell
Lowell
SSC Guru
SSC Guru (75K reputation)SSC Guru (75K reputation)SSC Guru (75K reputation)SSC Guru (75K reputation)SSC Guru (75K reputation)SSC Guru (75K reputation)SSC Guru (75K reputation)SSC Guru (75K reputation)

Group: General Forum Members
Points: 75749 Visits: 40993
i would call SSMS a developer tool, and don't think it's really a tool for end users to be working with; it doesn't have any place like Access does to build forms or reports..

Lowell
--help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!
todd.ayers
todd.ayers
Old Hand
Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)Old Hand (353 reputation)

Group: General Forum Members
Points: 353 Visits: 120
Thank you so so much for all the help you guys have provided. My boss is the one wanting to go to SQL server but doesn't know anything about it....and I am not too update on it as of yet. I don't think he realizes there is not really a front end/back end like there is for Access.
Jason-299789
Jason-299789
SSCertifiable
SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)SSCertifiable (5.2K reputation)

Group: General Forum Members
Points: 5191 Visits: 3232
I have seen Access Forms running over the top of SQL server, it works but its far from ideal.

Is the intention to port the Access application directly to SQL server? If it is then I would suggest you write an application to sit over the top and act as the User interface.

_________________________________________________________________________
SSC Guide to Posting and Best Practices
J Livingston SQL
J Livingston SQL
SSChampion
SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)SSChampion (12K reputation)

Group: General Forum Members
Points: 12681 Visits: 37702
http://www.access-programmers.co.uk/forums/showthread.php?t=216956

________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day

Chrissy321
Chrissy321
Hall of Fame
Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)Hall of Fame (3.4K reputation)

Group: General Forum Members
Points: 3358 Visits: 4799
It's still hard to beat Access as rapid application development environment for building data entry forms. If your access tables are properly normalized and have proper keys you can import the tables into SQL Server, create linked tables in access and then bind your forms to the linked tables with a minimum of effort.

It's a reasonably low cost solution for small to medium amounts of data/users. This setup can get a bad reputation because often poorly designed access databases get 'upsized' to SQL server.

I would evaluate your design before moving to SQL Server. If possible import your tables into SQL Server, generate DDL and start a new thread here asking for an evaluation of your database design.
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search