Index_S

S

Save, 418–419

scope, 174

Script object, 302

searching, 136–137

security

and Access 2003, 294–298

assigning passwords, 290

assigning permissions, 291

changing users programmatically, 291–294

compiling to an .mde file, 287–288

creating an administrator, 289–290

creating passwords programmatically, 285–286

digital certificates, 296–298

digital signatures, 295–298

Jet Sandbox, 294–295

Macro Security, 295–298

password-protecting the VBA code, 287

setting passwords, 284–285

turning off the Access user interface, 284

user-level, 288–294

Select Case structure, 97–98

SELECT keyword, 154–155

SelectObject, 419–420

SendObject, 420–422

sentinel-controlled repetition, 98

sequence structures, 92

SetMenuItem, 422

SetWarnings, 422–423

shared objects, 302

CommandBar object, 304–307

FileSearch object, 302–304

sharing databases, 349–350

shortcut menus, 48

customizing, 55–56

See also menus

ShowAllRecords, 423

ShowToolbar, 423–424

software development process

definition and analysis of requirements, 14–16

development of the design, 17–23

documentation, 24–25

evaluation of requirements, 16–17

implementation and testing, 23–24

maintenance, 25

steps, 14

splitting databases, 358–362

SQL, 30, 153

concatenation, 161

INNER JOIN keyword, 156–157

ORDER BY keyword, 156

output, 161–163

Query grid, 154

SELECT keyword, 154–155

SQL View, 153, 154

and VBA, 157–160

WHERE keyword, 155

SQL Server, 333–334

features, 334

Microsoft Access vs., 334

migrating Access to, 17

Service Manager, 336

stored procedures, 342–344

See also Access Data Projects

SSW Upsizing Pro, 337

startup properties, 269–272

static arrays, 105–107

See also dynamic arrays

static variables, 176

stored procedures, 342–344

Structured Query Language. See SQL

Sub keyword, 137–138

sub procedures, 65–66, 125, 165

declaring, 166

vs. functions, 201–202

See also procedures

submenus, 47, 266–267

See also menus

subs. See sub procedures

Switchboard Manager, 41–45

system architecture, 28–29