|
|
 |
|
|
|
Microsoft® Office Access 2003 Inside Out
|
|
|
Author
|
|
John L. Viescas
|
|
|
Pages
|
1344
|
|
Disk
|
1 Companion CD(s)
|
|
Level
|
Int/Adv
|
|
Published
|
10/29/2003
|
|
ISBN
|
9780735615137
|
|
Price
|
$49.99
To see this book's discounted price, select a reseller below.
|
|
|
|
|
|
|
|
|
Index
NOTE:
Page numbers with the prefix A refer to articles on the companion CD, as follows:
A1–A44: Article 1
A45–A48: Article 2
A49–A56: Article 3
A57–A60: Article 4
Symbols
& (ampersand) character
concatenating fields, 233
Nulls, 306
& (and) character, 455
* (asterisk) character, 454, 456, 460
All Columns option, 654
queries, 223
operator, 235
@ (at) character, 455
\ (backslash) character, 453, 456, 459
[ ] (brackets) character, 454, 456, 460
() (digit display) character, 453
\ (divide) operator, 235
= (equal to) operator, 112
! (exclamation mark) character, 453–456, 799–801
> (greater than) operator, 112, 455
>= (greater than or equal to) operator, 112
< (less than) operator, 112, 455
<= (less than or equal to) operator, 112
! mask character, 114–115
# mask character, 114–115
& mask character, 114
:; – / mask character, 115
? mask character, 114
# (number) character, 453
/ operator, 235
^ operator, 235
% (percentage) character, 454
. (periods), 799–801
+ (plus sign)
concatenating fields, 234
operator, 235
# (pound sign), 227
# (wildcard) character, 113
? (wildcard) character, 113
Numerics
0 mask character, 114
9 mask character, 114
A
a tag, 964
a mask character, 114
A/P character, 459
ABS function, A49
action queries
append queries, 352–353
creating, 353–355
running, 355–356
delete queries, 356–360
deleting inactive data, 359–360
running, 358–359
testing with select queries, 356–358
make–table queries, 346–352
creating, 346–350
limitations, 351
running, 350–352
SQL, A38
DELETE statement, A38–A39
INSERT statement, A39–A41
SELECT…INTO statement, A41–A42
UPDATE statement, A42–A44
troubleshooting, 360–362
data conversion errors, 360
duplicate primary keys, 360
error example, 361–362
locked records, 360
validation rule violations, 360
update queries. See update queries
action argument, 833
actions, custom, 934–936
Activate event, 720
Active Server Pages. See ASP
ActiveX, 7, 872
controls, 515–518
ActiveX objects, 975. See also ADO
forms, 376–378
adAsyncFetch option (Open method parameter setting), 809
adAsyncFetchNonBlocking option (Open method parameter setting), 809
adCmdStoredProc option (Open method parameter setting), 809
adCmdTable option (Open method parameter setting), 809
adCmdTableDirect option (Open method parameter setting), 809
adCmdText option (Open method parameter setting), 809
Add a network place option, 1091
Add axis box, 334
Add Table command (Query menu), 644
Add Table dialog box, 632, 640, 644
Add This User to the List option, 1180
Add Watch command (Debug menu), 771
Add Watch dialog box, 771
<additional data object> tag, 1116
AddMenu macro, 740, 834
AddNew method, 807
Address field (Companies table), 111
Adjust the field width so all fields fit on a page option, 557
adLockOptimistic LockType (Open method parameter setting), 808
adLockPessimistic LockType (Open method parameter setting), 808
adLockReadOnly LockType (Open method parameter setting), 808
Admin user ID, 1165
Administer permission, 1167
Admins built–in group, 1166
ADO (ActiveX Data Objects), 181, 795, 975
architecture, 795–798
recordsets, 807–811
ADO Extensions for DDL and Security, 796
ADOConnectString property, 791
ADODB model, 796
adOpenDynamic cursor type (Open method parameter setting), 808
adOpenForwardOnly cursor type (Open method parameter setting), 808
adOpenKeyset cursor type (Open method parameter setting), 808
adOpenStatic cursor type (Open method parameter setting), 808
ADOX (ADO Extensions for DDL and Security), 796
.adp files, exporting data to, A45
Advanced Customization options, 1225
Advanced Customization window, 1225
Advanced Filter/Sort command, 276
advanced report design, 555–595
adding PivotCharts to reports, 592–595
designing PivotChart forms, 592–593
embedding PivotChart forms, 593–595
calculated values, 572–585
conditional formatting, 584–585
hiding redundant values, 578–580
page numbers, 572–573
percentages, 580–581
performing calculations, 573–578
print date, 572–573
running sums, 581–584
string concatenation, 578–580
complex reports, 556–557
creating Facility Occupancy by Date report
defining criteria, 559–561
grouping criteria, 559–561
report properties, 564–572
Report Wizard, 557–559
section properties, 562–564
sorting criteria, 559–561
subreports, 585–592
challenges, 586–588
creating reports with subreports, 589–592
After Del Confirm event property, 717
After Final Render event property, 725
After Insert event property, 717
After Layout event property, 725
After Render event property, 725
After Update event, 913
After Update event property, 717
AfterDelConfirm event, 717
AfterDelete event, data source control, 1069
AfterFinalRender event, 725
AfterInsert event, 717, 1069
AfterLayout event, 725
AfterRender event, 725
AfterUpdate event, 717, 1069
aggregate functions, 296–303, 330
aggregate queries, 648
Align Left 1 option (Report Wizard), 551
Align Left button (Formatting toolbar), 415
Align Right button (Formatting toolbar), 415
alignment, controls, 433–444
horizontal alignment, 441–444
Snap to Grid command, 440–443
text box controls, 544
vertical alignment, 441–444
All databases command, 134
All databases option, 635
All databases setting (Options dialog box, General tab), 635
ALL option, 655
All records option, Default record locking, 210
All rows from tblCompanies check box, 646
All rows from tblCompanies option, 646
AllForms collection, 944
Allow Additions property, 472
Allow AutoCorrect property, 466
Allow Deletions property, 472
Allow Design Changes property, 419, 477
Allow Edits property, 472
Allow Filters property, 472
Allow pivot filtering option, 1064
Allow pivot grouping option, 1064
Allow Zero Length property, 108
Alphanumeric data type (Paradox), 185
alt property, 967
Always prompt for new location check box, 216
Always show full menus option, 930, 936
Always trust files from this publisher and open them automatically option, 1199
AM/PM character, 459
American National Standards Institute. See ANSI
ampersand character (&)
concatenating fields, 233
Nulls, 306
AMPM character, 459
analysis of data, 64–67
subject mapping, 66–67
subject selection, 64
Analyze command (Tools menu), 136, 165, 944
Analyze It with Microsoft Office Excel command (Tools menu), A46
and (&) character, 455
AND operator, query criteria, 228–231
ANSI (American National Standards Institute), 179
API (Application Programming Interface), 19
append queries, 352–353
creating, 353–355
INSERT statement, A39
running, 355–356
Append Query command (Query menu), 354
application engine, 791–793
Application object, 791
Application Programming Interface. See API
applications
AutoKeys macro, 956–957
automating. See automating
client/server
benefits, 1134–1135
desktop database applications, 1136–1137
compiling Visual Basic procedures, 957–958
controlling flow, forms, 365–366
design, 53–81
analyzing tasks, 58–60
concepts, 67–79
construction, 55
data analysis, 64–67
data elements, 55
data selection, 61
organizing data, 55
performance, 79–80
point–in–time data, 80–81
prototype, 55
reporting data snapshots, 81
review and refinement, 56
strategy, 56–57
task flow, 54
task identification, 54
task organization, 63
testing, 56
user interface, 55
desktop
client/server architecture, 1136–1137
upsizing, 1135–1138, 1147–1162
development systems, 11–13
distributing
creating shortcuts, 1215–1218
execute–only databases, 1214–1215
linked tables, 1204–1210
Microsoft Visual Studio Tools, 1218–1219
runtime mode, 1213–1214
verifying server connections, 1210–1213
implementation, 51–52
order–entry, 57–58
Performance Analyzer Wizard, 944–945
setting startup properties, 952–953
shortcuts, creating, 1215–1218
starting and stopping, 953–956
Web applications, 961–971
ASP (Active Server Pages), 981–982
dynamic Web pages, 973–978, 982–984
HTML, 962–969
SharePoint, 978–979
static Web pages, 971–973, 979–980
XML, 969–971
Apply existing filter option, 1107
Apply Filter/Sort command (Filter menu), 271
ApplyFilter event, 722
ApplyFilter macro, 739
architecture
Access application, 791–793
ADO, 795–798
DAO, 793–795
arguments
interval, 236
macros, 745
arithmetic expressions
creating, 235–240
operators, 235
arithmetic functions, A49–A50
arithmetic operators, precedence, 237
<array dimension> specification, 780, 787
Arrow key behavior, 260
Arrow key behavior option, 260
As datatype clause, 813
Asc function, A49
ASCII function, A49
ASP (Active Server Pages), 13, 981–982
dynamic Web pages, 1001–1017
defining DSN, 1001–1003
exporting data, 1004–1005
filters, 1011–1013
programming to use parameters, 1006–1010
vs. dynamic HTML, 1017
ASP.NET, processing live data with HTML forms, 976–977
assignment statements, 767
asterisk (*)
character, 454–456, 460
queries, 223
at (@) character, 455
ATAN function, A49
Atn function, A49
Attach a database file as a database name option, 605
Attach Contacts.bat file (MSDE), 638
Attribute member, 966
attributes, 5, 157–164
authentication
databases, 189
SQL server, 188
Auto Center property, 474, 566
Auto Number data types, 71
Auto Resize property, 474, 566
Auto Tab property, 467
AutoCorrect Options command, 939
Autoexec macro, 952
AutoForm: Columnar Form Wizard, control layout, 439
AutoFormats, controls, 478
AutoIncrement data type (Paradox), 185
AutoIndex on Import/Create command, 135
AutoKeys macro, 956–957
AutoLookups, 282
automating applications
Access application architecture, 791–793
ADO architecture, 795–798
applications, 745
class modules, 815–822
Property Get procedure, 816–818
Property Let procedure, 818–820
Property Set procedure, 820–822
collections, referencing, 798–801
DAO architecture, 793–795
data, zfrmLoadData form, 836–850
errors, 834
examining all error codes, 850–856
On Error Statement, 834–835
events
forms, 715–728
reports, 715–728
sequence, 728–730
Windows, 713–715
functions, Function statement, 812–814
automating applications, continued
macros, 731–732
action flow, 737–738
closing objects, 732–734
conditional expressions, 753–755
data search, 739–740
design window, 745–749
display, 741–742
DoCmd object, 832–833
equivalent Visual Basic actions, 834
executing queries, 736–737
focus, 741–742
grouping, 751–753
informing user actions, 743
menus, 740–741
multiple actions, 749–751
objects, 743–745
opening objects, 732–734
printing data, 735
setting values, 738
testing conditions, 737–738
Visual Basic, 755–756
menu commands
DoCmd object, 832–833
running, 833
objects
methods, 803–812
referencing, 798–801
Set statement, 801–803
properties, referencing, 798–801
statements, flow, 823–832
subroutines, Sub statement, 814–815
Visual Basic
assisting data entry, 859–878
automating data selection, 887–902
automating reports, 917–925
complex tasks, 909–917
constants, 774–783
debugging tools, 766
linking data in forms, 902–909
linking data in reports, 902–909
macros, 857–859
modules, 758–760
muliple–page forms, 886–887
validating complex data, 878–886
variable, 774–790
Visual Basic Editor, 760–765
AutoNumber data type, 103
AutoNumber field, primary key, 389
AutoReport
/Columnar option (Report Wizard), 546
/Tabular option (Report Wizard), 547
Autostart option, 994
Auto–start service when OS starts option (SQL Server Service Manager), 186, 214, 1148, 1233
Avg aggregate function, 297
Avg Distinct option, (Group By options), 649
Avg option, (Group By options), 649
.avi (video file), 104
Axis position list, 334
B
Back Color property, 467, 564
Back Style property, 467
Back Up Database command (File menu), 141
backslash (\) character, 453, 456, 459
backups, table modifications, 140–141
Beep macro, 743
Before Del Confirm event property, 717
Before Insert event property, 718
Before Query event property, 725
Before Render event property, 725
Before Screen Tip event property, 725
Before Update event, 912
Before Update event property, 718
Before Update through On Key Press property, 468
BeforeCollapse event, data source control, 1069
BeforeDelConfirm event, 717
BeforeDelete event, data source control, 1070
BeforeExpand event, data source control, 1070
BeforeFirstPage event, data source control, 1070
BeforeInitialBind event, data source control, 1070
BeforeInsert event, 718
data source control, 1070
BeforeLastPage event, data source control, 1070
BeforeNextPage event, data source control, 1070
BeforeOverwrite event, data source control, 1070
BeforePreviousPage event, data source control, 1070
BeforeQuery event, 725
BeforeRender event, 725
BeforeScreenTip event, 725
BeforeUpdate event, 718, 1070
Begin A Group property, 939
BEGIN statement, 673
BEGIN TRANSACTION statement, 675
Behavior entering field option, 260
Behavior member, 966
BETWEEN operator, 112, 231–232
BETWEEN predicate, A4–A5
bigint (SQL Server data type), 610
binary (SQL Server data type), 610
Binary Coded Decimal, Paradox data type (Paradox), 185
binary command, 1093
Binary data type (Paradox), 185
Bind To Schema option (View tab), 654
BirthDate field, properties, 225
bit (SQL Server data type), 610
bitmaps (.bmp), 89
Black Moshannon Systems Web site, 164
Blank Database command (NewFile task pane), 90
Blank password option, 1085
BLANKSAPWD=1 parameter, 1231
.bmp (bitmaps), 89
body tag, 963
Bold button (Formatting toolbar), 415
Bookmarks dialog box, 388
Boolean data type (Visual Basic), 775, 779
Border Color property, 467
border property, 967
Border Style property, 467, 473, 568
Border Width property, 467
borders
automating reports, 920–922
styles, 473
Bottom Margin property, 468
bottom–up design (data–driven design), 56
Bound Column Lookup property, 174
Bound Object Frame tool, 407
bound object frames, 376
bound records, forms, 402
Bound Span tool, data access pages, 1032
br tag, 963
brackets ([ ]) character, 454, 456, 460
Break in Class Module option, 764
Break on All Errors option, 764
Break on Unhandled Errors option, 764
Break When Value Changes option (breakpoints), 771
Break When Value Is True option (breakpoints), 771
breakpoints, 771
Break When Value Changes option, 771
Break When Value Is True option, 771
Immediate window, 768–770
Visual Basic debugging tools, 766–767
Browse dialog box, 387
Browse for File button, 266
Browse the Web button, 266
Browsed Pages option, 267
browsers, HTML tags, 965
Build button, 115
built–in groups, 1165–1166
built–in users, 1165–1166
by tblContactProducts option, 491
by tblProducts option, 491
bye command, 1093
ByRef keyword
Call statement, 823
functions, 813
Property Get procedure, 817
Property Let procedure, 819
Property Set procedure, 821
subroutines, 814
Byte data type (Visual Basic), 775, 779
Bytes data type (Paradox), 185
ByVal keyword
Call statement, 823
functions, 813
Property Get procedure, 817
Property Let procedure, 819
Property Set procedure, 821
subroutines, 814
Next
Last Updated: June 17, 2004
|
