Index_N

N

name data

concatenating and splitting, 335

fields, adding additional, client-requested changes, 274–277

FirstNameFirst variable, 67

LastNameFirst variable, 67

Name property, 52, 58, 189

named constants, 199, 370

NameSpace object, 427, 430–431

naming conventions, LNC, 50–52, 294–295

naming fields, in Datasheet View, 8

native tables, 11

nested queries, 152

New Form dialog box, 45

New Object button (New Query dialog box), 140

New Object selector button

PivotChart toolbar, 172

PivotTable toolbar, 166

New Query dialog box

Design view, 333

discussed, 134

Find Unmatched Query Wizard option, 338–339

New Object button, 140

New Report dialog box, 176

New Table dialog box

Datasheet View, 8–9

Design view, 8–9

Import Table option, 9, 329–330

LinkTable option, 9

Table Wizard, 9

New Thing forms, 231–235

Next button (Table Wizard), 12

No Primary Key option (Import Spreadsheet Wizard), 330

Node_Click event procedure, 318–319

non-updatable queries, 147

normalization

fifth normal form, 33

first normal form, 31

fourth normal form, 32

second normal form, 31–32

tables, 302–306

third normal form, 32

Not in List event procedure, 90–91, 320–321

notes, appointments, 434

number data type, 16

Nz function, 95, 376, 409, 438