简介
"Access Database Design and Programming" takes you behind the details of the Access interface, focusing on the general knowledge necessary for Access power users or developers to create effective database applications. When using software products with graphical interfaces, we frequently focus so much on the interface that we forget about the general concepts that allow us to understand and use the software effectively. In particular, this book focuses on three areas: Database design. The book provides an enjoyable, informative overview of database design that carefully shows you how to normalize tables to eliminate redundancy without losing data. Queries. The book examines multi-table queries (i.e., various types of joins) and shows how to implement them indirectly by using the Access interface or directly by using Access SQL. Programming. The book examines the VBA integrated development environment (IDE). It then goes on to provide an excellent introduction to Data Access Objects (DAO), ActiveX Data Objects (ADO), and ADO Extensions for Data Definition and Security (ADOX). These sections serve as a handy introduction and primer for basic database operations, such as modifying a table under program control, dynamically adding and deleting a record, and repositioning a record pointer. The concluding chapter focuses on common programming problems, such as computing running sums and comparing two sets. Unlike other Access books that take the long, detailed approach to every topic of concern to Access programmers, "Access Database Design andProgramming" instead focuses on the core concepts, enabling programmers to develop solid, effective database applications. This book alsoserves as a 'second course' in Access that provides a relatively experienced Access user who is new to programming with the frequently overlooked techniques necessary to develop successfully in the Microsoft Access environment. Anyone interested in learning Access in depth, rather than just scraping the surface, will enjoy and benefit immensely from reading this book.
目录
Preface p. xi
Database Design
Introduction p. 3
Database Design p. 3
Database Programming p. 9
The Entity-Relationship Model of a Database p. 11
What Is a Database? p. 11
Entities and Their Attributes p. 11
Keys and Superkeys p. 15
Relationships Between Entities p. 16
Implementing Entity-Relationship Models: Relational Databases p. 18
Implementing Entities p. 18
A Short Glossary p. 21
Implementing the Relationships in a Relational Database p. 22
The LIBRARY Relational Database p. 27
Index Files p. 31
NULL Values p. 33
Database Design Principles p. 35
Redundancy p. 35
Normal Forms p. 37
First Normal Form p. 38
Functional Dependencies p. 39
Second Normal Form p. 40
Third Normal Form p. 41
Boyce-Codd Normal Form p. 42
Normalization p. 43
Database Queries
Query Languages and the Relational Algebra p. 51
Query Languages p. 52
Relational Algebra and Relational Calculus p. 53
Details of the Relational Algebra p. 55
Access Structured Query Language (SQL) p. 81
Introduction to Access SQL p. 81
Access Query Design p. 81
Access Query Types p. 83
Why Use SQL? p. 84
Access SQL p. 85
The DDL Component of Access SQL p. 86
The DML Component of Access SQL p. 90
Database Architecture
Database System Architecture p. 115
Why Program? p. 115
Database Systems p. 117
Database Management Systems p. 118
The Jet DBMS p. 119
Data Definition Languages p. 121
Data Manipulation Languages p. 122
Host Languages p. 123
The Client/Server Architecture p. 124
Visual Basic for Applications
The Visual Basic Editor p. 129
The Project Window p. 129
The Properties Window p. 132
The Code Window p. 132
The Immediate Window p. 134
Arranging Windows p. 135
The Visual Basic Editor, Part II p. 137
Navigating the IDE p. 137
Getting Help p. 138
Creating a Procedure p. 138
Run Mode, Break Mode, and Design Mode p. 139
Errors p. 140
Debugging p. 143
Variables, Data Types, and Constants p. 146
Comments p. 146
Line Continuation p. 146
Constants p. 147
Variables and Data Types p. 149
VBA Operators p. 164
Functions and Subroutines p. 165
Calling Functions p. 165
Calling Subroutines p. 166
Parameters and Arguments p. 167
Exiting a Procedure p. 171
Public and Private Procedures p. 171
Fully Qualified Procedure Names p. 172
Built-in Functions and Statements p. 173
The MsgBox Function p. 174
The InputBox Function p. 176
VBA String Functions p. 177
Miscellaneous Functions and Statements p. 180
Handling Errors in Code p. 183
Control Statements p. 191
The If...Then Statement p. 191
The For Loop p. 192
The Exit For Statement p. 193
The For Each Loop p. 194
The Do Loop p. 194
The Select Case Statement p. 195
A Final Note on VBA p. 196
Data Access Objects
Programming DAO: Overview p. 201
Objects p. 201
The DAO Object Model p. 207
The Microsoft Access Object Model p. 209
Referencing Objects p. 211
Collections Are Objects Too p. 215
The Properties Collection p. 220
Closing DAO Objects p. 225
A Look at the DAO Objects p. 226
The CurrentDb Function p. 234
Programming DAO: Data Definition Language p. 241
Creating a Database p. 241
Opening a Database p. 243
Creating a Table and Its Fields p. 243
Creating an Index p. 246
Creating a Relation p. 248
Creating a QueryDef p. 250
Programming DAO: Data Manipulation Language p. 254
Recordset Objects p. 254
Opening a Recordset p. 255
Moving Through a Recordset p. 257
Finding Records in a Recordset p. 260
Editing Data Using a Recordset p. 262
ActiveX Data Objects
ADO and OLE DB p. 269
What Is ADO? p. 269
Installing ADO p. 270
ADO and OLE DB p. 272
The ADO Object Model p. 274
Finding OLE DB Providers p. 304
A Closer Look at Connection Strings p. 309
An Example: Using ADO over the Web p. 322
ADOX: Jet Data Definition in ADO p. 326
The ADOX Object Model p. 326
Programming Problems
Some Common Data Manipulation Problems p. 337
Running Sums p. 337
Overlapping Intervals I p. 340
Overlapping Intervals II p. 341
Making Assignments with Default p. 344
Time to Completion I p. 346
Time to Completion II p. 347
Time to Completion III--A MaxMin Problem p. 349
Vertical to Horizontal p. 352
A Matching Problem p. 354
Equality of Sets p. 355
Appendixes
DAO 3.0/3.5 Collections, Properties, and Methods p. 361
The Quotient: An Additional Operation of the Relational Algebra p. 378
Open Database Connectivity (ODBC) p. 381
Obtaining or Creating the Sample Database p. 401
Suggestions for Further Reading p. 411
Index p. 413
Database Design
Introduction p. 3
Database Design p. 3
Database Programming p. 9
The Entity-Relationship Model of a Database p. 11
What Is a Database? p. 11
Entities and Their Attributes p. 11
Keys and Superkeys p. 15
Relationships Between Entities p. 16
Implementing Entity-Relationship Models: Relational Databases p. 18
Implementing Entities p. 18
A Short Glossary p. 21
Implementing the Relationships in a Relational Database p. 22
The LIBRARY Relational Database p. 27
Index Files p. 31
NULL Values p. 33
Database Design Principles p. 35
Redundancy p. 35
Normal Forms p. 37
First Normal Form p. 38
Functional Dependencies p. 39
Second Normal Form p. 40
Third Normal Form p. 41
Boyce-Codd Normal Form p. 42
Normalization p. 43
Database Queries
Query Languages and the Relational Algebra p. 51
Query Languages p. 52
Relational Algebra and Relational Calculus p. 53
Details of the Relational Algebra p. 55
Access Structured Query Language (SQL) p. 81
Introduction to Access SQL p. 81
Access Query Design p. 81
Access Query Types p. 83
Why Use SQL? p. 84
Access SQL p. 85
The DDL Component of Access SQL p. 86
The DML Component of Access SQL p. 90
Database Architecture
Database System Architecture p. 115
Why Program? p. 115
Database Systems p. 117
Database Management Systems p. 118
The Jet DBMS p. 119
Data Definition Languages p. 121
Data Manipulation Languages p. 122
Host Languages p. 123
The Client/Server Architecture p. 124
Visual Basic for Applications
The Visual Basic Editor p. 129
The Project Window p. 129
The Properties Window p. 132
The Code Window p. 132
The Immediate Window p. 134
Arranging Windows p. 135
The Visual Basic Editor, Part II p. 137
Navigating the IDE p. 137
Getting Help p. 138
Creating a Procedure p. 138
Run Mode, Break Mode, and Design Mode p. 139
Errors p. 140
Debugging p. 143
Variables, Data Types, and Constants p. 146
Comments p. 146
Line Continuation p. 146
Constants p. 147
Variables and Data Types p. 149
VBA Operators p. 164
Functions and Subroutines p. 165
Calling Functions p. 165
Calling Subroutines p. 166
Parameters and Arguments p. 167
Exiting a Procedure p. 171
Public and Private Procedures p. 171
Fully Qualified Procedure Names p. 172
Built-in Functions and Statements p. 173
The MsgBox Function p. 174
The InputBox Function p. 176
VBA String Functions p. 177
Miscellaneous Functions and Statements p. 180
Handling Errors in Code p. 183
Control Statements p. 191
The If...Then Statement p. 191
The For Loop p. 192
The Exit For Statement p. 193
The For Each Loop p. 194
The Do Loop p. 194
The Select Case Statement p. 195
A Final Note on VBA p. 196
Data Access Objects
Programming DAO: Overview p. 201
Objects p. 201
The DAO Object Model p. 207
The Microsoft Access Object Model p. 209
Referencing Objects p. 211
Collections Are Objects Too p. 215
The Properties Collection p. 220
Closing DAO Objects p. 225
A Look at the DAO Objects p. 226
The CurrentDb Function p. 234
Programming DAO: Data Definition Language p. 241
Creating a Database p. 241
Opening a Database p. 243
Creating a Table and Its Fields p. 243
Creating an Index p. 246
Creating a Relation p. 248
Creating a QueryDef p. 250
Programming DAO: Data Manipulation Language p. 254
Recordset Objects p. 254
Opening a Recordset p. 255
Moving Through a Recordset p. 257
Finding Records in a Recordset p. 260
Editing Data Using a Recordset p. 262
ActiveX Data Objects
ADO and OLE DB p. 269
What Is ADO? p. 269
Installing ADO p. 270
ADO and OLE DB p. 272
The ADO Object Model p. 274
Finding OLE DB Providers p. 304
A Closer Look at Connection Strings p. 309
An Example: Using ADO over the Web p. 322
ADOX: Jet Data Definition in ADO p. 326
The ADOX Object Model p. 326
Programming Problems
Some Common Data Manipulation Problems p. 337
Running Sums p. 337
Overlapping Intervals I p. 340
Overlapping Intervals II p. 341
Making Assignments with Default p. 344
Time to Completion I p. 346
Time to Completion II p. 347
Time to Completion III--A MaxMin Problem p. 349
Vertical to Horizontal p. 352
A Matching Problem p. 354
Equality of Sets p. 355
Appendixes
DAO 3.0/3.5 Collections, Properties, and Methods p. 361
The Quotient: An Additional Operation of the Relational Algebra p. 378
Open Database Connectivity (ODBC) p. 381
Obtaining or Creating the Sample Database p. 401
Suggestions for Further Reading p. 411
Index p. 413
- 名称
- 类型
- 大小
光盘服务联系方式: 020-38250260 客服QQ：4006604884
云图客服：
用户发送的提问，这种方式就需要有位在线客服来回答用户的问题，这种 就属于对话式的,问题是这种提问是否需要用户登录才能提问
Video Player
×
Audio Player
×
pdf Player
×
