Data Connection Wizard, 98–100
data connections, creating, 97–100
data entry, 47. See also filling out forms
data entry controls, 113–118. See also controls
adding new, 114–115
advanced properties, 117–118
Check Box, 132–133
Date Picker, 131–132
drop-down lists and list boxes, 126–131
Option Button, 133–134
padding and margins, 116–117
Rich Text boxes. see Rich Text boxes
sizing, 115–116
text boxes. see text boxes
data exchange, 90
data files
downlevel view of, 311
previewing, 86
data integration, 5–7
Data Source Setup Wizard, 91–92
adding tables to data sources, 100–102
connecting to secondary data sources, 231–234
creating SQL statements, 102–104
Data Source view, Task Pane, 83–84, 92
data sources, 90–110
Access databases. see Access database (MBD)
adding tables to, 100–102
form design and, 72
secondary, 230–234
selecting databases as, 95–96
SQL Server. see SQL Server
web services. see web services
XML schema or files. see XML (Extensible Markup Language)
data types, 120
data, in form libraries
analyzing with Access, 275–277
analyzing with Excel, 271–275
column data, 259–261
datasheet view and, 268–271
exporting to Access, 277–279
filtering, 263–264, 267–268
grouping, 264–265
linking to Access, 279
reports with Access, 280–281
sorting, 262, 267–268
totaling, 265–266
database integration, processing models, 71
databases. See also Access database (MBD); SQL Server
creating forms from, 95
as data source, 95–96
forms interacting with, 6
datasheet view, SharePoint, 268–271
dates
adding Date Picker to control, 131–132
converting date values, 224
JScript date and time function, 336–337
scripting date fields, 223–224
debugger, scripting, 355
deployment. See publishing forms
Design a Form view, Task Pane, 74, 91
Design Tasks button, 113
designing forms, 68–73
concept definition, 69–70
creating design, 72–73
data sources, 72
deployment, 73
developing and testing design, 73
overview, 7
phases of, 68
processing model, 70–71
developers
concept definition, 69–70
data integration, 5–7
form design, 7
form validation, 9
publishing forms with SharePoint Portal Server, 8
scripting, 7–8
Developer's Reference, 217
display settings
changing default, 355–356
Rich Text boxes, 125–126
text boxes, 121–124
distributing forms. See publishing forms
do...while statements, JScript, 339
double slashes (//), 333
downlevel tool, 308–314
command-line options, 314
downlevel view of form template, 309–310
downlevel view of form with data, 311–312
function of, 308
overview, 308
updating downlevel files, 313–314
view options, 312
drop-down lists, 126–131
looking up entries from databases, 128–131
manual entries, 127–128
overview, 126–127
repeating sections and, 54
repeating tables and, 53