Access Database Design & Programming, 3rd Ed 2002.pdf
(
5965 KB
)
Pobierz
22888628 UNPDF
Access Database Design & Programming, 3rd Edition
Steven Roman
Publisher: O'Reilly
Third Edition January 2002
ISBN: 0-596-00273-4, 448 pages
Copyright
Table of Contents
Index
Full Description
About the Author
Reviews
Reader reviews
Errata
When using GUI-based software, we often focus so much on the interface
that we forget about the general concepts required to use the software
effectively.
Access Database Design & Programming
takes you behind the
details of the interface, focusing on the general knowledge necessary for
Access power users or developers to create effective database applications.
The main sections of this book include: database design, queries, and
programming.
1
TEAM FLY PRESENTS
Table of Content
Table of Content ............................................................................................................. 2
Preface............................................................................................................................. 7
Preface to the Third Edition ........................................................................................ 7
Preface to the Second Edition ..................................................................................... 8
The Book's Audience ................................................................................................ 11
The Sample Code ...................................................................................................... 11
Organization of This Book........................................................................................ 11
Conventions in This Book ........................................................................................ 14
Obtaining Updated Information................................................................................ 15
Request for Comments.............................................................................................. 15
Acknowledgments..................................................................................................... 15
Part I: Database Design................................................................................................. 17
Chapter 1. Introduction ................................................................................................. 17
1.1 Database Design.................................................................................................. 17
1.2 Database Programming ....................................................................................... 23
Chapter 2. The Entity-Relationship Model of a Database ............................................ 24
2.1 What Is a Database?............................................................................................ 24
2.2 Entities and Their Attributes ............................................................................... 24
2.3 Keys and Superkeys ............................................................................................ 28
2.4 Relationships Between Entities........................................................................... 29
Chapter 3. Implementing Entity-Relationship Models: Relational Databases ............. 31
3.1 Implementing Entities......................................................................................... 31
3.2 A Short Glossary................................................................................................. 33
3.3 Implementing the Relationships in a Relational Database ................................. 35
3.4 The LIBRARY Relational Database................................................................... 39
3.5 Index Files........................................................................................................... 44
3.6 NULL Values...................................................................................................... 46
Chapter 4. Database Design Principles ......................................................................... 47
4.1 Redundancy......................................................................................................... 47
4.2 Normal Forms ..................................................................................................... 49
4.3 First Normal Form .............................................................................................. 49
4.4 Functional Dependencies .................................................................................... 50
4.5 Second Normal Form .......................................................................................... 51
4.6 Third Normal Form............................................................................................. 53
4.7 Boyce-Codd Normal Form ................................................................................. 54
4.8 Normalization ..................................................................................................... 55
Part II: Database Queries .............................................................................................. 62
Chapter 5. Query Languages and the Relational Algebra............................................. 62
5.1 Query Languages ................................................................................................ 63
5.2 Relational Algebra and Relational Calculus ....................................................... 64
5.3 Details of the Relational Algebra........................................................................ 66
Chapter 6. Access Structured Query Language (SQL) ................................................. 91
6.1 Introduction to Access SQL................................................................................ 91
6.2 Access Query Design .......................................................................................... 91
2
TEAM FLY PRESENTS
6.3 Access Query Types ........................................................................................... 92
6.4 Why Use SQL? ................................................................................................... 94
6.5 Access SQL......................................................................................................... 95
6.6 The DDL Component of Access SQL ................................................................ 96
6.7 The DML Component of Access SQL.............................................................. 100
Part III: Database Architecture ................................................................................... 123
Chapter 7. Database System Architecture .................................................................. 123
7.1 Why Program? .................................................................................................. 123
7.2 Database Systems.............................................................................................. 124
7.3 Database Management Systems........................................................................ 126
7.4 The Jet DBMS................................................................................................... 126
7.5 Data Definition Languages ............................................................................... 128
7.6 Data Manipulation Languages .......................................................................... 129
7.7 Host Languages................................................................................................. 130
7.8 The Client/Server Architecture ......................................................................... 131
Part IV: Visual Basic for Applications ....................................................................... 133
Chapter 8. The Visual Basic Editor, Part I.................................................................. 133
8.1 The Project Window ......................................................................................... 134
8.2 The Properties Window .................................................................................... 136
8.3 The Code Window ............................................................................................ 137
8.4 The Immediate Window ................................................................................... 138
8.5 Arranging Windows.......................................................................................... 139
Chapter 9. The Visual Basic Editor, Part II ................................................................ 141
9.1 Navigating the IDE ........................................................................................... 141
9.2 Getting Help...................................................................................................... 142
9.3 Creating a Procedure......................................................................................... 142
9.4 Run Mode, Break Mode, and Design Mode ..................................................... 143
9.5 Errors................................................................................................................. 144
9.6 Debugging......................................................................................................... 147
Chapter 10. Variables, Data Types, and Constants..................................................... 150
10.1 Comments ....................................................................................................... 150
10.2 Line Continuation ........................................................................................... 150
10.3 Constants......................................................................................................... 150
10.4 Variables and Data Types ............................................................................... 153
10.5 VBA Operators ............................................................................................... 168
Chapter 11. Functions and Subroutines ...................................................................... 170
11.1 Calling Functions ............................................................................................ 170
11.2 Calling Subroutines......................................................................................... 171
11.3 Parameters and Arguments ............................................................................. 172
11.4 Exiting a Procedure......................................................................................... 176
11.5 Public and Private Procedures ........................................................................ 176
11.6 Fully Qualified Procedure Names................................................................... 177
Chapter 12. Built-in Functions and Statements .......................................................... 178
12.1 The MsgBox Function .................................................................................... 179
12.2 The InputBox Function ................................................................................... 181
12.3 VBA String Functions..................................................................................... 181
3
TEAM FLY PRESENTS
12.4 Miscellaneous Functions and Statements ....................................................... 186
12.5 Handling Errors in Code ................................................................................. 189
Chapter 13. Control Statements .................................................................................. 197
13.1 The If ...Then Statement ................................................................................. 197
13.2 The For Loop .................................................................................................. 197
13.3 The Exit For Statement ................................................................................... 198
13.4 The For Each Loop ......................................................................................... 199
13.5 The Do Loop ................................................................................................... 200
13.6 The Select Case Statement.............................................................................. 201
13.7 A Final Note on VBA ..................................................................................... 202
Part V: Data Access Objects ....................................................................................... 205
Chapter 14. Programming DAO: Overview ............................................................... 205
14.1 Objects ............................................................................................................ 205
14.2 The DAO Object Model.................................................................................. 211
14.3 The Microsoft Access Object Model .............................................................. 213
14.4 Referencing Objects........................................................................................ 215
14.5 Collections Are Objects Too........................................................................... 219
14.6 The Properties Collection ............................................................................... 224
14.7 Closing DAO Objects ..................................................................................... 230
14.8 A Look at the DAO Objects............................................................................ 230
14.9 The CurrentDb Function ................................................................................. 238
Chapter 15. Programming DAO: Data Definition Language ..................................... 245
15.1 Creating a Database ........................................................................................ 245
15.2 Opening a Database ........................................................................................ 246
15.3 Creating a Table and Its Fields ....................................................................... 247
15.4 Creating an Index ............................................................................................ 250
15.5 Creating a Relation ......................................................................................... 252
15.6 Creating a QueryDef ....................................................................................... 254
Chapter 16. Programming DAO: Data Manipulation Language ................................ 258
16.1 Recordset Objects ........................................................................................... 258
16.2 Opening a Recordset ....................................................................................... 259
16.3 Moving Through a Recordset ......................................................................... 260
16.4 Finding Records in a Recordset ...................................................................... 264
16.5 Editing Data Using a Recordset ...................................................................... 266
Part VI: ActiveX Data Objects ................................................................................... 271
Chapter 17. ADO and OLE DB .................................................................................. 271
17.1 What Is ADO?................................................................................................. 271
17.2 Installing ADO................................................................................................ 272
17.3 ADO and OLE DB.......................................................................................... 273
17.4 The ADO Object Model.................................................................................. 276
17.5 Finding OLE DB Providers ............................................................................ 311
17.6 A Closer Look at Connection Strings ............................................................. 316
17.7 An Example: Using ADO over the Web......................................................... 329
Chapter 18. ADOX: Jet Data Definition in ADO ....................................................... 333
18.1 The ADOX Object Model............................................................................... 333
Part VII: Programming Problems ............................................................................... 342
4
TEAM FLY PRESENTS
Plik z chomika:
darekisap
Inne pliki z tego folderu:
Access Database Design & Programming, 3rd Ed 2002.pdf
(5965 KB)
Access Database Design & Programming, Ed 2 1999.pdf
(1796 KB)
Beginning Database Design 2006.pdf
(10906 KB)
Database Design Manual Using Mysql for Windows 2004.pdf
(7350 KB)
Database Nation The Death of Privacy in the 21st Century 2000.pdf
(6268 KB)
Inne foldery tego chomika:
Ajax
Apache & Tomcat
Apress
ASP.NET
Bazy Danych
Zgłoś jeśli
naruszono regulamin