Free Training for Access 2007

Here are Three Free Training Resources for Learning Access 2007. The first one is an online course that will get you up to speed with using the Ribbon, finding familiar features, and understanding and using the new XML file format. The second one is a reference tutorial for the locations of Access 2003 commands in Access 2007. The third document is a spreadsheet that maps all Access 2003 menu and toobar items to Access 2007's ribbon interface.


1) Free Access 2007 Online Course: Up to Speed with Access 2007

After completing this course you will be able to:

• Download a database from the new Getting Started page.
• Create database objects by using the new Ribbon.
• Save and share your data in appropriate formats.

This course includes:

• Three self-paced lessons and three practice sessions for hands-on experience. Practices require Access 2007.
• A short test at the end of each lesson; tests are not scored.
• A Quick Reference Card you can take away from the course.

Access 2007 Course Contents:

Overview

A new beginning

• Get started with a template
• Meet the new look
• Work with the Ribbon
• Make the Quick Access Toolbar your own
• Manage your work with the Microsoft Office Button
• Practice
• Test yourself

OK, back to work

• Download a database
• Create a table from a template
• Create a form, format a form
• Create a report, format a report
• Practice
• Test yourself

Save your files in the format that works best

• Benefits
• Upgrade previous databases
• Share in an older format
• You can't have everything
• Practice
• Test yourself

Feedback

Quick Reference Card


2) Reference: Locations of Access 2003 commands in Access 2007

This tutorial describes the items of the new Microsoft Office Fluent user interface that are in Microsoft Access 2007. It also lists commands which you may already know how to use in Access 2003, and explains how to perform the same tasks using Access 2007.


3) Access Ribbon Mapping Workbook

This spreadsheet (.xls) maps all of the menu and toolbar features and options in Access 2003 to the equivalent in Access 2007.

• Database menu
• File menu
• Edit menu
• View menu
• Relationships menu
• Insert menu
• Query menu
• Diagram menu
• Format menu
• Records menu
• PivotTable menu
• PivotChart menu
• Filter menu
• Run menu
• Tools menu
• Window menu
• Help menu
• Formatting toolbar
• Page View toolbar
• Alignment and Sizing toolbar
• Page Design toolbar
• Web toolbar
• Macro Design toolbar
• Toolbox toolbar
• Print Preview toolbar
• Report Design toolbar
• Filter or Sort toolbar
• Form View toolbar
• Form Design toolbar
• Table Datasheet toolbar
• Table Design toolbar
• Source Code Control toolbar
• View Design toolbar
• Diagram Design toolbar
• Stored Procedure Design toolbar
• Trigger Design toolbar
• Function Design toolbar
• Font Fill Line toolbar
• Special Effect toolbar
• Databsheet Special Effect toolbar
• Gridlines toolbar
• Appearance toolbar