Résumé
Contents
2. The Anatomy of a Real Database.
3. An Introduction to Database Design.
4. Database Design Continued: An Introduction to Normalization.
5. Using Access to Build the Time Entry and Billing Database.
6. Maintaining Integrity Through Data Validation Rules.
7. The Basics of Referential Integrity.
8. SQL Basics.
9. SQL-Going Beyond the Basics.
10. Making SQL Queries a Part of Your Database.
11. Building the User Interface Components.
12. Providing Useful Output: An Introduction to Creating and Designing Reports.
Appendix A. The Structure of the TEB Database.
Appendix B. TEB Referential Integrity Rules.
Appendix C. Glossary.
Appendix D. Database-Oriented Periodicals.
Appendix E. Web-Based Resources.
Index.
Introduction.
I. DATABASE BASICS.
1. An Introduction to Databases.What Is a Database? How
Databases Are Used. Typical Database Management Systems
Used Today. Key Database Terminology. The Relational
Database Model: An Overview. Database-Related Careers. What
You Have Learned.
2. The Anatomy of a Real Database.
An Introduction to
Microsoft Access. The Sample Northwind Traders Database.
What You Have Learned.
II. DESIGNING AND BUILDING YOUR FIRST DATABASE.
3. An Introduction to Database Design.
Your Project: A Time Entry
and Billing Database. Determine the Requirements of the
Database. Introduction to Database Modeling. Model the Time
Entry and Billing Database. What You Have Learned.
4. Database Design Continued: An Introduction to Normalization.
What Does It Mean to
Normalize a Database? Steps to Normalize Your Data Model.
Denormalize Data-When Does It Make Sense to Break the
Rules? Normalization Applied-Review the TEB Database and
Refine the Design. What You Have Learned.
5. Using Access to Build the Time Entry and Billing Database.
Automatically Generate the
Database from the TEB Model. A Brief Review of the Access
Database Designer. Use the Design to Create the Time Entry
and Billing Database. What You Have Learned.
III. MAINTAININGYOUR DATABASE-AN INTRODUCTION TO DATABASE INTEGRITY.
6. Maintaining Integrity Through Data Validation Rules.
An Overview of How
Validation Rules Work in Databases. Implement Field-Level
Rules. Implement Row-Level Rules. What You Have
Learned.
7. The Basics of Referential Integrity.
What Is Referential
Integrity? Why Maintaining Referential Integrity Is
Important. How Referential Integrity Works. What You Have
Learned.
IV. USING YOUR DATABASE TO PROVIDE INFORMATION-AN INTRODUCTION TO SQL.
8. SQL Basics.
SQL Overview. Select
Statement. Filter Results I: Use the Where Clause. Organize
Output I: Use the Order By Clause. Combine Multiple Tables:
Use the Join Statement. Combine Multiple Resultsets: Use
the Union Clause. What You Have Learned.
9. SQL-Going Beyond the Basics.
Organize Output II: Use
the Group By Clause. Use Aggregate Functions. Filter
Results II: Use the Having Clause. Filter Results III:
Create Parameterized SQL Statements. Modify Data with the
Insert, Update, and Delete Statements. What You Have
Learned.
10. Making SQL Queries a Part of Your Database.
An Overview of the Access
Query Designer. Create Advanced Queries. What You Have
Learned.
V. PUTTING YOUR DATABASE TO WORK-BUILDING A SIMPLE ACCESS DATABASE APPLICATION.
11. Building the User Interface Components.
Overview of the Access
Form Designer. Create Forms for the TEB Application. Create
a Main Menu Form. What You Have Learned.
12. Providing Useful Output: An Introduction to Creating and Designing Reports.
Overview of the Access
Report Designer. Create Reports for the TEB Application.
Add Report Items to the Main Menu Form. What You Have
Learned.
Appendix A. The Structure of the TEB Database.
Appendix B. TEB Referential Integrity Rules.
Appendix C. Glossary.
Appendix D. Database-Oriented Periodicals.
Appendix E. Web-Based Resources.
Index.
L'auteur - John V. Petersen
John V. Petersen
is vice president of software development and R&D for IDT Marketing Systems and Services, Inc., a marketing database consulting firm. A two-time recipient of Microsoft's MVP Award, John is co-author of Hands On Visual Basic 6 for Web Development (also from Prima Tech).
Caractéristiques techniques
| PAPIER | |
| Éditeur(s) | Que |
| Auteur(s) | John V. Petersen |
| Parution | 22/03/2002 |
| Nb. de pages | 314 |
| Format | 18,7 x 23 |
| Couverture | Broché |
| Poids | 560g |
| Intérieur | Noir et Blanc |
| EAN13 | 9780789725691 |
| ISBN13 | 978-0-7897-2569-1 |
Avantages Eyrolles.com
Livraison à partir de 0,01 € en France métropolitaine
Paiement en ligne SÉCURISÉ
Livraison dans le monde
Retour sous 15 jours
+ d'un million et demi de livres disponibles
Nos clients ont également acheté
Consultez aussi
- Les meilleures ventes en Graphisme & Photo
- Les meilleures ventes en Informatique
- Les meilleures ventes en Construction
- Les meilleures ventes en Entreprise & Droit
- Les meilleures ventes en Sciences
- Les meilleures ventes en Littérature
- Les meilleures ventes en Arts & Loisirs
- Les meilleures ventes en Vie pratique
- Les meilleures ventes en Voyage et Tourisme
- Les meilleures ventes en BD et Jeunesse
