Index

P

parameters, 169–171

named, 172–173

optional, 171–172

passing parameters, 169

passwords

ALTER DATABASE PASSWORD, 285–286

assigning, 290

creating programmatically, 285–286

protecting the VBA code, 287

setting, 284–285

permissions, assigning, 291

personal DBMS, 28

Pmt( ) function, 212–214

predefined templates, 40–41

prefixes

object-identifying, 39

variable, 88

Preserve keyword, 110

PrintOut, 412–413

procedures, 65–66

creating, 83–90

declaring, 165–167

procedure calls, 96

starting a new procedure in the VBA editor, 137–138

sub procedures, 65–66

using to change a database structure, 176–180

See also functions; sub procedures

Project Explorer, 72, 114, 118–119

Project window, 9–10

properties, 140

pseudocode, 16