Save Changes button, 337
Save event, 116, 120
Save procedure
adding to clsCustomer class module, 488
adding to clsProjects class module, 366, 371, 378–379, 383
SaveAllRecords procedure, 144, 147, 152, 155
SaveCurrentRecord procedure, 147, 154–155, 168, 174
scaling up a database server, 14
SchemaTarget parameter, 209
scope
of an Activity Diagram, 7
defined, 45
global, 74
of a procedure, 45
of a variable, 54
Screen object, 98
screen prototypes, 8–11
SDLC (Systems Development Life Cycle), 3
Search Inventory Screen
Activity Diagram for, 8, 9
designing for Wrox Auto Sales, 5
mapping Use Cases to, 10–11
prototype for, 11
separate actions on, 5, 6
Use Case Diagram requirements, 8
search results, clearing, 503–504
Search Results screen, 515, 516
securing applications, 327–329
security information, specifying, 278, 279
security model, 3
Select clause, 160
Select statements, 160–164
Select…Case statements, 59–61, 60–61
Send method, 305
SendObject method, 210–211
separation of tiers concept, 103–104
server cursors, 134
server machine, 13
Server parameter, 204
services, installed with SQL Server 2005 Express Edition, 257–259
Set statement, 115
SharePoint data types, 221
SharePoint DSN, 229, 230–231
SharePoint hosting, 222
SharePoint lists
importing, 222–226
introduction to, 221–222
linking to, 225–232
types of, 221
using data from, 222–232
SHELLEXECUTE, external DLL function call to, 456, 457
ShellExecute external function, 384, 400
Shift key, selecting multiple controls to align, 197
Single data type, 50
Single line of text data type, 221
single-tier applications, 12–13
SiteAddress parameter, 226
sng (Single) prefix, 55
sort order, 161–162
Sort property, 156–157
source argument, 134
Source parameter, 201
SourceObject property of a subform, 194
SourceTableName property, 229, 231
SpecialFeaturesList enumerated type, 122, 123
SpecificationName parameter, 206
spInsertCustomer stored procedure, 469–470
splash screen, 325
Split Database button, 320
spreadsheets, importing, linking, and exporting, 204–205
SpreadsheetType parameter, 205
spRetrievalAllCustomers stored procedure, 470, 471
spRetrieveCustomerHistory stored procedure, 471–472
spRetrievePlans stored procedure, 472
spRetrieveSelectedCustomer stored procedure, 473
spUpdateCustomer stored procedure, 473–474, 517
SQL (Structured Query Language)
introduction to, 159–164
syntax of, 159–160
SQL code
adding, 470
for a stored procedure, 268
SQL Insert statements, 164–165
SQL queries, 324
SQL Server
Access as a front end to, 132
Access Projects as a front end to, 253–254
built-in functions, 275–277
setting up, 254–259
stored procedures, 267–271
versions of, 255
views, 271–274
SQL Server Browser Service, 259
SQL Server Configuration Manager, 257–258
SQL Server database
linking to, 253
modifying strConnection string to point to, 492–493
specifying, 466
specifying details necessary to connect to, 260, 261
transferring a complete, 203–204
using a new, 262–263
using an existing, 260–262
SQL Server Mobile Edition, 255
SQL Server objects, 264–277
SQL Server Service, 259
SQL Server storage engine, 259
SQL Server tables, 264–267
SQL Server 2005 Developer Edition, 255
SQL Server 2005 Enterprise Edition, 255
SQL Server 2005 Evaluation Edition, 255
SQL Server 2005 Express Edition, 255–259
SQL Server 2005 Standard Edition, 255
SQL Server 2005 Workgroup Edition, 255
SQL statements
adding procedures for creating, 391–393, 406–408
with and without ADO, 160
building dynamic, 512
deleting data using, 165–166
dialects of, 159
inserting current values on a form, 168, 174–175
modifying the unbound contacts form, 166–176
as a report’s RecordSource property, 241
running against a database, 167, 173
setting changes and removing passwords, 327–328
as the source for the Open method, 162
specifying the DataSource of a report, 236
for stored procedures, 269
updating an existing record, 168–169, 175
updating data using, 165
updating tables, 393–395, 406–407
viewing in Query Designer, 160
SQL View on the Design ribbon, 468, 469
standalone application, 13
standard DLLs, 287–291
standard modules
building for Project Tracker, 383–409
for the Customer Service application, 488–499
defined, 101
described, 29
Starting Point for an Activity Diagram, 7
static arrays, 51
static HTML pages, 249–251
Static keyword, 45, 54
Step Into option, 66
Step Over option, 66
storage engine for SQL Server, 259
stored procedures
adding to the Customer Service application, 467
calling, 269
creating for SQL Server, 269–271
described for SQL Server, 267
running, 269, 271
StoreLogin parameter, 201
str (String) prefix, 55
String data type, 50
string variable, 60
structure variable, declaring, 219
Structured Query Language. See SQL
StructureOnly parameter, 201
sub procedures
behind methods, 82–83
calling from events, 36
calling from other procedures, 35–36
creating and calling new, 33–35
defined, 33
scope and lifetime of, 45
Subform control, 194
subforms
described, 194
example of, 194, 195
minimizing the use of, 322
tying to a parent form, 194
subqueries, 162
switchboard forms, 182–187
syntax errors, 64, 65
system information, from an external DLL, 292–294
SYSTEM_INFO type declaration, 293
Systems Development Life Cycle. See SDLC