|< Day Day Up >|
Integrating Excel and Access will be useful to people who use Microsoft Office to handle data. This book will show you how Access and Excel can work together to improve your reporting and data analysis. Along the way, it will also introduce many programming topics that will help you sharpen your skills in VBA. While you do not need to be a programming expert, this book assumes that you have basic knowledge of Excel and that you are somewhat familiar with Excel macros. Any experience with Access will be helpful; however, you do not need that experience to learn from this book. Excel power-users will find ways that Microsoft Access can be used to increase the power of their applications. Also, you may find that something that you were doing in Excel is better done in Access, or vice versa.
After reading this book, you will understand how to do the following:
After these topics have been introduced, the book ends with a project that walks you through the steps to solve a business problem. After practicing the skills this book illustrates, you will have the necessary knowledge to tackle some of your most demanding reporting issues.
The book is organized to build on topics in a logical sequence. However, if you are trying to solve a specific issue, such as writing formulas in VBA, you can skip to the appropriate section. In addition, the code examples in the book illustrate each of the topics where VBA is used. All of the screenshots are produced from MS Office 2003, so your screen may look different, depending on which operating system you use, but most of the topics can be used in Office 97, 2000, and XP as well.
If you are interested in stretching your skills in the individual applications, I suggest reading Access Hacks and Excel Hacks, also from O'Reilly. Both books give great examples of how to use the applications to tackle problems.
|< Day Day Up >|