Sams Teach Yourself Microsoft Excel 2000 Programming in 21 Days gives you the skills you need to get up and running efficiently. With this complete tutorial, you'll master the basics and move on to the more advanced features and concepts. Learn to add new functions and capabilities to your Excel files and applications. Explore built-in functions, arrays, subroutines, error handling, string operators and expressions, variables, and constants--all in detail. Step-by-step lessons show you how to use Visual Basic to control different applications from withing Excel, and more.
Learn how to build forms in both the Outlook forms designer and VBA and how to write programming code. Examples emphasize PIM activities such as creating a follow-up call for a contact, managing standard replies and creating a recurring event without a date pattern. Make Outlook 2000 work as a capable database for you. Web site accompanies the book.
Business Modeling and Data Mining demonstrates how real world business problems can be formulated so that data mining can answer them. The concepts and techniques presented in this book are the essential building blocks in understanding what models are and how they can be used practically to reveal hidden assumptions and needs, determine problems, discover data, determine costs, and explore the whole domain of the problem. This book articulately explains how to understand both the strategic and tactical aspects of any business problem, identify where the key leverage points are and determine where quantitative techniques of analysis -- such as data mining -- can yield most benefit. It addresses techniques for discovering how to turn colloquial expression and vague descriptions of a business problem first into qualitative models and then into well-defined quantitative models (using data mining) that can then be used to find a solution. The book completes the process by illustrating how these findings from data mining can be turned into strategic or tactical implementations. Teaches how to discover, construct and refine models that are useful in business situations Teaches how to design, discover and develop the data necessary for mining Provides a practical approach to mining data for all business situations Provides a comprehensive, easy-to-use, fully interactive methodology for building models and mining data Provides pointers to supplemental online resources, including a downloadable version of the methodology and software tools.
Learn how to how to use C# for Internet programming with the hands-on techniques and clear explanations. This book discusses some C# features that allow rapid development of solutions such as garbage collection, simplified type declarations, and scalability support. The book explains key concepts in a simple and practical manner. Web Forms and Web Controls usher in an elegant way to make dynamic Web pages. The book covers these topics with how-to code examples and projects. One of the newest developments in Internet programming is the use of XML and the SOAP communication protocol. .NET Web Services harness these two technologies, and is covered in later sections of the book.
This revision of a bestseller will provide critical information on the many changes coming in the new version of Visual Basic. Includes a proven, step-by-step method for learning VB, which is especially helpful as programmers approach the wide variety of powerful features and tools in Visual Basic.NET.
.NET Windows Forms are a new programming paradigm introduced with Microsoft's .NET initiative. Windows Forms are very similar to Web Forms, which allow programmers to build complex Web application interfaces easily, sharing the same underlying framework and programming concepts. Windows Forms, however, are used for the Win32 platform, instead of the Internet, and allow programmers to build traditional Windows desktop-based applications structured around .NET. Sams Teach Yourself .NET Windows Forms in 21 Days covers all the major aspects of Windows Forms necessary to build professional, functional applications. This book follows the tried-and-tested 21 Days tutorial model to guide the reader through Windows Forms. It features code examples and tips for programmers migrating from pre-Windows Forms Microsoft technologies. The reader will be introduced to the many controls available for .NET Windows Forms and how to build them, learn how to create events and event handlers, explore ADO.NET and methods to retrieve data from dynamic data sources, and learn how to take advantage of the Internet and Internet Explorer from their .NET Windows Forms applications. As readers advance through the tutorials, they progress toward more advanced topics and projects by creating simple graphical applications and enhancing existing ones, learn how to integrate with other .NET applications, use Web services, build Windows services, build Windows Forms controls, create multi-threaded applications, work with COM and COM+ configure and deploy .NET Windows Forms, and how to de-bug .NET Windows Forms.
This book is a hands-on tutorial for Access users who want to learn Access by working through solid examples. It will show the reader how to use Access and how to develop solid databases from start to finish. The focus of the book will be Access databases on the desktop but will have two chapters on implementing Access in a networked or client/server environment. Key topics include understanding relational databases and the Access 2002 architecture; designing, building, and maintaining full-feature, robust database applications; implementing Data Access Pages; working with Visual Basic for Applications and the Visual Basic Editor; and publishing Access content to the WWW or a company's intranet.
