NEW PERSPECTIVE SERIES &ndash MICROSOFT ACCESS 2000 (Catlett, VA)

NEW PERSPECTIVE SERIES &ndash MICROSOFT ACCESS 2000

Local pick-up preferred (please call first) but will ship at the buyer s expenseNOTE This book is a college text. Certain passages were High Lighted with a yellow marker.Kingston Books 15 IMG_7803Illustrated Charts Graphs Tables Screen ShotsTable of Contents (in brief)Microsoft Access 2000 Level I TutorialsTutorial 1 Introduction to Microsoft Access 2000Tutorial 2 Maintaining a Data BaseTutorial 3 Querying a DatabaseTutorial 4 Creating Forms ReportsMicrosoft Access 2000 Level II TutorialsTutorial 5 Creating More Advanced Queries and Custom FormsTutorial 6 Customizing Reports and Integrating Access with Other ProgramsTutorial 7 Working with HTML Documents Data Access Pages and Hyperlink FieldsAppendix Relational Databases and Database DesignIndex ..1Task Reference ..10Certification Grid ..16File Finder ..22Introduction to Database Concepts Organizing Data Databases and Relationships Relational Database Management SystemsStarting AccessOpening an Existing DatabaseThe Access and Database WindowsOpening an Access TableNavigating an Access Datasheet Printing a Table Exiting AccessCreating and Printing a QueryCreating and Printing a Form To Create the Form using AutoForm WizardGetting Help Finding Information with the Office Assistant To get Help about reports To display the additional Help Features Creating Previewing and Printing a ReportTo create the report using AutoReport Columnar Wizard Compacting a Database Compacting and Repairing a Database Compacting a Database Automatically Backing Up and Restarting a DatabaseMaintaining a Database Creating Modifying and Updating an Order Table Guidelines for Designing DatabasesGuidelines for Designing Access Tables Assigning Field Data Types Assigning Field Sizes Creating a Table Defining Fields Specifying the Primary Key Saving the Table Structure Adding Records to a Table Saving a DatabaseModifying the Structure of an Access Table Moving a Field Adding a Field Changing Field Properties To Add the record to the Modified Order Table Copying Records from Another Access DatabaseUsing the Office ClipboardUpdating a Database Deleting RecordsChanging RecordsQuerying A Database Introduction to Queries Query Window Creating and Running a Query Defining Table Relationships One-to-Many Relationships Referential Integrity Defining a Relationship Between To TablesSorting Data in a QuerySorting Multiple Fields in a Design ViewFiltering DataDefining Record Selection Criteria for QueriesSpecifying an Exact MatchChanging a Datasheet s AppearanceUsing a Comparison Operator to Match a Range of ValuesDefining Multiple Selection Criteria for QueriesThe And Logical OperationThe Or Logical OperatorPerforming CalculationsCreating a Calculated FieldUsing Aggregate Functions Using Record Group CalculationsCreating Forms and Reports Creating an Order Data Form a Customer Order Form and a Customers and Orders ReportCreating a From Using the Form WizardChanging a Form s AutoFormatNavigating a FormFinding Data Using a FormPreviewing and Printing Selected Form RecordsMaintaining Table Data Using a FormCreating a Form with a Main Form and a SubformCreating a Report Using the Report WizardInserting a Picture in a ReportConverting an Access 2000 Database to a Previous Version Creating More Advanced Queries and Custom Forms Customizing Reports and Integrating Access with Other Programs Working with HTML Documents Data Access Pages and Hyperlink FieldsAppendix Relational Databases and Database DesignIndex ..(pages 1 through 9)All rights reserved. This publication is protected by federal copyright law. No part of this publication may be reproduced stored in a retrieval system or transmitted in any form or by any means electronic mechanical photocopying recording or otherwise or be used to make a derivative work (such as translation or adaptation) without prior permission in writing from Course Technology. Paperback 319 pages ISBN 0-7600-7089-X