Index_T

T

Tab Control button (Toolbox), 80

tab controls

forms, 60–61, 112–113

tags, 294

tab tag (tab control), 294

Table Wizard

Business option, 11

Customers template, 20–23

Mailing List template, 23–24

Next button, 12

Orders template, 28

Products table, 11–15

Products template, 26–27

Relationships button, 14–15

relationships in, setting, 12

VendorProductID, 13

table/query row source, comboboxes, 85–86

tables. See also databases

ALTER TABLE statement, 150

CREATE INDEX statement, 151

CREATE TABLE statement, 150

creating

Datasheet View, 8–9

Design View, 9

discussed, 5–7

ImportTable option, 9

LinkTable option, 9–10

Products table, 11–15

Table Wizard, 9

deleting, 151

DROP statement, 151

fields

adding, 150

calculated, errors in, 264

deleting, 150

FieldSize property, 19

Long Integer (Datasheet View), 9

lookup, 18

moving between, 19

naming, in Datasheet view, 8

primary data types, 16–18

renaming, 12, 150

tblInfo, 224–225

VendorID, 20

linked

comma-delimited text file, 10, 471

dBASE file, 10

Excel worksheets, 10

records, adding new, 332

when to use, 9

native, 11

normalization

ebook example, 302–306

fifth normal form, 33

first normal form, 31

fourth normal form, 32

second normal form, 31–32

third normal form, 32

not dependent on key columns, eliminating, 32

PivotTables

column headings, 158–159

customization, 160

data source queries, 156–157

drop zones, 157

Edit Pivot Table button, 157

filter values, 161

fonts, 162

overview, 155

properties sheet, 166–167

row headings, 158–159

summary display, 163

toolbar buttons, 164–166

totals, adding and removing, 162

primary, 34

records, deleting, 340

relationships

many-to-many, 37

one-to-many, 34–36

one-to-one, 36

overview, 33

referential integrity, 34

renaming, 150

as source objects, 419

tags, 292–293

Tables option (Word object model), 367

Tables to Rename dialog box, 297

tabs

Advanced (Options dialog box), 252

File Locations (Options dialog box), 421

Multiple Items (Import Outlook dialog box), 483, 488

Multiple Tables (Import from Word dialog box), 413–414

Single Item (Import from Outlook dialog box), 483

Single Table (Import from Word dialog box), 413–414

tabular data, TypeText method, 375

tabular reports, 181–182

Tag property, 52, 300

tags

bas (module), 291

bin (binary), 292

bln (boolean), 293

brk (page break), 294

byt (byte), 292

cbo (combobox), 293–294

cbr (commandbar), 293

chk (check box), 294

chr (text character), 293

cht (chart), 294

cls (class module), 291

cmd (command button), 294

ctl (control), 293

cur (currency), 292–293

dbl (double), 292–293

dbs (database), 293

dtm (date/time), 292

fdlg (form, dialog), 291

fmnu (form, menu), 291

fmsg (form, message), 291

fra (frame), 294

frb (bound object frame), 294

frm (form), 291, 293

fru (unbound object frame), 294

fsub (form, subform), 291

g (public variable), 291

grp (option group), 294

hlk (hyperlink), 292, 294

idn (autonumber, random nonsequential), 292

idr (autonumber, replication ID), 292

ids (autonumber, sequential), 292

img (image), 294

int (integer), 292–293

lbl (label), 293–294

lin (line), 294

lng (long), 292–293

lst (list box), 293–294

m (module-level variable), 291

mcr (macro), 291

mem (memo), 292

ocx (custom control), 294

ole (OLE), 293

opt (option button), 294

p (public variable), 291

pge (page), 294

qapp (query, append), 291, 304, 308

qddl (query, data definition), 291

qdel (query, delete), 291

qdf (querydef), 293

qflt (query, form filter), 291

qlkp (query, lookup), 291

qmak (query, make-table), 291, 304

qry (query, any type), 291

qsel (query, select), 291

qspt (query, SQL pass-through), 291

quni (query, union), 292

qupd (query, update), 292

qxtb (query, crosstab), 291

rpt (report), 292–293

rsub (report, subreport), 292

s (local static variable), 291

shp (shape), 294

sng (single), 293

snp (snapshot), 293

str (string), 293

sub (subform), 294

tab (tab control), 294

tbl (table), 292–293

tdbf (table, attached dBASE), 292

tfox (table, attached FoxPro), 292

tgl (toggle button), 294

tlkp (table, lookup), 292

todb (table, attached ODBC), 292

tpdx (table, attached Paradox), 292

tsql (table, attached SQL Server), 292

ttxt (table, attached text), 292

twks (table, attached Lotus), 292

txls (table, attached Excel), 292

txt (textbox), 293–294

typ (type, user-defined), 293

var (variant), 293

zh (hidden system objects), 290

zs (displayed system objects), 290

zt (temporary objects), 290

zz (backup objects), 290

TaskItem object, 450–451

tasks

adding to contacts, 450–451

business-related, 53

for databases, identifying, 5

Tasks option (Import Exchange/Outlook Wizard), 434

tbl tag (table), 292–293

tblCategories variable, 14, 43

tblContactsSeparate variable, 123

tblContactsWhole variable, 122

tblCustomerEMails variable, 43

tblCustomerPhones variable, 43

tblCustomers option (Custom Form Wizard), 46

tblEmployees object, LNC naming element, 294

tblInfo fields, 224–225

tblLogons object, 418

tblMailingList variable, 23–24

tblMailingListCompanies variable, 137

tblMailMergeList variable, 391

tblMaterials variable, 26

tblOrders variable, 28

tblRepairs variable, 27

tblRepairsMaterial variable, 43

tblShippingMethods variable, 28

tblTargetSeparate variable, 124

tblVendors variable, 14

tdbf tag (table, attached dBASE), 292

TemplateDir function, 280, 376

templates

Customers (Table Wizard), 20–23

Mailing List (Table Wizard), 23–24

Orders (Table Wizard), 28

Products (Table Wizard), 26–27

reports, 179–181

Templates option (Word object model), 367

temporary objects (zt tag), 290

text

bold, 180

freestyle, 375, 381

italic, 180

TypeText method, 375

wrapping, 183

Text Box button (Toolbox), 80

text boxes

forms, 47

raised, 47

tags, 293–294

uses for, 81

text character tag (chr), 293

text data type, 16

text files

exporting mail merge documents to, 392

writing data to, 555–556

tfox tag (table, attached FoxPro), 292

tgl tag (toggle button), 294

third normal form, normalization, 32

3D graphs, PivotCharts, 170

time

data/time data type, 16, 23–24

data/time tag, 292

DateTimePicker control, ActiveX, 117

EndTime property, 465–466

StartTime property, 465

tlkp tag (table, lookup), 292

tlkpForms variable, 210

tlkpLetters variable, 278

tlkpOutlookItemTypes variable, 440

tlkpReports variable, 210

tmakMatchingRecords variable, 459

ToDate function, 227

todb tag (table, attached ODBC), 292

toggle buttons

discussed, 76

forms, 112

tags, 294

Toolbar Options button (Toolbox), 80, 114

toolbars

Access 2000, adding Visual Basic Editor button to, 365

Database, 365

Debug, 216

Form

Filter by Selection button, 122

Sort Ascending button, 122

Sort Descending, 122

Form Design, 215

PivotCharts, 171–173

PivotTable, 164–166

Query Design

discussed, 333

Run button, 143

Standard, 365

Toolbox

accessing, 79

buttons, list of, 80

calendar controls, 113–114

More Controls tool, 112

More Tools button, 113

toggle button, 76

Toolbar Options button, 114

treeview controls, 114–116

Tools menu commands

Addins, 44, 205

Options, 24

Startup, 208

totals

PivotTables, adding and removing, 162

reports, 185

totals queries

aggregate functions, 127–128

Count function, 130

Group By function, 132

Max function, 131

Min function, 131

Sum function, 129

tpdx tag (table, attached Paradox), 292

TransferSpreadsheet method, 495, 527–528

TransferText method, 480, 512

TRANSMIT command, sending faxes, 541

transparent borders, 62

treeview controls, 114–116

Trim function, 311

tsql tag (table, attached SQL Server), 292

ttxt tag (table, attached text), 292

twks tag (table, attached Lotus), 292

txls tag (table, attached Excel), 292

txlsMailingList variable, 137

txt tag (textbox), 293–294

txtCaptionRH variable, 180

txtContactName variable, 276

txtDateRange variable, 181

txtEmail variable, 59

txtLetterText query, 402–403

txtMessageText variable, 441

txtPageTotal variable, 186

typ tag (type, user-defined), 293

Type property, 89

TypeText method, 375, 395–396