Author(s) : Timothy Zapawa
Publisher : Wiley
Year : Jul 2005
ISBN 10 : 0764588117
ISBN 13 : 9780764588112
Language : English
Pages : 504
File type : PDf
Size : 41 MB (book + source code)

By reading this book and following the practice exercises scattered liberally throughout the chapters, you can learn to develop powerful and innovative reporting solutions using Microsoft Excel 2003. This book�s step-by-step approach can help you steadily gain confidence in your ability to use Excel�s reporting functions as you enhance your skills by working through the hands-on examples.

You don�t have to know Structured Query Language (SQL) to get real value from this book. However, readers who are familiar with SQL programming will probably get the most out of it. Indeed, many SQL programmers find that Excel report development is the next logical progression in their technology education. Still, even if you are only an experienced user of Excel, you will learn a substantial amount about Excel reporting, especially in the earlier chapters where the graphical Excel tools are used to build SQL queries that run against external data sources such as delimited files, spreadsheets, databases, and data cubes.

If you�re new to Excel reports, you should start with Part I of the book. Advanced users who are already familiar with Excel�s reporting features and with external data sources can skip to Part II, where the core features, functions, and components of Excel reports are covered. The appendixes in Part III provide references for installing the NorthwindCS database, configuring your Windows operating system to display extensions for known file types, and using basic SQL.

Author(s) : John Low
Publisher : Lulu Press
Year : Feb 2005
ISBN 10 : 1411624173
ISBN 13 : 9781411624177
Language : English
Pages : 168
File type : PDF
Size : 5.5 MB

This Book is for programmers and would-be programmers who want to lear Word 2003 Visual Basic programming as quickly as possible. I assume that you are fluent in useing Word 2003 as a word processor and want to learn the Visual Basic programming part of Word 2003 to help you become more efficient with your word processing tasks. It is preferable that you have some programming background but the concepts are explained at the elementary level so a beginning programmer should be able to follow and learn.

I firmly believe in learning programming through examples so this book is full of programming examples to explaing the concepts and techniques of programming Visual Basic. I expect you to try all the examples in this book and make the code work for you. This is how you learn programming. Learning programming by doing is fun and I want you to have as much fun as I have writing this book.

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.