Access 2003 Personal Trainer (Personal Trainer (O'Reilly))

1728 Pages·2005·20.21 MB·English

by  Inc. CustomGuide

Access 2003 Personal Trainer
T able of Contents
C opyright
A bout CustomGuide, Inc.
C ustomGuide, Inc. Staff and Contributors
I ntroduction
A bout the Personal Trainer Series
A bout This Book
C onventions Used in This Book
U sing the Interactive Environment
H ow to Contact Us
S afari® Enabled
C hapter 1. The Fundamentals
L esson 1.1. Introduction to Databases
L esson 1.2. What's New in Access 2003
L esson 1.3. Starting Access and Opening a Database
L esson 1.4. Understanding the Access Program Screen
L esson 1.5. Using Menus
L esson 1.6. Using Toolbars
L esson 1.7. Filling Out Dialog Boxes
L esson 1.8. Keystroke and Right Mouse Button Shortcuts
L esson 1.9. Opening and Modifying Database Objects
L esson 1.10. Working with Multiple Windows
L esson 1.11. Tour of a Table
L esson 1.12. Adding, Editing, and Deleting Records
L esson 1.13. Tour of a Form
L esson 1.14. Tour of a Query
L esson 1.15. Tour of a Report
L esson 1.16. Previewing and Printing a Database Object
L esson 1.17. Selecting Data
L esson 1.18. Cutting, Copying, and Pasting Data
L esson 1.19. Using Undo
L esson 1.20. Checking Your Spelling
L esson 1.21. Getting Help
L esson 1.22. Changing the Office Assistant and Using
theButton
L esson 1.23. Using the Zoom Box
L esson 1.24. Closing a Database and Exiting Access
C hapter One Review
C hapter 2. Creating and Working with a Database
L esson 2.1. Planning a Database
L esson 2.2. Creating a Database Using the Database
Wizard
L esson 2.3. Creating a Blank Database
L esson 2.4. Creating a Table Using the Table Wizard
L esson 2.5. Modifying a Table and Understanding Data
Types
L esson 2.6. Creating a New Table from Scratch
L esson 2.7. Creating a Query in Design View
L esson 2.8. Modifying a Query
L esson 2.9. Sorting a Query Using Multiple Fields
L esson 2.10. Developing AND and OR Operators
L esson 2.11. Creating a Form with the Form Wizard
L esson 2.12. Creating a Report with the Report Wizard
L esson 2.13. Creating Mailing Labels with the Label
Wizard
L esson 2.14. Database Object Management
L esson 2.15. File Management
L esson 2.16. Compacting and Repairing a Database
L esson 2.17. Converting an Access Database
C hapter Two Review
C hapter 3. Finding, Filtering, and Formatting Data
L esson 3.1. Finding and Replacing Information
L esson 3.2. Sorting Records
L esson 3.3. Filtering by Selection
L esson 3.4. Filtering by Form
L esson 3.5. Creating an Advanced Filter
L esson 3.6. Adjusting Row Height and Column Width
L esson 3.7. Rearranging Columns
L esson 3.8. Changing Gridline and Cell Effects
L esson 3.9. Freezing a Field
L esson 3.10. Hiding a Column
L esson 3.11. Changing the Datasheet Font
C hapter Three Review
C hapter 4. Working with Tables and Fields
L esson 4.1. Understanding Field Properties
L esson 4.2. Indexing a Field
L esson 4.3. Adding a Primary Key to a Table
L esson 4.4. Inserting, Deleting, and Reordering Fields
L esson 4.5. Changing a Field's Data Type
L esson 4.6. Using Field Descriptions
L esson 4.7. Adding a Caption
L esson 4.8. Changing the Field Size
L esson 4.9. Formatting Number, Currency, and
Date/Time Fields
L esson 4.10. Formatting Number, Currency, and
Date/Time Fields by Hand
L esson 4.11. Formatting Text Fields
L esson 4.12. Setting a Default Value
L esson 4.13. Requiring Data Entry
L esson 4.14. Validating Data
L esson 4.15. Creating an Input Mask
L esson 4.16. Creating a Lookup Field
L esson 4.17. Creating a Value List
L esson 4.18. Modifying a Lookup List
C hapter Four Review
C hapter 5. Creating Relational Databases
L esson 5.1. Understanding Table Relationships
L esson 5.2. Creating Relationships Between Tables
L esson 5.3. Enforcing Referential Integrity
L esson 5.4. Testing Referential Integrity & Printing and
Deleting Table Relationships
L esson 5.5. Understanding Relationship Types
C hapter Five Review
C hapter 6. Working with Queries
L esson 6.1. A Quick Review
L esson 6.2. Understanding the Different Types of Queries
L esson 6.3. Creating a Multiple-Table Query
L esson 6.4. Creating a Calculated Field
L esson 6.5. Working with Expressions and the
Expression Builder
L esson 6.6. Using an IIf Function
L esson 6.7. Summarizing Groups of Records
L esson 6.8. Display Top or Bottom Values
L esson 6.9. Parameter Queries
L esson 6.10. Finding Duplicate Records
L esson 6.11. Finding Unmatched Records
L esson 6.12. Crosstab Queries
L esson 6.13. Delete Queries
L esson 6.14. Append Queries
L esson 6.15. Make-Table Queries
L esson 6.16. Update Queries
C hapter Six Review
C hapter 7. Working with Forms
L esson 7.1. Creating a Form with AutoForm
L esson 7.2. Modifying a Form
L esson 7.3. Adding and Deleting Fields
L esson 7.4. Moving and Sizing Controls
L esson 7.5. Changing the Tab Order
L esson 7.6. Working with Control Properties
L esson 7.7. Control Property Reference
L esson 7.8. Working with Form Properties
L esson 7.9. Form and Report Property Reference
L esson 7.10. Working with Multiple Controls
L esson 7.11. Adding, Cutting, Copying, and Pasting
Controls
L esson 7.12. Changing a Control's Data Source
L esson 7.13. Creating a Calculated Control
L esson 7.14. Changing a Control's Default Value
L esson 7.15. Using the Control Wizard
L esson 7.16. Creating a Subform
L esson 7.17. Modifying and Working with Subforms
C hapter Seven Review
C hapter 8. Working with Reports
L esson 8.1. Creating a Report with AutoReport
L esson 8.2. Modifying a Report
L esson 8.3. Adding and Deleting Fields
L esson 8.3. Moving and Sizing Controls
L esson 8.5. Adjusting Page Margins and Orientation
L esson 8.6. Adding Page Numbers and Dates
L esson 8.7. Understanding Report Sections
L esson 8.8. Grouping and Sorting Records
L esson 8.9. Creating Calculated Controls
L esson 8.10. Working with Section Properties
L esson 8.11. Creating Charts with the Chart Wizard
C hapter Eight Review
C hapter 9. Formatting Forms and Reports
L esson 9.1. Formatting Fonts with the Formatting
Toolbar
L esson 9.2. Changing Text Alignment
L esson 9.3. Using AutoFormat
L esson 9.4. Changing Colors
L esson 9.5. Applying Special Effects
L esson 9.6. Using the Format Painter
L esson 9.7. Adding Pictures and Lines
L esson 9.8. Aligning Controls with One Another
L esson 9.9. Changing a Control's Formatting Properties
C hapter Nine Review
C hapter 10. Working with Macros
L esson 10.1. Creating and Running a Macro
L esson 10.2. Editing a Macro
L esson 10.3. Working with Macro Groups
L esson 10.4. Assigning a Macro to an Event
L esson 10.5. Creating Conditional Expressions
L esson 10.6. Assigning a Macro to a Keystroke
Combination
L esson 10.7. Macro Action Reference
C hapter Ten Review
C hapter 11. Advanced Topics
L esson 11.1. Importing Information
L esson 11.2. Exporting Information
L esson 11.3. Importing Objects from Another Access
Database
L esson 11.4. Linking Information from an External
Source
L esson 11.5. Analyzing Records with Microsoft Excel
L esson 11.6. Exporting Records to Microsoft Word
L esson 11.7. Mail Merging Records to Microsoft Word
L esson 11.8. Using Hyperlink Fields
L esson 11.9. Using OLE Object Fields
L esson 11.10. Displaying Database Object Dependencies
C hapter Eleven Review
C olophon
I ndex
S YMBOL
A
B
C
D
E
F
G
H
I
J
K
L
M
N
O
P
Q
R
S
T
U
V
W
X
Y
Z