Author(s) : Helen Feddema
Publisher : Wrox
Year : May 2004
ISBN 10 : 0764559044
ISBN 13 : 9780764559044
Language : English
Pages : 624
File type : CHM
Size : 94 MB (book + source code)

If you are developing databases for your own use, you may not mind opening forms or printing reports directly from the database window, and you know what query to run before printing which report or exporting data to Word. However, if you are planning to create applications for the use of others, particularly for clients who aren�t familiar with Access, and don�t understand databases in general, you have to do a lot more work, mostly in the form of writing VBA code to automate the application�s processes.

As a rule of thumb, it�s generally true that the easier the application is for the end user, the harder (and more time-consuming) it is to develop. In this book I concentrate on teaching you how to set up your tables and relationships to ensure that the database is properly normalized, and write VBA code to create the connective tissue that turns a bunch of tables, queries, forms and reports into a complete and coherent application.

This book is for experienced Access users who are familiar with creating Access objects and writing VBA code, but who need help transitioning from competent users/programmers to full-fledged Access developers.

The book is divided into three parts, each centered around a separate case application. The first shows best methods for building a relatively simple Access application using the developer's own data. The next section shows how to build a distributed application serving multiple clients and types of data. The chapters in this section cover each step in the application lifecycle � from gathering application requirements from clients to migrating data from legacy systems to the new Access database system.

The last section of the book shows how to build Access applications that work with other Office applications, inlcuding Word, Excel, and Outlook, as well as non-Office applications. These integration issues cover some of the thorniest problems an Access developer will face. Feddema's years of experience as an author, consultant, and trainer ensure that she can provide highly original solutions and workarounds.

No one is better at revealing the secrets of Excel than "Mr. Spreadsheet" himself. This power-user's guide is packed with procedures, tips, and ideas for expanding Excel's capabilities with Visual Basic® for Applications. Excel 2007 has a few new tricks up its sleeve, and John Walkenbach helps you make the most of them all.



You'll learn to customize Excel UserForms, develop new utilities, use VBA with charts and PivotTables, and create event-handling applications. Work with VBA subprocedures and function procedures, facilitate interactions with other applications, build user-friendly toolbars, menus, and help systems, and much more. Get ready to make Excel do your bidding.

Millions of users create and share Excel spreadsheets every day, but few go deeply enough to learn the techniques that will make their work much easier. There are many ways to take advantage of Excel's advanced capabilities without spending hours on advanced study. Excel Hacks provides more than 130 hacks — clever tools, tips and techniques — that will leapfrog your work beyond the ordinary.Now expanded to include Excel 2007, this resourceful, roll-up-your-sleeves guide gives you little known "backdoor" tricks for several Excel versions using different platforms and external applications. Think of this book as a toolbox. When a need arises or a problem occurs, you can simply use the right tool for the job. Hacks are grouped into chapters so you can find what you need quickly, including ways to:

• Reduce workbook and worksheet frustration — manage how users interact with worksheets, find and highlight information, and deal with debris and corruption.
• Analyze and manage data — extend and automate these features, moving beyond the limited tasks they were designed to perform.
• Hack names — learn not only how to name cells and ranges, but also how to create names that adapt to the data in your spreadsheet.
• Get the most out of PivotTables — avoid the problems that make them frustrating and learn how to extend them.
• Create customized charts — tweak and combine Excel's built-in charting capabilities.
• Hack formulas and functions — subjects range from moving formulas around to dealing with datatype issues to improving recalculation time.
• Make the most of macros — including ways to manage them and use them to extend other features.
• Use the enhanced capabilities of Microsoft Office 2007 to combine Excel with Word, Access, and Outlook.

You can either browse through the book or read it from cover to cover, studying the procedures and scripts to learn more about Excel. However you use it, Excel Hacks will help you increase productivity and give you hours of "hacking" enjoyment along the way.

Author(s) : Liviu Asnash, Eran Megiddo, Craig Thomas
Publisher : Wrox
Year : Mar 2007
ISBN 10 : 0470104899
ISBN 13 : 9780470104897
Language : English
Pages : 404
File type : PDF
Size : 5.5 MB

Excel Services is a new technology being delivered as part of Microsoft Office SharePoint Server 2007. Excel Services will enable managed and secure distribution of Excel reports, incorporating spreadsheets in business intelligence dashboards and portals, protecting the proprietary information in spreadsheets, and building custom applications with Excel-based logic. This book will walk you through the process of understanding what Excel Services is, how your business can benefit from it, and how to incorporate it in your solutions.

This book is designed to be an introduction to Excel Services for all those that want to understand what it is, what it does, what the benefits are, and how to get started. The target audience is IT TDMs and developers that need to come up to speed on the new technologies in Office 2007 and may be responsible for evaluating and deploying Office 2007 and Office SharePoint 2007. This book is also great for all Microsoft partners including system integrators, consulting companies, hosting companies, VARs and independent software vendors that will be building and deploying solutions for their customers based on the new Office technologies. Anyone currently managing or developing solutions with Excel, Windows SharePoint Services, SharePoint Portal Server, or business intelligence solutions should read this book to understand the basics of Excel Services

This book is for anyone who wants to learn what Excel Services is, what it does, what the benefits are, and how to get started. You should have an understanding of Excel, basic knowledge of Excel 2007, and familiarity with Windows SharePoint Services.

The leading Microsoft Office application experts together in one book! Here's the best of the best on Office 2007. Microsoft designed Office 2007 to be used as a package. We designed this Bible as a package that combines the best from the Word, Excel, PowerPoint, Outlook, and Access Bibles with chapters covering Publisher, OneNote, and InfoPath, as well as Groove and SharePoint. It's a veritable buffet of information from some of the leading Office application experts. You'll learn to take advantage of every new feature and how they all work together to help you work better.