1332
Index
SQL (Structured Query Language). See also queries.
* (asterisk), wildcard character, 477
[ ] (square brackets), around field names, 476–477
filtering selections, 475
overview, 473–474
selecting fields, 475, 476–477, 484
sorting selections, 475, 484
specifying tables, 475, 480–484
SQL keywords
FROM, 475
case sensitivity, 476
ORDER BY clause, 475
SELECT, 475, 476–477
summary of, 475. See also specific keywords.
WHERE clause, 475
SQL pass-through, network applications, 755
SQL predicates
ALL, 478
FROM clause, 480–484
definition, 478
DISTINCT, 478–479
DISTINCTROW, 479–480
INNER JOIN...ON expression, 480–484
LEFT JOIN...ON expression, 480–484
ORDER BY clause, 484
RIGHT JOIN...ON expression, 480–484
TOP, 480
WHERE clause, 484
SQL queries, viewing, 474–475. See also queries.
SQL Server
naming conventions, 1211
overview, 1199–1200
SQL Server, connecting to
from Access, 1203–1214
connection strings, 1201–1203
creating a data source, 1204
DSN, setting up, 1205–1211
File DSN, 1204
linking to tables, 1211–1214
ODBC configuration options, 1204
System DSN, 1204
User DSN, 1204
SQL Server Compatible option, 650
SQL Server Express
downloading, 1200
overview, 1224–1225
specifications, 1250–1251spaces
displaying as characters, 60
filling, 60
in names, 40, 423
in path names, 1093
in search criteria, 196
in VBA event names, 455
in VBA variable names, 423
specialized queries, 133
specifications
Access databases, 1247
building to, 900–902
forms, 1248–1249
macros, 1249
queries, 1248
reports, 1248–1249
SQL Server Express, 1250–1251
tables, 1247–1248
specifying tables, 475
splash screens
contents, 1096
designing, 1095–1097
effects on perceived speed, 867–868
user considerations, 911–912
Split Form button, 261–262
Split Form command, 253
Split Form Datasheet property, 309
Split Form Orientation property, 309
Split Form Printing property, 309
Split Form Size property, 309
Split Form Splitter Bar property, 309
split forms, 261–262
SplitButton controls, 1013–1014, 1041–1042
Splitter Bar, 309
splitting
code windows, 393
VBA statements, 419
splitting databases
benefits of, 759–761
versus client/server architecture, 1193
Database Splitter wizard, 762–764
definition, 753
placing objects, 761–762
spreadsheets. See also flat-file databases.
aggregate functions, 247–248
versus databases, 92–94. See also flat-file databases.
importing from, 614–61852_475348-bindex.indd 133252_475348-bindex.indd 1332 4/1/10 2:02 PM4/1/10 2:02 PM