Share this Page URL
Help

Index > Index - Pg. 686

Index Insert Picture dialog box, 236, 269, 275 INSERT statement, 318 InsertFieldSet method, 408 InsertTotal method, 409 Inside Microsoft SQL Server 2000, 534 Installation Folder dialog box, 500 int data type, 516 Integer data type, 154 Integer field size, 83 integrated security, 501, 503, 513 (see also security) integration, Office (see Office; Office Automation) integrity, referential (see referential integrity) IntelliSense, 25, 141, 164, 595 international formats, 96 Internet (see data access pages; Web; Web pages) Internet Explorer data access pages in, 412, 420, 427, 428 help for data access pages, 439 HTML pages in, 415 HTML templates and, 418 security for data access pages, 439 viewing XML documents, 568, 578 intranet (see data access pages; Web pages) Is Not Null operator, 213, 215, 220 Is Null operator, 213, 215, 329 Item property, 179, 186 ItemsSelected collection, 291 686 mailing, 342, 378 PivotChart, 401 report, 348 text box, 266 language, sort order and, 198 Last function, 224 late binding, 593 layout form, 10 report, 340, 367 Layout Wizard, 429, 440 left outer joins, 328, 332 Left property, 256 legends, PivotChart, 397 Length property, 515 Leszynski­Reddick Naming Convention, 59 libraries (see object models; references) licensing, SQL Server, 538 lifetime, Visual Basic variable, 155 Like operator, 213 Limit To List property, 261, 264 line continuation character (_), 142, 144 lines, report, 378 Link Child Fields property, 83, 279, 282, 366, 367, 378 Link dialog box, 125, 128, 539, 559, 560 Link Master Fields property, 83, 366, 378 Link Tables dialog box, 125, 128 Link To Windows SharePoint Services Wizard, 539, 552 Linked Table Manager, 128 linking, 124 charts to report records, 378 data formats, 127 deleting linked tables, 127 forms, 229, 233 images, 271 importing vs., 107 (see also importing) linked table sort order, 198 refreshing links with Linked Table Manager, 128 splitting databases and, 108, 123 subreports to main reports, 363 tables through SharePoint Services, 540, 552 tables to multiple Office applications, 562 to Access data from Excel, 555 to Access data from InfoPath forms, 548 to Northwind database tables, 125 to Outlook data, 559 to SharePoint Services data, 538, 552 XML documents and, 584 List Box Wizard, 288 list boxes, 226, 282, 287 lists, SharePoint Services, 539, 552 literal characters, 90 Load event, 300, 301 local replica, 641 local variables, 155 Location Of New Replica dialog box, 635, 643 Locked property, 297 locking, record (see record locking) LockType property, 608, 630 logical errors, Visual Basic, 167 logical operators, 98 Logon dialog box, 661 logon passwords (see passwords) Long Integer field size, 83 lookup fields creating, 62 J Jet database engine, 219, 448, 454, 606 Join Properties dialog box, 328, 332 joins inner, 81, 220, 309, 328, 332 outer, 328 relationships and, 81 self­joins, 330 tables and, 209, 212 junction tables, 51 K Keep Together property, 345, 369 key fields (see foreign key fields; primary key fields) keyboard shortcuts CTRL key, Shift key, and selections, 250, 255, 291, 378, 496 Ctrl+Break key combination, 171, 172 F1 key, 166, 431 F2 key, 180 F7 key, 180 F8 key, 172, 610 macro actions, 459 menu bar, 476 Shift+F2 key combination, 94 keyset cursors, 608 keywords, Visual Basic, 149, 156 L Label tool, 348 Label Wizard, 342 Label X and Label Y properties, 266 labels adding, to form footers, 236 data access page, 440 database diagram, 524