Index

A note on the digital index

A link in an index entry is displayed as the section title in which that entry appears. Because some sections have multiple index markers, it is not unusual for an entry to have several links to the same section. Clicking on any link will take you directly to the place in the text in which the marker appears.

Symbols

# (pound sign), Validating text
( ) (parentheses), Date fields
* (asterisk)
delete queries, Delete Queries
inserting records, Editing a Table
selecting fields for queries, Creating a Query in Design View
validating text, Validating text
? (question mark), Validating text

A

.accdb file extension
information in, Creating a New Database
Access (Microsoft)
exportable file type support, Exportable File Types
Access Developer’s Toolkit, Getting Started
Access Options window
action query warnings, Update Queries
action queries
append queries, Append Queries
delete queries, Delete Queries
find-and-replace feature vs., Update Queries
viewing without running, Update Queries
adding
attachments, Attachment
descriptions for fields, Organizing and Describing Your Fields
fields between existing fields, Organizing and Describing Your Fields
fields in forms, Creating a Simple Form
fields to end of tables, Organizing and Describing Your Fields
fields to reports, Adding and Removing Fields
fields via Form wizard, The Form Wizard
lookups to fields, Creating a Simple Lookup with Fixed Values, Creating a Simple Lookup with Fixed Values, Creating a Simple Lookup with Fixed Values
math operations for, Simple Math with Numeric Fields, Expressions with Text
pictures to reports, Adding and Removing Fields
records to forms, Finding and editing a record
values to lookup lists, Adding New Values to Your Lookup List
Adobe Reader, Exporting a Report, Getting the “Save As PDF” Add-in
Allow Multiple Values option, Lookups with Related Tables
Allow Zero Length property, Blank values and empty text
And operator
field validation, Creating a Table Validation Rule
table validation, Creating a Table Validation Rule
Append or Make Table dialog box, Creating an Append (or Make-Table) Query
append queries, The Action Query Family, Append Queries, Append Queries, Creating an Append (or Make-Table) Query, Creating an Append (or Make-Table) Query, Delete Queries
arithmetic operators, Simple Math with Numeric Fields
Attachment control, Adding a record
Attachment data type
copying, Copying a Table from Access to Somewhere Else
lookup support, Lookups
one-to-one relationships and, One-to-One Relationship
showing pictures from databases, Adding a record
Attachments dialog box, Attachment
AutoFormat feature, Formatting a Report, Formatting a Report, Creating a Simple Form
AutoFormat wizard, Formatting a Report
automatic save feature, Saving and Opening Access Databases, Making Backups
AutoNumber data type
append query guidelines, Append Queries
changing values in fields, Referential Integrity
creating primary key field, Creating Your Own Primary Key Field
filtering support, Quick filters
forms and, Using a Form
linking with ID number, Linking with the ID Column
parent-child relationships and, Defining a Relationship
sorting options, Sorting
validation support, Applying a Field Validation Rule

B

backups
before action queries, Testing Action Queries (Carefully), Update Queries
changing data types and, Text
blank fields
importing Excel files, Importing from an Excel File
preventing, Preventing Blank Fields
blank values
empty text vs., Blank values and empty text, Blank values and empty text
filtering queries for, Multiple Joins
unlinked records, Blank values for unlinked records
borders, Gridlines, Borders
Byte option (Field Size property), Number size

C

calculated fields
defined, Calculated Fields
simple math with, Simple Math with Numeric Fields, Order of operations
text expressions, Order of operations
calculations
queries performing, Query Basics
reports and, Arranging a Report
calendar smart tag, Date/Time
Caption property, Attachment
cascading deletes, Cascading deletes, Cascading deletes
cascading updates, Cascading updates
circular references, Defining a Calculated Field
Clear All Sorts command, Sorting, Sorting on multiple fields
Clear Filter command, Quick filters
clipboard
shortcut keys, Using the Clipboard
Close Print Preview command, Print Preview
column headers
formatting for reports, Formatting a Report, Formatting Columns and Column Headers, Formatting Columns and Column Headers, Formatting numeric fields, Gridlines, Borders
Column Width dialog box, Resizing Rows and Columns
Columnar option (layouts), The Form Wizard
columns
exporting considerations, Getting the “Save As PDF” Add-in
filtering, Quick filters
fine-tuning printouts, Fine-Tuning a Printout
freezing, Freezing Columns
hiding, Fine-Tuning a Printout
naming, Creating a Simple Table
ordering for reports, Creating a Simple Report
rearranging, Rearranging Columns
rearranging for queries, Creating a Query in Design View
removing filters from, Quick filters
resizing in forms, Creating a Simple Form
Columns button, Previewing a Report
compacting databases, Saving and Opening Access Databases
compound indexes, Multifield indexes, Multifield indexes, Multifield indexes
conditional formatting, Formatting Columns and Column Headers
controls, Form Basics
converting
information to other types, Using the Clipboard
versions of databases, Opening a Database Created in an Older Version of Access
copy-and-paste operation, Cut, copy, and paste, Import and Export Operations
copying
attachments, Attachment
cells from Excel, Copying Cells from Excel into Access, Copying Cells from Excel into Access, Import and Export Operations
data types, Copying a Table from Access to Somewhere Else
tables elsewhere, Using the Clipboard, Copying a Table from Access to Somewhere Else
creating
calculated fields, Defining a Calculated Field, Defining a Calculated Field, Defining a Calculated Field
databases, Getting Started, Understanding Tables
forms, Form Basics, Creating a Simple Form, Creating a Simple Form, Using a Form
one-to-one relationship, Getting more detailed
primary key field, Creating Your Own Primary Key Field
queries, Query Basics, Creating a Query in Design View, Creating a Query in Design View, Creating a Query in Design View, Creating a Simple Query with the Query Wizard, Creating a Simple Query with the Query Wizard, Queries and Related Tables
reports, Creating a Report from Scratch
simple reports, Report Basics, Creating a Simple Report, Creating a Simple Report
tables, Understanding Tables, Creating a Simple Table
tables while importing, Importing Data
Crosstab Query Wizard, Creating a Simple Query with the Query Wizard
Ctrl+; key combination, Shortcut keys
Ctrl+Alt+Space key combination, Shortcut keys, Setting Default Values
Ctrl+C key combination, Cut, copy, and paste
Ctrl+End key combination, Shortcut keys
Ctrl+F key combination, Searching
Ctrl+F1 key combination, Managing Database Objects
Ctrl+Home key combination, Shortcut keys
Ctrl+K key combination, Hyperlink
Ctrl+S key combination, How Updates Work in Design View
Ctrl+V key combination, Cut, copy, and paste
Ctrl+X key combination, Cut, copy, and paste
Ctrl+Z key combination, Shortcut keys, Finding and editing a record
Ctrl+” key combination, Shortcut keys
Currency data type
custom string, Currency
description, Access Data Types
Currency option
Format field property, Number formatting, Currency
formatting numeric fields, Formatting numeric fields
cut-and-paste operation
import/export and, Copying Cells from Excel into Access

D

data types
considerations when changing, Text
copying, Copying a Table from Access to Somewhere Else
filtering support, Quick filters
lookups support, Lookups
overview, Access Data Types
Required field property support, Preventing Blank Fields
text-based, Filter by selection, Filter by condition
data validation
applying rules, Applying a Field Validation Rule
creating table rules, Creating a Table Validation Rule
Design view, Data Integrity Basics
input masks, Input Masks, Input Masks, Using a Ready-Made Mask, Using a Ready-Made Mask, Using a Ready-Made Mask, Validation Rules
lookups, Lookups, Creating a Simple Lookup with Fixed Values, Creating a Simple Lookup with Fixed Values
preventing blank fields, Blank values and empty text, Blank values and empty text, Blank values and empty text
preventing duplicate values, Preventing Duplicate Values with Indexes, Preventing Duplicate Values with Indexes, Preventing Duplicate Values with Indexes, Multifield indexes
setting default values, Setting Default Values, Preventing Duplicate Values with Indexes
writing rules, Writing a Field Validation Rule, Combining validation conditions
database design, Six Principles of Database Design, Six Principles of Database Design, 1. Choose Good Field Names, 4. Avoid Duplicating Information, 4. Avoid Duplicating Information, 4. Avoid Duplicating Information
database diagram
defined, Defining a Relationship
database objects
defined, Creating your First Database
reports as, Creating Reports
types of, Understanding Access Databases
databases
Attachment data type, Attachment
compacting, Saving and Opening Access Databases
consistency and, Input Masks
copying, Copying a Table from Access to Somewhere Else
creating, Getting Started, Getting Started, Creating a New Database, Creating Another Database
creating in previous versions, Creating a Simple Table
front end to, Form Basics
importing consideration, Understanding Imports
linking, Formatted text
opening, Opening a Database, Opening More Than One Database at Once
opening previous versions, Opening a Database Created in an Older Version of Access, Opening a Database Created in an Older Version of Access
planning, Creating a Simple Table
saving, Saving and Opening Access Databases
saving as previous version, Understanding Tables
saving with different names/formats, Saving a Database with a Different Name or Format
shrinking, Saving and Opening Access Databases
tables and, Understanding Tables
templates for, Getting Started
transferring records to, Creating an Append (or Make-Table) Query
using someone else’s, Getting Started
Datasheet option (layouts), The Form Wizard
Datasheet view
copying rows in, Copying a Table from Access to Somewhere Else
hyperlink support, Hyperlink
primary key and, The Primary Key
running queries, Creating a Query in Design View
switching views, Design View, Design View
tables and, Understanding Data Types
datasheets
customizing, Formatting the Datasheet
filtering records, Filtering, Filter by selection, Filter by selection, Filter by condition
find-and-replace feature, Printing the Datasheet
formatting, Datasheet Customization, Formatting the Datasheet
forms and, The Form Wizard
forms vs., Creating Simple Forms
moving around, Shortcut keys
printing, Printing the Datasheet, Fine-Tuning a Printout
query results as, Creating a Query in Design View
searching records, Searching, Searching, Searching, Searching
sorting records, Sorting, Sorting, Sorting on multiple fields, Sorting on multiple fields
Date data type
filtering support, Filter by condition
date expressions
queries and, Building filter expressions
validation rules and, Validating dates, Validating text
Date( ) function, Setting Default Values, Preventing Duplicate Values with Indexes, Validating dates
Date/Time data type
description, Access Data Types
date/time information
arranging for reports, Arranging a Report, Creating a Report from Scratch
copying, Copying a Table from Access to Somewhere Else
dBase, Importable File Types
decimal numbers, Number, Formatting numeric fields
Decimal option (Field Size property), Number size
Decimal Places field property, Number formatting
Default Value property, Setting Default Values
default values
dynamic, Setting Default Values
deleting
attachments, Attachment
cascading deletes, Cascading deletes, Cascading deletes
fields, Organizing and Describing Your Fields
fields from reports, Adding and Removing Fields
records, Editing a Table, Creating an Append (or Make-Table) Query, Delete Queries
records from forms, Deleting a record, Deleting a record
relationships, Lookups with Related Tables
Design view
accessing data types, Access Data Types
creating queries, Creating a Query in Design View, Creating a Simple Query with the Query Wizard
data validation, Blocking Bad Data
for forms, Using a Form
lookup lists, Creating a Simple Lookup with Fixed Values
ready-made masks, Using a Ready-Made Mask
setting primary key in, The Primary Key
switching to, Design View, Blocking Bad Data
Disabled Mode, Update Queries
disaster recovery, Testing Action Queries (Carefully)
Double option (Field Size property), Number size
double-clicking
collapsing ribbon, Managing Database Objects
Edit mode toggle, Edit mode
expanding columns, Creating a Simple Table
launching queries, Creating a Query in Design View
opening tables, Managing Database Objects
Down Arrow key, Shortcut keys
duplicate records
preventing, The Primary Key
dynamic default values, Setting Default Values

E

Edit Hyperlink window, Hyperlink
Edit mode, Edit mode
Edit Relationships dialog box, Defining a Relationship, Cascading updates
editing
attachments, Attachment
records, Shortcut keys
records in forms, Using a Form, Finding and editing a record
relationships, Editing Relationships
sorted columns, Sorting
tables, Shortcut keys
ellipsis (…), Using a Ready-Made Mask
empty text, Blank values and empty text, Blank values and empty text
Enable Referential Integrity option, One-to-One Relationship
Enforce Referential Integrity option, Defining a Relationship, Editing Relationships
error handling, Using a Relationship
error messages, Applying a Field Validation Rule
Esc key
adding records to forms, Adding a record
editing records, Shortcut keys
Euro option
formatting numeric fields, Formatting numeric fields
Excel (Microsoft)
Attachment data type support, Attachment
exporting data to, Understanding Exports, Exportable File Types
exporting reports to, Formatting a Report
importing from, Import and Export Operations, Importing from an Excel File, Importing from an Excel File, Importing from an Excel File, Importing from a Text File
explicit relationships, Using a Relationship
exponents, Order of operations
Export As dialog box, Getting the “Save As PDF” Add-in
Export wizard, Exporting Data
exporting
basic steps for, Exporting Data
data, Getting the “Save As PDF” Add-in
file types supported, Importing from a Text File, Exportable File Types
reports, Exporting a Report, Getting the “Save As PDF” Add-in
expressions
applying to different forms, Saving Filters for the Future
date, Validating dates, Validating dates, Building filter expressions
filter, Creating a Query in Design View, Building filter expressions, Building filter expressions, Building filter expressions, Creating a Simple Query with the Query Wizard
filtering multiple fields, Using the Filter by Form Feature
records and, Defining a Calculated Field
text, Expressions with Text
validating numbers, Validating numbers

F

F2 key, Edit mode
Field List pane
creating reports, Creating a Report from Scratch
field properties, Access Data Types
Field Properties section
setting maximum length, Text length
Field Size property
Number data types and, Text, Number, Number size
Replication IDs and, Using AutoNumbers without revealing the size of your table
fields
adding between existing fields, Organizing and Describing Your Fields
applying indexes to, Preventing Duplicate Values with Indexes
breaking down information in, 2. Break Down Your Information
building expressions out of, Defining a Calculated Field
data types and, Access Data Types, Access Data Types
defined, Creating a Simple Table
hidden, Adding and Removing Fields, Creating a Simple Form
listing in Design view, Organizing and Describing Your Fields
matching, Matching Fields: The Relationship Link
naming, 1. Choose Good Field Names
one-to-one relationship, One-to-One Relationship
order of, Organizing and Describing Your Fields
pointing to files, Formatted text
selecting for queries, Creating Queries, Creating a Query in Design View
sorting on multiple, Sorting on multiple fields
writing validation rules, Validating text
file extensions, Creating a New Database
File New Database dialog box, Creating a New Database, Understanding Tables
file types, Importable File Types
files
embedding in databases, Formatted text
filter by condition, Filter by condition, Filtering a Form
filter by form feature, Finding and editing a record, Using the Filter by Form Feature, Using the Filter by Form Feature, Using the Filter by Form Feature, Using the Filter by Form Feature
filter by selection, Filter by selection, Filter by selection, Filtering a Form
filter expressions
building, Building filter expressions
Criteria box and, Creating a Query in Design View
for duplicated values, Creating a Simple Query with the Query Wizard
for unlinked records, Creating a Simple Query with the Query Wizard
lookups and, Building filter expressions
filtering
delete queries and, Delete Queries
filter by condition, Filter by condition, Filtering a Form
filter by selection, Filter by selection
for unmatched records, Finding unmatched records
forms and, Printing records, Using the Filter by Form Feature, Using the Filter by Form Feature, Using the Filter by Form Feature, Using the Filter by Form Feature, Saving Filters for the Future, Saving Filters for the Future
quick filters, Quick filters, Filtering a Form
records in queries, Creating a Query in Design View
records in tables, Filtering, Quick filters, Quick filters, Filter by selection, Searching
reports, Filtering a Report
validation rules and, Building filter expressions
Find Duplicates Query Wizard, Creating a Simple Query with the Query Wizard
Find feature, Searching
Find Unmatched Query Wizard, Creating a Simple Query with the Query Wizard
find-and-replace feature
Find and Replace dialog box, Searching, Printing the Datasheet
folders
backups and, Making Backups
changing which Access uses, Opening a Database Created in an Older Version of Access
Form view, Using a Form, Using a Form
Form wizard, The Form Wizard, The Form Wizard, The Form Wizard
Format field property
Number data type, Number size, Currency
formatting
alternate rows, Alternating row formatting
AutoFormat wizard, Formatting a Report
borders, Borders
columns/column headers for reports, Formatting Columns and Column Headers, Formatting Columns and Column Headers
custom currency string, Currency
custom number string, Number formatting
datasheets, Formatting the Datasheet
Date/Time data type, Yes/No
exporting considerations, Exporting Data
forms and, Creating a Simple Form
gridlines, Gridlines, Borders
Memo data type and, Memo, Formatted text
numeric fields, Formatting numeric fields
reports, Formatting a Report, Alternating row formatting, Gridlines, Filtering and Sorting a Report
forms
AutoNumber fields in, Using a Form
creating, Creating a Simple Form
deleting records, Deleting a record
filtering, Sorting and Filtering in a Form, Filtering a Form, Using the Filter by Form Feature, Using the Filter by Form Feature, Using the Filter by Form Feature, Saving Filters for the Future
formatting, Creating a Simple Form
navigation controls, Finding and editing a record
printing records, Printing records, Sorting a Form
saving, Creating a Simple Form
sorting, Sorting and Filtering in a Form
split, The Form Wizard
text field size considerations, Creating a Simple Form
types of, The Form Wizard
viewing modes, Using a Form
freezing columns, Freezing Columns, Freezing Columns
functions, Validating dates

G

General Date format (Date/Time data type), Date/Time
General Number option (Format property), Number formatting, Formatting numeric fields
getting started
creating databases, Getting Started
creating tables, Creating a Simple Table, Creating a Simple Table
editing tables, Editing a Table, Edit mode, Shortcut keys
Getting Started page, Getting Started, Getting Started, Getting Started
Getting Started page
creating databases, Creating Another Database
opening databases, Getting Started
globally unique identifier (GUID), Using Replication IDs
gridlines, Gridlines

H

hiding columns, Hiding Columns, Hiding Columns, Fine-Tuning a Printout, Creating a Query in Design View
HTML
clipboard and, Using the Clipboard
exporting considerations, Exporting a Report, Exporting Data
importing considerations, Importable File Types

I

icons
paper clip, Attachment
ID numbers
AutoNumber and, Linking with the ID Column
linking tables with, Linking with the ID Column
lookups and, Lookups with Related Tables
related tables and, Joining Tables in a Query
implicit relationships, Using a Relationship
importing
basic steps for, Importing Data, Importing from an Excel File
from Excel files, Importing from an Excel File, Importing from an Excel File, Importing from an Excel File
from text files, Exportable File Types
from XML files, Importable File Types
Increment option (New Values field property), Using AutoNumbers without revealing the size of your table
Indexed field property, Preventing Duplicate Values with Indexes
indexes
compound, Multifield indexes
Indexes window, Multifield indexes, Multifield indexes
inner joins, Outer Joins, Finding unmatched records
Input Mask property, Using a Ready-Made Mask, Using a Ready-Made Mask
Input Mask wizard, Using a Ready-Made Mask
integer division, Simple Math with Numeric Fields
Integer option, Number size

J

Join Properties dialog box, Outer Joins
join queries
modifying information via, Joining Tables in a Query
multiple joins, Multiple Joins
outer joins, Outer Joins
relationships vs., Joining Tables in a Query
tables in, Joining Tables in a Query, Joining Tables in a Query, Joining Tables in a Query, Joining Tables in a Query, Joining Tables in a Query, Outer Joins
Justified option (layouts), The Form Wizard

L

.laccdb file extension, Opening More Than One Database at Once
Landscape option (Page Layout), Changing the page layout
landscape orientation, Changing the page layout, Previewing a Report
Layout view
for forms, Creating a Simple Form
for reports, The Many Views of a Report
layouts
page, Moving around the print preview
tabular, The Form Wizard
Left Arrow key, Shortcut keys
length, Text length
Like operator, Validating text, Validating text
linked records, Cascading updates
linked tables
forms and, Form Basics
parent-child relationship and, Joining Tables in a Query
with relationships, Linking Tables with Relationships, Redundant Data vs. Related Data, Redundant Data vs. Related Data, Matching Fields: The Relationship Link, Linking with the ID Column, The Parent-Child Relationship, The Parent-Child Relationship, Defining a Relationship, Defining a Relationship, Defining a Relationship, Defining a Relationship, Defining a Relationship, Defining a Relationship, Editing Relationships, Referential Integrity, Blank values for unlinked records, Cascading deletes, Cascading deletes, Cascading updates, Lookups with Related Tables, Lookups with Related Tables, Lookups with Related Tables, Lookups with Related Tables, More Exotic Relationships, One-to-One Relationship, One-to-One Relationship, Many-to-Many Relationship, Junction tables, Relationship Practice, The Music School, Identifying the relationships, Getting more detailed, Getting more detailed, Getting more detailed
linking/links
fields with relationships, Defining a Relationship
Long Date format (Date/Time data type), Date/Time
Long Integer option (Field Size property), Number size, Using AutoNumbers without revealing the size of your table
Long Time format (Date/Time data type), Date/Time
lookup lists
sorting, Lookups with Related Tables
Lookup Wizard
setting allowed values, Access Data Types
lookups
creating, Lookups with Related Tables
data validation, Creating a Simple Lookup with Fixed Values, Creating a Simple Lookup with Fixed Values
primary key and, Lookups with Related Tables
refreshing, Lookups with Related Tables
table-based, Creating a Simple Lookup with Fixed Values
with fixed values, Creating a Simple Lookup with Fixed Values, Creating a Simple Lookup with Fixed Values, Creating a Simple Lookup with Fixed Values, Adding New Values to Your Lookup List
Lotus 1-2-3, Importable File Types

M

macros, Understanding Access Databases
mail merge feature, Understanding Exports
make-table queries, The Action Query Family, Creating an Append (or Make-Table) Query, Creating an Append (or Make-Table) Query, Creating an Append (or Make-Table) Query, Delete Queries
many-to-many relationship, Many-to-Many Relationship, Many-to-Many Relationship, Junction tables, Multiple Joins
Margins option (Page Layout), Changing the page layout
matching fields, Matching Fields: The Relationship Link
math operations
order of, Order of operations
with numeric fields, Defining a Calculated Field, Simple Math with Numeric Fields, Date fields, Expressions with Text
maximum length
guidelines for, Memo
Memo data type and, Memo
text fields, Text, Memo
.mdb file extension, Creating a Simple Table
Medium Date format (Date/Time data type), Date/Time
Medium Time format (Date/Time data type), Date/Time
Microsoft Office Security Options dialog box, Update Queries
minibar, Formatted text
modules, Understanding Access Databases
modulus, Simple Math with Numeric Fields
moving
columns, Rearranging Columns
fields, Organizing and Describing Your Fields
fields in forms, Creating a Simple Form
multifield indexes, Multifield indexes, Multifield indexes, Multifield indexes
multiple joins, Multiple Joins, Multiple Joins, Multiple Joins
multiplication, Simple Math with Numeric Fields, Order of operations

N

named range, Importing from an Excel File
naming
fields, 2. Break Down Your Information
navigating
around forms, Using a Form
print preview, Print Preview
relationships, Navigating a Relationship, Navigating a Relationship
navigation pane
browsing tables with, Browsing Tables with the Navigation Pane, Browsing Tables with the Navigation Pane
printing reports from, Printing, Previewing, and Exporting a Report
running queries in, Update Queries
negative number values
Number data type, Number
New Values field property, Using AutoNumbers without revealing the size of your table
Normal mode, Edit mode
Now( ) function, Validating dates
Number data type
Currency data type and, Currency
Field Size property, Text, Number size
numbers
decimal, Number size, Formatting numeric fields
in text fields, Input Masks
negative, Number, Applying a Field Validation Rule
validating, Validating dates
numeric fields
formatting, Formatting Columns and Column Headers, Alternating row formatting
Nz( ) function, Simple Math with Numeric Fields

O

ODBC, Importable File Types
one-to-many relationships, The Parent-Child Relationship, Junction tables, Junction tables
one-to-one relationships
cautions for, One-to-One Relationship
Open Recent Databases section, Getting Started, Opening a Database
opening
databases, Opening a Database
multiple subdatasheets, Navigating a Relationship
previous version databases, Opening a Database Created in an Older Version of Access
tables, Browsing Tables with the Navigation Pane, Creating a Query in Design View
Zoom box, Memo, Formatted text, Order of operations
operators, Date fields
Or operator
filtering and, Saving Filters for the Future
order of operations, Order of operations
outer joins, Outer Joins, Outer Joins, Finding unmatched records, Multiple Joins
Outlook (Microsoft), Importable File Types

P

Page Down key, Shortcut keys, Moving around the print preview
page layouts, Moving around the print preview
page numbers (reports), Creating a Simple Report, Creating a Report from Scratch
Page Up key, Shortcut keys, Moving around the print preview
paper clip icon, Attachment
paper orientation
landscape, Previewing a Report
portrait, Changing the page layout, Previewing a Report
paper size, Previewing a Report
Paradox, Importable File Types
parent-child relationships
junction tables and, Junction tables
navigating, Navigating a Relationship
parentheses ( ), Order of operations
PDF files
exporting reports as, Exporting a Report
saving reports as, Exporting a Report, Getting the “Save As PDF” Add-in
percent symbol (%), Date fields
phone number mask, Using a Ready-Made Mask
pictures
adding to reports, Adding and Removing Fields
clipboard support, Using the Clipboard
point-in-time data, Ordering products
Portrait option (Page Layout), Changing the page layout
portrait orientation, Changing the page layout, Previewing a Report
PowerPoint (Microsoft), Understanding Exports
previewing reports, Printing, Previewing, and Exporting a Report
primary keys
duplicate records and, The Primary Key, Preventing Duplicate Values with Indexes, One-to-One Relationship
Print Preview mode
changing page layouts, Changing the page layout
forms and, Printing records
reports and, The Many Views of a Report
printing
changing settings for, The Many Views of a Report
print preview feature, Print Preview, Print Preview, Print Preview, Changing the page layout
records from forms, Sorting a Form
relationships, Getting more detailed
reports, Previewing a Report
properties, Access Data Types
Property Sheet
Publish As PDF dialog box, Getting the “Save As PDF” Add-in
table validation and, Creating a Table Validation Rule

Q

queries
append, Append Queries, Append Queries, Creating an Append (or Make-Table) Query, Creating an Append (or Make-Table) Query, Creating an Append (or Make-Table) Query
calculated fields, Calculated Fields, Defining a Calculated Field, Simple Math with Numeric Fields, Simple Math with Numeric Fields, Expressions with Text
delete, The Action Query Family, Creating an Append (or Make-Table) Query, Delete Queries
Design view and, Creating Queries, Creating a Query in Design View, Creating a Query in Design View, Creating a Query in Design View, Creating a Query in Design View, Creating a Query in Design View, Getting the top records
finding unmatched records, Finding unmatched records
make-table, Creating an Append (or Make-Table) Query
Query wizard, Creating Queries, Creating a Simple Query with the Query Wizard, Creating a Simple Query with the Query Wizard
saving, Creating a Query in Design View
saving filters with, Saving Filters for the Future
select, Query Basics, Queries that Update Records
SQL view and, Creating Queries
update, Update Queries, Update Queries, Update Queries, Update Queries, Update Queries, Update Queries
viewing top records, Getting the top records, Getting the top records
way to create, Creating Queries
query parameters, Update Queries
Query wizard, Creating Queries, Creating a Simple Query with the Query Wizard, Creating a Simple Query with the Query Wizard, Creating a Simple Query with the Query Wizard, Creating a Simple Query with the Query Wizard
Quick Access toolbar
Undo command, Making Backups
quick search feature, Searching
quotation marks (“), Building filter expressions

R

Random option (New Values field property), Using AutoNumbers without revealing the size of your table
RDBMS (relational database management system), The Parent-Child Relationship
Recent Document list (Office menu), Opening a Database
records
action queries and, Queries that Update Records
appending, Append Queries
AutoNumber data type in, AutoNumber
blank values for unlinked, Blank values for unlinked records
copying in one step, Cut, copy, and paste
deleting, Editing a Table, Creating an Append (or Make-Table) Query
editing, Editing a Table
filtering in tables, Filtering, Filter by selection, Filter by selection, Searching
finding/editing in forms, Finding and editing a record
identifying before deleting, Delete Queries
linked, Cascading updates
many-to-many relationships, Junction tables
one-to-one relationships, More Exotic Relationships
searching, Searching, Searching, Searching
sorting in queries, Creating a Query in Design View
sorting in tables, Sorting, Sorting, Sorting on multiple fields
updating, Update Queries
redundant data, 5. Avoid Redundant Information, Redundant Data vs. Related Data, Redundant Data vs. Related Data
referential integrity, Defining a Relationship, Referential Integrity, Referential Integrity, Cascading deletes, Cascading deletes, Lookups with Related Tables
Regional and Language Options dialog box, Yes/No
related data, Redundant Data vs. Related Data, Redundant Data vs. Related Data, Redundant Data vs. Related Data
relational database management system (RDBMS), The Parent-Child Relationship
relationship diagram, Defining a Relationship, Editing Relationships
Relationship window, Editing Relationships
relationships, Lookups with Related Tables
Chocolate Store practice, The Chocolate Store, The product catalog and customer list, Ordering products, Ordering products
defining, Defining a Relationship
defining between tables, Joining Tables in a Query
explicit, Using a Relationship
lookups with related tables, Lookups with Related Tables, Lookups with Related Tables
many-to-many, Many-to-Many Relationship
Music School practice, The Music School, Identifying the relationships, Getting more detailed
one-to-many, Junction tables
one-to-one, One-to-One Relationship, One-to-One Relationship, One-to-One Relationship
printing, Getting more detailed
redundant vs. related data, Redundant Data vs. Related Data
referential integrity, Defining a Relationship, Referential Integrity, Referential Integrity, Cascading deletes
Relationships tab
defining relationships, Defining a Relationship, Defining a Relationship, Defining a Relationship, Referential Integrity
Remove Filter command, Quick filters
renaming database objects, Managing Database Objects
Replication ID option (Field Size property), Using AutoNumbers without revealing the size of your table
replication IDs, Using AutoNumbers without revealing the size of your table, Using Replication IDs
report title, Arranging a Report, Creating a Report from Scratch
Report view (reports), Creating a Simple Report, The Many Views of a Report, Formatting a Report
reports
adding/removing fields, Adding and Removing Fields
arranging, Adding and Removing Fields
creating, Creating a Simple Report
exporting, Exporting a Report, Exporting a Report, Exporting a Report, Getting the “Save As PDF” Add-in
filtering, Filtering a Report, Filtering a Report
formatting, Creating a Simple Report, Formatting a Report, Formatting a Report, Formatting Columns and Column Headers, Formatting Columns and Column Headers, Alternating row formatting, Gridlines
hidden fields in, Adding and Removing Fields
previewing, Previewing a Report
printing, Printing, Previewing, and Exporting a Report, Exporting a Report, Exporting a Report, Getting the “Save As PDF” Add-in
saving, Creating a Simple Report
saving as PDF files, Getting the “Save As PDF” Add-in
sorting, Sorting a Report
views for, The Many Views of a Report, The Many Views of a Report, The Many Views of a Report
Required field property
empty values and, Preventing Blank Fields, Blank values and empty text
support for, Blank values and empty text
resizing
columns in forms, Creating a Simple Form
rows and columns, Resizing Rows and Columns, Resizing Rows and Columns
ribbon (Access 2007)
collapsing, Managing Database Objects
formatting datasheets, Formatting the Datasheet, Formatting the Datasheet
Print Preview mode, Previewing a Report
rich text, Formatted text, Copying a Table from Access to Somewhere Else
Right Arrow key, Edit mode, Saving a Database with a Different Name or Format
rows
copying elsewhere, Copying a Table from Access to Somewhere Else
formatting alternate, Alternating row formatting

S

Save As menu command, Saving a Database with a Different Name or Format
Save button (Quick Access toolbar), How Updates Work in Design View
saving
database diagram, Defining a Relationship
databases, Saving and Opening Access Databases, Saving and Opening Access Databases
filters, Saving Filters for the Future
report export settings, Exporting a Report
scientific notation, Formatting numeric fields
searching
records, Searching, Searching
security, Opening a Database
setting, Blank values for unlinked records, Cascading deletes, Cascading deletes
SharePoint, Importable File Types
Shift+F2 key combination, Memo, Formatted text, Resizing Rows and Columns, Order of operations
Shift+Tab key combination, Shortcut keys
Short Date format (Date/Time data type), Date/Time, Yes/No
Short Time format (Date/Time data type), Date/Time
shortcut keys
clipboard, Using the Clipboard
Edit Hyperlink window, Hyperlink
Show Dialog box, Multiple Joins
Show Table dialog box
adding tables, Defining a Relationship
Simple Query Wizard, Creating a Simple Query with the Query Wizard
Single option (Field Size property), Number size
Size option (Page Layout), Changing the page layout
Snapshot Viewer program, Exporting a Report, Getting the “Save As PDF” Add-in
sorting
forms, Sorting and Filtering in a Form
records in queries, Creating a Query in Design View
records in tables, Sorting, Sorting
spaces
adding between report rows, Arranging a Report
special characters
Access support, Creating a New Database
split forms, The Form Wizard
SQL view, Creating Queries
square brackets [], 1. Choose Good Field Names, Defining a Calculated Field
subdatasheets
adding and linking support, Ordering products
subtraction, Simple Math with Numeric Fields, Order of operations

T

Tab (or Enter) key, Shortcut keys
tab character, Importing from a Text File
tables
appending data to, Importing Data
combining related, Query Basics
data types and, Building Smarter Tables, Access Data Types, Access Data Types, Text, Memo, Memo, Memo, Formatted text, Number formatting, Currency, Date/Time, Yes/No, Hyperlink, Attachment, Attachment, Attachment, AutoNumber, Using AutoNumbers without revealing the size of your table, Using Replication IDs
database design principles, Six Principles of Database Design
Datasheet view, Design View
Design view, Design View, Design View, Design View, Organizing and Describing Your Fields, Access Data Types
duplicate information in, 4. Avoid Duplicating Information, 4. Avoid Duplicating Information
filter by selection, Filter by selection
junction, Junction tables, Junction tables, Multiple Joins
one-to-one relationships, One-to-One Relationship
ordering records, Sorting
primary key, The Primary Key, The Primary Key, Creating Your Own Primary Key Field
relationship diagram and, Editing Relationships
Relationships tab and, Defining a Relationship
removal restrictions, Referential Integrity
validation rules for, Creating a Table Validation Rule, Creating a Table Validation Rule, Creating a Table Validation Rule
tabs
Access Options window, Opening a Database Created in an Older Version of Access
tabular layouts, The Form Wizard
Tabular option (layouts), The Form Wizard
testing
action queries, Testing Action Queries (Carefully)
Text data type
length considerations, Text length, Text length
mask support, Input Masks, Input Masks, Input Masks, Using a Ready-Made Mask, Using a Ready-Made Mask, Using a Ready-Made Mask
text files
importing from, Exportable File Types
text-based information
numbers in, Input Masks
Try It text box, Using a Ready-Made Mask

U

Undo command
form changes and, Finding and editing a record
unfreezing columns, Freezing Columns
Unhide Columns dialog box, Hiding Columns
unhiding columns, Hiding Columns
universal dates, Validating dates
Up Arrow key, Shortcut keys
update queries, Update Queries, Update Queries, Update Queries, Update Queries, Update Queries, Update Queries, Update Queries, Update Queries
updates
cascading, Cascading updates
Design view and, How Updates Work in Design View
modifying records, The Action Query Family, Update Queries, Update Queries, Update Queries, Update Queries, Update Queries, Append Queries

V

Validation Rule property, Applying a Field Validation Rule, Applying a Field Validation Rule
validation rules
expressions for numbers, Validating numbers
field, Applying a Field Validation Rule, Applying a Field Validation Rule, Applying a Field Validation Rule, Validating text, Validating text, Combining validation conditions
filters and, Building filter expressions
for text, Validating dates, Validating text, Validating text
table, Creating a Table Validation Rule, Creating a Table Validation Rule, Creating a Table Validation Rule
Validation Text property, Applying a Field Validation Rule
views
for forms, Creating a Simple Form, Using a Form

W

width, Resizing Rows and Columns
Windows environment, Yes/No
Windows Task Scheduler, Making Backups
Windows Vista, Exporting a Report
workbooks, Importing from an Excel File
worksheets (Excel), Importing from an Excel File

Z

Zoom box
displaying column contents, Resizing Rows and Columns
opening, Memo
zoom feature, Moving around the print preview, Previewing a Report
..................Content has been hidden....................

You can't read the all page of ebook, please click here login for view all page.
Reset
18.222.196.175