Access , . Access , , , .
Access 2007 . , . Access , (Quick Access toolbar).
, . , ( , ), . . , , .
. , . RibbonX XML- , #. , Web- http://msdn2.microsoft.com/en-us/library/ms406046.aspx.
(Quick Access toolbar), Access QAT. . , , .
Access, . Access , . , . .1.
. .1. , , Access , . , , (, ) - , . , ...
, Access . (Show Below the Ribbon) .
|
|
.
■ , . , .
■ , . Access , , . Access. Access, , . ( , .)
, , Access " " (KeyTips) (. . " " ). <Alt>, Access ,
( 1 ). . , , . .1, <lt>+<1> , <Alt>+<2> (Undo) . .
, -, , : , (Add to Quick Access Toolbar).
.
1. ...
. .2. Access . , . ,
Access, (Customize) (. .2).
2. (Choose commands from).
, , . , , Access . Access . .
□ (Popular Commands) , Access. , , .
□ (Commands Not in the Ribbon) , Microsoft . , , , , , Access .
|
|
□ (All Commands) . , .
□ (Macros) . : , , . Access, . . .
, Office . , (Create), , .
3. , ,
, (Add).
(. .3).
4. ( 2)
.
. , . .
, (Reset).
5. , Access .
. .. Excel ,
. , , (Remove from Quick Access Toolbar).
... (Modify), . , .
, , ? , , . , , , .
Access , . . ,
, . ( ), .
, . , . . , .
, . , , ... (More Commands). - , (Customize Quick Access Toolbar), , . ( ) (For all documents (default)) (, C:\MyFiles\SecretSanta.accdb). . .
|
|
Access , ( , ) , . . .4 .
. .4. ()
( )
. , , , . , , , . .
Action query 272 Alias 249
Character Map 130 Custom 468
D
DAO 591, 610
M
MsgBox 535
N
Navigation pane 41
Outer join 235
F
Filter by selection 117
G
GUID 95
I
Inner join 234
J
Join query 297
Key Tips 23
P
PDF- 666 Primary key 96 Private 547 Public 547
Q
Quick filter 116 Quick search 120
S
Select query 208
Snapshot Viewer 339
SQL Server 645
Structured Query Language (SQL) 224
w
Totals query 263 Web- SharePoint 725
Windows- 652
U
X
UNC 629
Union query 226 XML- 676
XML- 658
125,128 48
581 Web- 733
501 :
490 370
241 369
370
369
369
(): 115,118
641
540 357
46 372,446
49 92
48
:
625
618 488
616 :
43 313
616 311
44 311
28,50 729
43 516
45 257,374,377
746 284
If 569 375
636
444
529
649 , 147
Windows 650 130
395 472
508 423
: 350
632 351
624, 638 361
539
586
588
350,361 34, 56, 359
33 54
42 672
141
25,199, 716
255,284
259 8
200, 716 53
272 342
264, 271 357
|
|
266 34,94
216, 218
273
277
262 353,405,438
259,284 362
289 363
279 363
129 354
495
. 503
505
159 527
648 527
132,211 518, 533
134 505
Access 630 511, 526
497
511, 526
503, 504
734 533
172 512
12 511
<b> 441 511
616 530
453 513,514
57 513
395 502
84 498, 531
26, 480, 485, 488, 493, 590
Auto Exec 520
Auto Keys 518
498, 524
516
520
500
513
512
520
511
517 66 66, 136, 445
137
141 :
Move to SharePoint Site Wizard 745
212
625
524
361
SQL Server 700
619
: 364
289 418 549, 553
Move 554
OpenForm 588
Refresh 553
Requery 553 DAO:
CurrentDb.Execute 606
CurrentDb.OpenRecordset 606
Recordset.MoveNext 606 418 26, 536, 573
542
508, 509, 540 507 639
:
350, 368
31, 52, 460
470
545 221
227
226, 228
231 548
DAO, Recordset 606
DoCmd 588
468 585 605 :
Immediate 537
Project 536
Properties 537
398
343, 368, 415, 426 :
241
241 :
Like 149
547
547 "" 549 734 :
124,363
123 580
500 158
-- 182
-- 181
-- 163
163 26, 317,488, 665
336
/ 323
322
349 330 319 327
326 359 348 346 336
341
340 332
:
753
505 556
262
86, 131, 711 54 556, 566 634 282 357, 358, 360 450 152,162, 185, 713
156
153 , 110 33, 357, 360
233
59 61
36
185
458
61
234
458
59
482
124
61
441 242 144 716, 737
738
Access 739 436, 439 351, 361 113 :
Excel 648, 664
Word 648 :
Access 706
acwzrtool 536
129 539,545, 546, 555 357, 358 237 129
727 437 624 Visual Basic 536 :
697
47
39
36, 39
698
464
34, 56, 57 85 357
310 284,296
, 303
300
301
:
298 298 298 298 298
306
297
306 549
BackColor 549
DAO, Recordset.EOF 606
Value 549
549 622 507 640 547 84 - 75 481, 520, 549, 555
542 539 375,400, 465
102
|
|
, 45 480
SharePoint 724, 732
390,421
515 449 363
, 100 631 463
25, 33 57 57 657, 743 183 479 54
120 411 56, 61
80, 397
79
/ 74
73
78
83, 393
64
70 580 692
54 :
SharePoint 724
726
726
383 528
144, 145, 209, 396, 445 208, 404, 485
267
:
:
accdb 29, 32
accde 628
laccdb 47
mdb 32
mde 628 661 333 :
106 107, 401 401 396, 401 109, 401 404 367, 396, 400 106
26, 305, 387
392
417
399
418
418
396
471, 630
562
411
457,477,483
395
630
388,417
413,418
394
418
418
400
477
476
418
399
400, 404 392
344
68 148, 240, 529,573, 592
Abs() 242
Date() 148
DatePart() 251
Format() 246
Instr() 250
IsNull() 529
Len()249
MsgBox() 533
Now() 148
Nz() 254
RGB() 559
Rnd()248
Round()241
Shell 587
242
247
716
/ 251
248
X
716
170 :
734
507 572
Do/Loop 572
For/Next 573 507, 508
28, 728
48
647
352, 357,370,406,
428, 439,520, 548, 550
447
398
424
432
433
434
436
426,444
431
434
562
368
:
Visual Basic 540
XML 668
(SQL) 216