by Laura C. Larsson

Contents

1. Abstract 
2. Introduction to the Workshop
3. What is Microsoft Access?
4. Converting Existing Information: Turn Data in an Excel Spreadsheet into an Access Database using the Access Conversion Wizard
5. Examining an Existing Access 97 Database
6. Planning a serials database in Access 97  the design process
7. Opening a New Database
8. Creating Tables and Adding Fields in Access 97
9. Building relationships (entity relationship diagrams, that is)
10. Creating Forms 
11. Data Entry
12. Finding Information in Access
13. Getting Information Out of the Database: Writing Queries 
14. The End Result: Generating a Report 
15. Present and Future Considerations 
16. Exporting Access Data to Excel
17. Helpful Hints
18. Reference and Resources 
19. Glossary of Terms

©1998. Permission to copy the content of this document is automatically granted for non-commerical educational use. Please e-mail the author (larsson@u.washington.edu) if you plan to use the document in a class. Permission for commercial use of the content, including seminars where a fee is charged, must be obtained in advance from the author.