| 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.
|
| Before creating a database conact your Information Security Manager
|
|
|
| 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 |
|
|
|
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 |
2.0 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... |
| 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 |
|
| 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 |
|
| |
|
|