Q

qualified structured references, 425

queries, 903–968

AND vs. OR in, 913–916

beginning, 904–905

Between, In, and Like comparison operators for, 916–917

building for report, 1020–1021

defining relationships between tables and, 885–886

deleting subdatasheet rows, 952

expressions in, 918–926

fields

choosing from multiple tables or, 1040

selection criteria for, 911–912

setting properties for, 909–911

specifying in, 907–909, 933–934

filtering

data by selection, 963–964

rows by form, 966–967

searching and, 961–968

inserting hyperlinks in, 954–956

limiting returned records in, 966

object-oriented systems and, 970

Report command with, 1039

select, 903

sorting

in Datasheet view, 957–961

importance of sort order, 936

output data for, 934–936

report, 1031

starting from Query Design button, 905–906

subdatasheets in, 943–946

testing validation rule changes with, 937–940

using dates and times in selection criteria, 912–913

viewing libraries or lists using Excel, 82

Query Builder

creating query for form property, 986–988

opening in Outlook, 633

Query Design button, 904, 905–906

Query window (Design view), 905, 906, 907

Query Wizard button, 904

question mark (?)

input mask character, 870

wildcard character, 869

Quick Access Toolbar

about, 7, 8, 23

Access, 766, 769–776

adding Access command to, 776

adding macro object, 772–773

changing button images on, 772–773

inserting separator on, 775

removing commands from, 770, 771–772

reordering commands on, 774

reverting to defaults, 775

adding Digitally Sign Message icon to, 703

customizing, 32–33

Encrypt command added to, 718

illustrated, 24

macros added to, 772–773, 1120–1121

navigating from Ribbon to, 33

PowerPoint

adding PowerPoint commands to, 524–525

resetting defaults, 525

Save button on, 851

quick create commands

about feature, 852

creating forms with, 1000–1003

PivotChart and PivotTable, 1003

Report command, 1037–1039

Quick Info, 1116

Quick Launch bar, 666

Quick Print option, 625

Quick Style galleries. See galleries

quotation mark ("), 358, 359.

See also double quotation marks ("")