Easy Microsoft Access 97

Easy Microsoft Access 97

by Jeffrey L. Byrne

Paperback(2nd Edition)

$16.62 $19.99 Save 17% Current price is $16.62, Original price is $19.99. You Save 17%.
View All Available Formats & Editions

Product Details

ISBN-13: 9780789718228
Publisher: Pearson Education
Publication date: 11/10/1998
Series: Easy Series
Edition description: 2nd Edition
Pages: 209
Product dimensions: 10.01(w) x 8.00(h) x 0.62(d)

Table of Contents

1. 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.

2. 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.

3. 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.

4. 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-UpTip Text to Fields. Saving Your New Form. Opening a Form. Entering and Editing Information with a Form. Changing the Field Order.

5. 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.

6. 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.

Customer Reviews

Most Helpful Customer Reviews

See All Customer Reviews