What Alison's book offers over most or all of the other books on the market is that Alison is able to take a highly technical topic and present it in a manner that is easy to comprehend. It is a book that the reader will often want to read from cover to cover, but it can also act as an excellent reference. The CD includes all source code from the book, sample databases, and complete applications.

Master Everything Access 2002 Has to Offer Reap the benefits of the latest release of Microsoft Access with Mastering Access 2002 Premium Edition. Get clelear, in-depth coverage of the entire range of Access functionality, from basic to advanced. Special attention to new features makes the transition from an earlier version quick and painless, and 200 pages of bonus macro material teaches you ways to customize and automate Access to make it work for you. Establish Key Skills Create a database that meets your precise needs Design easy-to-use forms with effective visual elements Expand and collapse views to bring in supporting details Import and export data, including XML Examine data using subdatasheet views Summarize, analyze, and trend data with PivotTables and PivotCharts Filter data and create reports Publish Access data to a Web server Personalize Access menus and toolbars Keep your data secure Take advantage of improved integration with other Office applications Create custom error messages Then Tackle These Cutting-Edge Topics Recording and running macros Maintaining data with macros Handling complex macro navigation Using macros to work with groups of records Identifying and correcting macro errors Using Access as SQL Server's front end Using Access as the core of a database-driven Web site Managing replication and conflict resolution Using Visual Basic to get the most out of Access Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Written with clarity and a down-to-earth approach, Sams Teach Yourself SQL Server 2005 Express in 24 Hours covers the basics of Microsoft's latest version of SQL Server. Expert author Alison Balter takes you from basic concepts to an intermediate level in 24 one-hour lessons. You will learn all of the basic tasks necessary for the administration of SQL Server 2005. You will also learn how to write and fully utilize: SQL Server stored procedures Functions Triggers using T-SQL, VB.NET, and C# You will also learn how to output SQL Server data to reports and the Internet. Sams Teach Yourself SQL Server 2005 Express in 24 Hours is a well-organized, authoritative introduction that will quickly have you up and running with SQL Server 2005.

What Alison¿s book offers over other books in that she is able to take a highly technical topic and present it in a manner that is easy to comprehend. It is a book that the reader will often want to read from cover to cover, but it can also act as an excellent reference. Readers of this book will learn: Access 11 application development and real-world solutions to specific development and programming problems. Professional programming techniques backed by concise, no-nonsense explanations of the underlying theories. Debugging and troubleshooting methods to solve problems quickly and get stalled development projects back on track.

This is the eBook version of the printed book. Microsoft Office Access 2007 includes a plethora of new features that could prove difficult to find for even seasoned users of previous versions of Access. Alison Balter's What's New in Microsoft Office Access 2007? includes a discussion of all the new features in Access 2007, providing details and practical examples on the use of each feature. Her teaching style is clear and succinct, providing you with a great jump-start to working with Access 2007. The topics covered include what's new with tables, the new and improved embedded macros, and what's new with importing and exporting. Table of Contents Section 1 What's New with the User Interface? Section 2 Exploring the New Database Templates Section 3 What's New with Tables? Section 4 What's New in Datasheet View? Section 5 What's New in Forms? Section 6 What's New in Reports? Section 7 The New and Improved Embedded Macros Section 8 The New and Improved Help Viewer Section 9 What's New in Importing and Exporting? Section 10 Access 2007 and Outlook 2007 Integration Section 11 What Else Is New with Microsoft Office Access 2007? Section 12 Additional Tips and Tricks Alison Balter has been writing about Access since Access 95. She has written eight books and co-authored two books on Access and has written one book on Microsoft SQL Server 2005 Express. Her books include Essential Access 95, Alison Balter's Mastering Access 95 Development, Alison Balter's Mastering Access 97 Development, Access 97 Unleashed, Alison Balter's Mastering Access 2000 Development, Alison Balter's Mastering Access 2002 Desktop Development, Alison Balter's Mastering Access 2002 Enterprise Development, Alison Balter's Mastering Office Access 2003 Development, Access 2003 In-a-Snap, Access 2003 in 24 Hours, and SQL Server Express in 24 Hours. Alison has more than 13 years of practical experience working with Access and Access applications. Her clients' projects range from small end-user projects through enterprisewide applications. Clients include the Archdiocese of Los Angeles, Southern California Edison, Accenture, Prudential Insurance, and the International Cinematographer's Guild. Her Access skills are not limited to writing and programming. Alison has also been teaching Access and speaking at conferences for more than 12 years. Her training has included everything from end-user training to corporate training, in both the United States and Canada.

This is the eBook version of the printed book. Access 2007 is tightly integrated with SharePoint. This Short Cut provides readers with everything that they need to know about working with Access 2007 and SharePoint. Topics covered include why SharePoint is important to an Access 2007 developer, how to move your database to a SharePoint site, and how to open and work with SharePoint lists from within Access 2007. It also covers how to integrate with the SharePoint workflow, how to work with SharePoint services off-line, and how to map Access data to SharePoint data. All of these topics are necessary when integrating Access 2007 and SharePoint. Alison Balter has been writing about Access since Access 95. She has written eight books, co-authored two books on Access, and has written one book on Microsoft SQL Server 2005 Express. Her books include Essential Access 95, Alison Balter's Mastering Access 95 Development, Alison Balter's Mastering Access 97 Development, Access 97 Unleashed, Alison Balter's Mastering Access 2000 Development, Alison Balter's Mastering Access 2002 Desktop Development, Alison Balter's Mastering Access 2002 Enterprise Development, Alison Balter's Mastering Office Access 2003 Development, Access 2003 In-a-Snap, Access 2003 in 24 Hours, SQL Server Express in 24 Hours. Alison has over 13 years of practical experience working with Access and Access applications. Her clients’ projects range from small end-user projects through enterprise-wide applications. Clients include Archdiocese of Los Angeles, Southern California Edison, Accenture, Prudential Insurance, and the International Cinematographer's Guild. Her Access skills are not limited to writing and programming. Alison has also been teaching Access and speaking at conferences for more than 12 years. Her training has included everything from end-user training to corporate training, in both the United States and Canada. Table of Contents Section 1: What is SharePoint Server 2007 and Why Integrate It With Your Access Applications? Section 2: The Access 2007 (accdb) File Format and SharePoint Section 3: Exporting Data to a SharePoint Site Section 4: Publishing Data to a SharePoint Site Section 5: Opening Access Forms and Reports from a SharePoint Site Section 6: Linking to and Importing from SharePoint Lists Section 7: Taking SharePoint Lists Offline with Access Section 8: The Basics of Working with SharePoint Section 9: Re-establishing Links When a SharePoint Site has been Moved Section 10: Modifying the Design of an Access Database Stored on a SharePoint Server