2007 Access Workshop

Please read the brief introduction to database analysis, design and creation prior to the beginning of this workshop.
- The Workshop Introduction is here.
Three PowerPoint lectures have been prepared for this workshop. They represent 3 basic levels of user expertise on MS Access. I suggest printing them as "handouts" before coming to the workshop. If you have time, read the lectures prior to the workshop.
Each level of user expertise is accompanied by a matching database. They are zipped into one archive. Please save the archive to your personal network drive (H://) and extract the Access (mdb) files, so that they are ready to use on May 21.
- The Zip archive containing the Access mdb files for all 3 levels is here.
Each level of user expertise is also accompanied by a series of exercises, digitized into a PDF file from the following book:
- Perry, J. T. & Schneider, G. P. (2003). Building accounting systems using Access 2002. Mason, OH: Thomson.
- The PDF file with the necessary exercises is here.
Basic workshop agenda
- Analysis
  - Identification of user needs
  - Identification of atomic data elements
- Design of database
  - Tables
  - Relationships
  - Data input
    - Forms
  - Data Output
    - Queries
    - Reports
    - Web
- Implementation of design on MS Access
  - Using MS Access
    - Level 1
    - Level 2
    - Level 3
  - Creation of tables and relationships on the basis of the design
  - Creation of select queries and reports for user specified output