[SYMBOL][A][B][C][D][E][F][G][H][I][J][K][L][M][N][O][P][Q][R][S][T][U][V][W][X][Y][Z]Name propertycontrols 2nd named parameters 2nd 3rd namingconstants controlsconflicts databasesrules fieldscautions legal characters length menus objects 2nd 3rd 4th 5th 6th 7th DAOs 2nd Database window objects 2nd Jet object/collection prefixes 2nd object tag prefixes 2nd Reddick naming convention 2nd scope/lifetime prefixes variable data type tags 2nd queries tablesconventions variables 2nd 3rd changing 2nd Jet object/collection prefixes Private Public scope/lifetime prefixes variable data type tags 2nd naming conventionsconstants 2nd naming prefixesaction queries naming standardsavoiding bugs natural keys navigatingapplicationsforms formssetting properties navigation buttons (data access pages) Navigation Buttons propertyforms nested queriescalculated fields networkingclient/server applicationssuitability of Access 2nd 3rd 4th file servers versus client/serversperformance considerations 2nd networksapplicationsdesigning data locking 2nd linked tablesaccessing load reduction securityshare-level serversinstalling applications workstationsinstalling Access installing applications New command (Edit menu) New Data Access Page dialog box new databasescreating 2nd Database Wizard 2nd 3rd 4th from scratch 2nd new featuressubforms and subreports subforms/subreports undoing/redoing new features (Access 2003)accessibility 2nd conversion error logging 2nd data access pages 2nd forms 2nd international functionality PivotCharts PivotTables programming 2nd reports SharePoint Team Services 2nd XML support New Form dialog box New menu commandKey New menu commandsDWORD Value String Value New Object dialog box New Query dialog box New Report dialog box New User/Group dialog box NextRecord propertyreports 2nd 3rd No Data events NO INDEX keyword (ANSI-92 extensions) NoData eventreports 2nd non-equi joins (SQL) 2nd normal forms first 2nd second 2nd third 2nd normalization 2nd application developmentrules 2nd 3rd denormalization first normal form 2nd second normal form 2nd third normal form 2nd normalizingtables Not (query criteria operator) not equal to (<*)query criteria operator Not functiontoggling Boolean expressions Nothing valueobject variables NotInList eventcombo boxes 2nd controls 2nd Null (query criteria operator) null entriescompared to zero-length Null valueavoiding in strings Variant variables 2nd 3rd 4th 5th Null valuesconverting to zero examples 2nd primary keys null valuesqueries Null valuesquery results 2nd 3rd 4th null valuesvariables Number field type NumberOfBytesFree function numeric datasummarizing (Totals queries) 2nd 3rd 4th 5th Numerical Shape propertycontrols Nz function 2nd