Preface |
|
xi | |
Part I. Database Design |
|
|
|
3 | (8) |
|
|
3 | (6) |
|
|
9 | (2) |
|
The Entity-Relationship Model of a Database |
|
|
11 | (7) |
|
|
11 | (1) |
|
Entities and Their Attributes |
|
|
11 | (4) |
|
|
15 | (1) |
|
Relationships Between Entities |
|
|
16 | (2) |
|
Implementing Entity-Relationship Models: Relational Databases |
|
|
18 | (17) |
|
|
18 | (3) |
|
|
21 | (1) |
|
Implementing the Relationships in a Relational Database |
|
|
22 | (5) |
|
The Library Relational Database |
|
|
27 | (4) |
|
|
31 | (2) |
|
|
33 | (2) |
|
Database Design Principles |
|
|
35 | (16) |
|
|
35 | (2) |
|
|
37 | (1) |
|
|
38 | (1) |
|
|
39 | (1) |
|
|
40 | (1) |
|
|
41 | (1) |
|
|
42 | (1) |
|
|
43 | (8) |
Part II. Database Queries |
|
|
Query Languages and the Relational Algebra |
|
|
51 | (30) |
|
|
52 | (1) |
|
Relational Algebra and Relational Calculus |
|
|
53 | (2) |
|
Details of the Relational Algebra |
|
|
55 | (26) |
|
Access Structured Query Language (SQL) |
|
|
81 | (34) |
|
Introduction to Access SQL |
|
|
81 | (1) |
|
|
81 | (2) |
|
|
83 | (1) |
|
|
84 | (1) |
|
|
85 | (1) |
|
The DDL Component of Access SQL |
|
|
86 | (4) |
|
The DML Component of Access SQL |
|
|
90 | (25) |
Part III. Database Architecture |
|
|
Database System Architecture |
|
|
115 | (14) |
|
|
117 | (1) |
|
|
117 | (1) |
|
Database Management Systems |
|
|
118 | (1) |
|
|
119 | (2) |
|
Data Definition Languages |
|
|
121 | (1) |
|
Data Manipulation Languages |
|
|
122 | (1) |
|
|
123 | (1) |
|
The Client/Server Architecture |
|
|
124 | (5) |
Part IV. Visual Basic for Applications |
|
|
The Visual Basic Editor, Part I |
|
|
129 | (8) |
|
|
129 | (3) |
|
|
132 | (1) |
|
|
132 | (2) |
|
|
134 | (1) |
|
|
135 | (2) |
|
The Visual Basic Editor, Part II |
|
|
137 | (9) |
|
|
137 | (1) |
|
|
138 | (1) |
|
|
139 | (1) |
|
Run Mode, Break Mode, and Design Mode |
|
|
139 | (1) |
|
|
140 | (3) |
|
|
143 | (3) |
|
Variables, Data Types, and Constants |
|
|
146 | (19) |
|
|
146 | (1) |
|
|
146 | (1) |
|
|
147 | (2) |
|
|
149 | (15) |
|
|
164 | (1) |
|
Functions and Subroutines |
|
|
165 | (8) |
|
|
165 | (1) |
|
|
166 | (1) |
|
|
167 | (4) |
|
|
171 | (1) |
|
Public and Private Procedures |
|
|
171 | (1) |
|
Fully Qualified Procedure Names |
|
|
172 | (1) |
|
Built-in Functions and Statements |
|
|
173 | (18) |
|
|
174 | (2) |
|
|
176 | (1) |
|
|
177 | (3) |
|
Miscellaneous Functions and Statements |
|
|
180 | (3) |
|
|
183 | (8) |
|
|
191 | (10) |
|
|
191 | (1) |
|
|
192 | (1) |
|
|
193 | (1) |
|
|
194 | (1) |
|
|
194 | (1) |
|
The Select Case Statement |
|
|
195 | (1) |
|
|
196 | (5) |
Part V Data Access Objects |
|
|
Programming DAO: Overview |
|
|
201 | (40) |
|
|
201 | (6) |
|
|
207 | (2) |
|
The Microsoft Access Object Model |
|
|
209 | (2) |
|
|
211 | (4) |
|
Collections Are Objects Too |
|
|
215 | (5) |
|
The Properties Collection |
|
|
220 | (5) |
|
|
225 | (1) |
|
A Look at the DAO Objects |
|
|
226 | (8) |
|
|
234 | (7) |
|
Programming DAO: Data Definition Language |
|
|
241 | (13) |
|
|
241 | (2) |
|
|
243 | (1) |
|
Creating a Table and Its Fields |
|
|
243 | (3) |
|
|
246 | (2) |
|
|
248 | (2) |
|
|
250 | (4) |
|
Programming DAO: Data Manipulation Language |
|
|
254 | (15) |
|
|
254 | (1) |
|
|
255 | (2) |
|
Moving Through a Recordset |
|
|
257 | (3) |
|
Finding Records in a Recordset |
|
|
260 | (2) |
|
Editing Data Using a Recordset |
|
|
262 | (7) |
Part VI. ActiveX Data Objects |
|
|
|
269 | (57) |
|
|
269 | (1) |
|
|
270 | (2) |
|
|
272 | (2) |
|
|
274 | (30) |
|
|
304 | (5) |
|
A Closer Look at Connection Strings |
|
|
309 | (13) |
|
An Example: Using ADO over the Web |
|
|
322 | (4) |
|
ADOX: Jet Data Definition in ADO |
|
|
326 | (11) |
|
|
326 | (11) |
Part VII. Programming Problems |
|
|
Some Common Data Manipulation Problems |
|
|
337 | (76) |
|
|
337 | (3) |
|
|
340 | (1) |
|
|
341 | (3) |
|
Making Assignments with Default |
|
|
344 | (2) |
|
|
346 | (1) |
|
|
347 | (2) |
|
Time to Completion III--A MaxMin Problem |
|
|
349 | (3) |
|
|
352 | (2) |
|
|
354 | (1) |
|
|
355 | (6) |
Part VIII. Appendixes |
|
|
A. DAO 3.0/3.5 Collections, Properties, and Methods |
|
|
361 | (17) |
|
B. The Quotient: An Additional Operation of the Relational Algebra |
|
|
378 | (3) |
|
C. Open Database Connectivity (ODBC) |
|
|
381 | (20) |
|
D. Obtaining or Creating the Sample Database |
|
|
401 | (10) |
|
E. Suggestions for Further Reading |
|
|
411 | (2) |
Index |
|
413 | |