Microsoft Access
Workshop Information

Back to All Handouts

Formats used for handouts are Microsoft Word and PowerPoint.

To save the files, right click on the link, choose "Save Target As..."

Access Basics & Database Fundamentals
3 hours
This workshop assumes you are comfortable with a computer and have some knowledge of other Microsoft Office programs. Topics include database concepts, introduction to tables, queries, forms and reports. This workshop is a prerequisite to the other Access workshops.
 
Access 2003    
     Workshop Handout
10 pages
     Workshop Presentation
30 slides
     Instructor Notes
23 pages
Access 2007    
     Workshop Handout
11 pages
     Workshop Presentation
30 slides
     Instructor Notes
21 pages
 
Access Tables
1.5 hours
This workshop requires completion of "Access: Basics". Topics include importing and linking tables, data types, formats, input masks, data entry, table analyzer, lookup values, copying tables, primary keys and AutoForms.
 
Access 2003    
     Workshop Handout
19 pages
     Instructor Notes
2 pages
Access 2007    
     Workshop Handout
19 pages
     Instructor Notes
3 pages
Access 2000, 2003, 2007
          Workshop Files
patients.xls (25KB)
visits.xls (33KB)
Employee Pictures, bitmap images 30kb each
 
Access Relationships
2.0 hours
This workshop requires completion of "Access: Basics" and "Access: Tables" highly recommended. Topics include one-to-one and one-to-many relationships; junction tables; primary and foreign keys; cascade update and cascade delete; and join properties.
 
Access 2003
          Workshop Handout
14 pages
          Workshop Planning Sheet
1 page
Access 2007
          Workshop Handout
9 pages
          Workshop Planning Sheet
1 page
Access 2000, 2003, 2007
          Workshop Presentation
34 slides
          Workshop Files
          
 
Access Select Queries
2.0 hours
This workshop requires completion of "Access: Basics", "Access: Tables" and "Access: Relationships" recommended. Topics include table filters, select queries, sorting, using criterias, creating joined fields, totals, formatting numbers, and crosstabs.
 
Access 2003
          Workshop Handout
14 pages
Access 2007
          Workshop Handout
14 pages
Access 2000, 2003, 2007
          Instructor Notes
4 pages
          Workshop File
 
Access Intro Forms and Reports
2.0 hours
This workshop requires completion of "Access: Basics"; "Access: Tables" and "Access: Relationships" recommended. Topics include using AutoForm, form wizards, AutoReport, report wizards, and creating simple forms and reports in a design view.
 
Access 2003
          Workshop Handout
16 pages
          Instructor Notes
2 pages
Access 2007
          Workshop Handout
20 pages
          Instructor Notes
2 pages
Access 2000, 2003, 2007
          Workshop File
 
Access Forms
2.0 hours
This workshop requires completion of "Access: Basics" and "Intro to Forms and Reports". Topics include formatting fields in a Form, Tab Controls, SubForms, Menu Forms, startup options and Linking Forms.
 
Access 2003
          Workshop Handout
11 pages
Access 2007
          Workshop Handout
13 pages
Access 2000, 2003, 2007
          Workshop File
 
Access Reports
1.5 hours
This workshop requires completion of "Access: Basics" and "Intro to Forms and Reports". Topics include using AutoReport, report wizard, sorting and grouping, using mathematical functions, using special queries and formatting reports.
 
Access 2003
          Workshop Handout
10 pages
Access 2007
          Workshop Handout
10 pages
Access 2000, 2003, 2007
          Workshop File
 
Access Advanced Queries
1.5 hours
This workshop requires completion of "Access: Basics" and "Select Queries", and "Intro to Forms and Reports". Topics include action queries; relationship join properties; linking query values to forms.
 
Access 2000/2003
          Workshop Handout
22 pages
Access 2007
          Workshop Handout
23 pages
Access 2000, 2003, 2007
          Active Lookup Drawing
1 slide
          Instructor Notes
3 pages
          Workshop File
 
Access Forms and Macros
1.5 hours
This workshop requires completion of "Access: Basics", "Intro to Forms and Reports" and "Forms". Topics include formatting creating menus, linking forms through buttons, creating tabular subforms, creating macros, using macros in buttons and in other events.
 
Access 2003
          Workshop Handout
10 pages
Access 2007
          Workshop Handout
11 pages
Access 2000, 2003, 2007
          Workshop Files
 
 
OTHER STUFF...
Access 2000/2003
How can I work with lots of images in my database?
1 page
How do I get the hyperlink field to work with email addresses?
1 page
Why can't I edit my linked Excel file?
1 page
What words should I not use when naming my fields/objects?
2 pages
How do I print the report name on the report?
2 pages