[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 |