Share this Page URL
Help

Index > Index - Pg. 692

Index SQL Server views and stored procedures as, 528 subqueries vs. nested queries, 312 table relationships and, 31 testing database designs with, 67 Visual Basic and, 223 Query, 555 Query Builder, 102, 239, 264, 291, 352, 355, 588 query design grid, 207, 212, 213, 304, 308, 318 Query Design toolbar, 315 Query Design window, 13, 209, 306, 324, 381, 533 query designer, 532 Query Form view, InfoPath, 547 Query Parameters dialog box, 222, 223, 355, 357 Query Properties dialog box, 326, 328 Query window, 31 Query Wizard, 555, 559 QueryDef object, 185, 223, 320 QueryDefs collection, 185 question mark icon, 143 quick watches, Visual Basic, 172 Quit method, 598 quotation mark, single ('), 140 quotation marks, double (""), 59, 122 692 selecting, with queries (see queries; select queries) sorting, in Datasheet view, 194 tables and, 4, 29 (see also tables) updating, with update queries, 314 validation rules, 99 Recordset objects, ADO, 605 (see also ADO (ActiveX Data Objects)) Connection objects and, 605 cursor types and, 607 help, 167 LockType and CursorType properties, 608 LockType property, 630 navigating records in, 609 object model and, 186 RecordCount property, 611 Recordset objects, DAO, 160, 183, 223 Recordset Type property, 299 RecordsetLabel property, 438, 440 record­level locking, 631 redundant data, 40, 46 (see also duplicate data) (see also normalization) references Microsoft Office XP Web Components, 406 Object Browser and, 180 object models, 141 (see also object models) objects in collections, 179 Office Automation, 593, 605 Outlook library, 188 References collection, 593 References dialog box, 141, 180, 593, 605 R Read Data permission type, 652 Read Design permission type, 652 read­only ADO Recordset objects, 608 read­only form data, 299 read­only PivotTables and PivotCharts, 380 real data type, 516 record locking