Jumat, 27 Maret 2015

[MS_AccessPros] Re: Learning to work in SQL Server

 

Adam

The Management Studio is a little different from Access, but table and view designers are very similar. I started out using the view designer but have long since learned how to create views using T-SQL. I still tend to use the designer GUI for creating tables because it takes less time.

But keep in mind SQL Server is far more complex than Access. Take some time to learn about security, collation, sizing, growth rates and backups if you are going to be the guy who is responsible for any databases you use.


---In MS_Access_Professionals@yahoogroups.com, <runuphillracing@yahoo.com> wrote :

What do I need to learn and do differently to start working in and SQL server environment, with and without Access? I'm not talking about migrating existing Access databases, but starting from scratch or taking over existing SQL server databases. I've not had the opportunity to dip my toes there yet. For example, does non-Access SQL have a GUI interface too?


Thanks

Adam

__._,_.___

Posted by: wrmosca@comcast.net
Reply via web post Reply to sender Reply to group Start a New Topic Messages in this topic (3)

.

__,_._,___

Tidak ada komentar:

Posting Komentar