Share this Page URL
Help

Index > Index - Pg. 695

Index data types vs. Access, 516 Desktop Engine, 499 editions of, 499 importing data and, 109 InfoPath and, 545 passwords, 515 relationship between Access, Desktop Engine, and, 538 SharePoint Services and, 537, 562 splitting databases and, 45 upsizing Access databases to, 503 SQL Server 2000 Books Online, 534 SQL Server Desktop Engine, 499 SQL View, 219, 309, 315, 318, 320 sql_variant data type, 517 square brackets ([]), 222 Stacked Column chart type, PivotChart, 399 standard layouts, form, 10 standard modules, Visual Basic, 145, 150 Standard style, 230 startup options, 490, 496, 669 static cursors, 608, 611 static data, Excel, 555 static variables, Visual Basic, 157 stepping through Visual Basic code, 172 Stop statement, 172 stored procedures, 532 stretching images, 250, 271 String data type, Visual Basic, 148 strings CDATA constructs and XML, 568 sorting and zero­length, 198 Visual Basic (see strings, Visual Basic) zero­length, 55, 87 Sum function, 218 summarizing, 266 (see also grouping) (see also totals) data with crosstab queries, 304 select queries and, 215 summary views, 215 Summary Options dialog box, 339 Switchboard Items table, 465 Switchboard Manager, 465 symbols, Format property, 95 synchronization, replication and, 637, 644, 645 Synchronize Database dialog box, 637, 644 syntax checking, Visual Basic Editor, 165 syntax errors, Visual Basic, 167 system administrator (SA) account, 502 695 T tab controls, 281 Tab Order dialog box, 259, 265 tab order, control, 258, 265 Tab Stop property, 260 Table Analyzer Wizard, 66 table definition statements, XML, 580 Table Design view, 47, 90, 104 Table Design window, 4, 7, 8, 517, 522 Table Properties dialog box, 82, 197 Table Wizard, 59 TableDef object, 185 TableDefs collection, 185 tables adding and removing, from Relationships window, 32