SQL for Microsoft Access (2nd Edition) provides a guide to getting the most out of Microsoft Access through the use of Structured Query Language. Step-by-step examples demonstrate how to use SQL script to create tables, add records to tables, and retrieve and manage records. Readers will also learn about calculated fields, Access projects, and the integration of SQL script in VBA and ASP code. Explore the relational database structure and the basics of SQL. Understand how table joins, unions, and subqueries are used to retrieve records from multiple tables simultaneously. Learn how to filter records and group data. Discover how to create parameter queries that prompt users for data. Test your knowledge and comprehension with the end-of-chapter quizzes and projects.

This hands-on guide provides much-needed information and guidance for the Access power user or developer wanting to exploit the power of SQL Server. It provides readers with the practical knowledge they need to harness the enterprise-level power and scalability SQL Server offers, while using the Access tools with which they are more familiar.

Learn Microsoft SQL Server 7 by successfully completing hands-on projects You don't have to be a fortune teller to realize that Microsoft's SQL Server 7 is going to be the most widely used database product on the planet. This book, unlike typical reference books, shows you how to use SQL Server to add value to your business operations. Drawing inspiration from the lab manuals you used in biology and earth science classes, the authors provide step-by-step instructions for accomplishing the kinds of projects you'll want to do with SQL Server. Here's a taste of some of the projects: * How to build an e-commerce site with Site Server Commerce Edition * Implementing a data-driven Intranet with SQL Server and IIS * Creating both single-source and multisource data marts * Working with OLAP Services and a variety of OLAP clients * Writing Visual Basic applications that work with SQL Server Plus two CD-Roms! * CD-ROM 1 contains Microsoft SQL Server 7.0 120-Day Evaluation Edition * CD-ROM 2 contains all the code from the book, example applications, 18 third party Development tools, and links to related Web sites

F. Scott Barker's Access 2002 Power Programming gives many practical techniques for the corporate and independent developer. The main topics covered are: The Root of Power Programming; Manipulating and Presenting Data; Extending Access with Interoperability; Adding the Professional Look and Distributing Applications; Managing Databases; Adding Finishing Touches. New features of Access 2002 will be covered thoroughly, including: A whole new chapter devoted to Data Pages, which is Microsoft's way of bringing the Web interface into everyday office solutions. A new chapter clarifying the confusion over ADP/MDB and DAO/ADO. Including when and where to use each. There are a number of new additions to VBA which developers will need good exposure to in order to take advantage of them. A number of changes have been implemented in the form design with control features added.

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

By covering this project management tool, this work offers the reader an understanding of the features, functions and best practices of project management.