Index

A

ABS (), 128

Access database, see Microsoft Access

Access project, see Microsoft Access project

Active Server Pages, see ASP

ADD, 202-203

ADO, 281, 295, 297

aggregate functions, 106, 112-115

creating join containing, 165-166

alias, 61, 80

creating, 80-81

ALL, 175, 185-186

ALTER COLUMN, 204-206

ALTER TABLE, 31, 45-47, 201-203

AND, 90-95

ANY, 175, 183-185

arithmetic operators, 106, 108-111

AS, 61, 81

ASC, 61, 69-70, 72

ASP, 276, 282-286

building page in, 286-289

integrating SQL script in, 275-277

attribute, 1, 7-8

AVG (), 112-113

B

BETWEEN, 90, 99-100

BINARY data type, 37

BIT data type, 37

button,

creating to prompt user, 239-243

viewing on form, 244-245

C

Cartesian product, 145, 163

CCUR (), 128-130

CHAR data type, 36

CHECK constraint, 40

using, 46-47

clause, 15, 18,

Get SQL for Microsoft Access, 2nd Edition now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial