G

General tab (Design view), 161–165

General tab (Options dialog box), 949

Get External Data-Access Database dialog box, 271, 296

Get External Data-dBASE File dialog box, 261, 263, 299

Get External Data-Excel Spreadsheet dialog box, 276, 281, 300

Get External Data-SharePoint Site wizard, 1187–1190

importing source data from, 1187–1188

saving import steps, 1189–1190

selecting lists for import to Access, 1188, 1189

linking data source with, 1191–1195

specifying lists, 1192–1193

Get External Data-Text File dialog box, 286

Get External Data-XML File wizard, 1254

Getting Started screen

about, 21–22, 102

Blank Database icon on, 148

Blank Database task pane, 196

global settings in Access Options dialog box, 87–97

global variables, 961

GoTo statement, 1020–1021

grand totals

calculating in report footer, 843–844

creating, 839–840

graphical calendar, 1063–1069

greater than (>) values

comparing values with, 169

returning query results with, 1503, A42

greater than or equal to sign (>=)

comparing values with, 168, 169

returning query results with, 1503, A42

Grid X) and Grid Y properties, 587, 760

grid dots

property settings making invisible, 587

setting color or removing, 564–565

grid pane (query designer), 1497, 1500, 1503–1507

gridlines

setting default datasheet options for Web, 1144

Sunken or Raised option disabling in Datasheet Formatting dialog box, 1146

Group, Sort, And Total pane, 761–769

adding new group level on grid, 764

changing grouping and sorting priorities, 768–769

data types unavailable in, 763

defining report groups, 761, 762–763

entering titles, 766–767

group interval options, 765–766

grouping specifications and data types, 765

headers/footers options for reports, 767–768

illustrated, 762

opening, 761–762

printing options for groupings, 768

selecting totals options in, 766

sort order and options in, 764–765

understanding grouping options, 818

Group button, 642–643

Group By button, 1505

GROUP BY clause

overview of, A44-A45

selecting Group By options in query designer, 1506

uses of, 464, A65-A66

group intervals

effect of groupings on, 818

selecting, 765–766

setting in Report Wizard, 779–780

Grouping & Totals group, 761

Grouping Intervals dialog box, 780

grouping macros, 897–900

groupings

about report, 736

adding to report in Layout view, 792–795

adding values across report, 837–838

changing priorities of, 768–769

data types and specifications for, 765

defining report criteria for sorting and, 816–818

moving grouped controls, 642–643

printing options for, 768

setting in Report Wizard, 779–780

understanding options for, 818

groups

adding, 59–60

adding to contextual tabs, 1276–1279

creating grouping options, 56–58

custom

creating object shortcuts in, 63–67

dragging and dropping objects into, 66

hiding, 67–69

modifying in custom categories, 59–63

renaming, 59, 60

working with, 53–55

disabling unused, 1283–1284

display order for, 61

filtering objects by, 49, 50, 81–82

found on Database Tools tab, 44–45

included in

Object Type category, 57

Tables And Related Views category, 57

macro, 897–898

Navigation Pane

collapsing in, 49

initial placement of, 62–63

report headers and footers for contact, 739–741