S

sample fields/tables,, Creating Tables the Simple Way

Save button,, Creating a Form by Using an AutoForm, Creating a Report from Scratch

saving,, Checking the Work of a Wizard, Checking the Work of a Wizard, Refining How Data is Displayed, Importing Information from a Delimited Text File, Refining Form Properties, Filtering by Form, Locating Information that Matches Multiple Criteria, Deleting Information from a Table, Creating a Report from Scratch, Securing a Database for Distribution, Key Points, Using VBA to Create a Web Page, Creating a Data Access Page with AutoPage, Glossary

automatically, Checking the Work of a Wizard

data access pages, Creating a Data Access Page with AutoPage

databases, as MDE files, Securing a Database for Distribution, Key Points

delete queries, Deleting Information from a Table

filtering criteria, Filtering by Form

filters as queries, Locating Information that Matches Multiple Criteria

forms, Refining Form Properties

import settings, Importing Information from a Delimited Text File

manually, impossibility of, Checking the Work of a Wizard

modules, Using VBA to Create a Web Page

reports, Creating a Report from Scratch

when switching from Design to Datasheet view, Refining How Data is Displayed

schema, XML,, Importing Information from an XML File, Exporting Information to Other Programs, Glossary

(see also )

exporting, Exporting Information to Other Programs

ScreenTips,, Adding Controls to a Form, Using VBA to Create a Web Page

for VBA expressions, Using VBA to Create a Web Page

scroll bars, removing from forms,, Creating a Form by Using an AutoForm

scrolling through forms,, Creating a Form by Using a Wizard

Security Wizard,, Setting Up a Workgroup

security,, Keeping Your Information Secure, Keeping Your Information Secure, Assigning a Password to a Database, Assigning a Password to a Database, Splitting a Database, Splitting a Database, Splitting a Database, Splitting a Database, Preventing Changes to a Database, Preventing Changes to a Database, Securing a Database for Distribution, Securing a Database for Distribution

encryption, Keeping Your Information Secure

groups, Splitting a Database (see )

locking records, Assigning a Password to a Database

MDE files, Securing a Database for Distribution

network, Assigning a Password to a Database

of publicly-distributed databases, Preventing Changes to a Database

user-level, Splitting a Database (see )

VBA code, Preventing Changes to a Database

workgroup information files (WIFs), Splitting a Database (see )

workgroups, Splitting a Database, Securing a Database for Distribution

(see also )

select queries,, Locating Information that Matches Multiple Criteria, Creating a Query in Design View, Creating a Query in Design View, Updating Information in a Table, Updating Information in a Table, Updating Information in a Table, Deleting Information from a Table, Glossary

(see also )

converting into action queries, Updating Information in a Table

converting into delete queries, Deleting Information from a Table

creating, Updating Information in a Table

duplicate queries, Creating a Query in Design View

running, Updating Information in a Table

unmatched queries, Creating a Query in Design View

selecting, Chapter 3 Getting Information Into and Out of a Database, Chapter 5 Locating Specific Information, Creating Tables the Simple Way, Manipulating Table Columns and Rows, Manipulating Table Columns and Rows, Refining Form Properties, Refining Form Properties, Refining Form Properties, Adding a Subform to a Form, Sorting Information, Sorting Information, Filtering Information in a Table, Using Data Type Settings to Restrict Data, Using Validation Rules to Restrict Data, Creating a Report by Using a Wizard, Modifying a Report, Modifying a Report, Modifying a Report, Creating a Report from Scratch, Adding a Subreport to a Report

adjacent columns, Manipulating Table Columns and Rows

columns, Sorting Information

columns, adjacent, Manipulating Table Columns and Rows

columns, multiple, Sorting Information

controls, all, Refining Form Properties

controls, multiple, Modifying a Report

fields, Using Validation Rules to Restrict Data

fields for tables, Creating Tables the Simple Way

filtering by, Chapter 3 Getting Information Into and Out of a Database, Filtering Information in a Table

hidden lines in reports, Modifying a Report

labels, Refining Form Properties, Modifying a Report

labels, multiple, Refining Form Properties

reports, Creating a Report from Scratch

rows, Using Data Type Settings to Restrict Data

subforms, Adding a Subform to a Form

subreports, Adding a Subreport to a Report

tables, Chapter 5 Locating Specific Information, Creating a Report by Using a Wizard

selector,, Glossary

sequentially increasing numbers,, Refining How Data is Displayed

Set Database Password dialog box,, Assigning a Password to a Database

setting, Using Data Type Settings to Restrict Data, Assigning a Password to a Database, Using VBA to Create a Web Page

field size, Using Data Type Settings to Restrict Data

passwords, Assigning a Password to a Database

variable values, Using VBA to Create a Web Page

setting up workgroups,, Splitting a Database

Setup button,, Previewing and Printing Access Objects

shadowing controls,, Refining Form Properties

sharing databases,, Assigning a Password to a Database, Assigning a Password to a Database, Sharing a Database, Sharing a Database, Glossary

(see also )

exclusively, Sharing a Database

on local area networks, Assigning a Password to a Database

property settings, Sharing a Database

Short Date format,, Refining How Data is Displayed

shortcut menus, restricting access to,, Setting Startup Options

shortcuts, editing,, Setting Up a Workgroup

Show Table button,, Adding a Subform to a Form

Show Table dialog box,, Adding a Subform to a Form

showing., Chapter 1 Getting to Know Microsoft Access 2003, Refining How Data is Displayed

(see also )

hidden columns, Chapter 1 Getting to Know Microsoft Access 2003

sizing., Exploring Tables (see )

Smart Tag Actions button,, Manipulating Table Columns and Rows

smart tags,, Manipulating Table Columns and Rows

Sort Ascending button,, Sorting Information, Creating a Data Access Page with AutoPage

Sort Descending button,, Sorting Information

Sorting and Grouping button,, Chapter 6 Keeping Your Information Accurate, Modifying a Report

sorting,, Locating Specific Information, Sorting Information, Sorting Information, Sorting Information, Sorting Information, Sorting Information, Sorting Information, Locating Information that Matches Multiple Criteria, Creating a Query in Design View, Creating a Query in Design View, Creating a Report by Using a Wizard, Creating a Data Access Page with AutoPage

ascending/descending, Sorting Information

columns, Sorting Information

fields, in reports, Creating a Report by Using a Wizard

fields, multiple, Sorting Information

forms, Sorting Information

numbers, Sorting Information

queries, Creating a Query in Design View

records, in data access pages, Creating a Data Access Page with AutoPage

reversing order, Sorting Information

tables, multiple, Locating Information that Matches Multiple Criteria

vs. queries, Creating a Query in Design View

spaces in field names,, Refining How Data is Displayed

spacing labels/text boxes,, Refining Form Properties

Special Keys,, Setting Startup Options

spelling, checking,, Exploring Visual Basic for Applications (VBA)

splash screens,, Opening an Existing Database, Opening an Existing Database, Creating a Switchboard by Using Switchboard Manager, Creating a Splash Screen, Creating a Splash Screen, Creating a Splash Screen, Creating a Splash Screen, Creating a Splash Screen, Creating a Splash Screen, Setting Startup Options, Setting Startup Options, Glossary

check boxes in, Creating a Splash Screen

displaying, Setting Startup Options

error when opening, Setting Startup Options

images, inserting, Creating a Splash Screen

labels, Creating a Splash Screen

rectangles, adding, Creating a Splash Screen

text, adding, Creating a Splash Screen

turning off, Opening an Existing Database

viewing in Form view, Creating a Splash Screen

splitting databases,, Replicating a Database

spreadsheets, importing,, Importing Information from Excel

SQL database,, Glossary

SQL., Exploring Queries (see )

standard modules,, Exploring Visual Basic for Applications (VBA), Glossary

(see also )

Start menu,, Creating a Splash Screen

starting, Chapter 2 Creating a New Database, Chapter 5 Locating Specific Information, Chapter 5 Locating Specific Information, Opening an Existing Database, Creating Tables the Simple Way, Creating a Form by Using a Wizard, Creating a Query with a Wizard, Using Input Masks to Restrict Data, Creating a Report by Using a Wizard, Creating a Splash Screen

Access, Opening an Existing Database, Creating a Splash Screen

Form Wizard, Chapter 2 Creating a New Database, Creating a Form by Using a Wizard

Input Mask Wizard, Chapter 5 Locating Specific Information, Using Input Masks to Restrict Data

Query Wizard, Creating a Query with a Wizard

Report Wizard, Chapter 5 Locating Specific Information, Creating a Report by Using a Wizard

Table Wizard, Creating Tables the Simple Way

Startup dialog box,, Setting Startup Options

startup options,, Creating a Splash Screen, Setting Startup Options, Setting Startup Options, Setting Startup Options

applying, Setting Startup Options

bypassing, Setting Startup Options

startup screens., Opening an Existing Database (see )

static HTML page,, Glossary

static Web pages,, Chapter 9 Keeping Your Information Secure, Working with Pages and Modules, Creating Static Web Pages, Creating Static Web Pages

creating, Creating Static Web Pages

exporting reports to, Chapter 9 Keeping Your Information Secure, Creating Static Web Pages

storing graphics in fields, Refining How Data is Displayed

strings,, Keeping Your Information Accurate, Glossary

empty, Keeping Your Information Accurate

structure, database,, Creating a New Database, Creating Tables the Simple Way

creating empty, Creating Tables the Simple Way

structure, table,, Refining How Data is Displayed

Structured Query Language (SQL),, Exploring Queries, Glossary

styles, Creating a Database Structure the Simple Way, Refining Form Layout, Creating a Form by Using an AutoForm

applying, Creating a Database Structure the Simple Way

applying to forms, Creating a Form by Using an AutoForm

creating, Refining Form Layout

sub procedures,, Exploring Visual Basic for Applications (VBA), Using VBA to Create a Web Page, Glossary

inserting, Using VBA to Create a Web Page

subdatasheets,, Exploring Tables, Exploring Tables, Exploring Tables, Glossary

collapsing, Exploring Tables

expanding, Exploring Tables

subdirectories, creating with VBA,, Using VBA to Create a Web Page

Subform Wizard,, Adding a Subform to a Form

subforms,, Exploring Forms, Creating a Form by Using an AutoForm, Adding a Subform to a Form, Adding a Subform to a Form, Adding a Subform to a Form, Adding a Subform to a Form, Glossary

(see also )

creating, Adding a Subform to a Form

creating, with Form Wizard, Adding a Subform to a Form

defining relationships for, Adding a Subform to a Form

selecting, Adding a Subform to a Form

SubReport Wizard,, Adding a Subreport to a Report

subreports,, Chapter 6 Keeping Your Information Accurate, Creating a Report from Scratch, Creating a Report from Scratch, Adding a Subreport to a Report, Adding a Subreport to a Report, Adding a Subreport to a Report, Adding a Subreport to a Report, Adding a Subreport to a Report, Adding a Subreport to a Report, Adding a Subreport to a Report, Adding a Subreport to a Report, Adding a Subreport to a Report, Glossary

(see also )

borders, transparent, Adding a Subreport to a Report

converting existing reports into, Adding a Subreport to a Report

creating, Creating a Report from Scratch

footers, Adding a Subreport to a Report

formatting, Chapter 6 Keeping Your Information Accurate, Adding a Subreport to a Report

headers, deleting, Adding a Subreport to a Report

layout, factors affecting, Adding a Subreport to a Report

selecting, Adding a Subreport to a Report

transparent borders, Adding a Subreport to a Report

width/height, changing, Adding a Subreport to a Report

Switchboard Manager,, Making It Easy for Others to Use Your Database

switchboards,, Opening an Existing Database, Opening an Existing Database, Exploring Forms, Checking the Work of a Wizard, Checking the Work of a Wizard, Checking the Work of a Wizard, Simplifying Data Entry with Forms, Making It Easy for Others to Use Your Database, Making It Easy for Others to Use Your Database, Making It Easy for Others to Use Your Database, Creating a Switchboard by Using Switchboard Manager, Creating a Switchboard by Using Switchboard Manager, Creating a Switchboard by Using Switchboard Manager, Creating a Switchboard by Using Switchboard Manager, Creating a Switchboard by Using Switchboard Manager, Creating a Switchboard by Using Switchboard Manager, Creating a Switchboard by Using Switchboard Manager, Creating a Switchboard by Using Switchboard Manager, Creating a Switchboard by Using Switchboard Manager, Creating a Switchboard by Using Switchboard Manager, Creating a Switchboard by Using Switchboard Manager, Creating a Switchboard by Using Switchboard Manager, Creating a Switchboard by Using Switchboard Manager, Setting Startup Options, Glossary

adding pages to, Creating a Switchboard by Using Switchboard Manager

buttons, Creating a Switchboard by Using Switchboard Manager (see )

closing, Opening an Existing Database

closing automatically, Creating a Switchboard by Using Switchboard Manager

creating, Making It Easy for Others to Use Your Database

displaying, Checking the Work of a Wizard

editing, Creating a Switchboard by Using Switchboard Manager, Creating a Switchboard by Using Switchboard Manager, Creating a Switchboard by Using Switchboard Manager

forms, creating, Creating a Switchboard by Using Switchboard Manager

forms, displaying, Checking the Work of a Wizard

forms, opening, Setting Startup Options

listing items in, Creating a Switchboard by Using Switchboard Manager

macros for, Creating a Switchboard by Using Switchboard Manager

modifying, Creating a Switchboard by Using Switchboard Manager

naming, Creating a Switchboard by Using Switchboard Manager

opening, Exploring Forms

opening, in Forms view, Creating a Switchboard by Using Switchboard Manager

reports, displaying, Checking the Work of a Wizard

Switchboard Manager, Making It Easy for Others to Use Your Database

viewing in Design view, Creating a Switchboard by Using Switchboard Manager

switching form views, Exploring Forms

synchronizing databases,, Sharing a Database, Replicating a Database, Glossary

syntax,, Glossary