|
|
 |
| Àâòîðèçàöèÿ |
|
|
|
| Ïîèñê ïî óêàçàòåëÿì |
|
|
|
|
|
|
|
 |
|
|
|
| Amundsen M., Smith C. — Teach Yourself Database Programming With Visual Basic 4 in 21 Days |
|
|
|
| Ïðåäìåòíûé óêàçàòåëü |
Structured Query Language (SQL), clauses, TOP n 287—288
Structured Query Language (SQL), clauses, TOP n PERCENT 287—288
Structured Query Language (SQL), clauses, UNION 293—294
Structured Query Language (SQL), clauses, WHERE 277—282
Structured Query Language (SQL), constraints 509—510
Structured Query Language (SQL), constraints, FOREIGN KEY...REFERENCES 514—518
Structured Query Language (SQL), constraints, PRIMARY KEY 510—511
Structured Query Language (SQL), constraints, UNIQUE KEY 511—513
Structured Query Language (SQL), creating queries (Data Manager) 60—61
Structured Query Language (SQL), data normalization 556—558
Structured Query Language (SQL), data normalization, data integrity 562—565
Structured Query Language (SQL), data normalization, eliminating repeating groups 558—561
Structured Query Language (SQL), data normalization, Fifth Normal Form 571
Structured Query Language (SQL), data normalization, First Normal Form 559—561
Structured Query Language (SQL), data normalization, Fourth Normal Form 569
Structured Query Language (SQL), data normalization, independent relationships 568—570
Structured Query Language (SQL), data normalization, primary keys 565—568
Structured Query Language (SQL), data normalization, redundant data 562—565
Structured Query Language (SQL), data normalization, related multiple relationships 570—575
Structured Query Language (SQL), data normalization, Second Normal Form 562—565
Structured Query Language (SQL), data normalization, Third Normal Form 566—568
Structured Query Language (SQL), DML (Data Management Language) 524—525
Structured Query Language (SQL), DML (Data Management Language), append queries 528—534
Structured Query Language (SQL), DML (Data Management Language), Delete Table queries 544—551
Structured Query Language (SQL), DML (Data Management Language), INSERT statement 525—528
Structured Query Language (SQL), DML (Data Management Language), Make Table queries 539—544
Structured Query Language (SQL), DML (Data Management Language), update queries 535—538
Structured Query Language (SQL), history 272—273
Structured Query Language (SQL), indexes, database integrity 508—509
Structured Query Language (SQL), indexes, DISALLOW NULL keyword 509
Structured Query Language (SQL), indexes, foreign key indexes 514—518
Structured Query Language (SQL), indexes, IGNORE NULL keyword 509
Structured Query Language (SQL), indexes, PRIMARY KEY keyword 509
Structured Query Language (SQL), indexes, sort key indexes 508
Structured Query Language (SQL), indexes, UNIQUE indexes 511—513
Structured Query Language (SQL), keywords, AS 282
Structured Query Language (SQL), keywords, ASC 508
Structured Query Language (SQL), keywords, DESC 508
Structured Query Language (SQL), keywords, IN 279
Structured Query Language (SQL), keywords, LIKE 279—280
Structured Query Language (SQL), keywords, UNIQUE 509
Structured Query Language (SQL), Microsoft JET engine, compared to ANSI SQL standards 273
Structured Query Language (SQL), saving queries (Data Manager) 60—61
Structured Query Language (SQL), set-oriented systems 69
Structured Query Language (SQL), SQL-VB Interpreter, creating scripts 496—498
Structured Query Language (SQL), SQL-VB Interpreter, editing scripts 497—498
Structured Query Language (SQL), SQL-VB Interpreter, loading 495—496
Structured Query Language (SQL), SQL-VB Interpreter, syntax 499—500
Structured Query Language (SQL), statements, ALTER TABLE 519—520
Structured Query Language (SQL), statements, ALTER TABLE...ADD COLUMN 503—505
Structured Query Language (SQL), statements, ALTER TABLE...DROP COLUMN 503—505
Structured Query Language (SQL), statements, CREATE INDEX 506—508
Structured Query Language (SQL), statements, CREATE TABLE 501—503
Structured Query Language (SQL), statements, DELETE...FROM 544—551
Structured Query Language (SQL), statements, DROP INDEX 506—508
Structured Query Language (SQL), statements, DROP TABLE 505
Structured Query Language (SQL), statements, INSERT 525
Structured Query Language (SQL), statements, INSERT INTO...FROM 528—534
Structured Query Language (SQL), statements, SELECT...FROM 274—275
Structured Query Language (SQL), statements, SELECT...INTO...FROM 539—544
Structured Query Language (SQL), statements, SET 69
Structured Query Language (SQL), statements, TRANSFORM...PIVOT 294—296
Structured Query Language (SQL), statements, UPDATE 69
Structured Query Language (SQL), statements, UPDATE...SET 535—538
Subforms, creating with data-bound grid control 437—443
Subtotal...command (Insert menu) 197—198
SUM (SQL aggregate function) 282
Summary Field...command (Edit menu) 195
Summary...command (Insert menu) 198
Syntax, SQL-VB Interpreter 499—500
System colors, designing forms 123—125
SYSTEM.MDA command (JET menu) 261
Table data objects 83—89
Table data objects, advantages/disadvantages 83—84
Table data objects, Bookmarks 88—89
Table data objects, instant record updates 84
Table data objects, ODBC (Open Database Connectivity) 89
Table data objects, pointers 84
Table data objects, Seek method 84—88
Table data objects, when to use 89
Table structures (Visdata), printing 255—256
Table window (Visdata) 231—235
Table window (Visdata), Copy Structure option 234
Table window (Visdata), Delete option 234
Table window (Visdata), Properties option 233
Table window (Visdata), Refresh option 235
Table window (Visdata), Remove All Records option 235
Table window (Visdata), Rename option 233—234
Table-level locking 580—581
TableDef data access object 328—336
TableDef data access object, collections 328
TableDef data access object, methods 330—336
TableDef data access object, properties 329
Tables 20
Tables, adding fields to 47—50 332—333
Tables, adding indexes to 51—54
Tables, adding records to 61—63
Tables, adding to databases 252—253
Tables, attaching external 55—57 334—336
Tables, backing up 539
Tables, building (Visdata) 254
Tables, columns, length 501
Tables, compared to databases 7
Tables, constraints, deleting 519—520
Tables, constraints, inserting 519—520
Tables, copying, Make Table queries 539—544
tables, creating 46—47
Tables, creating CREATE TABLE statement (SQL) 501—503
Tables, creating in databases 330—331
Tables, creating Make Table queries 539—544
Tables, creating relationships 57—59
Tables, data normalization 556—558
Tables, data normalization, data integrity 562—563
Tables, data normalization, eliminating repeating groups 558—561
Tables, data normalization, Fifth Normal Form 571
Tables, data normalization, First Normal Form 559—561
Tables, data normalization, Fourth Normal Form 569
Tables, data normalization, independent relationships 568—570
Tables, data normalization, primary keys 565—568
Tables, data normalization, redundant data 562—565
Tables, data normalization, related multiple relationships 570—575
Tables, data normalization, Second Normal Form 562—565
Tables, data normalization, Third Normal Form 566—568
tables, deleting 55 505
Tables, deleting fields 332—333
Tables, deleting indexes from 54
Tables, deleting records from 64
Tables, editing ALTER TABLE...ADD COLUMN statement 503—505
Tables, editing ALTER TABLE...DROP COLUMN statement 503—505
Tables, editing indexes in 55—63
Tables, editing update queries 535—538
Tables, indexes, sort key 508
Tables, linking WHERE clause (SQL) 280—291
Tables, locating records in 63—64
Tables, locking 580—581
Tables, multiple tables, creating Dynaset data objects from 73
Tables, optimizing speed 556—558
Tables, records, deleting 544—551
Tables, records, page-level locking 581—582
Tables, refreshing records in 63
tables, relationships 21—23 514—518
Tables, relationships, one-to-many relationships 23
Tables, relationships, one-to-one relationships 21—22
Tables, rows, append queries 528—534
tables, rows, inserting 525—528
Tables, updating records in 63
Tables, validation tables 514
Tables, virtual data tables 71
Tag property 363
Testing, BOOLEAN data field type 29
| Testing, BYTE data field type 29—30
Testing, COUNTER data field type 32—33
Testing, CURRENCY data field type 31
Testing, DATE data field type 31—32
Testing, graph libraries 404—406
Testing, SQL-VB project 762—763
Text box controls, bound text controls 112—113
Text box controls, DataField property 10—13 113
Text box controls, DataSource property 10—13 113
Text box controls, inserting into forms 9—10
Text box controls, KeyPress event 133—136
Text command (File menu) 249
TEXT data field type 26—27 33
Text Field...command, Edit menu 195
Text Field...command, Insert menu 197
Text fields, Crystal Reports Writer 182
Text fields, length 501
Text Files command (File menu) 244
ThisPoint property 393
ThisSet property 393
Tile command (Windows Menu) 747
Titles section of help files 711
Titles, graphs 396—397
Titles, online help 706—707
Too many files error 462
tool tips 5
Toolbox (graph control), loading 389—390
Tools for help files 725—726
Tools menu commands, Options 5
Tools menu commands, References 304
TOP n clause (SQL) 287—288
TOP n PERCENT clause (SQL) 287—288
Topic files (help) 703
Topic files (help), context strings 705—706
Topic files (help), creating browse sequences 708—709
Topic files (help), footnotes 705
Topic files (help), keywords 707—708
Topic files (help), pop-ups 715—717
Topic files (help), saving 709
Topic files (help), separating topics 704
Topic files (help), titles 706—707
Topic files (help), tracking 710
Topic files (help), writing text for files 703—704
Tracing ODBC activity 642
Tracking topic files for online help 710
Trailing spaces, removing from fields 189—190
Transactions 593
Transactions property (Database data access object) 321
Transactions, advantages 597
Transactions, building projects 594—597
Transactions, limitations 597
Transactions, workspace objects 593—594
TRANSFORM...PIVOT statement (SQL) 294—296
Trapping, errors, compared to input validation 130
Trapping, events (data-bound grid control) 433
TrimRight() function, Crystal Reports Writer 189—190
Twips, compared to pixels 118
Typing errors, correcting 103
UNION clause (SQL) 293—294
UNIQUE KEY clause (CONSTRAINT keyword) 511—513
UNIQUE keyword (SQL) 509
Unloading CompanyMaster data entry form 171
Updatable property (Database data access object) 322
Update queries 535—538
UPDATE statement (SQL) 69
UPDATE...SET statement (SQL) 535—538
UpdateControls method (data controls) 107—110
UpdateRecord method (data controls) 107—110
Updating, company logo (CompanyMaster data entry form) 173
Updating, databases, cascading updates/ deletes 587—588
Updating, databases, transactions 593
Updating, records in data tables, Data Manager 63
Updating, records in data tables, data-bound grid control 434—435
User login/logout system 649—660
User login/logout system, building user login form 660 663—664
User login/logout system, user logout 667—668
User login/logout system, verifying login 664—665 667
User rights, adding rights-checking to applications 688—692
User rights, building Access Rights Maintenance form 670—686
User rights, running forms 686—688
Utility menu commands, DBList/DBCombo 265—267
Utility menu commands, Global Replace 264—265
Utility menu commands, Import/Export 265
Utility menu commands, Query Builder 262—264
Validate event (data controls) 110—112
Validation lists 130 139—140
Validation of input 130—177
Validation of input, CompanyMaster data entry form 174—176
Validation of input, compared to error trapping 130
Validation of input, conditional fields 131
Validation of input, field level validation 132—140
Validation of input, field level validation, filtering keyboard input 132—136
Validation of input, field level validation, masking input 136—138
Validation of input, field level validation, validation lists 139—140
Validation of input, form level validation 140—146
Validation of input, form level validation, conditional fields 145—146
Validation of input, form level validation, field lengths 142—143
Validation of input, form level validation, required fields 144—145
Validation of input, form level validation, value ranges 141—142
Validation of input, library functions 146—156
Validation of input, library functions, CheckSize 152—153
Validation of input, library functions, InRange 150—152
Validation of input, library functions, IsConditional 154—156
Validation of input, library functions, IsValid 153—154
Validation of input, library functions, Key Upper 148—149
Validation of input, library functions, KeyNumbers 147—148
Validation of input, library functions, KeyUpperNumber 149
Validation of input, rules 131—132
Validation of input, validation lists 130
Validation tables 514
Value ranges (form level validation) 141—142
Variables, API calls 612
variables, declaring 74
Variables, declaring global variables (SQL-VB project) 749
variables, naming conventions 74
variables, static variables 82
Verify Database command (Database menu) 200
Verify on Every Print command (Database menu) 200
Version property (Database data access object) 322
View menu commands (Properties) 6
Virtual data tables 71
VisData 226—270
Visdata, adding indexes to databases 254—255
Visdata, adding tables to databases 252—253
Visdata, adding to Visual Basic Add-Ins menu 228—230
Visdata, advantages 226—227
Visdata, building tables 254
Visdata, compared to Data Manager 226
Visdata, compiling 227—228
Visdata, creating Microsoft JET engine databases 252
Visdata, editing fields in tables 254
Visdata, File menu commands 238—251
Visdata, File menu commands, Compact Database 249—250
Visdata, File menu commands, Errors 245
Visdata, File menu commands, Exit Visdata 251
Visdata, File menu commands, Make Visdata a VB Add-In 251
Visdata, File menu commands, New 247—249
Visdata, File menu commands, Open Database 239—245
Visdata, File menu commands, Properties 245—247
Visdata, File menu commands, Repair Database 250—251
Visdata, Help menu commands 268
Visdata, JET menu commands 256—261
Visdata, JET menu commands, Attachments 256—258
Visdata, JET menu commands, Multiuser Settings 260—261
Visdata, JET menu commands, Relations 258—260
Visdata, JET menu commands, SYSTEM.MDA 261
Visdata, Main Menu 231—232
Visdata, opening screen 230—231
Visdata, Preferences menu commands 267—268
Visdata, Preferences menu commands, Include System Files 268
|
|
|
| Ðåêëàìà |
|
|
|
|
|
Î ïðîåêòå