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.
Sams Teach Yourself Access 2002 Programming in 24 Hourswill considerably improve the quality of the database applications that the reader can create with Microsoft Access. Concise tutorials that quickly bring the reader up to speed will be the goal of each chapter. Having completed this book, the readers will be able to understand any sample VBA code that they see, and will possess the skills to attack all of the most common Access programming tasks.Topics covered in the book will include: Using data aware controls Creating data aware web pages Creating views to organize data Building reusable code modules Programming reports Communicating results with graphing Automating contact and task management with Outlook Access programming for Internet Explorer
A new edition of this title is available, ISBN-10: 0672330180 ISBN-13: 9780672330186 "Sams Teach Yourself SQL in 24 Hours, Third Edition" presents the key features of SQL (Structured Query Language) in an easy to understand format with updated code examples, notes, diagrams, exercises, and quizzes. New material covers more information on transactions, constructs, embedded databases, and object-oriented programming. In this edition, the authors include examples based on a database like MySQL, a very popular open source database.
This guide teaches readers how to design and implement their an open source database. Topics include designing and creating a database; normalizing data; adding tables, columns and indexes; importing and exporting data; administering, optimizing and troubleshooting My SQL; and locks and keys.
.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.
Understand how to take database needs and turn them into effective Access databases while gaining a thorough understanding of Access tables, forms, reports, and queries with this definitive handbook.
A guide to ASP and IIS fundamentals covers dynamic content, interactivity, writing files on the Web server, personalizing content, reading databases, and debugging scripts.
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.
John guides the reader through the new and unfamiliar Windows interface, while introducing the new features. The book provides information in several formats, all integrated with theory, tutorials, procedures, tips and comprehensive. Topics range from: * Installation of Windows XP * Whether to upgrade and if so, how to do it * Configuring services and setting up users * Navigation of the new menus * Explanation of the new internet options, such as third party cookie alert, firewalls, and web publishing wizard * Registry configurations * Integration ideas for home networks and explanations about using the networking wizards * Accessory overview * Using XP on laptops * Working with Linux Maintaining the system & productivity tips