Dotnetcat » .NET Books » SharePoint books

The one book you absolutely need to get up and running with Windows Server 2008 R2.

One of the world's leading Windows authorities and top-selling author Mark Minasi explores every nook and cranny of the latest version of Microsoft's flagship network operating system, Windows Server 2008 R2, giving you the most in-depth coverage in any book on the market.

• Focuses on Windows Windows Server 2008 R2, the newest version of Microsoft's Windows' server line of operating system, and the ideal server for new Windows 7 clients
• Author Mark Minasi is one of the world's leading Windows authorities and has taught tens of thousands of people to design and run Windows networks
• Covers Windows storage concepts and skills, Windows Server 2008 IP, WINS, NetBIOS, LMHosts, DNS, creating the simple Active Directory, and creating and managing user accounts
• Explains Group Policy in Active Directory; files, folders and shares; Sysvol, old and new; sharing printers on the network; remote server administration; connecting Windows clients to your network; working the Web with IIS 7.0; and AD maintenance and recovery
• Provides workarounds for things that don't quite work as they should and how-tos for many undocumented features

Find out everything you want to know-and then some!

The best of the best from the bestselling authors of Excel, Word, and PowerPoint Bibles!

Take your pick of applications from the Office 2010 suite and your choice of leading experts to show you how to use them. This Office 2010 Bible features the best-of-the-best content from the Excel 2010 Bible, by "Mr. Spreadsheet" John Walkenbach; the Word 2010 Bible by Microsoft MVP Herb Tyson; the PowerPoint 2010 Bible, by PowerPoint expert Faithe Wempen; and coverage of Access 2010 from Microsoft MVP Michael Alexander. If you want to quickly and effectively begin using Office 2010, start in the experts' corner with this must-have book.

• Gives you the best-of-the-best content on Office 2010 from the leading experts, authors, and contributors to our Excel, Word, PowerPoint, and Access Bibles
• Includes content from John Walkenbach, aka "Mr. Spreadsheet"; Word expert and Microsoft MVP Herb Tyson; PowerPoint expert Faithe Wempen; and Excel and Access expert and Microsoft MVP Michael Alexander
• Takes you beyond creating simple text documents, spreadsheets, and presentations to help you use multiple Office applications at once to conquer critical business tasks
• Hones in with expert coverage of the topics within each application that you need to know most
• Covers even more from Outlook and other key Office topics

Get the best of four books in one with this power-packed reference!

Microsoft Office 2007 is a major upgrade from the last version of Office; Access will also be greatly revised. Alison Balter is the name that Access developers will trust to guide them through Access 2007's new features. She has the rare ability to take complex topics and explain them clearly, as shown by the success of her ten previous books on Access. Balter is known for providing real-world solutions to specific Access development problems. She also is known for her ability to back up her practical examples with just enough underlying theory to give the reader a good overall understanding of Access. In short, this book will provide beginning and intermediate Access developers with everything that they need to know to design and build Access 2007 applications. It should also appeal to DBAs and power users who want or need to get started building custom Access apps. This latest book in her Mastering Access series will not disappoint her many fans who anxiously await each new version, and should win her new fans as well.

 

Introduction

Part I The Basics of Access Development

1 Access as a Development Tool. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 7

2 What Every Developer Needs to Know About Databases and Tables . . . . . . . 75

3 Relationships: Your Key to Data Integrity . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 115

4 What Every Developer Needs to Know About Query Basics. . . . . . . . . . . . . . . . . 137

5 What Every Developer Needs to Know About Forms. . . . . . . . . . . . . . . . . . . . . . . . . . 189

6 What Every Developer Needs to Know About Reports. . . . . . . . . . . . . . . . . . . . . . . . 269

7 What Are Macros, and When Do You Need Them? . . . . . . . . . . . . . . . . . . . . . . . . . . . 315

8 VBA: An Introduction . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 345

9 Objects, Properties, Methods, and Events Explained . . . . . . . . . . . . . . . . . . . . . . . . . . 401

10 Advanced Form Techniques. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 431

11 Advanced Report Techniques. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 493

12 Advanced Query Techniques . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 539

13 Advanced VBA Techniques. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 599

14 Exploiting the Power of Class Modules. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 637

15 What Are ActiveX Data Objects, and Why Are They Important?. . . . . . . . . . 671

Part II What to Do When Things Don’t Go as Planned

16 Debugging: Your Key to Successful Development . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 727

17 Error Handling: Preparing for the Inevitable . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 755

18 Optimizing Your Application. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 801

Part III Developing Multiuser and Enterprise Applications

19 A Strategy to Developing Access Applications. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 835

20 Using External Data. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 847

21 Access 2007 and SharePoint . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 883

22 Developing Multiuser and Enterprise Applications . . . . . . . . . . . . . . . . . . . . . . . . . . . . 909

00_0672329328_FM.qxd 5/4/07 9:23 AM Page iii

Part IV Black Belt Programming

23 Working with and Customizing Ribbons . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 935

24 Automation: Communicating with Other Applications. . . . . . . . . . . . . . . . . . . . . . 949

25 Exploiting the Power of the Windows API . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 985

26 Creating Your Own Libraries. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1011

27 Using Builders and Wizards . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1027

28 An Introduction to Access and the Internet/Intranet. . . . . . . . . . . . . . . . . . . . . . . . 1055

Part V Adding Polish to Your Application

29 Documenting Your Application. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1073

30 Maintaining Your Application. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1091

31 Database Security Made Easy . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1103

The following appendixes are available for download

at www.samspublishing.com/title/0672329328.

Part VI Appendixes

A Naming Conventions. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . PDF:1131

B Table Structures. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . PDF:1137

Index. . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . 1193

 

Built on Microsoft technologies including Microsoft Office SharePoint Server, SQL Server, Microsoft Office 2007, and Visual Studio 2005 and 2008, the latest K2 [blackpearl] release provides you with mature workflow management systems that can automate processes or pull together people, services, and systems. You’ll get an introduction to workflow and business processes management, planning and administering a K2 infrastructure, and building processes and workflow.

"Exchange experts and Microsoft MVPs Richard Luckett, William Lefkovics, and Bharat Suneja have packed this book with practical guidance, useful information, and years of knowledge and experience. If you’re responsible for one or more aspects of an Exchange 2007-based messaging system, keep this book close, as you’ll be referring to it often!" --Scott Schnoll, Principal Technical Writer, Exchange Server Product Team, Microsoft Corporation

"I recommend this book for anyone who wants a strong foundation in Access."
—Jeff Lenamon, CIBC World Markets

Updated edition with exciting new Access 2007 features!

Harness the power of Access 2007 with the expert guidance in this comprehensive reference. Beginners will appreciate the thorough attention to database fundamentals and terminology. Experienced users can jump right into Access 2007 enhancements like the all-new user interface and wider use of XML and Web services. Each of the book's six parts thoroughly focuses on key elements in a logical sequence, so you have what you need, when you need it. Designed as both a reference and a tutorial, Access 2007 Bible is a powerful tool for developers needing to make the most of the new features in Access 2007.

• Build Access tables using good relational database techniques
• Construct efficient databases using a five-step design method
• Design efficient data-entry and data display forms
• Utilize the improved Access report designer
• Use Visual Basic(r) for Applications and the VBA Editor to automate applications
• Build and customize Access 2007 ribbons
• Seamlessly exchange Access data with SharePoint(r)
• Employ advanced techniques such as the Windows(r) API and object-oriented programming
• Add security and use data replication in your Access applications

What's on the CD-ROM?

Follow the examples in the book chapter by chapter using the bonus materials on the CD-ROM. You'll find separate Microsoft Access database files for each chapter and other working files, including

• All the examples and databases used in the book, including database files, images, data files in various formats, and icon files used in the book's examples
• A complete sample application file, including queries, reports, objects, and modules, that you can use as a reference

See the CD-ROM appendix for details and complete system requirements.

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

The expert guidance you need to get the most out of Access 2010

Get the Access 2010 information you need to succeed with this comprehensive reference. If this is your first encounter with Access, you'll appreciate the thorough attention to database fundamentals and terminology. If you're familiar with earlier versions, you can jump right into Access 2010 enhancements such as the new Access user interface and wider use of XML and Web services.

• Takes you under the hood of Microsoft Access 2010, the database application included with Microsoft Office 2010
• Explores the latest enhancements, such as a new user interface and wider use of XML and Web services; also, how to exchange data with Word, Excel, PowerPoint, and other Office apps
• Covers how to create tables, manipulate datasheets, and work with multiple tables
• Explains the seven database objects and how to use a seven-step design method to build a database tailored to your needs
• Shows you how to build forms, use Visual Basic and the VBA Editor, automate query parameters, create functions and subroutines, use XML to create data access pages, and more
• Includes a CD with all source code from the book and working examples, plus bonus shareware, freeware, trial, demo and evaluation programs that work with or enhance Microsoft Office

You’ll want to keep this soup-to-nuts Access reference close at hand!

Note: CD-ROM/DVD and other supplementary materials are not included as part of eBook file.

Now you can do the things you do every day with Microsoft Office FrontPage 2003—format Web pages, create hyperlinks, use style sheets—and ramp up on new and more advanced techniques—faster, smarter, better!

With the information in Microsoft Office PerformancePoint Server 2007, you can learn the best practices for managing business performance using Office PerformancePoint 2007 and related Microsoft tools. The specific end-user scenarios begin by describing the business requirements and objectives and end with detailed technical guidance for implementing performance management solutions. Leverage PerformancePoint with other key technologies, including SharePoint Server, SQL Server Business Intelligence tools and Office Excel and Excel Services. Use PerformancePoint for common performance management scenarios, including scorecarding, dashboarding, reporting, analysis, planning, budgeting and forecasting.

Here s the eminently practical, pocket-sized reference for IT and Web professionals working with IIS 7.0. Designed for quick referencing and compulsively readable, this portable guide covers all the basics needed for Web administration fundamentals, Web server administration, essential services administration, and performance, optimization, and maintenance. It s the fast-answers guide that helps users consistently save time and energy as they administer IIS 7.0. Written by an award-winning author of more than two dozen computer books, this guide puts expert administration and troubleshooting advice right at your fingertips. Featuring quick-reference tables, concise lists, and step-by-step instructions, this handy, one-stop guide provides fast, accurate answers on the spot whether you re at your desk or in the field.

Delivers must-know details and procedures for administering, supporting and troubleshooting IIS 7.0, including information for performance optimization

Features concise tables, easy-to-scan lists, and step-by-step instructions for the answers you need, wherever you need them