Index

S

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