S

Sample database(s), 32 installing, 7

in Northwind database, 6 Scenarios, use of looping structures and, 98 SearchForBook,148-149 Second function, 132 Secret Message program, 140-144 controls and properties of, 142 enhanced, 155-156, 157 Security, 8, 325 Security (Access), 336-346

activating logon procedures, 336-338 connecting to a workgroup, 342-344 enabling user-level security, 338-342 securing from data access pages, 344-346 Select Case structure, 67, 72-74, 76, 95, 98, 114, 204 SELECT command, 216 SELECT statements, 216-218, 236 Self-documenting code, 278 Semicolon (;)

columns/column data separated by, 110, 111, 118 after SQL statement, 217

Sequential access modes, 200 Sequential data reading from file, 200-201 writing to a file, 201-202 Sequential data file, opening, 199-200 Sequential file access, 199-200 Server-side cursors, 247 SET keyword, 232, 301 SetRecordset procedure, 252 Shortcuts, keyboard, 351-352 Show method, 311, 313 Simple SELECT statements, 216-218 Single data type, 112, 118 Single-dimension arrays, 158-160 Single quote(s) (') in comments, 41 around numeric data, 220

textual data in WHERE clause's expression in, 219 Smart Tags, with Access objects, 1 Sorting, in SQL, 225-227 Sort key, 226 Source property, 196

SQL (Structured Query Language), 26, 213, 215, 239 aggregate functions in, 222-225, 236 computed fields in, 221-222 conditions in, 218-221 grouping in, 227-228 joins in, 228-231

preferred syntax nomenclature for, 216 sorting in, 225-227 SQL expressions, conditional operators used in, 219 SQL queries specifying column names in, 218 for students query, 28 SQL Server databases, managing with Access projects, 2 SQL statements, 31

readability of, 216, 236 Standard modules, 154-157, 178 Startup dialog window changing startup forms in, 23 customizing startup properties with, 24 Startup forms, 23-24 Startup properties, customizing, 24 Statements, VBA, 40-41 Static keyword, 158, 178 Step keyword, 103 Stepping into code, 183 Stepping over, 183 Stopwatches, 130 StrComp function, 125-126, 144 Str function, 134

String array, initializing for For loop, 159 String-based functions, 121-129 common, 122 InStr, 128-129 LCase, 122-123 Left, 127-128 Len, 124 Mid, 128 Right, 126-127 StrComp, 125-126 UCase, 122 String data, string variables versus, 54 Strings, 52, 55

converting to numbers, 56 defined, 121 formatting, 137 String variables, string data versus, 54 Structured Query Language. See SQL Structures, 164, 178

Students database, group levels added to, 331-335

Students table, selecting for new query, 27

Subprocedures, 39, 149, 151, 163, 177, 284, 301

Subscript, 160

Sub statement, 151

Subtraction operator (-), 59

SUM function, 225, 236

Symbols

&, 41, 50, 54, 137 =, 44, 68, 219 [], 42, 43, 216, 218 ., 37, 43, 44 _, 41, 42 ', 41 +, 59 -, 59

!, 43, 44, 137 0, 138 #, 138 %, 138 \\, 138 <>, 68, 219 >, 68, 137, 219 <, 68, 137, 219 >=, 68, 219 <=, 68, 219 @, 137

common character codes, 349-350 date and time formats, 139

Syntax errors, 182, 210 System requirements, 2-3

0 0

Post a comment