See queries; searching
FindNext method, 848
FindRecord method
described, 865
FindFirst method versus, 869
indexed fields for improving efficiency, 848
for selecting specific record, 865??“867
First() function, 595
first normal form (1NF)
always needed, 92
example, 91??“92
limitations of, 92
rule for, 90
violated by flat-file approach, 90??“91
five-step design method. See also designing databases
flowchart, 11
overview, 10??“11
step 1: overall system design, 11??“12
step 2: report design, 13??“14
step 3: data design, 14??“17
step 4: table design, 17??“21
step 5: form (user interface) design, 21??“22
time spent on each step, 11
Fix() function, 462
Fixed number format, 57, 58
fixed-width text files
importing, 564??“566
linking to, 542
overview, 540
flat-file databases, 91, 98??“99, 103
FlexFormat() function, 674
focus changes
Access error messages after, 448
characters inserted in expressions upon, 448
defined, 448
1314
Index F
order of event firing, 428??“429
SetFocus statement for, 866
fonts
adding emphasis to reports at runtime, 660??“662
changing for controls, 258, 259, 293, 323??“324
changing in datasheets, 225??“226
Format Painter for, 635
footer
adding page numbers and dates to forms, 632??“633
adding to forms, 290??“291
Group Footer report section, 314, 317, 332??“333, 334
Page Footer report section, 314, 317, 341??“343, 671??“672
Report Footer section, 314, 317, 665
For Each statement, 376??“377
Force New Page section property, 337
ForeColor control property, 620
foreign keys
defined, 19
referential integrity rule for, 108??“109
in second normal form (2NF), 95
in table design process, 19??“20
form design
adding ToolTip help, 635??“636
animating controls, 627??“628
background pictures, 636??“637
closing forms automatically, 629
combo box techniques, 630??“631
determining if form is open, 631??“632
in five-step design method, 21??“22
Format Painter for, 635
modeling on printed forms, 21
on-screen objects for, 21
performance optimization, 842??“844
removing controls from tab order, 626
selecting data for overtyping, 628??“629
SQL for faster combo box refresh, 628
tabbed pages, 638??“641
tallying check boxes, 626??“627
toggling control properties with Not, 629
Form Design window
deleting controls, 260
overview, 243??“244
resizing the form area, 244
form events
ADP, 425??“426
data, 423??“424
defined, 421
for filtering, 638
mouse and keyboard, 423
order of firing, 428??“431
PivotTable, 424??“425
primary, 421??“422
Form keyword, 454
form modules.
Pages:
2361
2362
2363
2364
2365
2366
2367
2368
2369
2370
2371
2372
2373
2374
2375
2376
2377
2378
2379
2380
2381
2382
2383
2384
2385