Index

S

sa login account, Login and User Accounts

sample tables, creating<$endrange>, Figure 11.14: The three panes for the Access project Query Designer with a view that sorts orders by Freight...

sample tables, creating<$startrange>, Creating Sample Tables

Save method (ActiveWorkbook object), Running Excel Procedures from an Access Procedure

Save method (Recordset object)<$endrange>, Persisting Recordsets

Save method (Recordset object)<$startrange>, Persisting Recordsets

Save method (Recordset object)\

saving to Stream objects<$endrange>, Saving To and Recovering From Streams

saving to Stream objects<$startrange>, Saving To and Recovering From Streams

Save method\

DoCmd object, Creating and Saving a Report with a Custom Name

SaveAccessDBRecordSource( ) (example), Persisting Recordsets

SaveEditInsertShippersAtNorthwindCS( ) (example), Persisting Recordsets

SaveToAndRecoverFromStream( ) (example), Saving To and Recovering From Streams

saving recordsets<$endrange>, Persisting Recordsets

saving recordsets<$startrange>, Persisting Recordsets

saving recordsets\

to streams<$endrange>, Saving To and Recovering From Streams

to streams<$startrange>, Saving To and Recovering From Streams

saving\

data access pages<$endrange>, Saving a Data Access Page

data access pages<$startrange>, Saving a Data Access Page

scalar user-defined functions<$endrange>, Figure 11.25: The visual designer for in-line functions lets you base a function on tables, views, or other table-returning...

scalar user-defined functions<$startrange>, Scalar User-Defined Functions

SchemaEnum enumeration, The OpenSchema Method, The OpenSchema Method

schemas, XSD<$endrange>, XSD Schemas

schemas, XSD<$startrange>, XSD Schemas

schemes of URLs, Recordsets, Records, Streams, and the Web

ScopeFolders collection (FileSearch object), FileSearch Object

Script Editor<$endrange>, Using the Microsoft Script Editor

Script Editor<$startrange>, Using the Microsoft Script Editor

Script objects, Table 8.1: Shared Office Objects

Scroll Bars property (forms), Creating a Splash Screen

searching for files<$endrange>, Empowering Users to Create and Open Files from the Task Pane

searching for files<$startrange>, FileSearch Object

searching for files\

basic file search<$endrange>, Generalizing a Search and Sorting Its Return Set

basic file search<$startrange>, Conducting a Basic File Search

copying files with FileSystemObject<$endrange>, A Utility for Copying Files Based on FileSystemObject

copying files with FileSystemObject<$startrange>, A Utility for Copying Files Based on FileSystemObject

file contents searches<$endrange>, Searching Based on File Contents

file contents searches<$startrange>, Searching Based on File Contents

generalized searches and return set sorting<$endrange>, Generalizing a Search and Sorting Its Return Set

generalized searches and return set sorting<$startrange>, Generalizing a Search and Sorting Its Return Set

multiple search criteria (advanced search)<$endrange>, Figure 8.5: The Access11Files Properties dialog box with the settings to implement read-only Simple File Sharing with Windows...

multiple search criteria (advanced search)<$startrange>, Specifying Multiple Search Criteria

within specified file types<$endrange>, Figure 8.4: You use the members of the MsoCondition enumeration group to specify conditions for advanced...

within specified file types<$startrange>, Controlling FileType with a Custom Form and Procedure

searching\

for recordsets[searching\

recordsets]<$endrange>, Seeking Records

recordsets]<$startrange>, Finding Records

recordsets], Selected Recordset Methods

SearchSubFolders property (FileSearch object), Conducting a Basic File Search, Searching Based on File Contents

sections in reports<$endrange>, Report Sections

sections in reports<$startrange>, Report Sections

security<$endrange>, Summary

security<$startrange>, Chapte 10: Database Security, Overview of SQL Server Database Security Concepts

security\

Access 11 innovations, Access 2003 Security Innovations

Access 2003 innovations\

alternatives to user-level security, Securing Files Without User-Level Security

authentication. <charcntd>See <Default Para Font>authentication<$nopage>, Connecting to Non-Jet Databases

authentication<$endrange>, Roles

authentication<$startrange>, Authentication

authentication\

Excel macros, Working with Values from Excel Worksheets

exporting/importing XML documents, Importing XML Documents

creating with T-SQL<$endrange>, Creating Login and User Accounts with T-SQL

creating with T-SQL<$startrange>, Creating Login and User Accounts with T-SQL

creating with SQL-DMO<$endrange>, Testing User Accounts

dynamic permissions with user accounts<$startrange>, Dynamically Adding Permissions to a User Account

dynamic permissions<$startrange>, Dynamically Adding Permissions to a User Account

selective object permissions<$startrange>, Selectively Applying Object Permissions

selective object permissions<$endrange>, Selectively Applying Object Permissions

T-SQL role help<$startrange>, T-SQL Help for Roles

T-SQL role help<$endrange>, T-SQL Help for Roles

testing user accounts<$startrange>, Testing User Accounts

testing user accounts<$endrange>, Figure 13.4: The Immediate window showing the users in the Northwind database after adding the Access11User and then removing...

macro security<$endrange>, What Are Digital Signatures and How Do I Use Them?

macro security<$startrange>, Macro Security

password security<$endrange>, Setting a Module Password

password security<$startrange>, Setting a Database Password Manually

password security\

permissions<$endrange>, Managing Permissions

permissions<$startrange>, Managing Permissions

roles and permissions<$startrange>, Programming Roles and Permissions

roles and permissions\

roles<$endrange>, Roles

roles<$startrange>, Roles

roles and permissions\

Simple File Sharing capabilities, Empowering Users to Create and Open Files from the Task Pane

SQL Server\

SQL-DMO programming<$endrange>, Attaching and Detaching Multiple Files

SQL-DMO programming<$startrange>, SQL-DMO Programming

SQL-DMO programming\

user-level security<$endrange>, Figure 10.9: Form1 from Chapter10.mdb illustrates operational features of the Jet SandBox.

user-level security<$startrange>, Overview of User-Level Security

user-level security\

ADOX for<$endrange>, Jet SQL Statements and Keywords for User-Level Security

ADOX for<$startrange>, User-Level Security via ADOX

attaching/detaching database files<$endrange>, Attaching and Detaching Multiple Files

attaching/detaching database files<$startrange>, Attaching and Detaching Database Files

copying table designs between databases<$startrange>, Copying a Table's Design from One Database to Another

copying table designs between databases<$endrange>, Setting Up the SQL Server Security Demonstrations

creating with SQL-DMO<$startrange>, Creating Login and User Accounts with SQL-DMO

demonstrations, setting up, Setting Up the SQL Server Security Demonstrations

ensuring secure login and enumerating databases<$startrange>, Ensuring Secure Login and Enumerating Databases

ensuring secure login<$startrange>, Ensuring Secure Login and Enumerating Databases

ensuring secure login<$endrange>, Setting Mixed Authentication

ensuring secure login and enumerating databases<$endrange>, Setting Mixed Authentication

Jet SandBox<$endrange>, How Do You Disable and Enable the Jet SandBox?

Jet SandBox<$startrange>, Jet SandBox

Jet SQL and ADO for<$endrange>, Figure 10.9: Form1 from Chapter10.mdb illustrates operational features of the Jet SandBox.

Jet SQL and ADO for<$startrange>, User-Level Security via Jet SQL and ADO

mixed authentication, setting<$startrange>, Setting Mixed Authentication

mixed authentication, setting<$endrange>, Figure 13.3: An Access form that lets a user browse selected database objects on the local SQL server., Figure 13.3: An Access form that lets a user browse selected database objects on the local SQL server.

object navigator, building<$startrange>, Building a SQL Server Object Navigator

object navigator, building<$endrange>, Copying a Table's Design from One Database to Another

permissions settings, effects of<$endrange>, Demonstrating the Effects of Permission Settings

permissions settings, effects of<$startrange>, Demonstrating the Effects of Permission Settings

Admin user account, Step 1 Create Workgroup and Administrator and Force Logon

instituting, three-step process<$endrange>, Step 3 Create Other Users with Different Permissions

instituting, three-step process<$startrange>, Three-Step Process for Instituting User-Level Security

defined, What Is User-Level Security?

securityadmin role, Roles

Seek method, Selected Recordset Properties

Seek method (Recordset object)<$endrange>, Seeking Records

Seek method (Recordset object)<$startrange>, Seeking Records

SeekEnum enumeration, Seeking Records

SeekingUnShippedOrders( ) (example), Seeking Records

SeekWith2IndexValues( ) (example), Seeking Records

select queries<$endrange>, Creating a Recordset with a Select Query, Selecting with Unions

select queries<$startrange>, Creating a Recordset with a Select Query, Jet SQL Syntax for Select Queries

select queries\

adding and removing<$endrange>, Creating and Using Parameter Queries

adding and removing<$startrange>, Adding and Removing Queries

aggregated fields<$endrange>, Right Outer Joins

aggregated fields<$startrange>, Using Aggregates with GROUP BY and HAVING Clauses

basic queries<$endrange>, Basic Select Queries

basic queries<$startrange>, Basic Select Queries

calculated fields<$endrange>, Figure 4.3: Output of the SelectGroupBy procedure demonstrates the effect of a GROUP BY...

calculated fields<$startrange>, Selecting and Ordering with Calculated Fields

DISTINCT keyword<$endrange>, Table 4.2: Jet SQL SELECT Keyword Predicates

DISTINCT keyword<$startrange>, Selecting with the DISTINCT Keyword

inner joins<$endrange>, Right Outer Joins

inner joins<$startrange>, Selecting with Inner Joins

lookup forms<$startrange>, Looking Up and Displaying Data

lookup forms\

charting data subsets<$startrange>, Charting a Subset of Data

dynamic information display, Dynamically Displaying Information

interactivity with parameter queries and ADO<$endrange>, Figure 5.23: These forms let the user see monthly sales data for a selected year.

interactivity with parameter queries and ADO<$startrange>, User Interactivity Based on Parameter Queries and ADO

results displayed in list box<$endrange>, Figure 5.23: These forms let the user see monthly sales data for a selected year.

results displayed in list box<$startrange>, Displaying Returned Rows Via a List Box

results displayed in message box<$endrange>, Displaying Results in a Message Box, Figure 5.22: A form to display customer orders in the List Box control.

results displayed in message box<$startrange>, Displaying Results in a Message Box, Displaying Returned Rows via a Message Box

outer and self joins<$endrange>, Selecting with Subqueries

outer and self joins<$startrange>, Selecting with Outer Joins and Self Joins

parameter queries<$endrange>, Creating and Using Parameter Queries

parameter queries<$startrange>, Creating and Using Parameter Queries

PivotCharts for<$endrange>, Adding a PivotChart View to a Custom Form

PivotCharts for<$startrange>, Adding a PivotChart View to a Custom Form

PivotTables for<$endrange>, Figure 7.7: An updated excerpt from our sample PivotTable that shows summary data for the Quantity...

PivotTables for<$startrange>, Constructing a PivotTable for a Query

selecting fields<$endrange>, Table 4.1: Correspondence of Access and ADO Wildcard Symbols

selecting fields<$startrange>, Selecting Fields from Every Record

subqueries<$endrange>, Selecting with Unions

subqueries<$startrange>, Selecting with Subqueries

unions<$endrange>, Selecting with Unions

unions<$startrange>, Selecting with Unions

wildcards in criteria expressions<$endrange>, Figure 4.2: The output on the left comes from the SelectNotDistinctOrderDetails procedure. The output...

wildcards in criteria expressions<$startrange>, Writing Criteria Expressions with Wildcards

SELECT statements, Basic Select Queries, SQL Server Views

SELECT statements\

DISTINCT keyword<$endrange>, Table 4.2: Jet SQL SELECT Keyword Predicates

DISTINCT keyword<$startrange>, Selecting with the DISTINCT Keyword

GROUP BY clause<$endrange>, Right Outer Joins

GROUP BY clause<$startrange>, Using Aggregates with GROUP BY and HAVING Clauses

HAVING clause, Using Aggregates with GROUP BY and HAVING Clauses

in-line user-defined functions<$endrange>, In-Line User-Defined Functions

in-line user-defined functions<$startrange>, In-Line User-Defined Functions

inner joins<$endrange>, Right Outer Joins

inner joins<$startrange>, Selecting with Inner Joins

inside SELECT statements (subqueries)<$endrange>, Selecting with Unions

inside SELECT statements (subqueries)<$startrange>, Selecting with Subqueries

object permissions, Managing Permissions

ORDERBY clause<$endrange>, Figure 4.3: Output of the SelectGroupBy procedure demonstrates the effect of a GROUP BY...

ORDERBY clause<$startrange>, Selecting and Ordering with Calculated Fields

outer and self joins<$endrange>, Selecting with Subqueries

outer and self joins<$startrange>, Selecting with Outer Joins and Self Joins

UNION keyword<$endrange>, Selecting with Unions

UNION keyword<$startrange>, Selecting with Unions

WHERE clause, Selecting Fields from Some Records

SelectAllFields( ) (example), Basic Select Queries

SelectCommand( ) (example), Creating a Recordset with a Select Query

SelectDistinctOrderDetails( ) (example), Selecting with the DISTINCT Keyword

SelectForDateCriterionAndDescendingOrder( ) (example), Selecting and Ordering with Calculated Fields

SelectGroupBy( ) (example), Using Aggregates with GROUP BY and HAVING Clauses

SelectGroupByWithHaving( ) (example), Using Aggregates with GROUP BY and HAVING Clauses

SelectInClauseParameters( ) (example)<$startrange>, Creating and Using Parameter Queries

SelectInClauseParameters( ) (example)<$endrange>, A Delete Parameter Query

SelectInsertDeleteAndUpdateWithNewUser2( ) (example), Granting and Revoking Permissions

SelectInsertDeleteAndUpdateWithNewUser2( ) (example), Putting It All Together

SelectNotDistinctOrderDetails( ) (example), Selecting with the DISTINCT Keyword

SelectRightOuterJoin( ) (example), Right Outer Joins

SelectSelfJoinForManagers( ) (example), Self Joins

SelectSelfJoinForMissed1998Dates( ) (example), Self Joins

SelectSomeFields( ) (example), Selecting Fields from Every Record

SelectSomeFieldsAndRows( ) (example), Selecting Fields from Some Records

SelectSortedUnion( ) (example), Selecting with Unions

SelectThreeTableUnion( ) (example), Selecting with Unions

SelectWhichInClause( ) (example), Selecting Fields from Some Records

SelectWithAggregatedFunctions( ) (example), Using Aggregates with GROUP BY and HAVING Clauses

SelectWithCalculatedField( ) (example), Selecting and Ordering with Calculated Fields

SelectWithCalculatedFieldAndOrderLastNames( ) (example), Selecting and Ordering with Calculated Fields

SelectWithMultiCharacterWildcard( ) (example), Writing Criteria Expressions with Wildcards

SelectWithPatternMatch( ) (example), Writing Criteria Expressions with Wildcards

SelectWithPatternMatch2( ) (example), Writing Criteria Expressions with Wildcards

SelectWithSingleCharacterWildcard( ) (example), Writing Criteria Expressions with Wildcards

self joins, Selecting with Outer Joins and Self Joins

self joins<$endrange>, Selecting with Subqueries

self joins<$startrange>, Self Joins

Send method (Outlook mail items), Merging Access Contacts with an Outlook Message

SendSnapshots( ) (example)<$startrange>, Mailing Snapshots

SendSnapshots( ) (example)<$endrange>, Mailing Snapshots

server filters for forms, programming<$endrange>, Sorting on Any Field in Any Direction

server filters for forms, programming<$startrange>, Programming Form Server Filters

server identifiers, What's a SQL Server Identifier?

server part of URLs, Recordsets, Records, Streams, and the Web

ServerFilter property (hyperlinks), Opening and Filtering Forms with Links

service providers, OLE DB Providers and ADO Object Model Summary

SetAllTablePermissionsForGroup( ) (example), Putting It All Together

SetData method (PivotCharts)<$endrange>, Adding a PivotChart View to a Custom Form

SetData method (PivotCharts)<$startrange>, Adding a PivotChart View to a Custom Form

SetPermissions method (Group, User object)<$endrange>, Setting Permissions

SetPermissions method (Group, User object)<$startrange>, Setting Permissions

SetRIDTablePermissionsForGroupTable( ) (example), Putting It All Together

SetStartAndStop( ) (example), Creating a Table with Custom AutoNumber Settings

ShowDemoMessages( ) (example), Enumerating Items in the Contacts Folder

ShowStreamForRecord( ) (example), Retrieving Data from Web Files

ShowWebBar( ) (example), Making Invisible Command Bars Visible

Simple File Sharing, A Utility for Copying Files Based on FileSystemObject

SizeMode property (forms), Creating a Splash Screen

Smalldatetime data type (SQL server), Table 11.3: SQL Server Column Data Types

Smallint data type (SQL server), Table 11.3: SQL Server Column Data Types

Smallmoney data type (SQL server), Table 11.3: SQL Server Column Data Types

snapshots for distributing reports<$endrange>, Other Uses for Snapshots

snapshots for distributing reports<$startrange>, Distributing Reports Using Snapshots

snapshots for distributing reports\

mailing<$startrange>, Mailing Snapshots

viewing<$endrange>, Figure 6.24: One Print event procedure for this report draws rectangles around the Report Header and...

viewing<$startrange>, Viewing a Snapshot

Sort property (Recordset object), Selected Recordset Properties

Sort property (Recordset object)<$endrange>, Figure 1.8: The Object Browser showing a selection of data type constants for defining fields.

Sort property (Recordset object)<$startrange>, Sorting Recordsets

SortCustomersDefaultCityUpDown( ) (example)<$endrange>, Figure 1.7: Program output from the SortedTableTypes procedure, showing a list of tables sorted by...

SortCustomersDefaultCityUpDown( ) (example)<$startrange>, Sorting Recordsets

SortedTableTypes( ) (example), Sorting Recordsets

sorting recordsets, Selected Recordset Properties

sorting recordsets<$endrange>, Figure 1.8: The Object Browser showing a selection of data type constants for defining fields.

sorting recordsets<$startrange>, Sorting Recordsets

sorting recordsets\

Access project reports<$endrange>, Sorting on Any Field in Any Direction

Access project reports<$startrange>, Sorting on Any Field in Any Direction

stored procedure results<$endrange>, Figure 11.22: The output to the Immediate window for the InOutReturnDemo VBA procedure.

stored procedure results<$startrange>, Sorting Result Sets

sorting\

file search results<$endrange>, Generalizing a Search and Sorting Its Return Set

file search results<$startrange>, Generalizing a Search and Sorting Its Return Set

reports data\

by date<$endrange>, Sorting and Grouping by Date

by date<$startrange>, Sorting and Grouping by Date

string data<$endrange>, Sorting and Grouping String Data

string data<$startrange>, Sorting and Grouping String Data

Source property (Recordset objects), Using an ADO Recordset as the Report's Record Source

Sourceproperty (Error object), Error Object Properties

sp_dbfixedrolepermission procedure, T-SQL Help for Roles

sp_helpdbfixedrole procedure, T-SQL Help for Roles

sp_helpsrvrole procedure, T-SQL Help for Roles

sp_srvrolepermission procedure, Managing Permissions, T-SQL Help for Roles

special characters, XML, XML Document Syntax

splash screens<$endrange>, Automatically Publishing a Datasheet to a Web Site

splash screens<$startrange>, Splash Screen Forms

spreadsheets<$endrange>, Office Spreadsheet Sample

spreadsheets<$startrange>, Office Spreadsheet Sample

SQL Server, Chapte 11: Using Access to Build SQL Server Solutions: Part I

SQL Server databases\

connecting to (example)<$endrange>, Connecting to Non-Jet Databases

connecting to (example)<$startrange>, Connecting to Non-Jet Databases

SQL Server\

Access projects<$endrange>, Installing and Using MSDE 2000

Access projects<$startrange>, Access Projects and SQL Server Versions

Access projects\

Access user interfaces for<$endrange>, The Access UI for Stored Procedures

Access user interfaces for<$startrange>, The Access UI for Stored Procedures

adding tables from database diagrams<$endrange>, Linking Two Tables in a Database Diagram

adding tables from database diagrams<$startrange>, Adding a Table from a Database Diagram

additional educational resources<$endrange>, Working with the Pubs Database

additional educational resources<$startrange>, Books Online and Other SQL Server Learning Resources

aggregating records in<$endrange>, Converting Dates and Times to Different Formats

aggregating records in<$startrange>, Aggregating Records in a View

archiving updated and deleted records<$endrange>, Figure 11.24: A message box generated by the ComputePercentChangeBetweenYears stored procedure when...

archiving updated and deleted records<$startrange>, Archiving Updated and Deleted Records

attaching/detaching database files<$endrange>, Attaching and Detaching Multiple Files

attaching/detaching database files<$startrange>, Attaching and Detaching Database Files

basic concepts<$endrange>, Managing Permissions

basic concepts<$startrange>, Overview of SQL Server Database Security Concepts

changing tables with<$endrange>, Figure 11.24: A message box generated by the ComputePercentChangeBetweenYears stored procedure when...

changing tables with<$startrange>, Programmatically Changing a Table with a Trigger

column data types<$endrange>, Mapping SQL Server to Access and ADO Data Types

column data types<$startrange>, SQL Server Column Data Types

conditional combo boxes<$endrange>, Figure 12.11: Column values containing hyperlink data from the CreateLinksTable procedure.

conditional combo boxes<$startrange>, Programming Conditional Combo Boxes

converting date and time formats<$endrange>, Figure 11.17: The output from the time conversion sample.

converting date and time formats<$startrange>, Converting Dates and Times to Different Formats

copying table designs between databases<$startrange>, Copying a Table's Design from One Database to Another

creating and opening<$endrange>, Adapting Books Online Code for the SQL Pane

creating and opening<$startrange>, Creating and Opening Access Projects

architecture of<$endrange>, Access Project Architecture

architecture of<$startrange>, Access Project Architecture

authentication, Connecting to Non-Jet Databases

data access page source, Using a SQL Server Database for the Data Source of a Data Access Page

forms from one-click tables<$endrange>, Another Main/Subform Example

forms from one-click tables<$startrange>, Creating a Form Based on a Table with One Click

secure programming\

server identifiers, What's a SQL Server Identifier?

SQL-DMO programming<$endrange>, Attaching and Detaching Multiple Files

SQL-DMO programming<$startrange>, SQL-DMO Programming

SQL-DMO programming\

stored procedures<$endrange>, Creating and Using Triggers from the Access UI

stored procedures<$startrange>, Creating and Using Stored Procedures

stored procedures\

creating and using<$endrange>, Creating and Using Triggers from the Access UI

creating and using<$startrange>, Creating and Using Triggers from the Access UI

creating login and user accounts<$startrange>, Creating Login and User Accounts with SQL-DMO

demonstrations, setting up, Setting Up the SQL Server Security Demonstrations

ensuring secure login and enumerating databases<$startrange>, Ensuring Secure Login and Enumerating Databases

event procedures with<$endrange>, Figure 12.9: A combo box that's conditional upon another and opens a second form.

event procedures with<$startrange>, Programming a Combo Box with an Event Procedure

form server filters, programming<$endrange>, Sorting on Any Field in Any Direction

form server filters, programming<$startrange>, Programming Form Server Filters

hyperlink processing<$endrange>, Processing Hyperlinks in an Access Project Form

hyperlink processing<$startrange>, Processing Hyperlinks in an Access Project Form

in-line<$endrange>, In-Line User-Defined Functions

in-line<$startrange>, In-Line User-Defined Functions

manual creation, fixing<$endrange>, Figure 11.24: A message box generated by the ComputePercentChangeBetweenYears stored procedure when...

manual creation, fixing<$startrange>, Problem and Fix for Manual Trigger Creation

mixed authentication, setting<$startrange>, Setting Mixed Authentication

multistatement<$startrange>, Multistatement User-Defined Functions

object navigator, building<$startrange>, Building a SQL Server Object Navigator

parameters and return values, managing<$endrange>, Managing Input Parameters, Output Parameters, and Return Values

parameters and return values, managing<$startrange>, Managing Input Parameters, Output Parameters, and Return Values

parameters, specifying<$endrange>, Figure 11.21: A comparison of two Design views that sort records: one for a view, and one for a stored procedure.

record manipulation<$endrange>, Creating and Using Triggers from the Access UI

record manipulation<$startrange>, Inserting, Updating, and Deleting Records

RecordsetType property, specifying<$endrange>, Figure 12.11: Column values containing hyperlink data from the CreateLinksTable procedure.

RecordsetType property, specifying<$startrange>, Specifying a Form's RecordsetType Property in Access Projects

reports programming<$startrange>, Programming Reports in Access Projects

roles and permissions<$startrange>, Programming Roles and Permissions

scalar<$endrange>, Figure 11.25: The visual designer for in-line functions lets you base a function on tables, views, or other table-returning...

scalar<$startrange>, Scalar User-Defined Functions

sorting result sets<$endrange>, Figure 11.22: The output to the Immediate window for the InOutReturnDemo VBA procedure.

sorting result sets<$startrange>, Sorting Result Sets

parameters, specifying<$startrange>, Specifying Parameters in the Text-Based Designer

supported databases, Supported SQL Server Databases

tables and database diagrams<$endrange>, Figure 11.14: The three panes for the Access project Query Designer with a view that sorts orders by Freight...

tables and database diagrams<$startrange>, Tables and Database Diagrams

tables and database diagrams\

filtering table data by date<$endrange>, Filtering by Date

filtering table data by date<$startrange>, Filtering by Date

joining tables for lookups<$endrange>, Converting Dates and Times to Different Formats

joining tables for lookups<$startrange>, Joining Tables for a Lookup

LIKE operator with datetime values<$endrange>, Using the LIKE Operator with datetime Column Values

LIKE operator with datetime values<$startrange>, Using the LIKE Operator with datetime Column Values

linking tables in database diagrams<$endrange>, Figure 11.14: The three panes for the Access project Query Designer with a view that sorts orders by Freight...

linking tables in database diagrams<$startrange>, Linking Two Tables in a Database Diagram

defining tables and inserting rows<$endrange>, Figure 11.12: The Properties dialog box for the OrderID column that shows the setting for the Identity,...

defining tables and inserting rows<$startrange>, Defining Tables and Inserting Rows

triggers<$endrange>, Figure 11.24: A message box generated by the ComputePercentChangeBetweenYears stored procedure when...

triggers<$startrange>, Triggers

triggers\

unbound combo boxes on forms<$endrange>, Figure 12.11: Column values containing hyperlink data from the CreateLinksTable procedure.

unbound combo boxes on forms<$startrange>, Creating Unbound Combo Boxes on Forms

unbound combo boxes on forms\

user-defined functions<$startrange>, User-Defined Functions

user-defined functions\

views<$endrange>, Figure 11.17: The output from the time conversion sample.

views<$startrange>, SQL Server Views

views\

SQL statements as form source<$endrange>, Processing Main/Subforms

SQL statements as form source<$startrange>, Assigning a SQL Statement as the Source

Sql_variant data type (SQL server), Table 11.3: SQL Server Column Data Types

SQL Server\

SQL-DMO programming\

copying table designs between databases<$endrange>, Setting Up the SQL Server Security Demonstrations

creating login and user accounts<$endrange>, Testing User Accounts

object navigator, building<$endrange>, Copying a Table's Design from One Database to Another

mixed authentication, setting<$endrange>, Figure 13.3: An Access form that lets a user browse selected database objects on the local SQL server.

ensuring secure login and enumerating databases<$endrange>, Setting Mixed Authentication

SQLState property (Error object), Error Object Properties

startup account, Login and User Accounts

startup, custom\

.adp files<$endrange>, FileSearch Object

.adp files<$startrange>, Building a Custom Startup in an .adp File

.mdb files<$endrange>, Figure 8.2: The FileSearch object is one of the shared Office objects.

.mdb files<$startrange>, Building a Custom Startup in an .mdb File

security possibilities, Using a Custom Interface

StartupShowDBWindow property (CurrentDB object), Building a Custom Startup in an .mdb File

statement permissions, Managing Permissions

static cursors, recordset, Selected Recordset Properties

stored action queries<$endrange>, Creating a Table with Custom AutoNumber Settings

stored action queries<$startrange>, Creating and Running Action Queries with ADOX

stored action queries\

delete parameter queries<$endrange>, Creating a Table with Custom AutoNumber Settings

delete parameter queries<$startrange>, A Delete Parameter Query

insert parameter queries<$endrange>, An Insert Parameter Query

insert parameter queries<$startrange>, An Insert Parameter Query

update parameter queries<$endrange>, Creating a Table with Custom AutoNumber Settings

update parameter queries<$startrange>, An Update Parameter Query

stored procedures<$endrange>, Creating and Using Triggers from the Access UI

stored procedures<$startrange>, Creating and Using Stored Procedures

stored procedures\

<charcntd>See also <Default Para Font>triggers<$nopage>, Triggers

Access user interfaces for<$endrange>, The Access UI for Stored Procedures

Access user interfaces for<$startrange>, The Access UI for Stored Procedures

LIKE operator with datetime values<$endrange>, Using the LIKE Operator with datetime Column Values

LIKE operator with datetime values<$startrange>, Using the LIKE Operator with datetime Column Values

parameters and return values, managing<$endrange>, Managing Input Parameters, Output Parameters, and Return Values

parameters and return values, managing<$startrange>, Managing Input Parameters, Output Parameters, and Return Values

parameters, specifying<$endrange>, Figure 11.21: A comparison of two Design views that sort records: one for a view, and one for a stored procedure.

parameters, specifying<$startrange>, Specifying Parameters in the Text-Based Designer

record manipulation<$endrange>, Creating and Using Triggers from the Access UI

record manipulation<$startrange>, Inserting, Updating, and Deleting Records

sorting result sets<$endrange>, Figure 11.22: The output to the Immediate window for the InOutReturnDemo VBA procedure.

sorting result sets<$startrange>, Sorting Result Sets

Stream objects, Recordsets, Records, Streams, and the Web, Recordsets, Records, Streams, and the Web

Stream objects\

Chatset property, Retrieving Data from Web Files

EOS property, Retrieving Data from Web Files

Open method, Retrieving Data from Web Files

Read method, Recordsets, Records, Streams, and the Web

reading text files<$endrange>, Saving To and Recovering From Streams

reading text files<$startrange>, Reading Text Files with Streams

ReadText method, Recordsets, Records, Streams, and the Web, Saving To and Recovering From Streams

streams, Recordsets, Records, Streams, and the Web, Recordsets, Records, Streams, and the Web

streams\

reading text files<$endrange>, Saving To and Recovering From Streams

reading text files<$startrange>, Reading Text Files with Streams

string data in reports, sorting/grouping<$endrange>, Sorting and Grouping String Data

string data in reports, sorting/grouping<$startrange>, Sorting and Grouping String Data

sub- and main forms<$endrange>, Summing Subform Control Values on a Main Form

sub- and main forms<$startrange>, Processing Main/Subforms

sub- and main forms\

controls formatting<$endrange>, Figure 5.17: A form that performs a simple lookup operation.

controls formatting<$startrange>, Formatting Controls on Main and Subforms

controls formatting\

conditional formatting<$endrange>, Figure 5.17: A form that performs a simple lookup operation.

conditional formatting<$startrange>, Conditional Formatting

controls programming<$endrange>, Programming a Subform's Subdatasheet Controls

controls programming<$startrange>, Programmatically Referencing Main and Subform Controls

creating and specifying sources<$endrange>, Creating Main/Subforms

creating and specifying sources<$startrange>, Creating Main/Subforms

inserting data into subform records<$endrange>, Figure 5.12: The frmMyOrdersSubtotal form presents the total extended price for the line items appearing...

inserting data into subform records<$startrange>, Programmatically Inserting Data into a Subform Record

referencing subforms fields from main forms<$startrange>, Referencing Subform Fields from a Main Form

subdatasheets<$endrange>, Subdatasheets, Programming a Subform's Subdatasheet Controls

subdatasheets<$startrange>, Subdatasheets, Programming a Subform's Subdatasheet Controls

summing subform control values<$endrange>, Summing Subform Control Values on a Main Form

summing subform control values<$startrange>, Summing Subform Control Values on a Main Form

with bound images, Creating a Main/Subform with a Bound Image

SubdatasheetExpanded property (forms), Programming a Subform's Subdatasheet Controls

subqueries<$endrange>, Selecting with Unions

subqueries<$startrange>, Selecting with Subqueries

subreports<$endrange>, Graphing Child Data in a Main/Subreport Design

subreports<$startrange>, Hierarchical Reports with Groups, Subreports, and Charts

SUM function (SQL), Using Aggregates with GROUP BY and HAVING Clauses

SummarizeFixedDBRoles( ) (example), T-SQL Help for Roles

SummarizeFixedServerRoles( ) (example), T-SQL Help for Roles

summarizing data with PivotTables. <charcntd>See <Default Para Font>PivotTables<$nopage>, Chapter 7: Designing and Using PivotTables and PivotCharts

SummaryInfo objects, Printing Access DocumentProperty Object Information

summing report page values<$endrange>, Summing Page Values

summing report page values<$startrange>, Summing Page Values

switchboard forms<$endrange>, Figure 5.7: A sample On Click event setting that lets a hyperlink execute a function procedure even though the form on which...

switchboard forms<$startrange>, Switchboard Forms

switchboard forms\

code behind forms<$endrange>, Figure 5.7: A sample On Click event setting that lets a hyperlink execute a function procedure even though the form on which...

code behind forms<$startrange>, Navigating with Code Behind Form

hyperlink navigation<$endrange>, Navigating with Hyperlinks

hyperlink navigation<$startrange>, Navigating with Hyperlinks

SyntaxForSubDatasheetOnSubForm( ) (example), Programming a Subform's Subdatasheet Controls

SyntaxForSubForms( ) (example)<$startrange>, Programmatically Referencing Main and Subform Controls

SyntaxForSubForms( ) (example)<$endrange>, Programming a Subform's Subdatasheet Controls

sysadmin role, Roles

Systems Adminstrator account, Login and User Accounts