F

Field Name column,, Refining How Data is Displayed

field names, Refining How Data is Displayed, Refining How Data is Displayed, Refining How Data is Displayed, Refining How Data is Displayed

captions for, Refining How Data is Displayed

changing, Refining How Data is Displayed

Datasheet view display, Refining How Data is Displayed

spaces in, Refining How Data is Displayed

Field Properties section,, Refining How Data is Displayed

field properties,, Creating Tables the Simple Way, Refining How Data is Displayed, Refining How Data is Displayed, Refining How Data is Displayed, Refining How Data is Displayed, Refining How Data is Displayed, Refining How Data is Displayed, Refining How Data is Displayed, Refining How Data is Displayed, Keeping Your Information Accurate

Caption, Refining How Data is Displayed

default, Creating Tables the Simple Way

displaying information on, Refining How Data is Displayed

Field Size, Refining How Data is Displayed

Format, Refining How Data is Displayed

Indexed, Refining How Data is Displayed

Input Mask, Refining How Data is Displayed

New Values, Refining How Data is Displayed

Validation Rule, Refining How Data is Displayed

Field Size field property,, Refining How Data is Displayed

fields,, Chapter 4 Simplifying Data Entry with Forms, Getting to Know Microsoft Access 2003, Creating Tables the Simple Way, Creating Tables the Simple Way, Creating Tables the Simple Way, Creating Tables the Simple Way, Creating Tables the Simple Way, Creating Tables the Simple Way, Creating Tables the Simple Way, Refining How Data is Displayed, Refining How Data is Displayed, Refining How Data is Displayed, Refining How Data is Displayed, Refining How Data is Displayed, Refining How Data is Displayed, Refining How Data is Displayed, Refining How Data is Displayed, Refining How Data is Displayed, Refining How Data is Displayed, Refining How Data is Displayed, Refining How Data is Displayed, Refining How Data is Displayed, Refining How Data is Displayed, Refining How Data is Displayed, Refining How Data is Displayed, Refining How Data is Displayed, Refining How Data is Displayed, Manipulating Table Columns and Rows, Creating a Form by Using a Wizard, Sorting Information, Sorting Information, Filtering Information in a Table, Locating Information that Matches Multiple Criteria, Creating a Query in Design View, Creating a Query in Design View, Creating a Query with a Wizard, Keeping Your Information Accurate, Keeping Your Information Accurate, Keeping Your Information Accurate, Keeping Your Information Accurate, Keeping Your Information Accurate, Keeping Your Information Accurate, Keeping Your Information Accurate, Using Data Type Settings to Restrict Data, Using Data Type Settings to Restrict Data, Using Data Type Settings to Restrict Data, Using Data Type Settings to Restrict Data, Using Data Type Settings to Restrict Data, Using Input Masks to Restrict Data, Using Input Masks to Restrict Data, Using Validation Rules to Restrict Data, Using Validation Rules to Restrict Data, Using Lookup Lists to Restrict Data, Glossary

applying smart tags to, Manipulating Table Columns and Rows

captions, Refining How Data is Displayed

copying, to design grids, Locating Information that Matches Multiple Criteria, Creating a Query in Design View

data type, Keeping Your Information Accurate (see )

data, formatting, Refining How Data is Displayed, Refining How Data is Displayed

dates, specifying range for, Refining How Data is Displayed

default entries, specifying with input masks, Refining How Data is Displayed (see )

defining, Using Data Type Settings to Restrict Data

deleting, Refining How Data is Displayed

EmailAddress, deleting, Refining How Data is Displayed

empty strings, allowing, Keeping Your Information Accurate

filtering, by multiple selection, Filtering Information in a Table

form, Creating a Form by Using a Wizard

formatting data in, Refining How Data is Displayed, Refining How Data is Displayed

graphics in, Refining How Data is Displayed

in queries, Creating a Query in Design View

in queries, hiding, Creating a Query with a Wizard

in Table Wizard, Creating Tables the Simple Way

including in queries, Chapter 4 Simplifying Data Entry with Forms

indexing, disallowing duplicates, Refining How Data is Displayed

limiting size, Refining How Data is Displayed

long integers in, Refining How Data is Displayed

moving, Sorting Information

names, Refining How Data is Displayed (see )

number, properties for, Using Data Type Settings to Restrict Data

numbers in, Refining How Data is Displayed

phone numbers, requiring area codes for, Using Input Masks to Restrict Data

phone numbers, restricting to specific area codes, Using Validation Rules to Restrict Data

properties, Keeping Your Information Accurate (see )

random numbers in, Refining How Data is Displayed

renaming, Creating Tables the Simple Way

required, Keeping Your Information Accurate

restricting data types, Keeping Your Information Accurate

restricting input, Using Data Type Settings to Restrict Data

restricting length, Using Input Masks to Restrict Data

restricting to specific options, Using Lookup Lists to Restrict Data (see )

sample, Creating Tables the Simple Way

selecting, Creating Tables the Simple Way, Using Validation Rules to Restrict Data

selecting, for tables, Creating Tables the Simple Way

size, controlling, Refining How Data is Displayed

size, restricting input with, Using Data Type Settings to Restrict Data

size, setting, Using Data Type Settings to Restrict Data

sorting multiple, Sorting Information

table, Creating Tables the Simple Way

times, specifying range for, Refining How Data is Displayed

zero length, allowing, Keeping Your Information Accurate

fields., Getting to Know Microsoft Access 2003

(see also )

file name extensions,, Importing Information from a Delimited Text File

File New Database dialog box,, Creating a Database Structure the Simple Way, Keeping Your Information Accurate

files, Creating a Database Structure the Simple Way, Keeping Your Information Secure, Maintaining a Workgroup

binary, Keeping Your Information Secure

hidden, displaying, Maintaining a Workgroup

naming, Creating a Database Structure the Simple Way

Filter By Form button,, Chapter 4 Simplifying Data Entry with Forms, Filtering by Form

Filter By Selection button,, Chapter 3 Getting Information Into and Out of a Database, Filtering Information in a Table

filtering,, Chapter 3 Getting Information Into and Out of a Database, Chapter 3 Getting Information Into and Out of a Database, Chapter 4 Simplifying Data Entry with Forms, Chapter 4 Simplifying Data Entry with Forms, Locating Specific Information, Sorting Information, Sorting Information, Filtering Information in a Table, Filtering Information in a Table, Filtering Information in a Table, Filtering Information in a Table, Filtering Information in a Table, Filtering by Form, Filtering by Form, Locating Information that Matches Multiple Criteria, Locating Information that Matches Multiple Criteria, Locating Information that Matches Multiple Criteria, Locating Information that Matches Multiple Criteria, Creating a Query in Design View

advanced, Chapter 4 Simplifying Data Entry with Forms, Locating Information that Matches Multiple Criteria

applying filters, Chapter 4 Simplifying Data Entry with Forms, Filtering by Form

by form, Filtering Information in a Table

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

criteria, Filtering by Form

deleting filters, Chapter 3 Getting Information Into and Out of a Database, Filtering Information in a Table

design grids for, Locating Information that Matches Multiple Criteria

displaying results, Filtering Information in a Table

excluding selection when, Filtering Information in a Table

saving filter as query, Locating Information that Matches Multiple Criteria

sorting, Locating Specific Information (see )

tables, multiple, Locating Information that Matches Multiple Criteria

vs. queries, Creating a Query in Design View

wildcard characters, Sorting Information

filters, Chapter 3 Getting Information Into and Out of a Database, Chapter 4 Simplifying Data Entry with Forms, Filtering Information in a Table, Filtering by Form, Locating Information that Matches Multiple Criteria, Using Lookup Lists to Restrict Data

applying, Chapter 4 Simplifying Data Entry with Forms, Filtering by Form

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

removing, Using Lookup Lists to Restrict Data

saving as queries, Locating Information that Matches Multiple Criteria

finding,, Locating Specific Information, Filtering by Form, Using Lookup Lists to Restrict Data, Exploring Visual Basic for Applications (VBA)

records, Filtering by Form

text, Using Lookup Lists to Restrict Data

VBA objects, Exploring Visual Basic for Applications (VBA)

finishing wizards,, Creating a Database Structure the Simple Way

firing events,, Using Visual Basic for Applications to Enter Data in a Form

First Record button,, Adding a Subform to a Form

fixed-width text files,, Importing Information from a Delimited Text File, Importing Information from a Delimited Text File, Importing Information from a Fixed-Width Text File, Glossary

file name extensions, Importing Information from a Delimited Text File

importing, Importing Information from a Fixed-Width Text File

flag,, Glossary

flags, VBA,, Using VBA to Create a Web Page

flat databases,, Discovering What’s Special About Access, Glossary

folders, displaying hidden,, Maintaining a Workgroup

font weight, for controls,, Refining Form Properties

footers, form,, Refining Form Layout

footers, report, Chapter 6 Keeping Your Information Accurate, Modifying a Report, Creating a Report from Scratch, Adding a Subreport to a Report, Adding a Subreport to a Report

adding to groups, Chapter 6 Keeping Your Information Accurate, Modifying a Report

deleting, Adding a Subreport to a Report

displaying, Creating a Report from Scratch, Adding a Subreport to a Report

Form view,, Exploring Queries, Creating a Form by Using a Wizard, Creating a Splash Screen, Glossary

viewing splash screens in, Creating a Splash Screen

Form Wizard, Chapter 2 Creating a New Database, Creating a Form by Using a Wizard, Creating a Form by Using a Wizard, Adding a Subform to a Form

Available Fields list, adding fields to, Creating a Form by Using a Wizard

creating subforms with, Adding a Subform to a Form

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

Format field property,, Refining How Data is Displayed, Refining How Data is Displayed

drawbacks of, Refining How Data is Displayed

Format Painter button,, Adding Controls to a Form

formatting, Chapter 6 Keeping Your Information Accurate, Refining How Data is Displayed, Refining How Data is Displayed, Refining How Data is Displayed, Refining Form Properties, Refining Form Properties, Adding Controls to a Form, Adding Controls to a Form, Adding a Subreport to a Report, Adding a Subreport to a Report, Creating a Splash Screen

controls, all, Refining Form Properties

copying, Adding Controls to a Form

dates, Refining How Data is Displayed

field data, Refining How Data is Displayed, Refining How Data is Displayed

label backgrounds, Refining Form Properties

labels, Adding Controls to a Form, Adding a Subreport to a Report, Creating a Splash Screen

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

Forms Switchboard window,, Checking the Work of a Wizard

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

forms,, Chapter 2 Creating a New Database, Chapter 3 Getting Information Into and Out of a Database, Chapter 3 Getting Information Into and Out of a Database, Chapter 3 Getting Information Into and Out of a Database, Opening an Existing Database, Opening an Existing Database, Exploring Queries, Exploring Queries, Exploring Queries, Exploring Queries, Exploring Forms, Exploring Forms, Exploring Forms, Exploring Forms, Exploring Forms, Exploring Forms, Exploring Forms, Exploring Forms, Checking the Work of a Wizard, Checking the Work of a Wizard, Creating Tables the Simple Way, Importing Information from an XML File, Simplifying Data Entry with Forms, Simplifying Data Entry with Forms, Simplifying Data Entry with Forms, Simplifying Data Entry with Forms, Simplifying Data Entry with Forms, Simplifying Data Entry with Forms, Creating a Form by Using a Wizard, Creating a Form by Using a Wizard, Creating a Form by Using a Wizard, Creating a Form by Using a Wizard, Creating a Form by Using a Wizard, Refining Form Properties, Refining Form Properties, Refining Form Properties, Refining Form Properties, Refining Form Properties, Refining Form Properties, Refining Form Properties, Refining Form Layout, Refining Form Layout, Adding Controls to a Form, Adding Controls to a Form, Adding Controls to a Form, Adding Controls to a Form, Using Visual Basic for Applications to Enter Data in a Form, Using Visual Basic for Applications to Enter Data in a Form, Creating a Form by Using an AutoForm, Creating a Form by Using an AutoForm, Creating a Form by Using an AutoForm, Adding a Subform to a Form, Sorting Information, Filtering Information in a Table, Using Validation Rules to Restrict Data, Creating a Report by Using a Wizard, Creating a Report by Using a Wizard, Creating a Splash Screen, Setting Startup Options, Setting Startup Options, Using VBA to Create a Web Page, Glossary, Glossary

AutoForms, Using Visual Basic for Applications to Enter Data in a Form

backgrounds, Chapter 3 Getting Information Into and Out of a Database, Refining Form Properties, Refining Form Layout

benefits of, Exploring Queries

Calls, Checking the Work of a Wizard

combo boxes, Adding Controls to a Form

command buttons, Simplifying Data Entry with Forms (see )

control sources, Creating a Form by Using a Wizard

controls, Exploring Queries (see )

created with all fields in table, Using Visual Basic for Applications to Enter Data in a Form

creating, Chapter 3 Getting Information Into and Out of a Database, Creating a Form by Using an AutoForm

creating, manually vs. with wizards, Simplifying Data Entry with Forms

creating, with subforms, Adding a Subform to a Form

creating, with wizards, Chapter 2 Creating a New Database, Simplifying Data Entry with Forms

exporting, Importing Information from an XML File

fields in, Creating a Form by Using a Wizard

filtering by, Filtering Information in a Table

font, changing, Refining Form Properties

footers, displaying, Refining Form Layout

for new tables, opening, Creating Tables the Simple Way

headers, adding captions to, Chapter 3 Getting Information Into and Out of a Database, Adding Controls to a Form

in Design view, Exploring Forms

label controls, Exploring Forms

labels, Simplifying Data Entry with Forms (see )

layout, applying, Creating a Form by Using a Wizard

layout, customizing, Refining Form Properties

main form, Exploring Forms

multiple tables in, Creating a Report by Using a Wizard

new, displaying, Exploring Forms

opening, Exploring Forms

opening, in Design view, Refining Form Properties

opening, in switchboards, Setting Startup Options

option buttons, Simplifying Data Entry with Forms, Using Validation Rules to Restrict Data

pointer shapes, Refining Form Properties

properties of, Refining Form Properties

record selectors, Glossary (see )

record sources, Creating a Form by Using a Wizard

rectangles, adding, Creating a Splash Screen

Report Date Range, inability to open, Checking the Work of a Wizard

saving, Refining Form Properties

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

scrolling through, Creating a Form by Using a Wizard

sections, resizing, Adding Controls to a Form

shortcut menus, restricting access to, Setting Startup Options

sorting records in, Sorting Information

styles, applying, Creating a Form by Using an AutoForm

subforms, Exploring Forms (see )

switchboards, Opening an Existing Database (see )

text box controls, Exploring Forms (see )

viewing, Adding Controls to a Form

views, Opening an Existing Database, Exploring Queries

(see also ; )

views, switching, Exploring Forms

vs. data access pages, Using VBA to Create a Web Page

vs. reports, Creating a Report by Using a Wizard

formulas., Locating Information that Matches Multiple Criteria (see )

freezing columns,, Manipulating Table Columns and Rows

front-end databases,, Replicating a Database, Glossary

(see also )

function procedures,, Exploring Visual Basic for Applications (VBA), Glossary

function,, Glossary

functions, Creating a Query in Design View, Creating a Query in Design View, Performing Calculations in a Query

aggregate, Performing Calculations in a Query

currency conversion, Creating a Query in Design View

in Expression Builder, Creating a Query in Design View