A

A/a input mask character, 871

absolute references

changing reference to, 396

copying, 398–399, 400

defined, 395

.accdb files

Blank, 896–899

database file format, 841

using Attachment data type with, 861

Access, 759–1017.

See also Access Options dialog box;

custom categories in Access;

forms;

queries

Access Options dialog box, 769

adding data to presentation from, 603–604

Allow Layout view features, 999

automatic detection of data types, 15

commands available from Microsoft Office Button, 766, 767–769

content security in, 776–782

copying content to PowerPoint with screen capture, 604

Create tab for, 784–785

custom categories in, 795–805

Database Tools tab for, 786–787

databases

creating, 842–849

disabling untrusted, 777–778

opening existing, 764–767

sample, 940

searching for objects in, 820–824

selecting default file format for, 894–895

starting from scratch, 847–849

templates for, 842–847, 895–899

date and time functions in, 932

displaying single category in Navigation Pane, 823–824

expressions in queries, 918–926

ExprN default field name, 918, 933

External Data tab, 785–786

feature changes in, 15–16

fields

creating relationship on multiple, 886–888

data types for, 857–861

naming, 859

setting properties for, 861–865

specifying in queries, 907–909, 933–934

validation rules for, 868–870

zero-length strings vs. Null, 866

Filter window in, 964–966

filtering query data by selection, 963–964

forms

building input, 988–997

conceptual architecture of, 970–971

object-oriented programming and, 969–972

quick create commands for, 1000–1003

simplifying data input with, 1011–1017

hiding custom groups in categories, 809–811

Home tab for, 784

Hyperlink data type, 953–957

indexes, 888–891

input masks

defining, 870–874

missing characters in, 874

preventing input with incorrect, 874

jumping to objects in Navigation Pane, 788

matching closest entries when typing, 1015

minimizing Ribbon, 787

modifying datasheet and form navigation keys, 948–949

modifying global settings, 829–839

name separators in SQL, 929

Navigation Pane in, 766, 787–789

new user interface for, 763–764

object shortcuts

creating in custom groups, 805–809

renaming hidden, 811–814

revealing hidden, 814–817

object views in, 790–795

opening first time, 761–762

primary key definitions, 874–875

printing table definitions, 899–900

privacy options in, 761–762, 780–781

Quick Access Toolbar, 769–776

changing button image on, 772–773

default commands on, 769–770

macros on custom, 772–773

reverting to defaults, 775

reports

building in Layout view, 1052–1071

designing, 1021–1023

formatting and finishing, 1031–1036

previewing, 1036

quick, 1037–1039

Report Wizard, 1039–1052

setting group intervals, 1027–1028, 1041–1042

sorting options for, 1026–1027

Ribbon in, 783–787

selecting templates for, 763, 764, 843–844, 845

single- vs. multiple-document interface, 825–828

sorting

Navigation Pane objects manually, 819–820

query output data, 934–936

reports, 1026–1027

saving and reusing criteria, 968

and selecting views in, 818–819

tables

creating in Design view, 855–856

customizing design of, 891–895

Description properties for fields of, 856

designing fields for sample, 866–867

entering data in, 849–851

joining, 881–888

properties defining subdatasheets, 878–881

setting up validation rules for, 875–878

templates for, 851–855

tabs for applications in, 827–828

trusted locations for, 781–782

working in Datasheet view, 940

Access Help window, 42

Access Options dialog box

about, 769

adjusting navigation keys in, 948–949

customizing user interface in, 826–827

illustrated, 753

modifying global settings, 829–839

Name AutoCorrect options in, 892–893

Object Designers category in, 893–894

opening, 829

reordering commands in, 774

Trust Center opened from, 778

accessing external content, 686, 687

.accfl files, 853

Account Configuration Wizard, 133–135

Accounting Number Format button, 465

accounts. See Groove account; Microsoft Passport

activating

hyperlinks, 954, 955

Microsoft Office, 1195

active cells

about, 344

insertion point for, 352

moving without losing selection, 350

redisplaying, 395

Active Directory, 709–711

active workbooks, 386

active worksheet area, 341

ActiveX

database size limits for ActiveX objects, 901

inserting controls, 982

setting security for controls, 56–57

Add Appointment dialog box, 152

Add method, 1097

Add New E-Mail Account dialog box, 658

Add View dialog box, 372

add-in tools

creating formulas using, 481

launching from Formulas tab, 445

Microsoft Save As PDF or XPS, 531

playing video DVDs in PowerPoint with, 605

restricting Access, 780

security with digitally signed, 49

setting security options for, 54–55

Add-Ins category

Access Options dialog box, 836–837

PowerPoint Options dialog box, 527

Add-Ins dialog box, 445

Address Cards view (Outlook), 681, 683

ADDRESS function, 480

Advanced category

Access Options dialog box, 835

PowerPoint Options dialog box, 526

Advanced Filter Design window, 959–960

Advanced Options dialog box (Office), 673

.aiff file format, 573

Alert Properties dialog box, 747

alerts

adding, 744–746

configuring Outlook, 743–749

editing and deleting, 746–747

Groove, 138, 175, 185–186

Message Bar security, 49

phishing, 72–73

PowerPoint security, 608–609

rules based on, 747–749

setting up, 726–729

specifying contact’s, 187–188

algorithms, 702

alignment

resolving in range of cells, 359

text box, 548

text-alignment prefix characters, 358–359

Word alignment tabs, 228

Allow Layout view feature, 999

Allow Users To Edit Ranges dialog box, 375

Alt key shortcuts, 27

ampersand (&)

combining text strings in VBA, 1100, 1114

concatenating text values with, 402–403

creating consecutive line breaks in VBA, 1133

input mask character, 871

using with Null fields, 920

AND logical function, 472–473

AND logical operator, 913–916

animation.

See also Custom Animation task pane

animating SmartArt graphics, 578

PowerPoint, 576–578, 600

apostrophe (')

adding in closed workbook reference, 401

aligning text in Excel with, 358, 359

preceding VBA comment lines with, 1080

appending .zip file extension to files, 1149, 1165

Apple QuickTime movies, 575, 605

applications.

See also client applications;

and specific Office applications

adding developer as trusted publisher, 609

collaborative work of Office, 5

copying Groove network settings to other, 181

launching Outlook automatically, 665

moving notebook content to other, 109

Office system, 16

providing navigation tabs in Access, 828

updating, 53

using new interface, 22

XML editors, 1147–1148

Apply Names dialog box, 417

architecture

Access form, 970–971

Office Open XML Formats, 11

archiving Groove workspaces, 204

AREAS function, 484

arguments

arrays as, 458

functions without, 457

logical values, 458

LOOKUP function, 476–477

mixed argument types, 458

named references as, 458

numeric value, 457

object model member, 1097–1098

parentheses around function, 456

placement in functions, 404

ScreenTips for, 455

selecting, 459–460

separating with comma, 457

text value, 457

using expressions as, 457

working with VBA, 1098–1099

arithmetic expressions

data types returned in, 929

defining, 920–926

operators for, 921

arithmetic operators

precedence of, 923

used in expressions, 921

using in OneNote, 114

VBA’s use of, 1114

Arrange tab (Form Design Tools tab), 978

Arrange Windows dialog box, 381–382

array arguments, 434

array constants, 434

array expansions, 439

array formulas

counting occurrence of text strings, 470

defined, 434

rules for, 435

single-cell, 437, 438

array ranges, 434

arrays, 434–439

array constants, 437–439

array expansions, 439

defined, 434

entering SUM formula as, 462

LOOKUP function array form, 476–477

one-dimensional, 434–435

rules for array formulas, 435

single-cell array formulas, 437, 438

two-dimensional, 436

using as argument, 458

art borders, 287–288

ASCII functions in Excel, 468

.asf file format, 575

asterisk (*)

multiplication operator, 393, 921, 923

record indicator icon, 946

wildcard character, 869

asterisk icon, 946

attaching label to form controls, 991

Attachment data type

about, 858, 860–861

unavailable in Group, Sort, And Total pane, 1025

attachment fields, 889

attachments

encrypting outgoing messages and, 699, 718

previewing e-mail, 636

security for, 660

unable to open in Message History dialog box, 184

.au file format, 573

audio

file formats for OneNote, 111

recording in OneNote, 109–111

searching for OneNote files, 119

unable to play back in Message History dialog box, 184

Audio And Video Recording toolbar (OneNote), 110, 111

auditing worksheets, 387–389

authentication

digital certificate, 690

Groove, 135

Auto Expand property, 1015

Auto Lists

completing variables from, 1093–1094

selecting constants from, 1099–1100

using, 1090–1091

autocompletion of formulas, 406–407, 425, 456

AutoCorrect Log (Access), 893

automatic lookup formulas, 476

automatic Outlook startup, 665

Automatic Picture Download dialog box, 688

automating

Microsoft Office, 1141–1142

UserForms, 1138–1140

AutoNumber data type, 858, 860

AutoRecover options in PowerPoint, 543

AutoShapes

changing text box shapes, 269

controlling text in, 268

formatting, 267–270

resizing automatically to show content, 269–270

AVERAGE function, 466

.avi file format, 575