* 74, 164-165
? 164-165
# 162
.bas files 47
.mak files 47
.mdb files 45, 48
.prn files 422
.vbp files 47
1 : N forms in Access 306
Access
form properties 317-319
Access forms 300, 349
Access forms Event tab 319
Access macro design window 320
Access macros 318
Access modules 436-456
Access reports 414
Access RunCommand 321, 325
Access subform 307-309
Access wizards 349
ActiveX data control 376-377
ActiveX Data Objects 427-435
ADD COLUMN 106
ADD CONSTRAINT 108
Adding a record in Access forms 302
AddNew method 122, 353-354, 364, 385
Adding records to a query 76
ADO 427-435
ADO data control 376-377
ADO data grid 376
Aggregate functions 85, 156, 174, 231
ALL 220
ALL option of UNION 254
AllowAddNew property of data grid 377
AllowDelete property of data grid 377
AllowUpdate property of data grid 378
ALTER TABLE 98, 106, 107, 111
And 84
And with Or 84
AND, OR, NOT 169
ANSI-86 SQL 195, 200, 202, 208
ANSI-89 SQL 194, 200, 208
ANY 220
App.Path 361, 363
Approaches to database application development 349-351
ASC | DESC 113, 185, 189
Atomic primary key 27
Attributes 4, 13, 24
Autoforms 300
Autonumber field 50
BeginTrans
450-456
BETWEEN 166
Binary relationship 14
BOF 381
BCNF 35
Boyce-Codd Normal Form 35
Candidate
primary key 27, 54
Cartesian product 26
Cascade delete 60-61, 67, 146-149
Cascade update 60-61, 66, 104, 141-143
Closing a database 385
Closing a recordset 385
Column aliases 160, 210
Column homogeneous 256
Combining INNER JOIN and LEFT JOIN 209-214
Combo box on Access form 310-315
CommitTrans 450-456
Compact database 366
Composite primary key 27, 57, 105
Compound primary key 27, 57, 105
Conditions in Access macros 322
Connection string 427-435
ConnectionString property 377
Conjunction 84
Connection.Open method 427-435
CONSTRAINT 103, 105, 108
Correlated subquery 228, 235-241
COUNT 178
CREATE INDEX 98, 113-119
Creating a database 48
Creating Access forms manually 315-317
CREATE TABLE 98, 101
Creating 1:N forms in Access 306
Creating relationships 58
Creating tables 49
Criteria in query design view 79ff
CROSSTAB QUERIES 293-297
Crystal Reports 414
Currency field 50
CurrentDb 446
CurrentX, CurrentY 422
DAO
350, 383-426, 442
Data control 6, 349-382
Data dictionary 58
Data duplication 13
Data fields 162, 166
Data redundancy 4
Data Source Name 427-435
DataSource 427-435
Database updates with data control 352-353
DataField property 353
Datasheet view 74
DataSource property 353, 377
Data types 50
Database design iteration 3
Database integrity 58
DatabaseName property 352, 361, 372
DBGrid 371-375
DCL commands 98
DeMorgan's Law 268
Default join type 193
DELETE 143-152
Delete method 355, 365, 385
Deleting a record in Access forms 302
Deletion anomaly 35
DDL commands 98, 107, 113, 121
Design view 49
Determinant 35
Dim 354
DISALLOW NULL 113-115
Disjunction 84
Disjunctive Normal Form 84
DISTINCT 158-160, 197
DML commands 98, 121
DNF 84
DoCmd 439-440
Domain 25-26
DROP COLUMN 107
DROP CONSTRAINT 107
DROP INDEX 98, 120
DROP TABLE 98, 109-112
DSN 427-435
Duplicate primary key value 124
Dynaset recordset 384
Edit
method 355, 365, 385
E.F.Codd 26
Embedded SQL 7, 96-97, 102, 105, 132-133, 374, 447,
411-412, 421 Enable / Disable 360
Entity 13
Entity modelling 3, 11, 14ff
Entity-relationship modelling 3, 11, 14ff
Entity type 13, 14ff, 26
EOF 381
Err 358
Error 358
Error handling 357-358
Error prevention 359
Exclusive OR 172
Execute method 102
Existential quantifier 246
EXISTS can't be replaced by IN 242, 245
EXISTS can't be replaced by join 245
Exponential notation 52
Fields
50
Fields collection 385
Fifth normal form 37
Filtering in Access forms 304
FindFirst method 367-368, 385
Finding in Access forms 305-306
FindNext method 368, 385
First normal form 30-31
Folders 46
FOR loop 375
Form Load event 362, 382
Form modules 438
Form modules and Standard modules 438
Form wizard 306
FormResize event 406
Forms 5, 48
Foreign key 28-29
Fourth normal form 35
Frames 360
Fuzzy matching 164, 368
General
Declarations 362
Global 406
Graphs in Access reports 337
Greater than join 197-198
GROUP BY 85, 175-180
Grouping on more than one column 179
HAVING
87-88, 181-183, 185
Hyperlink fields 50, 53
IGNORE
NULL 113
IN 167-168, 220
Index property 396
Indexes 54-56, 113-119
Indexing a foreign key 119
INNER JOIN 62, 90-91, 194-196
InputBox 367
INSERT INTO external database 130-131
INSERT INTO a stored query 124-126
INSERT INTO (multiple-record) 121, 127-129
INSERT INTO (single record) 121
Insertion anomaly 35
Inverse relationship 15
Integer field 50
Interactive SQL 96-97, 101
INTERSECT 263-265
IsNull 443
Jet
engine 55
Jet's join nesting rule 212-214
Join type 60-61, 104
Joining more than two tables 200-202
Joining views 280-281
Joins 89, 90-92
LEFT
JOIN 62, 90-91, 203-208
LEFT JOIN and RIGHT JOIN 203-208
LIKE 50, 164-165, 368
Limitations of Access GROUP BY 183
Limitations of Jet SQL 183, 229, 241, 263
Linking forms using a macro 319
Logic 84, 168-174
Long integer field 50
Lookup wizard fields 50, 53
Macros
6, 48, 318
Mandatory relationship 15, 17
Many-to-many relationship 18-21
MAX 86
Memo field 50
Menu 368
Microsoft Jet 3.51 OLE DB 377
Modules 7, 48, 437
MoveComplete event (ADO data grid) 378, 380
MoveFirst method 353, 365, 385
MoveLast method 353, 385
MoveNext method 353, 355, 385
MovePrevious method 353, 385
MsgBox 359
Multiple field constraint 105
Multivalued dependency 36
Mutually exclusive relationship 23
Navigation
usinf Access forms 301
Nested joins 210
Nonloss decomposition 37
No join equivalent of subquery 234
NoMatch property 381
Normalization 3, 11, 13, 30ff
NOT EXISTS 208
NOT EXISTS can't be replaced by NOT IN 242
NOT IN 208, 220
NULL 62, 135, 156, 162-163, 173, 208, 214, 237
Number field 50
ODBC
427-435
OLE DB 376, 427-435
ON clause 193, 195, 200
On Error Goto 357-358, 403, 447
One-to-many relationship 16, 28-30
One-to-one relationship 17
Opendatabase method 384
OpenRecordset 384, 386, 394
OpenTable 393
Optional relationship 15, 18
Optionality 66
Or 83, 100
ORDER BY 184-187, 256
Parallel
relationship 23
Partial dependency 32-34
PERCENT 191
Possible ambiguities with ANY and ALL 231, 234
Predicate calculus 246
PRIMARY 113
Primary key 4, 27ff, 54
PrimaryKey index 396
Print# 415-421
Printer object 422-425
Printers collection 425
Programming Access modules 436-456
Projection 75, 81, 157
Provider property 427-435
Queries
built on queries 271-289
Query 48, 61
Query design grid 73
Query design view 5, 73
Record
selector bar in Access forms 303
RecordCount property 375
Records 4, 26
Recordset, 301, 353, 355, 374
RecordSource property 352, 377
RecordSource property of Access forms 307
REFERENCES 103
Referential integrity 60, 64-65, 104, 110, 149
Refresh method 356, 374, 380
Refresh 423
Relation 25-26
Relational model 24-25
Relational operators 82, 161
Relationship cardinality 15
Relationship degree 16
Relationship optionality 15
Relationship window 59, 111
Relationships 4, 14ff
Replacing ANY and ALL 233
Reports 5, 48
Reports via VB code 413-425
Reposition event 373-374
Required fields 76
Restrict 161
Resume 357-359, 366
RIGHT JOIN 62, 91, 203-208
Rollback 450-456
Rows 4
ScaleWidth
423
Schema 12, 14
Scope 354
Second normal form 32
Seek 396
SELECT INTO 290-292
SELECT statement 154-214
SELECT with a single table 155-192
SELECT with joined tables 193-214
SELECT with multiple tables 193ff
Self join 199, 222
Selecting columns 155-157
Selection 81, 161
Selection criteria 81, 87
Show method 382
Single field constraint 103
Snapshot recordset 384, 411
SOME 230
Sorting in Access forms 305
SQL 96-298
SQL
...ADD COLUMN 106
...ADD CONSTRAINT 108
...Aggregate functions 85, 156, 174, 231
...ALL 220
...ALL option of UNION 254
...ALTER TABLE 98, 106, 107, 111
...AND, OR, NOT 169
...ANSI-86 SQL 195, 200, 202, 208
...ANSI-89 SQL 194, 200, 208
...ANY 220
...ASC | DESC 113, 185, 189
...BETWEEN 166
...Combining INNER JOIN and LEFT JOIN 209-214
...CONSTRAINT 103, 105, 108
...Correlated subquery 228, 235-241
...COUNT 178
...CREATE INDEX 98, 113-119
...CREATE TABLE 98, 101
...CROSSTAB QUERIES 293-297
...DCL commands 98
...DELETE 143-152
...DDL commands 98, 107, 113, 121
...DISALLOW NULL 113-115
...DISTINCT 158-160, 197
...DML commands 98, 121
...DROP COLUMN 107
...DROP CONSTRAINT 107
...DROP INDEX 98, 120
...DROP TABLE 98, 109-112
...Embedded SQL 7, 96-97, 102, 105, 132-133, 374, 447, 411-412,
421
...Exclusive OR 172
...EXISTS can't be replaced by IN 242, 245
...EXISTS can't be replaced by join 245
...Greater than join 197-198
...GROUP BY 85, 175-180
...Grouping on more than one column 179
...HAVING 87-88, 181-183, 185
...IGNORE NULL 113
...IN 167-168, 220
...INNER JOIN 62, 90-91, 194-196
...INSERT INTO external database 130-131
...INSERT INTO a stored query 124-126
...INSERT INTO (multiple-record) 121, 127-129
...INSERT INTO (single record) 121
...INTERSECT 263-265
...LEFT JOIN 62, 90-91, 203-208
...LEFT JOIN and RIGHT JOIN 203-208
...LIKE 50, 164-165, 368
...Limitations of Access GROUP BY 183
...Limitations of Jet SQL 183, 229, 241, 263
...MAX 86
...Multiple field constraint 105
...NOT EXISTS 208
...NOT EXISTS can't be replaced by NOT IN 242
...NOT IN 208, 220
...NULL 62, 135, 156, 162-163, 173, 208, 214, 237
...ON clause 193, 195, 200
...ORDER BY 184-187, 256
...PERCENT 191
...Possible ambiguities with ANY and ALL 231, 234
...PRIMARY 113
...Queries built on queries 271-289
...REFERENCES 103
...Replacing ANY and ALL 233
...RIGHT JOIN 62, 91, 203-208
...SELECT INTO 290-292
...SELECT statement 154-214
...SELECT with a single table 155-192
...SELECT with joined tables 193-214
...SELECT with multiple tables 193ff
...Self join 199, 222
...Selecting columns 155-157
...Selection 81, 161
...SOME 230
...SUM 85, 156, 174, 231
...TOP 188-192
...UNION 208, 252-262
...UNION ALL 254
...UNION queries 252-270
...UNION with INTERSECT 266
...UNIQUE 113-114
...Universal quantifier 246, 250
...UPDATE 134-142
...UPDATE a stored query 138-140
...Versions of SQL 97-98
...Views 271-289
...WHERE clause 81, 88, 93, 143-145, 161-163
Standard modules 438, 440
Subqueries 86, 217-251
Subquery 151
SUM 85
Syntax 99
Table
26, 48-49
Table aliases 195-196, 201
Table recordset 384
Temporary table 127
Ternary relationship 22
Text field 50
Third normal form 34-35
TOP 188-192
Transaction processing 7, 450-456
Tuples 4
Unary
relationship 14, 17
Unload method 382
UNION 208, 252-262
UNION ALL 254
UNION queries 252-270
UNION with INTERSECT 266
UNIQUE 113-114
Universal quantifier 246, 250
UPDATE 134-142
UPDATE a stored query 138-140
Update anomaly 35
UpdateControls method 356-357
Update method 353-356, 365, 385
Updateable queries 272, 276
Updateable views 272, 276
Updating views 282-286
VB
projects 9
VB Grid properties 388
VB Grids 386-406
VBA 6, 436-456
VB6 Data Reports 414
Versions of SQL 97-98
Views 271-289
WHERE
clause 81, 88, 93, 143-145, 161-163
WinZip 46
Wizards 6
Yes / No fields 50