| [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] DAO databases DAO library, referencing 2nd 3rd declaring 2nd 3rd file types, filtering 2nd 3rd GetOpenFilename method 2nd 3rd 4th 5th 6th locating 2nd OpenDatabase method opening 2nd DAO (Data Access Objects) 2nd databases records, adding 2nd 3rd records, editing 2nd 3rd 4th databases, creating 2nd CreateDatabaseWithDAO() function 2nd 3rd fields, defining 2nd 3rd 4th 5th fields, number of 2nd preexisting databases, checking for 2nd 3rd 4th 5th 6th recordsets 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th ReDim statement 2nd 3rd references tables 2nd 3rd 4th 5th 6th 7th 8th user-defined names 2nd 3rd 4th queries, executing 2nd Append queries 2nd 3rd 4th 5th Delete queries 2nd nonpersistent queries 2nd 3rd SQL parameters 2nd Update queries 2nd recordsets copying to workbooks 2nd creating 2nd 3rd 4th 5th 6th creating with ADO 2nd 3rd 4th 5th 6th 7th 8th dynaset-type recordsets 2nd snapshot-type recordsets 2nd specifying type of 2nd 3rd table-type recordsets 2nd 3rd versions data . [See also ranges] filtering 2nd Advanced Filter 2nd 3rd 4th 5th AutoFilter 2nd 3rd 4th 5th 6th formulas as filter criteria 2nd finding INDEX function 2nd 3rd 4th 5th 6th 7th 8th MATCH function 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th OFFSET function 2nd 3rd 4th importing 2nd 3rd 4th 5th data location and format, specifying 2nd 3rd 4th 5th 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 read-only mode 2nd 3rd 4th shared mode 2nd to pivot tables 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th lists creating 2nd 3rd Data Forms 2nd 3rd defined 2nd rows 2nd sort order sorting 2nd 3rd 4th structure of 2nd 3rd 4th 5th variable names 2nd 3rd 4th lookups. [See lookups] rearranging 2nd 3rd Paste Special command 2nd 3rd TRANSPOSE function 2nd 3rd retrieving from pivot tables 2nd entering GETPIVOTDATA automatically 2nd Excel 2002/Excel 2003 2nd Excel 97/Excel 2000 2nd Data Access Objects. [See DAO] Data Forms 2nd 3rd Data menu commands Filter Form Get External Data 2nd Group and Outline Import External Data 2nd 3rd 4th List PivotTable and PivotChart Report Refresh External Data Sort 2nd 3rd Data Range Properties dialog box 2nd 3rd data ranges. [See ranges] Data Source Options dialog box data sources ADO 2nd data types fields 2nd 3rd 4th user-defined data types data validation labels versus codes 2nd 3rd DatabaseName property (CreateDatabaseWithDAO() function) DatabaseName variable databases 2nd . [See also queries]2nd [See also Reservations application]3rd [See also queries]4th [See also queries] ADO connections ADO library, referencing 2nd 3rd connection strings 2nd 3rd 4th 5th 6th 7th 8th 9th data sources, specifying 2nd declaring 2nd instantiating 2nd New keyword 2nd opening 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th records, adding 2nd 3rd records, editing 2nd 3rd 4th UDL (universal data link) files 2nd 3rd 4th 5th 6th creating from Excel 2nd creating with ADO recordsets 2nd 3rd 4th 5th 6th 7th 8th tables 2nd 3rd 4th 5th 6th 7th creating with DAO 2nd CreateDatabaseWithDAO() function 2nd 3rd fields, defining 2nd 3rd 4th 5th fields, number of 2nd preexisting databases, checking for 2nd 3rd 4th 5th 6th recordsets 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th ReDim statement 2nd 3rd references tables 2nd 3rd 4th 5th 6th 7th 8th user-defined names 2nd 3rd 4th DAO connections 2nd DAO library, referencing 2nd 3rd declaring 2nd 3rd file types, filtering 2nd 3rd GetOpenFilename method 2nd 3rd 4th 5th 6th locating databases 2nd OpenDatabase method opening 2nd records, adding 2nd 3rd records, editing 2nd 3rd 4th fields defining 2nd 3rd 4th 5th names 2nd 3rd 4th 5th 6th 7th 8th 9th number of 2nd setting type of 2nd 3rd 4th importing data into 2nd 3rd 4th 5th 6th indexes 2nd b-tree creating automatically 2nd creating manually 2nd 3rd 4th multiple field indexes 2nd 3rd 4th 5th Jet databases 2nd 3rd 4th Access database passwords 2nd 3rd 4th Admin restrictions opening 2nd 3rd 4th password requests 2nd 3rd securing 2nd 3rd 4th 5th 6th user accounts, creating 2nd user-level security 2nd 3rd 4th workgroup information files 2nd 3rd 4th managing from Excel Excel features 2nd flexibility 2nd 3rd 4th overview 2nd 3rd users, accomodating 2nd primary keys queries Append queries 2nd 3rd 4th 5th 6th 7th creating 2nd Delete queries 2nd 3rd 4th 5th 6th executing 2nd 3rd Update queries 2nd 3rd 4th 5th records adding with ADO (ActiveX Data Objects) 2nd 3rd adding with DAO 2nd 3rd 4th 5th adding with DAO (Data Access Objects) 2nd 3rd appending 2nd 3rd child records deleting 2nd deleting from Reservations application 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th 17th 18th 19th 20th 21st 22nd 23rd 24th 25th 26th 27th editing with ADO (ActiveX Data Objects) 2nd 3rd 4th editing with DAO (Data Access Objects) 2nd 3rd 4th finding 2nd locking 2nd 3rd parent records searching 2nd 3rd 4th updating 2nd 3rd 4th 5th variable numbers of 2nd 3rd 4th recordsets 2nd copying to workbooks 2nd 3rd 4th 5th creating with ADO 2nd 3rd 4th 5th 6th 7th 8th creating with DAO 2nd 3rd 4th 5th 6th 7th 8th 9th 10th 11th 12th 13th 14th 15th 16th esablishing relationships defining 2nd identifying 2nd one-to-many 2nd one-to-one 2nd viewing 2nd tables creating 2nd creating with ADO 2nd 3rd 4th 5th 6th 7th creating with DAO 2nd 3rd 4th 5th 6th 7th 8th defined joins 2nd primary keys 2nd 3rd referential integrity 2nd 3rd DATE() function date/time fields grouping 2nd 3rd dbObject parameter (OpenDatabase method) dbReservation variable 2nd declaring Connection objects 2nd DAO databases 2nd 3rd 4th 5th 6th object variables 2nd variables 2nd 3rd 4th 5th 6th 7th Define command (Name menu) 2nd 3rd Define Names window 2nd defining dynamic range names 2nd 3rd 4th 5th relationships 2nd Delete queries 2nd 3rd 4th 5th 6th 7th executing with ADO (ActiveX Data Objects) 2nd 3rd 4th executing with DAO (Data Access Objects) 2nd Delete Query command (Query menu) DeleteOldOrders function DeleteOldOrders() function DeleteOldOrdersWithSQL() function 2nd DeleteOldRecords() function 2nd 3rd DeleteOldRecordsWithString1() function 2nd deleting records 2nd records from Reservations application clean up 2nd code listing 2nd 3rd 4th 5th 6th 7th 8th 9th 10th records, finding 2nd recordsets, establishing recurring reservations 2nd 3rd 4th 5th Sub statement user requests, verifying and confirming 2nd variable declarations 2nd 3rd dialog boxes Choose Data Source 2nd 3rd 4th Confirm Workgroup Information Create New Data Source Data Range Properties 2nd 3rd Data Source Options Edit Relationships 2nd External Data Range Properties Grouping 2nd 3rd Import Data 2nd ODBC Microsoft Access Setup 2nd Paste Special PivotTable Options References Select Database 2nd Show Table 2nd Table Options Workgroup Information File 2nd Dim statement 2nd 3rd 4th 5th Dir function displaying worksheets 2nd DLLs (dynamic link libraries) Do While loops 2nd 3rd 4th 5th 6th dot notation 2nd 3rd 4th double-precision variables Driver() function 2nd 3rd dropdowns DSN files 2nd 3rd 4th 5th (data source name) dynamic link libraries (DLLs) dynamic range names defining 2nd 3rd 4th 5th dynamically defined ranges, selecting 2nd extraneous values 2nd dynaset-type recordsets 2nd |