|
|
 |
|
|
|
Microsoft® Office Access 2003 Step by Step
|
|
|
Author
|
|
Online Training Solutions Inc.
|
|
|
Pages
|
368
|
|
Disk
|
1 Companion CD(s)
|
|
Level
|
Beg/Int
|
|
Published
|
08/27/2003
|
|
ISBN
|
9780735615175
|
|
Price
|
$24.99
To see this book's discounted price, select a reseller below.
|
|
|
|
|
|
|
|
|
Index
A
Access. See Microsoft Access
action queries, 130, 146, 293 See also queries
append queries, 130
converting from select queries, 168
creating, 168
delete queries (see delete queries)
make-table queries, 130
update queries (see update queries)
actions. See events
Active Server Pages (ASP), 260, 293
Add Procedure dialog box, 269
advanced filtering, xxxiv, 127 See also filtering
aggregate functions, 140, 293 See also functions
aligning labels, 90, 210
analyzing performance, 218, 220
apostrophes in VBA code, 103
append queries, 130, 293 See also queries
application title, 214
Apply Filter button, xxxiv, 124–25
applying
filters, xxxiv, 125
smart tags, to fields, 54
startup options, 215
styles, 35
themes, to data access pages, 284
area codes
requiring, 155
restricting to specific, 158
arithmetic operators, 129, 293 See also expressions
ASCII, 293
assigning passwords, 230 See also passwords
authorizing database access, 240
autocomplete, in Visual Basic Editor, 266
AutoDialer dialog box, 38
AutoFormat dialog box, 94
AutoFormats, creating, 95
AutoForms, 104–106, 293
automatically
numbering, 46
saving, 37
automating actions, 22
AutoNumber data type, 46
AutoPage, creating data access pages with, 276
B
back-end databases, 239, 293 See also databases
backgrounds, form, 91
resizing, xxxii, 93
styles for, 105
backgrounds, label, 89
backing up
databases, 238
databases, with Briefcase, xlii, 235
tables, 169
binary files, 226, 293
blank databases, creating, 41, 146
Bold button (Formatting toolbar), 280
Boolean data type, 147, 150, 293
borders, transparent, 196
bound, 293
Briefcase
backing up databases with, xlii, 235
copying files to, 235
creating new, xlii, 234
defined, 293
installing, 234
opening, 236
renaming, xlii, 234
replicating databases to, 234
updating, 237
browsers, 259
building expressions, 137 See also expressions
bulleted lists, creating, 280
Bullets button (Formatting toolbar), 280
business tables, 42
buttons on data access pages, hiding, 282
buttons, command. See command buttons
buttons, switchboard
adding, 205
assigning properties to, 204
displaying, 207
labeling, 204
making visible, 207
On Click event, 207
C
Calls form, 39
Caption property, 47
captions
adding to form headers, xxxii
combo box, 99
field, 47
form header, 97
label, 90
centering text
in labels, 98
in text boxes, 189
characters, input mask, 153
Check Box button (Toolbox), 210
check boxes, 210 See also controls
checking spelling, 266
Choose Builder dialog box, 102
class modules, 263, 293
clearing design grids, xxiv, 127 See also design grids
Close button, 9
Close button (Print Preview toolbar), 198
closing
data type list, without making changes, 46
databases, 6
Print Preview, 26
switchboards, 5, 204
tables, 9
code, VBA. See VBA code
collapsing subdatasheets, 9 See also subdatasheets
Color dialog box, 89
coloring backgrounds/borders, 90
columns, 2
adjacent, selecting, 53
Data Type, 46
Description, 46
in Design view, 46
Field Name, 46
freezing, 54
hiding, xxix, 53, 166
locking, 54
resizing, 8, 52
resizing to display all text, xxviii
resizing to minimum width, xxviii
restoring, xxix, 53
selecting, 120
selecting adjacent, 53
sizing to fit, 112
sorting, 120
unhiding, xxix, 53
widening, 52
width, setting to widest entry, 8
columns. See also fields
combo boxes, 160, 293 See also controls
captions, 99
creating, with Lookup Wizard, 161
inserting, 98
lookup lists (see lookup lists)
comma-delimited text file, 294
command button, 294
Command Button button (Toolbox), 211
Command Button Wizard, 211
command buttons, 83 See also controls
adding to forms, 211
creating, 211
comment, 294
comments, VBA, 103, 265
removing, 270
compacting databases, xl, 218–19
comparison operators, 129, 294 See also expressions
component, 294
compression, 294
and encrypting, 228
ConnectionString property (data access pages), 282
constant, 294
control property, 294
control sources, 86, 90, 294
Control Wizards button (Toolbox), 98, 210
controlling access to VBA code, 253
controls, 14, 83, 95–100, 294
borders, coloring, 90
check boxes, 210
combo boxes, 98
command buttons (see command buttons)
creating without wizards, 98
deselecting, 90
disabling, 106
displaying list of, 96
experimenting with, 96
font weight, 91
formatting all, 89
grouping, 183
incrementally positioning, 94
label, 15
label (see also labels)
modifying multiple simultaneously, 185
moving, incrementally, 94
option buttons, 83, 160
pictures, inserting, xxxii, 97
properties, 88
ScreenTips, 97
selecting all, 89
selecting multiple, 183
shadowing, 90
sizing to fit, 98
text box (see text boxes)
turning off, 106
unbound (see unbound controls)
converting
databases, into MDE files, irrevocability of, 256
reports, into subreports, 192
select queries, into action queries, 168
select queries, into delete queries, 171
Copy button, xxxi, 79
copying See also pasting
database information, 78
fields, to design grids, 127, 133
formatting, 99
tables, 169
tables, between databases, 79
VBA code, 270
copyright symbol, 280
criteria, 294
criteria, expression, 129 See also expressions
criteria, query, 13, 167 See also queries
crosstab queries, 130, 294 See also queries
currency conversion function, 135
custom
date formats, xxxviii
menus/toolbars, preventing changes to, 214
customizing
colors, 90
date formats, 182
form layout, 92
D
data access pages, 21, 260, 276, 294
applying themes to, 284
ConnectionString property, 282
creating, manually, xliv, 287
creating, with AutoPage, 276
creating, with Page Wizard, 283
elements, properties of, 281
exporting, 73
Field List, 276
Field List, displaying 287
vs. forms, 276
getting help on, 278
hiding buttons, 282
losing, 282
moving, errors when, 283
navigating in, 278
opening, errors when, 282
paths to data sources, 282
PivotTables and, 287
renaming, errors when, 283
vs. reports, 276
saving, 278
sorting records in, 279
Toolbox, displaying, 287
viewing, 277, 279
data source, 294
Data Type column, 46
data types, 146, 294
AutoNumber, 46
Boolean, 147
Boolean, display options, 150
changing, 48
date, 149
descriptions of, 46
entering quickly, 147
list of, 46
Long Integer, 47
Lookup Wizard, 160
OLE Object, 48
phone number, 48
restricting, 146
setting, 147
viewing list of, 46
Yes/No, 147
Yes/No, display options, 150
data warehouses, 234, 295
data, restricting. See restricting input
database applications, 31, 295
database programs, 3, 295
database security, 225–256, 295
Database Splitter Wizard, 238
database structure, 32
creating empty, 41
database windows, 5, 295
maximizing, 8
minimizing, 8
navigation areas, 9
turning off display at startup, 214
Database Wizard, 33, 36
databases
access, authorizing, 240
allowing users to directly manipulate data (see data access pages)
applications, 31
back-end, 238
backing up, 238
backing up, with Briefcase, xlii, 235
benefits of, 2
blank, creating, 41, 146
closing, 6
columns (see columns)
compacting, xl, 218–19
converting into MDE files, irrevocability of, 256
copying tables between, 79
copying/pasting information from, 78
creating blank, 41
creating empty, 41
creating, with wizards, 33
data, entering, 31
default storage location, 34
defined, 2
Design Masters (see Design Masters)
Detect and Repair command, 218
distributing as MDE files, 254
documenting, 218, 221
encrypting/decrypting, 226
entering data, 31
exporting, as HTML, xliv, 261
filling with data, 31
flat, 3
forms (see forms)
front-end, 238
importing from, 66–67
linking, 76
losing, 282
macros (see macros)
merging, 66
modules (see modules)
multiple tables in, 41
multiple users, 231
naming, 33–34
navigation areas, 9
on networks (see sharing databases)
non-Access, importing from, 68
Northwind Traders, 22
objects (see objects)
opening, 4
opening, errors when, 282
opening, exclusively, 230
pages (see data access pages)
password protecting (see passwords)
populating, 31
properties, 218
publicly distributed, securing, 254
queries (see queries)
records (see records)
relational, 3, 57
repairing, xl, 218, 219
replicating, 233–238
reports (see reports)
restricting access to, 213
rows (see rows)
sample, 22
saving as MDE files, 255, 257
sharing (see sharing databases)
splitting, 238–240
startup options, 213
structure (see database structure)
switchboards (see switchboards)
synchronizing, 233, 237
windows (see database windows)
Datasheet view, 6, 295
Field Properties section, 46
opening tables in, 8, 44
primary key icons, 46
printing tables in, 23
switching to, 148
switching to Design view from, 6, 50
switching to from Design view, 45
datasheets, embedded. See subdatasheets
date and time
custom formats, creating, 182
entering, 149
formatting, 49
inserting, 183, 189
specifying permitted range for, 50
Date and Time dialog box, xxxix, 189
dates
custom formats, creating, xxxviii
inserting, xxxix
dBASE, importing from, 68
declaring variables, 265
requiring, 269
decrypting, 295 See encrypting/decrypting
default field properties, 44
default views, 112
defining
fields, 147
variables (see declaring variables)
Delete button, 281
delete queries, 130, 170, 295 See also queries
converting select queries into, 171
running, xxxvii 172
saving, 172
unintended effects, 170
deleting
EmailAddress field, 50
fields, 50
filters, xxxiii, 122, 166
footers, from reports, 193
headers, from reports, 193
labels, xxxviii, 90, 182
lines, in reports, 182
passwords, 230
passwords, for VBA code, 254
primary keys, 46
records, irrevocability of, 170
relationships, 109
from tables, 170
from tables with relationships, 171
text boxes, 193
delimited text files, 61, 295
delimiter, 295
Description column, 46
deselecting controls, 90 See also controls
Design button, 101
design grids, 11, 13, 295 See also queries
clearing, xxxiv, 127
columns in, sizing to fit, 137
copying fields to, 127, 133
for filtering, 126
Design Masters, 233, 295
Design view, 6, 86
columns in, 46
defined, 295
forms in, 15
icon associated with, 197
opening forms in, 87
queries in, 13
reports in, 20
switching to Datasheet view from, 6, 50
switching to from Datasheet view, 45
viewing reports in, 181
viewing switchboards in, 206
desktop shortcuts, 246
Detail section, resizing, 96
Details button, 7, 12
Detect and Repair command, 218
DHTML, 295
dialing phone numbers, 38
dialog boxes, moving, 88
Dim statements, 265
disabling. See turning off
displaying
field names, 47
form footers, 93
form properties, 88
forms switchboard, 37
hidden columns, xxix, 53
hidden files/folders, 252
list of controls, 96
multiple tables, 7
New File task pane, xxviii, 32
object descriptions, 7
queries, all, 12
query commands, 168
query types, 12
report header/footers, 186, 194
reports, 20
reports switchboard, 40
toolbox, xxvii, xxxviii, 18, 97, 188
Visual Basic Editor components, 264
distributing databases as MDE files, 254
documenting databases, 218, 221 See also databases
downloading, 33
duplicate queries, 129, 295 See also queries
Dynamic Hypertext Markup Language (DHTML), 295
dynamic Web pages, 260, 296
Active Server Pages (ASP), 260
data access pages (see data access pages)
E
Edit Switchboard Item dialog box, 204
Edit Switchboard Page dialog box, 203
editing
captions, 90
label captions, 90
relationships, 108–109
shortcuts, 247
switchboards, 203, 205, 207
text box control sources, 90
EmailAddress field, deleting, 50
embedded datasheets. See subdatasheets
empty strings, allowing, 145
encrypting, 296
encrypting/decrypting, 226–228
compression and, 228
databases, 226
enforcing referential integrity, 108
entering
dates, 149
records, 37
text, 149
event, 296
events, 100–104
attaching VBA code to, 102
firing, 101
procedures associated with, 264
recognized by object, list of, 100
Excel. See Microsoft Excel
exclusive use, 296
expanding subdatasheets, 8 See also subdatasheets
experimenting with controls, 96
exporting, 58, 73
databases, as HTML, xliv, 261
defined, 296
forms, 73
to HTML files, 76
macros, 73
modules, 73
pages, 73
queries, 73
reports, 73
reports, to static Web pages, xliv, 261
tables, 73
tables, to Excel, 74
transforms and, 72
Expression Builder, 137, 296 See also expressions
creating validation rules with, 157
dialog box, xxxiv, 134
functions in, 134
opening, 137
expressions, 129, 296
Access objects in, 169
arithmetic operators, 129
building (see Expression Builder)
comparison operators, 129
computing percentage in, 136
creating, with Expression Builder, 137
criteria, 129
entering in text boxes, xxxix, 195
Expression Builder (see Expression Builder)
logical operators, 129
multiplying in, 136
operators, 129
renaming, 137
ScreenTips for, 272
validation rules (see validation rules)
Extensible Markup Language (XML), 296 See also XML files
F
Field Name column, 46
field names
captions for, 47
changing, 47
Datasheet view display, 47
spaces in, 45
field properties, 145
Caption, 47
default, 44
displaying information on, 46
Field Size, 47–48
Format, 47
Indexed, 47
Input Mask, 49
New Values, 47
Validation Rule, 50
Field Properties section, 46
Field Size field property, 47–48
fields, 2, 43, 145, 296
applying smart tags to, 54
captions, 47
copying, to design grids, 127, 133
data type (see data types)
data, formatting, 47, 49
dates, specifying range for, 50
default entries, specifying with input masks (see input masks)
defining, 147
deleting, 50
EmailAddress, deleting, 50
empty strings, allowing, 145
filtering, by multiple selection, 123
form, 86
formatting data in, 47, 49
graphics in, 48
including in queries, xxxiv
indexing, disallowing duplicates, 47
limiting size, 48
long integers in, 47
moving, 120
names (see field names)
number, properties for, 150
numbers in, 47–48
phone numbers, requiring area codes for, 155
phone numbers, restricting to specific area codes, 158
properties (see field properties)
in queries, 132
in queries, hiding, 139
random numbers in, 47
renaming, 43
required, 145
restricting data types, 146
restricting input, 149
restricting length, 154
restricting to specific options (see lookup lists)
sample, 42
selecting, 42, 159
selecting, for tables, 42
size, controlling, 48
size, restricting input with, 150
size, setting, 150–51
sorting multiple, 120
table, 43
in Table Wizard, 42–44
times, specifying range for, 50
zero length, allowing, 145
fields. See also columns
file name extensions, 61
File New Database dialog box, 33, 146
files
binary, 226
hidden, displaying, 252
naming, 34
Filter By Form button, xxxiv, 125
Filter By Selection button, xxxiii, 122
filtering, 121–128
advanced, xxxiv, 127
applying filters, xxxiv, 125
criteria, 125
deleting filters, xxxiii, 122
design grids for, 126
displaying results, 123
excluding selection when, 122
by form, 123
vs. queries, 130
saving filter as query, 126
by selection, xxxiii, 122–123
sorting (see sorting)
tables, multiple, 129
wildcard characters, 121–122
filters
applying, xxxiv, 125
deleting, xxxiii, 122
removing, 166
saving as queries, 126
finding, 117
records, 124
text, 166
VBA objects, 264
finishing wizards, 35
firing events, 101
First Record button, 112
fixed-width text files, 63, 296
file name extensions, 61
importing, 64–65
flag, 296
flags, VBA, 273
flat databases, 3, 296
folders, displaying hidden, 252
font weight, for controls, 91
footers, form, 93
footers, report
adding to groups, xxxviii, 184
deleting, 193
displaying, 186, 194
Form view, 14, 86, 296
viewing splash screens in, 211
Form Wizard
Available Fields list, adding fields to, 85
creating subforms with, 114
starting, xxxi, 85
Format field property, 47
drawbacks of, 50
Format Painter button, 99
formatting
controls, all, 89
copying, 99
dates, 49
field data, 47, 49
label backgrounds, 89
labels, 98, 194, 210
subreports, xxxix, 193
forms, 14–18, 83–114, 296
AutoForms, 104–105
backgrounds, xxxii, 91, 93
benefits of, 14
Calls, 39
combo boxes, 98
command buttons (see command buttons)
control sources, 86
controls (see controls)
created with all fields in table, 104–105
creating, xxxii, 105
creating, manually vs. with wizards, 84
creating, with subforms, 114
creating, with wizards, xxxi, 84–85
vs. data access pages, 276
in Design view, 15
exporting, 73
fields in, 86
filtering by, 123
font, changing, 88
footers, displaying, 93
headers, adding captions to, xxxii, 97
label controls, 15
labels (see labels)
layout, applying, 85
layout, customizing, 92
main form, 15
multiple tables in, 178
new, displaying, 16
for new tables, opening, 43
opening, 17
opening, in Design view, 87
opening, in switchboards, 216
option buttons, 83, 160
pointer shapes, 92
properties of, 87–88
record selectors (see record selectors)
record sources, 86
rectangles, adding, 208
Report Date Range, inability to open, 40
vs. reports, 176
saving, 92
scroll bars, removing, 106
scrolling through, 86
sections, resizing, 96
shortcut menus, restricting access to, 216
sorting records in, 120
styles, applying, 105
subforms (see subforms)
switchboards (see switchboards)
text box controls (see text box controls)
viewing, 99
views, 14
views, switching, 17
views (see also Design view Form view)
Forms Switchboard window, 37
Forms view, opening switchboards in, 206
formulas. See expressions
freezing columns, 54
front-end databases, 238, 297 See also databases
function, 297
function procedures, 265, 297
functions
aggregate, 140
currency conversion, 135
in Expression Builder, 134
G
graphics. See images
group, 297
grouping
controls, 183
records, 186
Grouping Intervals dialog box, 178
grouping level, 297
in reports, 178
Grouping Options button, 178
groups, security, 240 See also users
assigning users to, 245
default, 240
permissions, modifying, 250
permissions, viewing, 243
H
headers, form, 97
captions, adding, xxxii
headers, report
deleting, 193
displaying, 186
for groups, 187
hidden files/folders, displaying, 252
hiding
buttons, on data access pages, 282
columns, xxix, 53, 166
fields, in queries, 139
toolbars, 214
Visual Basic Editor components, 264
HTML
code, viewing, 262
exporting databases as, xliv, 261
tags, 69, 259
HTML files
exporting to, 76
importing, 70
importing from, 69
HTML pages. See Web pages
HTML tag, 297
Hypertext Markup Language (HTML), 297
I
icon
Access, changing 214
primary key 46
IDE. See Visual Basic Editor
Image button (Toolbox), 209
images
in fields, 48
inserting in controls, 97
in splash screens, 209
Import Objects dialog box, 67
Import Spreadsheet Wizard, 59
Import Text Wizard, 61
Import XML dialog box, 72
ImportError tables, 60
importing, 57
databases, 66–68
from dBASE, 68
defined, 297
from delimited text files, 61
Excel documents, 58
into existing tables, 60
fixed-width text files, 64, 65
HTML files, 69–70
from Lotus 1-2-3, 68
objects, 66
from Paradox, 68
query results, as table, 66
saving settings for, 62
spreadsheets, 59
text files, xxix, 61
transforms and, 72
worksheets from Excel, 58
XML files, 71
increasing row height, xxviii, 52
Indexed field property, 47
indexing field information, 47
Input Mask field property, 49
drawbacks of, 50
Input Mask Wizard, 154
starting, xxxvi
input masks, 49, 152–157, 297 See also restricting input
applying universally, 156
characters in, 153
characters, literal, 153
creating, xxxvi, 154
drawbacks of, 50
insertion point, moving, 155
placeholder character, selecting, 155
restricting field input with, 152
testing, 156
text in, 156
wizard for creating, 154
inserting
check boxes, in splash screens, 210
combo boxes, 98
copyright symbol, 280
date and time, xxxix, 183, 189
line breaks, in VBA, 267
lines, in reports, 184
logos, in splash screens, 209
Option Explicit declaration, 269
page numbers, in reports, xxxix, 190
pictures, in controls, xxxii, 97
reports, xxxvii, 176
splash screen labels, 209
sub procedures, 269
text boxes, in reports, xxxviii, 182
unbound controls, 194
installing
Briefcase, 234
modems, 38
intranets, 58, 297
introductory screens. See splash screens
J
joining workgroups, 248
K
keyboard shortcuts
opening Visual Basic Editor, xliii, 253
selecting all, 89
undoing, 91, 193
keyword, 297
keywords, VBA, 265
L
Label button (Toolbox), 209
label controls, 15, 297 See also controls
labeling
reports, xxxviii, xxxix, 188
switchboard buttons, 204
labels, 83
aligning, 90, 210
backgrounds, formatting, 89
captions, editing, 90
deleting, xxxviii, 90, 182
expanding to fit text, 188
font, changing, 87–88
font, configuring, xxxviii, 188
formatting, 98, 194, 210
inserting in splash screens, 209
resizing, 210
selecting, 88, 183
selecting multiple, 90
sizing, to fit contents, 91
spacing from text boxes, 91
text, centering, 98
Landscape orientation, printing, 26
LANs. See local area networks (LANs)
layout
form, 85
form, customizing, 92
previewing, 19, 197
Layout Preview, 19, 197, 297 See also Print Preview
opening, 198
line breaks
inserting in VBA code, 267
lines, report
inserting, 184
selecting hidden, 185
Link Spreadsheet Wizard, 78
Link Tables dialog box, 76
linking, 58
databases, 76
defined, 297
lookup lists to tables, 161
tables, 76
to files on LANs, 76
links, updating, 283
lists
bulleted, 280
of data types, 46
lookup (see lookup lists)
with specific names for field input (see lookup lists)
local area networks (LANs), 297
linking to files on, 76
sharing databases on, 231
locating. See finding
locking
columns, 54
records, edited only, 232
records, pessimistic vs. optimistic, 231
VBA code, xliii, 253
logging on to workgroups, 249 See also workgroups
logical operators, 297 See also expressions
Logon dialog box, 246
logos, inserting in splash screens, 209
Long Integer data type, 47
lookup lists
allowing users to make new entries in, 163
creating, with Lookup Wizard, 161
linking to tables, 161
restricting input with, 160
Lookup Wizard, 161, 298
losing data access pages/ databases, 282
Lotus 1-2-3, importing from, 68
lowercase text, requiring in fields, 157
M
macros, 22, 298
exporting, 73
vs. modules, 22
for switchboards, 204
uses for, 22
magnifying. See zooming
mailing labels, reports for, 20
main form, 15, 298
main reports, 186, 298 See also reports
make-table queries, 130, 298 See also queries
manually saving, impossibility of, 37
many-to-many relationships, 107, 298 See also relationships
mapped network drive, 298
margins, setting, 184, 298 See also input masks
Maximize button, 8
maximizing database windows, 8
MDE (Microsoft Database Executable) files, 298
conversion into, irrevocability of, 256
creating, 256
distributing databases as, 254
saving databases as, 255, 257
MDE files, creating, xliii
menu bars, toggling between, 217
menus
custom, 214
shortcut, 216
merging
databases, 66
tables, with Word document, 79
Microsoft Access
cross-compatibility of, 3
icon, changing, 214
objects, in expressions, 169
Special Keys, 217
specifications, 6
starting, 4, 212
Microsoft Active Server Pages (ASP) See Active Server Pages
Microsoft Database Executable (MDE) See MDE files
Microsoft Excel
exporting tables to, 74
importing documents from, 58
importing named ranges from, 58
pasting Access data into, 78
pasting into, 79
Microsoft Visual Basic for Applications. See VBA
Microsoft Word, 78–79
Microsoft Works Database component, 3
minimizing database windows, 8
missing records, 13
modems, 38
modifying
controls, multiple, 185
permissions, 250
reports, 180–185
switchboards, 207
workgroups, 252
modules, 22, 263, 298 See also procedures
class, 263
creating, 268
Declarations section, 265
displaying all procedures in, 264
exporting, 73
vs. macros, 22
Option Explicit declaration (see Option Explicit declaration)
procedures in, displaying, 265
requirements, setting, 265
saving, 268
standard, 263
uses for, 22
More Controls button, 96
moving
controls, incrementally, 94
data access pages, errors when, 283
dialog boxes, 88
fields, 120
text boxes, 94
toolbox, 18
multiplying in expressions, 136 See also expressions
N
named range, 298
importing from Excel, 58
naming
databases, 33
queries, 137
switchboards, 203
native format, 298
navigating wizards, 34
navigation areas, 9
navigation button, 298
network security, 231, 298
network server, 298
New button, 146
New Data Access Page dialog box, xliv, 277
New File task pane, 4
displaying, xxviii, 32
New Form dialog box, xxxii, 105
New Record button (Navigation bar), 16, 104
New Report dialog box, xxxvii, 176
New Table dialog box, xxviii, 41
New Values field property, 47
Next Page button (Navigation bar) , xl, 198
Next Record button, 10, 113
Northwind Traders database, 22
not equal sign, 13
number fields, 150 See also fields
numbering automatically, 46
numbers, 48
formatting, 48
increasing sequentially, 47
random, 47
sorting, 119
Next
Last Updated: June 17, 2004
|
