Microsoft Access 2010
Workshop Information


Formats used for handouts are Microsoft Word and PowerPoint.

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

* Reccomend core classes
 
*Level 1: Access Basics and Database Fundamentals
3.0 hours
Microsoft Access is a relational database application. It's the perfect tool when you begin to outgrow your data collection in Excel. With Access you can obtain better collection results by creating user-friendly forms with rules to protect the validity of your data. You can create queries to analyze and filter your data, and reports that can be regenerated anytime you need them.

Topics for this workshop include database concepts, planning a database, and a hands on introduction to tables, queries, forms and reports. This workshop is a prerequisite for the other Access workshops.

This workshop assumes you are comfortable with a computer and have some knowledge of other Microsoft Office programs.

 
Handout: 
18 pages
Presentation: 
33 slides
Notes: 
23 pages
Working with 'sensitive' data? Check out data security!
 
*Level 2: Working with Tables and Field Properties
2.0 hours
Tables are the core of the Access database, where all data is saved. Topics for this workshop include working with different data types; data entry shortcuts; the table analyzer wizard; simple relationships; AutoForms; and field properties such as: field size, formats, input masks, captions, default values, and validation rules.

Completion of "Access: Basics" highly recommended.

 
Handout: 
25 pages
Files: 
Employee Pictures, bitmap images 30kb each
 
Level 2: Link, Import, and Export data with Microsoft Excel
1.5 hour
In this workshop we will create Access tables from Excel Workbooks and an other Access database. Topics include 'cleaning' Excel data; linking to Excel; importing from Excel; handling import errors; exporting tables and queries to Excel; linking to another Access database; importing database objects from another Access database; and working with Saved Import/Exports.

This workshop assumes some prior knowledge of Microsoft Excel and Access.
 
Handout: 
13 pages
Files: 
Database (360kb)
visits.xls (33KB)
 
Level 2: Understanding Database Relationships
2.5 hours
Proper relationships are essential for "good" data entry. The relationship between two tables allows for specific rules to be applied. Relationships can be set so data has to be entered in the correct order – a student has to exist in the database before they can register. Relationships can be set to prevent orphan data – patients cannot be deleted if they have attended appointments.

Topics for this workshop include a discussion of one-to-one and one-to-many relationships; creating junction tables; working with primary and foreign keys; setting the cascade update and cascade delete options. The hands on portion of this workshop will be an individual assignment.

Completion of "Access: Basics" highly recommended.

 
Handout: 
14 pages
Presentation: 
33 slides
Planning Sheet: 
1 page
Files:
Database (360kb)
 
*Level 2: Working with Select Queries & Crosstabs
2.0 hours
Queries compile data from tables into a desired dataset. You can choose multiple fields from one or more data tables, and set criteria to limit the records displayed. By its simplest definition a query is a saved filter, but they can also be used to combine fields, preform calculations, and create summaries.

Topics for this workshop include using data filters, setting custom sorts, using criteria, creating joined field expressions, calculating simple math, summarizing with totals, formatting numbers, and creating crosstabs.

Completion of "Access: Basics" highly recommended.

 
Handout: 
21 pages
Files: 
 
*Level 2: Intro to Building Forms and Reports
2.0 hours
Forms are primarily created for data entry. Reports are typically an organized 'print out' of data. The design structure of forms and reports are very similar. In this workshop we will learn how to use the built in tools to create forms and reports, as well as creating them from a blank canvas.

Topics include using the AutoForm/AutoReport tool, and the Form and Report Wizards. Creating forms and reports in the design view - including: using the property sheet; field placement, sizing, aligning, and formatting; simple command buttons; working with multiple sections on a report; stacked and tabular tables; sorting reports; and creating mailing labels.

Completion of "Access: Basics" highly recommended.

 
Handout: 
29 pages
Files: 
 
Level 3: Forms II - SubForms and Menus
2.0 hours
Topics include building forms with the wizard and in design view; customizing tab orders; creating combo boxes to display data and to search through records; working with SubForms and Tab Controls; creating Navigation menus; and working with startup options.

Completion of "Access: Basics" and "Intro to Forms and Reports" highly recommended.

 
Handout: 
16 pages
Files: 
 
Level 3: Reports II - Summary and Grouping
2.0 hours
Topics include customizing reports; working with sorting and grouping; using basic math functions; summary reports; special queries; and building reports from scratch.

Completion of "Access: Basics", "Select Queries" and "Intro to Forms and Reports" highly recommended.

 
Handout: 
12 pages
Files: 
 
Level 3: Queries II - Action Queries and Lookups
1.5 hours
Topics include action queries; relationship join properties; linking query values to forms and reports.

Completion of "Access: Basics", "Select Queries" and "Intro to Forms and Reports" highly recommended.

 
Handout: 
20 pages
Active Lookup:
1 slide
Files: 
 
Level 4: Forms and Macros
1.5 hours
Topics include formatting creating menus, linking forms through buttons, creating tabular subforms, creating macros, using macros in buttons and in other events.

Completion of "Access: Basics", "Intro to Forms and Reports", and "Forms II" highly recommended.

 
Handout: 
12 pages
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
Example of a "complex" database

Primary Navigation

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