Cover image for Access 2000 programming weekend crash course
Title:
Access 2000 programming weekend crash course
Author:
Prague, Cary N.
Personal Author:
Publication Information:
Foster City, CA : IDG Books Worldwide, [2000]

©2000
Physical Description:
xxviii, 614 pages : illustrations ; 24 cm + 1 computer optical disc (4 3/4 in.)
General Note:
Includes index.
Language:
English
Title Subject:
Subject Term:
ISBN:
9780764546884
Format :
Book

Available:*

Library
Call Number
Material Type
Home Location
Status
Central Library QA76.9.D3 P716 2000 Book and Software Set Central Closed Stacks
Searching...

On Order

Summary

Summary

The big day is Monday -- the day you get to show off what you know about Access 2000 programming. The problem is, you're not really up to speed, which is why we created this Weekend Crash Course(r). Open the book Friday evening and on Sunday afternoon, after completing 30 fast, focused lessons, you'll be able to jump right in and start programming.


Author Notes

About the Authors Cary Prague is an internationally known best-selling author and lecturer in the database industry. He is the president of Database Creations, Inc. the world''s largest Microsoft Access add-on company. This direct-mail company creates and markets add-on software, books, and video training for personal computer databases. Cary also manages a very successful consulting company which is a Microsoft Certified Solution Provider, specializing in Microsoft Access application development. He is one of the best-selling authors in the computer database management market, having written over 40 books (which have sold nearly one million copies) on software including Microsoft Access, Borland''s dBASE IV, Paradox, R:Base, and Framework. Cary''s books include eight different editions of the Microsoft Access Bible. Other books have included Access 97 Secrets, dBASE for Windows Handbook, dBASE IV Programming (winner of the Computer Press Association''s Book of the Year award for Best Software Specific Book), and Everyman''s Database Primer Featuring dBASE IV. Cary is certified in Access as a Microsoft Certified Professional and has passed the MOUS test in end-user subjects in Access and Word. He is a frequent speaker at seminars and conferences around the country. Cary holds a Master of Computer Science degree from Rensselaer Polytechnic Institute, and an M.B.A and Bachelor of Accounting degree from the University of Connecticut. He is also a Certified Data Processor. Jennifer Reardon is considered a leading developer of custom database applications. She has over 10 years'' experience developing client/server and PC-based applications. She has accumulated much of her application development experience working as lead developer for Database Creations. She has worked with Cary Prague to develop applications for many Fortune 500 companies. Ms. Reardon owns her own consulting firm, Advanced Software Concepts, which provides custom applications to both the public and private sectors. She has contributed several chapters for books on dBase and Microsoft Access, including the Microsoft Access 2000 Bible, Microsoft Access 97 Bible, and Access 97 Secrets, published by IDG Books. Jennifer holds a Bachelor of Science degree from the University of Massachusetts. Lawrence S. Kasevich is presently vice president of development for Database Creations, Inc. He oversees the consulting division and manages the project efforts for numerous clients and new product development. Before joining Database Creations, Mr. Kasevich was an independent consultant assisting companies with their information and project management needs. He is currently a member of the adjunct faculty at Rennselear Polytechnic Institute where he has been teaching information systems courses since 1989. His previous books include Mastering Framework III, Windcrest Books., 1989, Controlling Your Resources, TAB Books, Inc., 1986, Framework II, TAB Books, Inc., 1986, Using Framework -- A Pictorial Guide, TAB Books, Inc., 1985. He earned a Bachelor of Science degree in Engineering from the University of Connecticut in 1974. In 1986, he received a Master of Management degree from the Hartford Graduate Center. P. V. Phan currently serves as director of information & technical services/developer for Database Creations, Inc. In this capacity he heads the support team for in-house support as well as customer technical support to end users and developers. He is also a member of the development and consulting team for the full line of Database Creations, Inc. products as well as numerous consulting projects for many Fortune 500 companies. He has been programming and developing and conducting training with Access for over five years and has had over 12 years of computer experience. Diana Reid is responsible for managing the daily operations of Database Creations, Inc. She is responsible for the company''s e-commerce site and all Webrelated activities, including design and programming of the company''s Web site and client Web sites. She is a contributing editor for several books on Microsoft Access and has been a technical editor for many of the Access Bible books. She also is a speaker at Microsoft sponsored developer conferences, speaking on Frontpage, HTML and many other Web technologies. Ms. Reid received a Bachelor of Science degree in Finance from Central Connecticut State University in 1991.


Table of Contents

Preface
Acknowledgments
Friday
Part I Friday Evening
Session 1 Introduction to Microsoft Access and Programming
Session 2 From Macros to Modules
Session 3 System and Process Design, Testing, and Debugging
Session 4 Events amp;#151; A Place to Run Your Code
Saturday
Part II Saturday Morning
Session 5 Declaring and Understanding Variables and Using Naming Conventions
Session 6 Logical Constructs amp;#151; Loops, Decisions, Choices, and Quick Exits
Session 7 Procedures, Modules, and Class Modules
Session 8 Programming Calendars
Session 9 Working with Data Programmatically
Session 10 Adding, Updating, and Deleting Records Using DAO and ADO
Part III Saturday Afternoon
Session 11 Navigating an Application Using Switchboards,.Custom Menus, and Keyboard Events
Session 12 Using Unbound Forms amp;#151; True Client/Server Programming
Session 13 Programming Check Box, Option Group, Combo, and List Box Controls
Session 14 Programming Subforms and Continuous Forms
Session 15 Programming Tabbed Controls
Session 16 Message Boxes and Error-Handling Programs and Techniques
Part IV Saturday Evening
Session 17 Importing and Exporting Data
Session 18 Techniques to Improve the Speed of an Application
Session 19 Creating Animated Splash Screens, About Boxes, and Startup Screens
Session 20 Creating Help Systems
Sunday
Part V Sunday Morning
Session 21 Creating Search Dialog Box Forms
Session 22 Dialog Boxes and Reports
Session 23 Packaging Your Application
Session 24 Creating Setup Routines Using Office Developer Edition or Third-Party Programs
Session 25 Programming Wizard-Type Forms for Easier Processing
Session 26 Using Add-Ins with Your Application
Part VI Sunday Afternoon
Session 27 Programming and Using File Attachments
Session 28 Securing Access Databases
Session 29 Access and Client/Server
Session 30 Working With The Web
Appendix A
Appendix B

Google Preview