|
|
T \t, Chapter 1: Designing Applications
table-type Recordset objects, DAO
RecordCount property \b \rtabletype2, Table-Type Recordsets
table-type Recordset objects, DAO \i \rtabletype1, Table-type Recordset Objects
TableDef objects, DAO
CreateField method, Working with Tables
TableDef objects, DAO \rTableDef1 VBA
TableDef objects , Working with Tables
TableDef objects, DAO \rTableDef2, Working with Tables
TableDef objects, DAO \rTableDef3, Working with Tables
Tabledefs collections, DAO, Working with Tables
Append method, Working with Tables
Tabledefs collections, DAO \i \rTabledefs1 DAO
Database object, The TableDefs Collection
Tabledefs collections, DAO \rTableDefs1, Creating a Library Database
tables
DAO, Working with Tables
linked tables \b \rlinked1, Linked Tables
local tables \b \rlocal1, Differences between Linked and Local Tables
matching records tables \b \rmatching1, Using a Matching Records Table
records \b \rrecords1, Inserting Records
XML schemas \b \rschemas1, Working with Tables
tables \i \rtables1, Chapter 8: Working with Tables, Table Design, How to Export a Table as XML
TBU (Target Benchmark Users), Jet vs. SQL Server: Why Move?
SQL Server Desktop performance
technical analysis, Access applications \i \rtechnical1, Technical Analysis
templates, Word, Microsoft Word
Terminate event \rTerminate1, The Class Initialize and Terminate Events
test data \i \rdata1, Creating Test Data
test harnesses \i \rharnesses1, Timing the Code Samples
test tables \i \rtables1, Populating the Test Table
testing, Access applications, Testing
testing, Access applications \i \rtesting1, Testing
text files
CSV files, Specifications
CSV files \b \rCSV1, Text Files
CSV files \b \rCSV2, Specifications
Export Text wizard, Specifications
fixed width files, Specifications
fixed width files \b \rfixed1, Text Files
fixed width files \b \rfixed2, Specifications
specifications \b \rspecifications1, Specifications
text files \i \rtext1, Text Files
TextToDisplay property, Hyperlink type, Hyperlinks in VBA
Then keyword (see If statements) \t, If...Then...
Time function, Other Useful Date and Time Fuctions
timeGetTime function \rtimeGetTime1, Declaring a DLL in Code
Timer function, Timing the Code Samples
Timer function \rTimer1, Timing the Code Samples
times \i \rtimes1, Times
timestamps
SQL Server migration, Upsizing Wizard, Running the Upsizing Wizard
TLAs (three letter acronyms) \rTLAs1, DAO vs ADO
TOP command, SQL
as ORDER BY alternative, views, Views
TransferDatabase method, DoCmd object \rTransferDatabase1, Databases
TransferSpreadsheet method, DoCmd object \rTransferSpreadsheet1, Spreadsheets
TransferText method, DoCmd object, Specifications
TransferText method, DoCmd object \rTransferText1, Text Files
TRANSFORM syntax
T-SQL not supporting, qryxSS
type conversion \i \rconversion1, Type Conversion
TypeName function \i \rTypeName1, The TypeName() Function
types
optimization \b \rtypes1, Use the Right Data Type
structures \b \rstructures1, User-defined Data Types
types \i \rtypes1, Variable Types
|
|
|
|
U \t, Chapter 1: Designing Applications
UDA (Universal Data Access) \i \rUDA1, Universal Data Access
UDF (user-defined functions), SQL Server, What's New in your Database?,
@@ system functions, listing, User-Defined Functions (UDFs)
Access/SQL Server built-in, listing, User-Defined Functions (UDFs)
deterministic/
multi-line, Multi-Line User-Defined Functions
scalar/in-line, User-Defined Functions (UDFs)
underscores, Parameters or Arguments
Unique property, DAO Index objects, Working with Tables
Unique Records property, queries, Microsoft Outlook
Universal Data Access (UDA) \i \rUDA1, Universal Data Access
Until keyword (see Do
Updatable property, DAO Recordset objects \rUpdatable1, When a Recordset Can't be Updated
Update method, ADO Recordset objects \rUpdate1, Inserting Records
Update method, ADO Recordset objects \rUpdate2, Try It Out-Updating Records using ADO
Update method, DAO Recordset objects, Editing Records in Recordsets
UpdateBatch method, ADO Recordset objects \i \rUpdateBatch1, Disconnected Recordsets
Upsizing Pro tool, Running the Upsizing Wizard
Upsizing Wizard, running pre-requisites, Running the Upsizing Wizard
Upsizing Wizard, Access, Running the Upsizing Wizard
running, pre-requisites, Running the Upsizing Wizard
SQL Server 2000/Desktop, migrating to, Running the Upsizing Wizard
upsizing database, example, Results of Upsizing the IceCream Database
upsizing database, steps, Running the Upsizing Wizard
URLs \i \rURLs1, The Internet
usability testing \i \rusability1, Testing
user defined errors \i \ruser1, User Defined Errors
user defined types \i \ruser1, User-defined Data Types
user interfaces \i \ruser1, Adding to the User Interface
user requirements analysis \i, The Challenge - Flexibility vs. Manageability
user-defined functions, SQL Server, see UDF\t, User-Defined Functions (UDFs)
users, SQL Server security, Users
creating/adding to database, login example, Try It Out-Create the Whole Works
User32.dll file, Dynamic Link Libraries (DLLs), Declaring a DLL in Code
|
|