Share this Page URL
Help

Index > Index - Pg. 694

Index PivotTables and, 380 replicated database, 643 SQL Server, 500, 501, 503, 509, 515 statistics, 646 types of, 646 user­level, 647 XML documents, 568 Select Access Database dialog box, 431, 448 Select Case statement, 159, 164 Select Data Source dialog box, 443, 446, 546, 554 SELECT keyword, 220, 309, 313, 327, 590 select queries, 206 (see also queries) calculating field totals, 209 creating single­table, in Design view, 206 criteria to select data, 212 date expressions, 215 different views of, 219 moving and inserting fields in query design grid, 212 multitable, 207, 209 Null values and, 215 object dependencies and, 624, 629 shortcuts, 207 SQL Server views as, 528 summarizing and grouping records, 215 turning off AutoJoin, 209 updating data in multitable, 210 selection multiple items, 250, 255, 291, 378, 496 subforms and subform controls, 282 self­describing, XML as, 565 self­joins, 330 (see also joins) semicolon (), 309, 313 series fields, 361 SET keyword, 316 Set Maximum Record Count dialog box, 532 Set statement, 149 Setup.exe, 500 SetValue macro action, 462 SetWarnings macro action, 130 SetWarnings method, 323 Shape object, 603 Shapes collection, 603 shared databases, 645 SharePoint Portal Server, 539 SharePoint Services, 537 collaboration with, 537 distributed computing and, 537 importing and, 109 linking tables through, 540, 552 linking to SharePoint Services data from Access, 538, 552 SharePoint Portal Server vs., 539 SQL Server, SQL Server Desktop Engine, and, 538, 562 SharePoint Team sites, 538 Shift key, 250, 255, 291, 378, 496 Shift+F2 key combination, 94 Shortcut Menu Bar property, 484 shortcut menus assigning, to forms, 482 creating custom, 479 filtering and, 199 sorting and, 198 shortcuts, keyboard (see keyboard shortcuts) Show box, 312 694 Show Table dialog box, 52 showing (see hiding and unhiding) Simple Query Wizard, 13, 18, 217 Single field size, 83 Single Form view, 233 single quotation mark ('), 140 single stepping macros, 496 size controls, 248, 258, 265 disk (see disk space) fragmented files, 618, 624 picture, 271 replication and database, 635 SQL Server database, 503, 509 Size Mode property, 250 Slide object, 600 Slides collection, 603 slides, PowerPoint, 600 smalldatetime data type, 516 smallint data type, 516 smallmoney data type, 516 Smart Tag property, 492 smart tags, 492 Snap To Grid command, 255 sorting, 266 (see also grouping) combo box items, 266 crosstab queries and, 308 Datasheet view and, 194 Excel and, 557, 559 forms and, 247 Null values and, 215 Order By property and, 82 queries and, 208, 224 reports and, 339, 341, 345, 350, 369 SQL and, 309, 313, 325 SQL Server views and, 531, 534 Sorting And Grouping dialog box, 345, 353, 364, 369 Source Object property, 279, 282, 365, 367, 405 space, disk (see disk space) Spacebar, 291 spaces, 58 spacing, control, 265 Special Effect property, 271, 273, 275 special effects, form, 271 split databases, 45, 46, 107, 108, 123, 615 Spreadsheet component, 444 SQL (Structured Query Language) as Office Spreadsheet component data source, 446 creating calculated fields, 219 creating PivotTables with, 408 creating queries with, 308, 333 custom report feature and, 586 data­definition queries, 325 expressions for filtering, 295 pass­through queries, 325 SQL Server stored procedures and, 532 SQL Server views and viewing, 532 SQL­specific queries, 323 statements as form record sources, 238 union queries, 324, 325 SQL property, 223 SQL Server creating tables in projects, 515 data access pages and, 412 data provider, 606 data types, 575