[ Pobierz całość w formacie PDF ]
.See Structured Query Language (SQL) queries, conversion to/from, 826, 1021 1023statements queries, in, 272, 356, 372 373, 813 817, 826 832sql_variant SQL Server data type, 1129 query selection, 830 831Sqr( ) function, 335 records, displaying based on top values, 830Src property, 1251, 1252 sort order, 827, 831standard deviation, 746 stored procedures, in, 1161starting Access.See also startup options subqueries, 817Access shortcut icon, from, 43 table lookup properties, in, 195Office folder, from icon in, 44 45 table selection, 827, 830 831Start menu, from, 42 44 viewing, 826Windows Explorer, from, 45 46 WHERE clauses, 829 830, 831Startup dialog box, 47, 57, 1087 Style property, 1107startup options SubDatasheet properties, 440, 825Access icon, specifying, 1086 Subform Wizard, 834command-line parameters, 46 47 subroutines, 1018databases, opening, 46 47 subtraction operator, 319databases, passing values to, 47 Sum( ) function, 334, 673forms, opening, 47 48, 438, 455, 906, 1086 1087 Summary Options dialog box, 306, 307macros, running, 47 48, 906, 1086 sunken effects, 475 476, 646menu bar, 1086 Surgical Strike (on the CD), 1294 1295Startup dialog box, hiding, 47 switchboardsstatus bars, specifying at, 1086 actions possible from, 969title bar text, specifying, 1086 command buttons, 1049 1050toolbars, specifying at, 1086 creating from forms, 1051user profile options, 46 creating using Database Wizard, 967 969username/password options, 46 design, 115 116, 967 969Visual Basic (VBA) procedures, running, 47 introduced, 115 116Startup properties window, 906 page definitions, 968 969Status Bar Text property, 496, 1106 startup, loading at, 1086status bars, 57, 213, 496, 1086 Sybase Server, 692, 718status line messages, 494 synchronizationStopMacro macro action, 912, 913, 932, 939 databases, using Briefcase, 59Str( ) function, 333 forms, using macros, 927 929string data type (Visual Basic), 1003 tables, 147string data types, Access.See memo data type;text data typeTstring manipulation functions, 335.See also text,tab controls, 397, 407 408, 1103 1109, 1256working withTab Order dialog box, 453, 1108string operators, 323 326.See also text, working withTab properties, 453, 1107Structured Query Language (SQL) statements.See also specific statementsActive Server Pages (ASP), in, 1202conditions, specifying, 831 8323596-X Index.F 5/30/01 11:52 AM Page 1338Index &' T1338Table Analyzer Table Wizard, 131 132, 961 962accessing, 187 189 tables.See also columns; fields; rows; tabledescribed, 186 187 relationshipsfield changes using, 192 196 Active Server Pages (ASP), saving as, 1198 1199installation, 188 analyzing using Table Analyzer, 189 192keys, operations on, 194 197 background color, 239Looking At the Problem window, 188 cells, 65normalization, checking, 186 187 changing, 162, 192, 197Relationships window, 189, 192 closing, 133reliability issues, 186, 195 copying, 163 164Solving the Problem window, 188 189 copying structure, 163spell checking, 196 197 creating by dragging field to empty area, 193table changes using, 191, 192 196 creating using make-table action queries, 719, 773,table selection for, 189 776, 781 784table splitting, 191 creating using Table Wizard, 129 134tasks accomplished by, 186 187 data access pages (DAPs), conversion to, 1255 1256Table Analyzer DB (on the CD), 187 data access pages (DAPs) using multiple, 1220Table Design window, 134 139, 157, 1128 1130 data access pages (DAPs) using single, 1221 1230table joins.See table relationships, joins data separation into, 85 86, 100 106Table Properties dialog box, 207 database, maintaining in separate, 124, 709 712Table Properties window, 160 161, 1131 1138 Database Wizard, using, 964 965table relationships.See also keys; referential integrity; databases versus, 67tables Datasheet view, 65 69, 132 134analyzing using Table Analyzer, 189 192 deleting, 163AutoJoin, 822, 823 described, 83 84conflicts, solving, 182 design, 85 86, 100 108, 130, 141 144, 161creating, 180 186 Design View, 70 72, 134deleting, 181, 183 184 dynasets, based on, 273design, 103 108 dynasets versus, 273displaying, 166, 178 179, 181, 184 185 fields, adding to, 71, 131, 140 141editing, 180, 181, 183 fields, moving, 192 193Find Unmatched queries, 182 fields, relation to, 212join lines, 166, 184 185, 345 346, 1139 file format, 39joins, changing properties of, 362 363 flat-file tables, 190 191joins, creating in queries, 357 360, 803 forms, multiple-table, 457 463joins, cross-product (Cartesian), 358, 359, 367 forms, updating from, 1037, 1038joins, deleting in queries, 358, 360 forms data source, specifying, 254joins, inner (equi-joins), 361 362, 363 364, 831 hyperlinks in, 1211, 1213joins, left, 366 367, 831 HyperText Markup Language (HTML) tables,joins, meaningless, 359 360 linking, 694, 706 707, 1210joins, multiple-field, 360 identifiers, unique, 102joins, outer, 363 367 junction tables, 176 177joins, right, 364 366, 831 local, 124joins, self, 361  local tablename suffix, 1147, 1150joins, types of, 360 361 lookup tables, permanent, 801linked tables, 713 lookup tables, transient, 801, 803lookup table relationship, 176 lookup tables, 109 110, 166 167, 176many-to-many, 176 177 lookup tables in queries, 803 805many-to-one, 176 lookup tables in subforms, 852 859one-to-many, 176, 356 357 lookup tables using DLookUp( ) function, 802 803one-to-one, 175 176 moving linked, 717parent-child relationship, 177 name, changing, 162, 192, 193 194, 716primary table, 181 naming, 133, 373queries, creating in, 174, 343 345, 349, 351 354, navigating, 65 69357 360 normalization, 86, 103 106queries, overridden by, 177 opening, 65 66reports of, printing, 186 Paste As operations, 163 164, 786saving, 184 procedures, updating using, 1037 1038subforms, layout in, 838 839 project objects, as, 1127, 1157updateability, effect on, 354 355 project tables stored in server database, 11263596-X Index [ Pobierz całość w formacie PDF ]