Microsoft Access 2010 Bible

1298

Index

HTML data, 587, 594–595

versus importing and exporting, 582

limitations of, 587–588

non-database data, 591–594

ODBC (Object Database Connectivity), 588, 590–591

other Access databases, 588–590

text data, 596–597

text files, 587

uses for, 582

xBase files, 591

F

Fail on Error property, 653

Fast Laser Printing property, 311

fatal errors, 821

Fetch Defaults property, 310

Field Delimiter option, 624–625

Field List, 268–271, 315–316

field names

automatic correction, 1091–1092

SQL Server, 1239

Field objects, 506

field separators, importing text files, 620

field variables, absolute speed, 865

fields (columns). See also queries, fields; records; tables.

adding to forms, 315–316

aliases, 649

column headings, modifying, 658–659

data type conversion, 57–58

data type issues, 1178

data types, specifying, 45, 48–50. See also specific types.

default size, 49

definition, 8

deleting, 41, 56

descriptions, adding, 54–55

disabled, 296

display width, modifying, 237

finding, 229–230

hiding/showing, 241

incompatibilities, 1174

indexing, 72–73

inserting in tables, 41, 55–56

listing, 314–316

locked, 296

modifying, 41

moving, 57

naming, 45, 47–48

navigating among, 294

Export group, 611

exporting

Access tables to SharePoint, 1123–1127

ribbon customizations, 1022

exporting external data

definition, 581

HTML documents, 627–628

versus linking and importing, 582

Merge it With Microsoft Word option, 636

Microsoft Word Mail Merge option, 636

to other Access databases, 634–635

Snapshot Viewer option, 636

special options, 636

through ODBC drivers, 635

uses for, 584

to XML files, 625–627

Expression Builder, 640–642

Expression option, 655, 656

expressions. See also operators.

. (period), table and field name separator, 174
[ ] (square brackets), table and field name notation, 174
definition, 171
field-name notation, 174
in group headers, 369–370
invalid, 1177
in queries, 187–193
table-name notation, 174
in text controls, 353
for totals, 664–666
eXtensible Markup Language (XML). See XML (eXtensible
Markup Language).
external data. See also exporting external data; importing
external data.
file types supported, 581
HTML tables, 583
text tables, 583
types of, 580
unsupported programs, 584
External Data tab, 610–611
external tables, linking to. See also linked tables; linking
tables.
CSV (comma-separated values), 596–597
data types supported, 582
dBase databases, 587
definition, 581
disadvantages of, 583
Excel data, 587, 591–594
external database tables, 585–587
fixed-width text files, 596–597

52_475348-bindex.indd 129852_475348-bindex.indd 1298 4/1/10 2:02 PM4/1/10 2:02 PM