|
|
 |
|
|
|
Microsoft® Access Version 2002 Step by Step
|
|
|
Author
|
|
Online Training Solutions, Inc.
|
|
|
Pages
|
352
|
|
Disk
|
1 Companion CD(s)
|
|
Level
|
Beg/Int
|
|
Published
|
06/06/2001
|
|
ISBN
|
9780735612990
|
|
Price
|
$29.99
To see this book's discounted price, select a reseller below.
|
|
|
|
|
|
|
|
|
Index
A
Access. See Microsoft Access
Access objects
data access pages (see data access pages)
in expressions, 156
access to VBA code, controlling, 237
action queries, 119
converting select queries into, 156
creating, 156
actions. See events
Active Server Pages (ASP), 244
advanced filtering, 116
aggregate functions, 128
aligning label text, 80
analyzing performance, 204, 206
apostrophes in VBA, 93
append queries, 119
application title, renaming, 200
applying
filters, 114
form layout, 75
startup options, 201
styles, 28
styles, to forms, 96
themes, to data access pages, 271
area codes, requiring for phone numbers, 143
arithmetic operators, 118
ASCII, 53
ASP (Active Server Pages), 244
assigning
passwords, 216
permissions, 228
users to groups, 230
authorizing database access. See user-level security; workgroups
autocomplete, in Visual Basic Editor, 250
AutoFormats, creating new, 85
AutoForms, 94
background styles for, 96
automatically
numbering, 39
saving, 31
automating actions. See macros; modules
AutoNumber data type, 39
AutoPage, creating data access pages with, 261
B
back-end databases, 223–24
backgrounds
AutoForm, styles for, 96
form, 81
form, resizing, 84
label, 79
backing up
before running update queries, 156
databases, 224
tables, 156
binary files, 212. See also databases
blank databases, creating, 34
Boolean data type, 135
display options, 138
borders
of controls, color of, 80
subreport, transparent, 182
Briefcase
folder, creating new, 219
installing, 220
renaming, 220
replicating databases to, 219
updating, 222
browsers. See Web browsers
building expressions, 123
business tables, 35
C
Calls form, 32
Caption property, 40
captions
adding to form headers, 87
for combo boxes, 89
for fields, 40
for labels, 80
changes, undoing, 31
changing. See also editing
Access icon, 200
data types, 41
delimiters for delimited text files, 54
field names, 40
font, on form labels, 77
passwords, 236
primary key fields, 39
query criteria, 155
characters
in input masks, 141–42
uniformly spaced (see fixed-width text files)
check boxes, inserting in forms, 196
checking
variable spelling, 250
VBA code syntax, 255
wizard results, 30
class modules, 247
clearing design grids, 116
closing
data type list, without making changes, 39
databases, 6
dialog boxes, 32
switchboards, 6
switchboards, automatically, 190
tables, 10
code, for tables in Web pages, viewing, 67
code, VBA, 247
collapsing datasheets, 10
colors, 79
columns, 2
adjacent, selecting, 46
Data Type, 39
Description, 39
in Design view, 39
Field Name, 39
freezing, 47
headings, setting, 51
hiding, 46
locking, 47
resizing, 8, 45
restoring, 46
selecting, 110
selecting adjacent, 46
sizing to fit, 103
unhiding, 46
widening, 8, 45
combining XML data and schema, 66
combo boxes, 88–89 see also lookup lists
comma-delimited text files, importing, 52
command buttons, adding to forms, 197
command shortcuts in Names list, hiding, 8
comments, VBA, 93, 249
compacting databases, 204
comparing databases, 219
comparison operators, 118
compression, 214
configuring splash screen pictures, 195
ConnectionString property of data access pages, 264
control source, 76, 80
controlling
access, to VBA code, 237
database access, 214
field input, 133
controls, 15
borders, color of, 80
combo boxes, 88
deselecting, 80
disabling, 96
displaying list of, 85
experimenting with, 86
font weight, 81
formatting all at once, 79
grouping, 169
incrementally positioning, 84
label, 16, 73
pictures in, 87
positioning, precisely, 84
properties, 78
ScreenTips for, 87
selecting all, 79
selecting multiple, 169
shadowing, 80
sizing, to fit, 88
text box, 16, 73
turning off, 96
unbound, 88
converting
databases, into Design Masters, 218
databases, into MDE files, irrevocability of, 240
reports, into subreports, 177
select queries, into action queries, 156
select queries, into delete queries, 158
copying
data, 69
fields, to design grids, 116, 121
formatting, 88
records, 70
tables, 69
VBA code, 254
copyright symbol (©), inserting, 267
creating
action queries, 156
AutoFormats, 85
back-end databases, 224
blank databases, 34
Briefcase, new, 219
custom date formats, 168
data access pages, manually, 273
data access pages, with AutoPage, 261
data access pages, with Page Wizard, 269
database replicas, 218
database structures, 26
databases, back-end, 224
databases, blank, 34, 134
databases, with empty structures, 34
expressions, with Expression Builder, 123
forms, manually vs. with wizards, 74
forms, with subforms, 105
lookup lists, with Lookup Wizard, 148
modules, 252
queries, 120
records, 94
relationships, 99
reports, from scratch, 171
reports, with wizards, 162
static HTML pages, 245
styles, 85
subdirectories, with VBA, 258
subforms, 100
subreports, 176
switchboard forms, 190
switchboards, 188
tables, 34–35
validation rules, 145
validation rules, by hand, 145
Web pages, with VBA, 252
workgroup information file (WIF), 227
workgroups, 227
criteria, 14, 118
crosstab queries, 119
currency conversion function, 124
custom menus and toolbars, disallowing changes to, 201
customizing colors, 79
D
DAP. See data access pages
data
copying, 69
linking, 67
merging with Word mail merge document, 70
moving in and out of databases, 69
pasting, 69
restricting (see restricting input)
sharing, 69
data access pages , 22, 244, 261
applying themes to, 271
ConnectionString property, 264
creating, manually, 273
creating, with AutoPage, 261
creating, with Page Wizard, 269
elements, properties of, 268
errors when moving or opening, 264
Field List, 262, 273
vs. forms, 262
layout, modifying, 268
losing, 264
moving, errors caused when, 264
opening, errors when trying to, 264
paths to data sources, 264
and PivotTables, 273
renaming, errors caused when, 264
vs. reports, 262
saving, 263
toolbox, displaying, 274
viewing, 262, 265
Data Type column, 39
data types
AutoNumber, 39
Boolean, 135, 138
changing, 41
date, 137
descriptions of, 39
importing, 52
list of, 39
Long Integer, 40, 62
OLE Object, 41
for phone numbers, 41
restricting input with, 134
setting, 135
Yes/No, 135, 138
data warehouses, 219
database applications, 25
database programs, 2
database windows, 6
display at startup, turning off, 200
maximizing/minimizing, 8
navigation areas, 10
Database Wizard, 27, 30
databases, 2
authorizing access (see user- level security)
back-end, 223
backing up, 224
benefits of, 2
blank, creating, 34
changes to, undoing, 31
closing, 6
columns (see columns)
compacting, 204
comparing, 219
controlling who can open, 214
converting, into Design Masters, 218
converting, into MDE files, irrevocability of, 240
creating blank, 34, 134
creating, with wizards (see wizards)
data, entering, 25
Database Wizard, 27
decrypting, 214
default folder for storing, 27
default format, 3
Detect and Repair command, 204
distributing, 218
distributing, as MDE files, 239
documenting, 204
encrypting, 212
entering data, 25
errors when opening, 264
exporting, 50
exporting, as HTML, 245
fields (see fields)
file name extensions, 5
filling with data, 25
flat, 2
forms (see forms)
front-end, 223
importing, 49, 57
linking, 49, 67
losing, 264
macros (see macros)
merging, 219
minimized, restoring, 6
modules (see modules)
multiple tables in, 2, 34
multiple users (see databases, sharing)
naming, 27
naming conventions, 27
navigation areas, 10
on networks (see databases, sharing)
non-Access, importing from, 59
Northwind Traders, 23
objects (see objects)
opening, exclusive, 215
opening, existing, 4–5
opening, new, 5
pages (see pages)
password protecting (see passwords)
populating, 25
properties, 205
publicly distributed, securing, 239
publishing to the Web (see dynamic Web pages; static HTML pages; Web pages)
queries (see queries)
records (see records)
relational (see relational databases)
repairing, 204
replicating, 218–19
reports (see reports)
rows (see rows)
sample, 23
security (see security)
sharing, 216–18
single-table, 2
splitting, 223
splitting, backing up before, 224
storing, default folder for, 27
structure, 25–26
structure, avoiding redundancy in, 49
structure, creating empty, 34
switchboards (see switchboards)
synchronizing, 219
tables (see tables)
undoing changes to, 31
uses for, 2
windows (see database windows)
Datasheet view, 7
Field Properties section, 39
opening tables in, 10, 37
primary key icons, 39
switching to Design view from, after making changes, 43
switching to/from Design view, 7, 38, 43
datasheets, embedding in one another. See subdatasheets
dates
custom formats, creating, 168
entering, 137
formatting, 42
inserting, 169
specifying permitted range for, 43
dBASE, importing from, 59
declaring variables, 250
requiring (see Option Explicit declaration)
decrypting databases, 214
default field properties, 37
default file name extensions, 27
default views, 102
defining
custom colors, 79
fields, 135
variables, 250
delete queries, 119, 157
converting select queries into, 158
saving, 159
unintended effects, 157
deleting
EmailAddress field, 44
fields, 44
filters, 111
footers, from subreports, 178
from tables with relationships, 159
headers, from subreports, 178
labels, 80
labels, in reports, 168
lines in reports, 168
linked tables, 69
primary keys, 39
records, irrevocability of, 157
relationships, 99
table information, 157
tables, linked, 69
delimited text files, 52–54
Description column, 39
deselecting controls, 80
design grids, 12, 14
clearing, 116
columns in, sizing to fit, 126
copying fields to, 116, 121
for filtering, 115
Design Masters, converting databases into, 218
Design view, 7, 76
columns in, 39
forms in, 15
opening forms in, 76
queries in, 14
reports in, 21
switching to/from Datasheet view, 7, 38, 43
desktop shortcuts. See shortcuts
Details button, 8
Detect and Repair command, 204
dialing numbers, 32
dialog boxes
closing, 32
moving, 78
Dim statements, in VBA, 250
disabling controls, 96
displaying
commands for, query commands, 155
data type list, 39
dates, 169
field names, 40
filter results, 112
form footers, 83
form properties, 78
forms switchboard, 17, 30
hidden columns, 46
hidden folders/files, 237
information from multiple tables, 8
list of controls, 85
object descriptions, 8
procedures in modules, 248
queries, all, 13
query types, 13
report header/footers, 172
reports, 20
reports switchboard, 33
source code, for tables in Web pages, 67
tables, on Web pages, 60
task pane, 5
toolboxes, 86, 172
Visual Basic Editor components, 248
distributing databases, as MDE files, 239
documenting databases, 204
downloading templates, 27
dynamic Web pages, 244
Active Server Pages (ASP), 244
allowing users to directly manipulate data in (see data access pages)
data access pages (see data access pages)
generating different views in response to user choices (see ASP)
E
editing
captions, 80
relationships, 98–99
shortcuts, 232
switchboard properties, 189
text box control sources, 80
EmailAddress field, deleting, 44
embedded datasheets. See subdatasheets
empty strings, 133
encrypting, 212, 214
enforcing referential integrity, 99
entering
dates, 137
records, 30
errors when importing, 52
events, 90
attaching VBA code to, 92
firing, 91
and procedures, 249
recognized by object, list of, 90
responding to (see macros)
VBA, 249
Excel. See Microsoft Excel
expanding datasheets, 9
experimenting with controls, 86
exporting, 50, 64
databases, as HTML, 245
formats for, 64
to HTML files, 67
tables, 65
tables, to Excel worksheets, 70
XML, 66
Expression Builder, 123
expressions, 118
Access objects in, 156
arithmetic operators, 118
comparison operators, 118
computing percentage in, 125
creating, with Expression Builder, 123
criteria, 118
Expression Builder, 123
logical operators, 118
multiplying in, 124
operators, 118
renaming, 126
ScreenTips for, 257
validation rules (see validation rules)
Extensible Markup Language. See XML
F
Field Name column, 39
field names, importing, 52
field properties
Caption, 40
default, 37
displaying information on, 40
Field Size, 40–41
Format, 40
Indexed, 40
Input Mask, 42
New Values, 40
Validation Rule, 43
Field Properties section, 39
Field Size field property, 40–41
fields, 2
allowing only particular data types, 134
allowing zero length, 133
captions, 40
controlling input, 133
copying to design grids, 116, 121
data, formatting, 42
data types, 39, 134
dates, specifying permitted range for, 43
default entries, specifying with input masks, 144
defining, 135
deleting, 44
EmailAddress, deleting, 44
empty strings in, 133
formatting data in, 40, 42
in forms, 76
graphics in, 41
indexing, disallowing duplicates, 40
limiting size, 41
long integers in, 40
moving, 110
names, 40
names, spaces in, 38
numbers in, 40
numbers in, number of digits for, 41
PostalCode, 62
properties (see field properties)
providing specific choices in, 148
in queries, hiding, 127
in queries, including, 121
quotes around, 52
random numbers in, 40
renaming, 37
requiring, 133
restricting input, 133
selecting, 35
size, 41, 138–39
sorting, multiple, 110
in Table Wizard, 35
in Table Wizard, renaming, 37
times, specifying permitted range for, 43
zero length, allowing, 133
file name extensions
for databases, 5
default, 27
not recognized by Access, 53
for text files, 53
for XML, 63
files
binary, 212
hidden, displaying, 237
text (see text files)
filtering, 110
advanced, 116
applying filters, 114
criteria, 114–15
deleting filters, 111
design grids, 115
excluding selection, 111
by form, 113
by multiple selection, 112
multiple tables (see queries)
vs. queries, 119
results, displaying, 112
saving as query, 116
by selection, 111
with wildcards, 111
finding
specific information, 107
text, 154
finishing wizards, 28
firing events, 91
fixed-width text files
adjusting dividing lines in, 57
file name extensions, 53
importing, 54
importing, problems with, 56
flags, VBA, 258
flat databases, 2
folders
for storing databases, default, 27
hidden, displaying, 237
font
of form labels, changing, 77
weight, for controls, 81
footers, form, 83
footers, report, 172
footers, subreport, 178
Form view, 15, 76
Format field property, 40
Format Painter, 88
formats, Short Date, 42
formatting
controls, all at once, 79
copying, 88
dates, 42
field data, 40, 42
labels, 79, 88
number of digits in numbers, 41
subreports, 178
forms, 15, 73
applying styles to, 96
AutoForms, 94
backgrounds, 81
backgrounds, resizing, 84
benefits of, 15, 73
check boxes, 196
combo boxes (see combo boxes)
command buttons, adding, 197
control source, 76
controls (see controls)
created with all fields in table, 94
creating with subforms, 105
creating, manually vs. with wizards, 74–75
vs. data access pages, 262
in Design view, 15
export formats, 64
fields in, 76
filtering by, 113
footers, displaying, 83
headers, adding captions to, 87
label controls, 16
labels (see labels)
layout, customizing, 82
main form, 16
multiple tables in, 164
for new tables, opening, 36
opening, in Design view, 76
pointer shapes, 82
properties of, 77–78
record source, 76
Report Date Range, inability to open, 34
vs. reports, 162
saving, 82
scrolling through, 76
sorting records in, 110
subforms (see subforms)
switchboards (see switchboards)
text box controls, 16
text boxes (see text boxes)
uses for, 15
views for, 15
views, switching, 18
Forms view, opening switchboards in, 192
formulas. See expressions
freezing columns, 47
front-end databases, 223
function procedures, 249
functions
aggregate, 128
currency conversion, 124
in Expression Builder, 123
G
graphics in fields, 41
grouping
controls, 169
records, 172
grouping levels in reports, 165
groups, security. See user-level security
H
headers, report, 172
headers, subreport, 178
headings, column, 51
hidden files and folders, displaying, 237
hiding
columns, 46
command shortcuts in Names list, 8
fields, in queries, 127
toolbars, 201
Visual Basic Editor components, 248
HTML
code, viewing, 246
exporting databases as, 245
files (see HTML files)
pages, static, 244
similarity to XML, 63
static pages, 245
tags, 60, 243
tags, for tables, 60
tags, nonstandard, 243
viewing, 246
HTML files
exporting to, 67
importing from, 60
Hypertext Markup Language. See HTML
I
importing, 49
from Access databases, 57
comma delimited text files, 52
data types, 52
databases, 57
from dBASE, 59
from delimited text files, 52
errors, 52
from Excel, 50
from Excel, benefits of, 50
from Excel, Import Spreadsheet Wizard, 50
failure of, 52
field names, 52
fixed-width text files, 54, 56–57
from HTML files, 60
from Lotus 1-2-3, 59
from non-Access databases, 59
objects, 57–58
from Paradox, 59
problems with, 52
queries, 57
settings for, saving, 53
tables, 57
text files, 52–53
transaction records, 59
XML data, 63
increasing row height, 45
Indexed field property, 40
indexing field information, 40
Input Mask field property, 42
drawbacks of, 43
input masks, 42, 141
characters in, 141–42
drawbacks of, 43
moving insertion point in, 143
restricting field input with, 140
testing, 144
text in, 144
wizard for, 142
inserting
check boxes, in forms, 196
combo boxes, 88
copyright symbol, 267
date and time, 169
line breaks, in VBA, 251
Option Explicit declaration, 253
reports, 163
splash screen labels, 196
sub-procedures, 253
text boxes, in reports, 168
insertion point in input masks, moving, 143
installing
Briefcase, 220
modems, 32
intranets, benefits of, 50
introductory screens, 5
Next
Last Updated: Friday, July 6, 2001 |
