Microsoft Access 2003
Workshop Information


Formats used for handouts are Microsoft Word and PowerPoint.

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

 
#1 - Access 2003 Basics & Database Fundamentals
3.0 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 for the other Access workshops.
 
Before creating a database contact your Information Security Manager
Health Science Center: "Find your ISM"
Other UF Areas: Contact Security Office
     Workshop Handout
10 pages
     Workshop Presentation
30 slides
     Instructor Notes
23 pages
 
#2 - Access 2003 Tables and Field Properties
2.0 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.
 
     Workshop Handout
18 pages
Employee Pictures, bitmap images 30kb each
 
#3 - Access 2003 Relationships
2.5 hours
This workshop requires completion of "Access: Basics". Completion of "Access: Tables" recommended. Topics include table filters, select queries, custom sorts, using criteria, creating joined field expressionss, simple math, totals, formatting numbers, and crosstabs.
 
          Workshop Handout
14 pages
          Workshop Planning Sheet
1 page
          Workshop Presentation
34 slides
          Workshop Files
          
 
#4 - Access 2003 Select Queries
2.0 hours
This workshop requires completion of "Access: Basics". Completion of "Access: Tables" and "Access: Relationships" recommended. Topics include table filters; select queries; sorting; using criteria; creating joined fields; simple math; totals; formatting numbers; and crosstabs.
 
          Workshop Handout
14 pages
          Instructor Notes
4 pages
          Workshop File
 
#5 - Access 2003 Intro Forms and Reports
2.0 hours
This workshop requires completion of "Access: Basics". Topics include using AutoForm, form wizards, AutoReport, report wizards, and creating simple forms and reports in a design view.
 
          Workshop Handout
16 pages
          Instructor Notes
2 pages
          Workshop File
 
#6 - Access 2003 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.
 
          Workshop Handout
11 pages
          Workshop File
 
#7 - Access 2003 Reports
2.0 hours
This workshop requires completion of "Access: Basics", "Select Queries", and "Intro to Forms and Reports". Topics include using AutoReport, report wizard, sorting and grouping, using mathematical functions, using special queries and formatting reports.
 
          Workshop Handout
10 pages
          Workshop File
 
#8 - Access 2003 Advanced Queries
1.5 hours
This workshop requires completion of "Access: Basics", "Select Queries", and "Intro to Forms and Reports". Topics include action queries; relationship join properties; linking query values to forms and reports.
 
          Workshop Handout
22 pages
          Active Lookup Drawing
1 slide
          Workshop File
 
#9 - Access 2003 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.
 
          Workshop Handout
10 pages
          Workshop Files
 
 
OTHER STUFF...
Common Questions/Solutions    
- Working with Multiple Choice Questions
- How do I print the report name on the report?
2 pages
-What words should I not use when naming my fields/objects?
2 pages
- How do I get the hyperlink field to work with email addresses?
1 page
- How can I work with lots of images in my database?
1 page
 

Primary Navigation

  • Home
  • Schedule
  • Email Lists
  • Handouts
  • List All Workshops
  • UF Training Resources
  • Reserve Training Room
  • Directions
  • Contact Us