Professional Excel Development [Electronic resources] : The Definitive Guide to Developing Applications Using Microsoft® Excel and VBA® نسخه متنی

اینجــــا یک کتابخانه دیجیتالی است

با بیش از 100000 منبع الکترونیکی رایگان به زبان فارسی ، عربی و انگلیسی

Professional Excel Development [Electronic resources] : The Definitive Guide to Developing Applications Using Microsoft® Excel and VBA® - نسخه متنی

Stephen Bullen, Rob Bovey, John Green

| نمايش فراداده ، افزودن یک نقد و بررسی
افزودن به کتابخانه شخصی
ارسال به دوستان
جستجو در متن کتاب
بیشتر
تنظیمات قلم

فونت

اندازه قلم

+ - پیش فرض

حالت نمایش

روز نیمروز شب
جستجو در لغت نامه
بیشتر
لیست موضوعات
توضیحات
افزودن یادداشت جدید











Conclusion


We've covered a lot of ground in a very short space in this chapter. We've explained what databases are and under what circumstances you should use them. We've explained how to structure your data properly for storage in a relational database. We've provided a brief introduction to SQL and ADO and demonstrated how you can use them to retrieve and manipulate data in a relational database from your Excel VBA application. Because we cannot possibly do justice to any of these topics in a single chapter, we've also provided you with pointers to some excellent resources for additional information.

The ability to work with databases may have been an optional skill for the professional Excel developer five or six years ago. Today it is an absolute requirement. As different types of applications converge, there are fewer and fewer nontrivial Excel applications that do not require interaction with a back-end database of some kind. If you need to be a true professional Excel developer, you will need to understand how to work with databases.


/ 225