Free Trial

Safari Books Online is a digital library providing on-demand subscription access to thousands of learning resources.

  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint

Summary

So you are now at the end of the book and should be feeling confident in working with SQL Server from installation through developing for it. This chapter saw the final piece of the jigsaw, where you could now connect and execute code against a SQL Server database from one of several different languages and tools.

Excel is an excellent basic reporting tool and ideal for retrieving results quickly and efficiently in a well-formatted manner to your users. If you combine this with VBA code, you can perform a huge range of actions, and there are companies that purely use Excel with VBA as their interaction with a database. It’s not perfect in some respects, but users love Excel, and as a developer you can get a front end built and ready in minutes.


  

You are currently reading a PREVIEW of this book.

                                                                                                                    

Get instant access to over $1 million worth of books and videos.

  

Start a Free 10-Day Trial


  
  • Safari Books Online
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint