Index S

[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [K] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] [X] [Y] [Z]

s (custom display format) placeholder 
Sample Databases command (Help menu) 
sample.xml file 
sandbox mode  2nd  3rd  4th  5th  6th 
Save ADE As dialog box 
Save As DAP operations
    Form/Report to Data Access Page Wizard  2nd 
    forms  2nd  3rd 
    limitations of  2nd  3rd 
    object property values, extracting  2nd 
    queries  2nd  3rd  4th  5th 
    reports  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th 
    tables  2nd  3rd  4th  5th 
Save as Query button  2nd 
Save as Query dialog box  2nd 
Save method
    DoCmd object  2nd 
    Recordset object 
saving  [See also Save As DAP operations; john fix]
    filters
        as queries  2nd 
    forms
        as data access pages  2nd  3rd  4th  5th  6th  7th  8th  9th 
    queries as read-only pages  2nd  3rd  4th  5th 
    reports
        as data access pages  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th 
SBS (Small Business Server)  2nd 
Scale property
    Table Design window  2nd 
schema
    XML schema
        tables exported to HTML  2nd  3rd  4th  5th  6th  7th  8th 
    XSD schema
        document/literal SOAP messages 
        online inference engine 
schema.xsd file 
schemas
    XDR schema 
    XML schema  2nd 
        importing in XSD format  2nd 
scope
    arrays 
    class modules 
    variables  2nd 
screen scraping 
ScreenTips
    displaying 
Script Editor
    adding elements
        to table-based pages  2nd  3rd  4th 
    DAP  2nd  3rd  4th  5th 
script.js file 
scripts
    T-SQL scripts  2nd 
Scrolling Text button (Page
    Toolbox) 
search and replace operations  2nd  [See also finding]3rd  4th  5th 
Search Results page  2nd 
Second function 
section siblings  2nd  3rd 
sections
    form sections
        adding  2nd  3rd 
        background bitmap pictures  2nd  3rd  4th  5th  6th  7th 
        background colors  2nd 
        border color  2nd 
        border style  2nd 
        custom colors  2nd  3rd 
        foreground color  2nd  3rd 
        john make forms/sections like this 
        labels, adding  2nd  3rd 
        properties  2nd 
        sizing  2nd  3rd 
    report sections 
        adding  2nd 
        deleting  2nd 
        page breaks 
        printing 
security 
    ADP
        compiling as encoded .ade files  2nd  3rd 
        user-level 
    client/server apps
        john fix 
        password-protecting front ends  2nd  3rd  4th  5th  6th 
        trusted connections 
    HTML data 
    integrated security 
    macro security warning  2nd  3rd  4th 
    managing with MSDE User Manager  2nd  3rd  4th 
    MSDE  2nd 
    SQL Server security
        system administrator accounts  2nd  3rd 
    XML documents 
Security IDs (SIDs) 
Security Wizard  2nd  3rd  4th  5th  6th  7th  8th  9th 
Seek method
    Recordset object  2nd  3rd  4th 
Select Case...End Select structure  2nd  3rd 
Select Data Source dialog box  2nd  3rd 
Select Directory Containing
    Free Tables dialog box  2nd 
Select Objects button (Toolbox) 
select queries 
    creating
        Query Design window  2nd  3rd 
        Simple Query Wizard  2nd  3rd  4th 
SELECT queries
    opening 
    upsizing  2nd 
SELECT statement  2nd  3rd 
    based on combo box values  2nd  3rd  4th  5th  6th  7th 
    elements in  2nd  3rd 
    FROM clause 
    GROUP BY clause
        aggregate functions  2nd  3rd 
    ORDER By clause 
    QBE translation  2nd  3rd  4th  5th  6th  7th  8th 
    subqueries  2nd  3rd  4th  5th  6th 
    UNION queries  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
        creating 
        restrictions  2nd 
        syntax 
    WHERE clause  2nd  3rd 
        joins, creating  2nd 
Select Unique Record
    Identifier dialog box  2nd 
selecting
    fields
        Query Design window  2nd  3rd  4th  5th 
    records  2nd  3rd 
        Query Design window  2nd  3rd  4th 
    text
        keyboard operations  2nd  3rd  4th 
SelectObject method
    DoCmd object  2nd 
self joins  2nd  3rd  4th 
semicolon (custom display format) placeholder
    john replace w a semicolon 
semicolon (input mask) placeholder
    john replace w semicolon 
SendKeys method (DoCmd object) 
SendObject method
    DoCmd object 
serialization 
serially numbered documents  2nd 
ServerFilter property
    DataSourceControl class  2nd  3rd 
servers
    exported XML file sets, deploying  2nd 
    john should this
        and Web servers be same 
    linked SQL Server servers  2nd 
        linking Jet databases  2nd  3rd  4th 
        linking SQL Server databases  2nd  3rd  4th  5th 
    transferring ADP databases to  2nd  3rd 
Service Options dialog box  2nd 
Set statement
    named variables, creating  2nd 
SetDefaultWorkgroupFile method
    Application object 
SetMenuItem method
    DoCmd object  2nd 
Setup
    MSDE  2nd  3rd  4th  5th  6th  7th  8th 
Setup.exe
    Web Service References  2nd 
SetValue method
    DoCmd object 
SetWarnings method
    DoCmd object 
SGML (Standard Generalized
    Markup Language) 
ShallAllRecords method
    DoCmd object 
shared file systems
    future of  2nd  3rd 
shared-file systems  2nd 
Shift+ key combination 
Shift+ key combination 
Shift+Delete key combination 
Shift+Enter key combination  2nd 
Shift+F1 key combination 
Shift+F12 key combination 
Shift+F2 key combination 
Shift+F3 key combination 
Shift+F4 key combination 
Shift+F7 key combination 
Shift+F8 key combination  2nd 
Shift+spacebar key combination 
Shift+Tab keycombination 
shortcut keys
    john add entries,notthispage 
    VBA code shortcuts  2nd 
shortcut menus
    right-click shortcut menus  2nd 
Show All Relationships button 
Show Direct Relationships button  2nd 
Show Table dialog box  2nd 
Show/Hide the Office Assistant command
    (Help menu) 
ShowToolbar method
    DoCmd object 
SID (system ID) 
SIDs (Security IDs) 
Simple Query Wizard  2nd  3rd  4th  5th  6th  7th  8th 
Single data type  2nd 
    converting to other data types  2nd 
    relationships  2nd 
single-column inner equi-joins  2nd  3rd  4th 
single-column reports 
single-line text boxes, creating  2nd  3rd  4th 
Size property
    Parameter object 
sizing
    DAP controls  2nd 
    form controls  2nd 
    form sections  2nd  3rd 
    john add entries 
Slammer worm  2nd 
    SQL Server SP3 
Small Business Server (SBS)  2nd 
smart tags  2nd  3rd  4th  5th 
    Auto Correct Options 
    Date 
    Error Checking options 
    error checking options  2nd  3rd  4th 
    Financial Symbol 
    for form controls 
    Person Name 
    Property Options smart tag  2nd  3rd 
    Propery Options 
    third-party smart tags 
    Web-based smart tags  2nd  3rd 
Smart Tags property
    Table Design window 
Snap to Grid command  2nd 
snapshot backups  2nd 
snapshot replication 
Snapshot Viewer  2nd  3rd 
    obtaining 
SOAP messages  2nd  3rd  4th  5th  6th  [See also WebService Studio]
    formats 
    IXMLDOMNodeList object  2nd  3rd  4th  5th  6th  7th  8th  9th 
    populating tables  2nd  3rd 
    XSD schema 
SOAP Toolkit
    SQLXML, installing 
Social Security Numbers (SSNs) 
Software Assurance and
    Licensing terms 
Sort Ascending button
    Form view 
    Table Datasheet
        s/b Datasheet view 
    Table Datasheet toolbar 
Sort Descending button
    Form view 
    Table Datasheet
        s/b Datasheet view 
    Table Datasheet toolbar 
Sort property
    Recordset object 
sorting
    DAP records  2nd  3rd  4th 
    form data 
    multitable query result sets  2nd  3rd 
    Recordsets
        in tables saved as pages 
    report data  2nd 
        by alphabetic code characters  2nd 
        by date/time  2nd 
        by expressions  2nd  3rd 
        by numeric value  2nd  3rd 
        by ranges of values  2nd  3rd 
        by using subgroups  2nd 
    table data  2nd  3rd  4th  5th 
        composite criteria  2nd  3rd 
        freezing fields  2nd  3rd 
        multifield sort criteria  2nd  3rd  4th  5th 
        on multiple fields  2nd  3rd  4th 
        on single fields  2nd  3rd 
        removing sort orders  2nd 
Sorting and Grouping dialog box  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th 
Source Connect Str property 
Source Database property  2nd 
Source property
    Error object 
    Recordset object 
sp (stored procedures) prefix 
Space function 
space-delimited files 
    importing  2nd  3rd  4th  5th  6th  7th 
Special Effects button
    Datasheet Formatting toolbar 
spelling options  2nd 
Spreadsheet OWC controls
    adding to DAP  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
    AutoFilter feature  2nd  3rd  4th 
spreadsheets  [See also PivotTables]
    importing spreadsheet files  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th  16th  17th 
    linking spreadsheet files  2nd  3rd 
SQL  2nd  3rd  4th  5th  6th  7th 
    ANSI SQL  2nd 
        aggregate functions 
        AS alias name construct (js search) 
        conforming computed columns  2nd  3rd  4th  5th  6th  7th 
        GROUP BY query 
        joins, creating  2nd 
        keywords 
        punctuation  2nd  3rd  4th  5th  6th 
        reserved words  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th 
        SQL Server Compatible Syntax  2nd 
        updates  2nd 
    commands 
    functions
        aggregate functions  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th 
        group aggregate functions 
        upsizing VBA functions to  2nd  3rd  4th 
        utility functions 
        VBA function support 
    identifiers  2nd  3rd 
    Jet SQL
        reserved words  2nd  3rd  4th  5th  6th  7th  8th  9th  10th 
    keywords  2nd  3rd 
    punctuation  2nd  3rd 
    statements
        controls and  2nd  3rd  4th 
        formatting 
        forms and  2nd 
        indirect table relationships  2nd 
        JOIN  2nd  3rd  4th  5th 
        nested queries  2nd 
        QueryDefs, creating  2nd 
        SELECT.  [See SELECT statement]
        sorted queries, Top Values limit  2nd 
        SQL views 
        translating into QBE designs  2nd  3rd  4th  5th  6th  7th 
        troubleshooting 
        upsizing  2nd  3rd  4th  5th 
        usage categories  2nd  3rd 
    stored procedures  2nd  3rd 
        append procedures  2nd  3rd  4th  5th  6th 
        crosstab queries, emulating  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th  16th  17th 
        delete procedures  2nd 
        john okay or under SQL Server instead? 
        logins, adding/revoking  2nd  3rd  4th  5th 
        make-table procedures  2nd  3rd  4th  5th  6th 
        parameters, specifying  2nd  3rd  4th 
        permissions, adding/revoking  2nd  3rd  4th  5th 
        transaction processing  2nd  3rd  4th 
        troubleshooting 
        update procedures  2nd  3rd  4th  5th  6th 
        versus views/inline-functions  2nd 
SQL button, view designer toolbar 
SQL examples
    append queries  2nd 
    delete queries  2nd 
    john change to SQL statements? 
    john need to distinguish Jet SQL examples? 
    john verify this wording 
    make-table query  2nd 
    parameterized make-table query 
    renaming query columns  2nd 
    Simple Query Wizard query  2nd 
    summary query  2nd 
    update queries  2nd 
SQL Server  [See also MSDE]
    Books Online documentation 
    configuring for Web access  2nd  3rd  4th  5th 
    da Vinci toolset  2nd 
        john add pages 
    data types  2nd  3rd 
    Distributed Transaction Coordinator (DTC) 
    editions  2nd  3rd 
    Enterprise Manager 
        Copy Database Wizard 
    extended properties  2nd 
    functions  2nd  [See also functions]3rd 
        in-line functions  2nd  3rd  4th  5th  6th 
        user-defined 
    HTTP query features  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th 
        returning documents  2nd  3rd  4th 
        style sheets, applying  2nd  3rd  4th  5th 
        template queries  2nd 
        XML template files  2nd  3rd 
    installation  2nd 
    licensing  2nd 
    linked servers  2nd 
        Jet databases, linking  2nd  3rd  4th 
        SQL Server databases, linking  2nd  3rd  4th  5th 
    moving database
        files between servers  2nd 
    named instances, installing  2nd  3rd  4th  5th 
    new features  2nd  3rd  4th 
    referential integrity, enforcing  2nd 
    security
        system administrator accounts  2nd  3rd 
    SQLXML
        creating  2nd  3rd  4th  5th  6th  7th  8th  9th 
        downloading  2nd  3rd 
        installing  2nd  3rd 
        testing  2nd  3rd 
    SQLXML Web services 
        IIS requirements 
        service packs 
    tables
        appending records  2nd  3rd  4th  5th  6th 
        check constraints  2nd 
        creating  2nd  3rd  4th  5th  6th 
        Database window 
        deleting records  2nd 
        project designer.  [See project designer]
        Properties dialog box  2nd  3rd  4th  5th  6th  7th  8th  9th 
    versus MSDE  2nd  3rd  4th 
    views  2nd  3rd  4th  5th  6th  7th  8th  9th 
        adding tables  2nd  3rd  4th  5th  6th 
        creating  2nd  3rd  4th 
        Datasheet View toolbar 
        duplicating queries  2nd  3rd 
        row fix-up feature  2nd 
        setting JOIN properties  2nd  3rd  4th  5th  6th 
        versus stored procedures/in-line functions  2nd 
        view designer  2nd  3rd  4th  5th  6th  7th  8th  9th 
    Yukon 
SQL Server 2000
    installation 
SQL Server 2000 Books Online 
SQL Server Agent  2nd 
SQL Server Client Tools
    obtaining 
    SQLXML and 
SQL Server Compatible Syntax  2nd 
SQL Server databases
    backups  2nd 
    check constraints  2nd 
        in tables saved as pages 
    entity integrity 
    linking remote databases to local MSDE  2nd  3rd  4th  5th 
    referential integrity 
    remote databases, connecting to  2nd  3rd  4th 
    transaction processing (TP) 
SQL Server Login dialog box  2nd 
SQL Server SP3
    Slammer worm 
SQL Service Manager  2nd 
SQL Xerver identity fields
    john verify 
SQL-92 
SQL-99  2nd 
SQL3  2nd 
SQLState property
    Error object 
SQLXML
    downloading  2nd 
SQLXML Web services 
    creating  2nd  3rd  4th  5th  6th  7th  8th  9th 
    downloading 
    IIS requirements 
    installing  2nd  3rd 
    service packs 
    testing  2nd  3rd 
SSNs (Social Security Numbers) 
stacked column charts  2nd  3rd  4th  5th  6th  7th  8th 
Standard Generalized Markup
    Language (SGML) 
standard modules  2nd 
    john verify
        same as Access modules 
Startup dialog box  2nd 
startup mode 
startup properties  2nd 
State property
    Command object 
    Connection object  2nd  3rd 
    Recordset object 
stateless front ends  2nd 
statement autocompletion  2nd 
statements
    SQL statements
        usage categories  2nd  3rd 
statements (SQL)
    controls and  2nd 
    DELETE
        syntax  2nd 
    formatting 
    forms and  2nd 
    indirect table relationships  2nd 
    INSERT
        parameters, specifying  2nd  3rd  4th 
    INSERT INTO
        syntax  2nd 
    JOIN  2nd  3rd  4th  5th 
    nested queries  2nd 
    QueryDef objects, creating  2nd 
    reports and  2nd 
    SELECT  [See SELECT statement]
    sorted queries, Top Values limit  2nd 
    SQL views 
    translating into QBE designs  2nd  3rd  4th  5th  6th  7th 
    troubleshooting 
    UPDATE
        parameters, specifying  2nd  3rd  4th 
        syntax  2nd 
    upsizing  2nd  3rd  4th  5th 
static reports
    exporting 
    exporting as XML  2nd  3rd  4th  5th  6th  7th 
Static reserved word  2nd 
static variables  2nd 
static Web reports 
status bar 
Status property
    Field object 
    Recordset object  2nd  3rd  4th 
StayInSync property
    Recordset object 
StDev function  2nd 
StDevP function  2nd 
StopAllMacros method
    (DoCmd object) 
    DoCmd object 
StopMacro method (DoCmd object)  2nd 
stored procedures  2nd  3rd 
    append procedures  2nd  3rd  4th  5th  6th 
        syntax  2nd 
    as Web service methods  2nd  3rd  4th 
    crosstab queries, emulating  2nd  3rd  4th  5th  6th  7th  8th  9th  10th  11th  12th  13th  14th  15th  16th  17th 
    delete procedures  2nd 
        syntax  2nd 
    logins, adding/revoking  2nd  3rd  4th  5th 
    make-table procedures  2nd  3rd  4th  5th  6th 
        syntax  2nd 
    parameterized
        Command object  2nd  3rd  4th  5th 
    parameters, specifying  2nd  3rd  4th 
    permissions, adding/revoking  2nd  3rd  4th  5th 
    transaction processing  2nd  3rd  4th 
    troubleshooting 
    update procedures  2nd  3rd  4th  5th  6th 
        syntax  2nd 
    update stored procedures  2nd 
    versus views/inline-functions  2nd 
Str function 
StrComp function 
Stream object  2nd  3rd  4th  5th 
    creating  2nd  3rd  4th 
    FOR XML AUTO queries  2nd  3rd 
Stream objects 
strFormName argument
    OpenForm method 
String data type 
String function 
string identifiers 
    john same as delimiters 
string literals  2nd 
StrReverse function  2nd 
structured information  2nd  3rd 
Structured Query Language  [See SQL]
structures  2nd  3rd  4th  5th 
    Do Until...Loop  2nd  3rd 
    Do While...Loop  2nd  3rd 
    For...Next  2nd  3rd 
    If...Then...End If  2nd  3rd 
    Select Case...End Select  2nd  3rd 
    While...Wend 
    With...End With  2nd 
style sheets
    CSS
        john add entries 
    XSL
        john add entries 
STYLE tag, HTML  2nd  3rd  4th  5th 
styles, AutoFormat
    forms  2nd  3rd  4th  5th 
    reports  2nd 
Sub reserved word 
Subdatasheet Expanded property
    Table Properties window 
Subdatasheet Height property
    Table Properties window 
Subdatasheet Name property
    Table Properties window 
subdatasheets  2nd  3rd  [See also lookup fields]4th 
    cascading 
    editing data 
    expand indicator 
    nesting 
    opening 
    properties  2nd  3rd 
    query properties 
    query subdatasheets  2nd  3rd 
    removing  2nd 
    table subdatasheets  2nd  3rd  4th 
Subform Field Linker dialog box  2nd 
Subform Wizard  2nd  3rd  4th  5th  6th  7th  8th 
SubForm Wizard  2nd 
Subform/Subreport button (Toolbox) 
subforms  2nd  3rd 
    adding
        to tab control pages  2nd  3rd  4th  5th  6th  7th  8th 
    controls
        VBA references to  2nd 
    editing
        in-situ subform editing 
    in-situ subform editing 
    naming  2nd  3rd 
    PivotChart subforms
        cloning linked forms/subforms  2nd  3rd 
        editing design  2nd  3rd 
        linking  2nd 
        using forms as  2nd  3rd 
    properties  2nd  3rd  4th  5th  6th 
    saving as DAP  2nd 
    troubleshooting  2nd 
subgroups
    grouping reports with  2nd 
subprocedures  2nd  [See also event handling]
    arguments  2nd 
    calling in class modules 
    custom subprocedures 
    functions as  2nd  3rd  4th 
    private 
    public 
    versus functions  2nd 
subqueries  2nd  3rd  4th 
    creating  2nd 
    syntax  2nd 
subreports 
    reports as  2nd  3rd  4th 
subroutines  [See procedures]
subtraction (-) operator
    john change to en dash 
subtypes, number fields  2nd  3rd  4th 
Sum function 
summary queries  2nd  3rd  4th  5th  [See also crosstab queries]6th  7th 
    choosing data sources for  2nd 
    converting to parameter queries  2nd 
    creating for Chart Wizard  2nd  3rd  4th 
    non-updatable, troubleshooting 
    testing  2nd 
Support method (Recordset object)  2nd 
Supports method
    Recordset object  2nd 
Switchboard Manager  2nd  3rd 
Switchboard Manager command (Tools menu) 
switchboards
    Main Switchboard  2nd  3rd  4th  5th 
        Design view  2nd  3rd 
Sybase
    linking/exporting tables  2nd  3rd 
symbolic constants 
    data types, specifying 
    declaring 
    intrinsic  2nd 
    system-defined 
synchronizing forms  2nd 
Syntax error or access
    violation message
        john quotes 
system administrator accounts
    adding  2nd 
    passwords, setting  2nd  3rd 
system ID (SID) 
System Info button (Help menu) 
system-defined constants 
System.mdw file  2nd