| [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] identifying relationships 2nd implicit intersections 2nd Import command (Get External Data menu) Import Data dialog box 2nd Import External Data command (Data menu) 2nd 3rd 4th importing text 2nd 3rd 4th 5th 6th importing data 2nd 3rd 4th 5th data location and format, specifying 2nd 3rd 4th Choose Data Source dialog box Create New Data Source dialog box ODBC Microsoft Access Setup dialog box 2nd Select Database dialog box 2nd DSN files 2nd 3rd 4th 5th exclusive mode 2nd 3rd queries, building with Microsoft Query 2nd 3rd 4th 5th 6th queries, building with Query Wizard 2nd 3rd 4th 5th 6th 7th 8th 9th Choose Columns window Sort Order window read-only mode 2nd 3rd 4th shared mode 2nd to pivot tables 2nd populating pivot tables 2nd Refresh on Open versus Workbook_Open event 2nd 3rd 4th 5th 6th 7th 8th refreshing cache 2nd INDEX function combining with MATCH function 2nd 3rd two-way arrays 2nd 3rd INDEX functionv 2nd indexes 2nd 3rd b-tree creating automatically 2nd creating manually 2nd 3rd 4th multiple field indexes 2nd 3rd 4th 5th INDIRECT function ineffective data orientation 2nd changing with Paste Special command 2nd changing with TRANSPOSE function 2nd inner For-Next loops 2nd inner joins 2nd 3rd Insert Cells for New Data, Delete Unused Cells property (data ranges) Insert Entire Rows for New Data, Clear Unused Cell property (data ranges) Insert menu commands Modules Name insert rows instantiating Connection objects 2nd integrity referential integrity 2nd 3rd intersections implicit intersections 2nd items numbers, looping with 2nd 3rd |