Access Data Analysis Cookbook (Cookbooks)

s_Generation field 

SaveSetting function 

ScaleMode property (reports) 

schema information 

schemas

    importing XML using XSD 

screens 

scripts 

Scripts collection 

Scripts container 

scrollbars 

ScrollBars property (forms)

    communicating without email 

    dialog forms 

    navigation buttons 

    pop-up calendars 

    status meters 

search criteria

    asterisk in 

    date variables as 

    string expressions and 

Section property (reports) 

sections, report 

security considerations

    activating 

    adjusting applications 

    attaching linked tables 

    cautions 

    CurrentUser function and 

    for databases  2nd 

    Hidden property and 

    removing user access to queries 

    sending email 

    views to update data 

Security Wizard 

Seek method (recordsets)

    linked tables and 

    recommendations on usage 

    saving queries in tables 

    small tables and 

SELECT (SQL) statement  2nd  3rd 

Select Case statement 

    bookmarking records 

    internationalizing messages 

    list-filling functions and 

    object existence and 

select queries

    cautions using Update To value 

    parameters in 

    recursive relationships and 

Selected property (list boxes) 

self-join queries 

semicolon (;)

    multiple columns and 

    RecordsetLabel property and 

    SQL statements and 

SendKeys queue  2nd 

SendMessage function  2nd 

serialization 

serialized DataSet using MSXML 

ServerFilter property (forms) 

ServerFilterByForm property (forms) 

SetFileTime function (Windows API) 

SetOption method (Application object)

    changing global options 

    keyboard shortcut  2nd 

    support for 

settings

    changing defaults 

    changing margin settings 

    consistent for objects 

    storing 

SetWindowLong function 

shared databases

    communicating via 

    tracking open 

SharePoint Services 

    Data View Web Part  [See Data View Web Part]

    limitations 

    linking to data source 

    working with data from Access 

Shell function  2nd  3rd  4th  5th 

ShellExecute function (Windows API)  2nd  3rd  4th 

Shift-Tab keys, cursor movement and 

shortcut menus

    bookmarking records 

    Calendar control 

    creating 

    disabling on forms 

ShortcutMenuBar property (forms)  2nd  3rd 

Show Smart Tags on Forms setting 

ShowGroup function (Windows shell)  2nd  3rd 

ShowToolbar macro action  2nd 

Simple Object Access Protocol (SOAP) 

SizeMode property (bitmaps) 

sizing 

    form controls 

    screen windows 

Skew function (Excel) 

slash (/) operator 

slides

    creating 

    creating text 

Slides collection 

smart tags 

    conditional processing for 

    creating custom

        DLL 

        XML 

    creating DLLs 

    creating on table  2nd 

    creating XML files 

    Date  [See Date smart tag]

    deleting from table 

    displaying when application starts 

    DLLs 

    executing action without displaying smart tag 

    Financial Symbol  [See Financial Symbol smart tag]

    obtaining weather report with 

    Person Name  [See Person Name smart tag]

    saving settings in variable 

    setting viewing options 

    SQL Server and 

    that ship with Access 2003 

    unregistering 

    using multiple 

SmartTag objects 

sndPlaySound function  2nd 

sorting

    arrays 

    AutoNumber fields and 

    ORDER BY clause 

    reports at runtime 

Sorting and Grouping dialog 

Sorting dialog (report) 

sound files 

sound-alike records 

Soundex 

SourceControl property (subforms) 

SourceObject property (subforms) 

Space function 

SpecialEffects property (text boxes) 

splash forms  2nd 

splash screens 

SQL property (queries) 

SQL Server 

    ADP and 

    client/server applications and 

    compared with Jet database engine 

    data types 

    development environment 

    dynamic connections 

    multiple databases 

    replication services and 

    smart tag properties 

    using views to update data 

    WITH VIEW_METADATA option 

SQL Server Profiler 

SQL statements 

    accelerating multiuser applications 

    cleaning out test data with 

    converting queries to  2nd 

    improving form performance and 

    inequality joins and 

    viewing query's 

square brackets [ ]

    Access interpretation 

    as delimiters 

    embedded spaces and 

    parameters and 

    printing query parameters 

Src property (buttons)  2nd 

stacks  2nd 

    Click events and 

    profile 

    VBA routines and 

Startup dialog  2nd 

Startup form 

Startup group, adding items to 

Static keyword 

static variables

    bookmarking records and 

    capabilities of 

    maximum locking intervals 

    multitasking and 

    tracking form instances with 

statistical functions 

status meters, creating 

StatusBarText property (controls) 

Stock Quote on MSN MoneyCentral 

StrComp function 

StrConv function 

string expressions  2nd 

    concatenation limitations 

    embedded quotes and 

    terminating characters for 

    using fixed length 

subforms

    debugging 

    filtering reports 

    form performance and 

    multipage forms with 

    SourceObject property and 

Substitute function (Excel) 

Sum function 

Switch function 

switchboard forms  2nd 

SYD function (Excel) 

synchronization

    height of two controls 

    multiple databases 

    report records with form 

syntax

    Excel Automation object 

    object and property  2nd 

    SQL Server objects 

    Windows 9x shell 

SysCmd function

    collecting information 

    filtering reports 

    language version and 

    purpose of 

    status meter and 

SysRel container 

System Identifier (SID) 

system objects 

system registry 

system tables

    excluding from lists 

    forms as binary data in 

    MSysObjects and  2nd 

    naming conventions for 

System.mdw  2nd  3rd  4th 

SystemParametersInfo function