| |
| |
| |
| Learning the Basics | |
| |
| |
| |
| Installing Microsoft Access 97 | |
| |
| |
| |
| Starting Access from the Start Button | |
| |
| |
| |
| Opening an Existing Database | |
| |
| |
| |
| Using Menu Commands | |
| |
| |
| |
| Using Toolbar Buttons | |
| |
| |
| |
| Using Tab Buttons | |
| |
| |
| |
| Getting Help | |
| |
| |
| |
| Using the Index | |
| |
| |
| |
| Choosing an Office Assistant | |
| |
| |
| |
| Asking a Question | |
| |
| |
| |
| Using Context-Sensitive Help | |
| |
| |
| |
| Exiting Access | |
| |
| |
| |
| Designing and Creating an Access Database | |
| |
| |
| |
| Adding a Folder for the Database | |
| |
| |
| |
| Creating a New Database | |
| |
| |
| |
| Using the Table Wizard | |
| |
| |
| |
| Adding a New Field in Design View | |
| |
| |
| |
| Working with Number Fields | |
| |
| |
| |
| Adding a Yes/No Field | |
| |
| |
| |
| Saving a New Table Definition | |
| |
| |
| |
| Opening a Table | |
| |
| |
| |
| Changing a Field Name | |
| |
| |
| |
| Moving a Field Within a Table | |
| |
| |
| |
| Inserting a Field | |
| |
| |
| |
| Adding a New Field in Datasheet View | |
| |
| |
| |
| Deleting a Field | |
| |
| |
| |
| Building a Table from Scratch | |
| |
| |
| |
| Entering and Editing Data | |
| |
| |
| |
| Entering New Information in a Table | |
| |
| |
| |
| Copying Information from Another Record | |
| |
| |
| |
| Editing Data in a Field | |
| |
| |
| |
| Undoing an Edit | |
| |
| |
| |
| Searching for Information | |
| |
| |
| |
| Replacing Selected Information | |
| |
| |
| |
| Sorting Records | |
| |
| |
| |
| Using Filters | |
| |
| |
| |
| Filtering by Form | |
| |
| |
| |
| Deleting a Selected Record | |
| |
| |
| |
| Completing the Supplier Table | |
| |
| |
| |
| Resizing Rows and Columns | |
| |
| |
| |
| Freezing and Unfreezing Columns | |
| |
| |
| |
| Hiding and Unhiding Columns | |
| |
| |
| |
| Using Database Forms | |
| |
| |
| |
| Using an AutoForm | |
| |
| |
| |
| Building a Form with a Wizard | |
| |
| |
| |
| Opening the Form Design View Window | |
| |
| |
| |
| Adding Fields to a Form | |
| |
| |
| |
| Moving Fields in Form Design | |
| |
| |
| |
| Headers and Footers | |
| |
| |
| |
| Creating Labels | |
| |
| |
| |
| Using a Combo Box | |
| |
| |
| |
| Adding a List Box | |
| |
| |
| |
| Moving Objects | |
| |
| |
| |
| Editing a Label | |
| |
| |
| |
| Using an Option Button | |
| |
| |
| |
| Adding a Calculated Field | |
| |
| |
| |
| Adding Pop-Up Tip Text to Fields | |
| |
| |
| |
| Saving Your New Form | |
| |
| |
| |
| Opening a Form | |
| |
| |
| |
| Entering and Editing Information with a Form | |
| |
| |
| |
| Changing the Field Order | |
| |
| |
| |
| Getting Information from the Database | |
| |
| |
| |
| Opening Query Design View | |
| |
| |
| |
| Running and Saving a Query | |
| |
| |
| |
| Using the Crosstab Query | |
| |
| |
| |
| Selecting Records with Wildcards | |
| |
| |
| |
| Selecting Records with an OR Criteria | |
| |
| |
| |
| Selecting Records with More than One Criterion | |
| |
| |
| |
| Using Arithmetic Operators | |
| |
| |
| |
| Adding a New Field | |
| |
| |
| |
| Calculating a Value with a Query | |
| |
| |
| |
| Deleting Records with a Query | |
| |
| |
| |
| Creating a Query That Prompts for a Criteria Variable | |
| |
| |
| |
| Creating and Using Reports | |
| |
| |
| |
| Building a Report with a Wizard | |
| |
| |
| |
| Opening the Report Design View | |
| |
| |
| |
| Adding Fields to the Report | |
| |
| |
| |
| Using Titles | |
| |
| |
| |
| Automatic Page Numbers and Dates | |
| |
| |
| |
| Grouping Records | |
| |
| |
| |
| Sorting Records | |
| |
| |
| |
| Moving Field Labels on the Report | |
| |
| |
| |
| Moving Fields on the Report | |
| |
| |
| |
| Calculated Fields in a Report | |
| |
| |
| |
| Adding Special Effects to a Report | |
| |
| |
| |
| Viewing a Report | |
| |
| |
| |
| Saving a Report | |
| |
| |
| |
| Printing a Report | |