Table of Contents:
  • Dedication
  • List of Chapters
  • Our Contract with You, The Reader
  • Table of Contents
  • Foreword
  • Acknowledgements
  • About the Authors
  • How to Download the Files
  • Introduction
  • Who we are
  • How we started
  • Who you are
  • You can do this!
  • Why get certified?
  • Certification benefits
  • Transcript
  • Wallet card, lapel pin
  • Logo
  • Other goodies
  • Leveraging your preparation time
  • Study in groups
  • Know what Microsoft wants
  • Know what you do best
  • Practice
  • Overcoming obstacles
  • Scheduling and taking the examsUse the pencil!
  • Certification requirements
  • MCSD requirements
  • Exams 70-155 and 70-156
  • Exam 70-100
  • Exam retirement
  • Further reading
  • Testing centers
  • Exam demos
  • Chapter 1 Developing the Conceptual and Logical Design
  • Conceptual design
  • Logical design
  • Further reading
  • Design
  • Object-oriented design
  • Chapter 2 Developing a Logical Data Model
  • Normalization rules
  • First Normal Form (1NF)
  • Second Normal Form (2NF)
  • Third Normal Form (3NF)
  • Boyce-Codd Normal Form (BCNF)
  • Fourth Normal Form (4NF)Fifth Normal Form (5NF)
  • The primary key
  • Relationships
  • One-to-one relationships
  • One-to-many relationships
  • Many-to-many relationships
  • Foreign keys
  • Referential integrity
  • Business rules, data integrity and the data model
  • Denormalization
  • Denormalization for reporting
  • Denormalization for data warehousing
  • Denormalization for performance
  • Further reading
  • Chapter 3 Deriving the Physical Design
  • Design considerations
  • Performance
  • Maintainability
  • Extensibility
  • Availability
  • An example with COMClass libraries
  • Inheritance
  • Encapsulation
  • Containership
  • Delegation
  • Polymorphism
  • Class libraries
  • Designing an interface for data access
  • Designing the properties and methods of components
  • Designing the presentation tier
  • Further reading
  • Chapter 4 Establishing the Development Environment
  • Installing Visual FoxPro
  • Configuring Visual FoxPro
  • Registry configurations
  • SET commands and configuration files
  • Resource files
  • Command line switches
  • Toolbars
  • Configuring Visual SourceSafe
  • Configuring Microsoft Transaction ServerConfiguring Microsoft Internet Information Server
  • Configuring Microsoft Message Queue
  • Further reading
  • Third-party software
  • Chapter 5 Creating User Services
  • Providing a personalized interface
  • Personalizing colors
  • Keyboard and mouse access
  • Sound and focus
  • User or group options
  • Planning the interface
  • Forms
  • Menu systems
  • Form controls in general
  • Toolbars
  • User interaction with forms
  • Form properties, events, and methods
  • Binding data to controls