Access 2002 Book

Chapter 1	Working with Access
	Case Study
1.1	Getting Started with Access
1.1.1	Loading and Exiting Access	3
1.1.2	Opening a Database File at Startup	4
1.1.3	Touring Access	7
1.1.4	Working in the Database Window	10
1.2	Viewing and Printing Your Data
1.2.1	Moving Around a Datasheet	14
1.2.2	Adjusting Column Widths and Row Heights	18
1.2.3	Previewing and Printing	20
1.3	Manipulating Table Data
1.3.1	Selecting and Editing Data	23
1.3.2	Using the Undo Command	26
1.3.3	Adding Records	27
1.3.4	Deleting Records	30
Chapter 2	Creating a Database
	Case Study
2.1	Designing Your First Database
2.1.1	Planning a Database	50
2.1.2	Starting a New Database	51
2.1.3	Employing the Database Wizard	54
2.2	Creating a Simple Table
2.2.1	Creating a Table Using the Table Wizard	60
2.2.2	Creating a Table in Datasheet View	63
2.3	Using the Table Design View
2.3.1	Creating a Table in Design View	65
2.3.2	Assigning a Primary Key	68
2.3.3	Defining and Removing Indexes	70
2.4	Modifying a Table
2.4.1	Inserting and Deleting Fields	72
2.4.2	Renaming and Moving Fields	75
2.4.3	Printing a Table's Design Structure	77
Chapter 3	Organizing and Retrieving Data
	Case Study
3.1	Customizing Datasheet View
3.1.1	Formatting a Datasheet	98
3.1.2	Changing the Field Column Order	101
3.1.3	Hiding and Unhiding Columns	103
3.1.4	Freezing and Unfreezing Columns	106
3.2	Sorting, Finding, and Maintaining Data
3.2.1	Sorting Records in a Datasheet	107
3.2.2	Performing a Simple Search	110
3.2.3	Specifying Search Patterns	111
3.2.4	Performing a Find and Replace	113
3.2.5	Spell-Checking a Datasheet	114
3.3	Using Filters
3.3.1	Filtering for Input	116
3.3.2	Filtering by Selection	118
3.3.3	Filtering by Form	120
3.4	Creating a Simple Query
3.4.1	Creating a Query Using the Query Wizard	124
3.4.2	Displaying the Query Window	127
Chapter 4	Presenting and Managing Data
	Case Study
4.1	Creating a Simple Form
4.1.1	Creating a Form Using the AutoForm Wizards	147
4.1.2	Creating a Form Using the Form Wizard	151
4.1.3	Navigating Data Using a Form	155
4.1.4	Working with a Form	158
4.2	Creating a Simple Report
4.2.1	Creating a Report Using the AutoReport Wizards	161
4.2.2	Creating a Report Using the Report Wizard	163
4.2.3	Previewing and Printing a Report	167
4.2.4	Publishing a Static Report to the Web	170
4.3	Generating a Mailing Labels Report
4.3.1	Creating a Report Using the Label Wizard	174
4.4	Managing Database Objects
4.4.1	Renaming, Copying, and Deleting Objects	180
4.4.2	Compacting, Repairing, and Converting a Database	183
	Answers to Self-Check Questions
	Glossary
Appendix	Preparing to Use Office XP