See what's new in the world's bestselling relational database software, including new feature coverage, and how to migrate your existing data to Access 2003.
Key Features
Comprehensive Coverage -- Access is a straightforward but extremely versatile information management tool, which includes myriad features to store, retrieve, and present information. Users need the breadth and depth of ?The Complete Reference? to learn how to use and get the most out of this product.
Teaches basic database concepts as well as intermediate to advanced database design and programming.
Virginia Andersen has more than 25 years of experience with computer technologies and database applications, and contributes her years of teaching experience in creating a user-friendly guide to this complex database application.
Includes a sample project throughout the chapters that begins with simple concepts and ends up with a complete relational database solution. The CD includes a practice database.
Author Biography
Virginia Andersen (Coronado, CA) is a freelance author and writer who has written or contributed to nearly 25 books about PC-based applications, including many student tutorials and accompanying instructor manuals with exercise disks. Virginia is certified as a Microsoft Access MOUS Expert.
She has over 25 years experience in computer science applications, analysis, and engineering - including extensive technical writing and editing. Her government and defense projects include lunar mapping, reliability engineering, undersea surveillance, weapon system interface simulation, and naval communications. Her civilian projects include computerized project management and horse race handicapping.
Table of Contents
Part I: Getting Started
1: Quick Tour of Microsoft Office Access 2003
2: The World of Relational Databases
3: Creating a Database
4: Creating and Modifying Tables
5: Relating Tables
6: Entering and Editing Data
Part II: Retrieving and Presenting Information
7: Sorting, Filtering, and Printing Records
8: Extracting Information with Queries
9: Creating Advanced Queries
10: Creating Form and Report Designs
11: Using the Form Wizard
12: Customizing Forms
13: Using the Report Wizard
14: Customizing Reports
15: Creating Charts and Graphs
Part III: Improving the Workplace
16: Customizing the Workplace
17: Improving Database Performance
18: Understanding Events and the Event Model
19: Automating with Macros
20: Customizing Menus and Toolbars
21: Creating Custom Switchboards and Dialog Boxes
Part IV: Sharing Data with Others
22: Exchanging Database Objects and Text
23: Exchanging Data with Outside Sources
24: Sharing with Multiple Users
25: Securing a Database
Appendix A: Converting to Access 2003
Appendix B: What?s on the CD
Reviews
Reviews
In this new edition of Smith's book, the focus has changed with the times. There are about half as many lens designs in the new edition, and the new material is directed toward design projects. Smith shows what he did, including blunders, to design a lens from first concept to final design. The designs include a cemented doublet, a triplet anastigmat, a Heliar, a Schmidt-Cassegrain, a landscape lens, and many more. The computer program OSLO was used to design the work, but the write-ups are program-neutral. Therefore, this book can be used with any lens design software. This book is a working person's text; there are very few derivations of techniques or derivations from first principles, Maxwell's equations, or Fermat's principle. The assumption is that the reader understands the basic optical principles and may have a command of the fundamentals of classical optical design methods. In short, a compendium of design techniques available today and a prescriptive resource for a variety of already designed lens types that can be starting points for a lens designer's efforts. Summing Up: Recommended. Upper-division undergraduates through professionals. -- D.B. Mason, Albright College