List of online resources to help home study learners improve their knowledge of Microsoft Access 2007. Includes official Microsoft Office links and videos.

 

Microsoft Online Training

Get to know Access 2007
For convenient, reliable data management, get to know Access 2007.
http://office.microsoft.com/en-us/access-help/get-to-know-access-2007-RZ010274013.aspx

 

Create tables for a new Access 2007 database
Learn how to build the tables for a new database. Tables are the backbone of a database, so building them well is a critical step. This course, the second in a series, explains how to use Access 2007 by creating a database from scratch.
http://office.microsoft.com/en-us/access-help/create-tables-for-a-new-access-2007-database-RZ010288610.aspx

 

Build relationships for a new Access 2007 database
Learn how to create relationships among your database tables. Relationships bring the data in your tables together. That enables you to find information and make sound business decisions, and that makes your data powerful. This course is the third in a series that explains how to use Access 2007 to build a database from the ground up.
http://office.microsoft.com/en-us/access-help/build-relationships-for-a-new-access-2007-database-RZ010291798.aspx

 

Create queries for a new Access 2007 database
Learn how to create queries. In Access 2007, you use queries to extract data from your database, and to provide data for forms and reports.
http://office.microsoft.com/en-us/access-help/create-queries-for-a-new-access-2007-database-RZ010291917.aspx

 

Create forms for a new Access 2007 database
Learn how to create forms. Forms provide a window into your data, make your database look polished and professional, and help you enter data more accurately.
http://office.microsoft.com/en-us/access-help/create-forms-for-a-new-access-2007-database-RZ010291967.aspx

 

Create reports for a new Access 2007 database
Learn how to create reports. In Access, reports help others understand your data and answer critical business questions.
http://office.microsoft.com/en-us/access-help/create-reports-for-a-new-access-2007-database-RZ010292018.aspx

 

Queries: Create basic select queries Learn how to create basic select queries
Select queries retrieve data from your database, and they're one of the most frequently used and versatile tools Access provides.
http://office.microsoft.com/en-us/access-help/queries-ii-create-basic-select-queries-RZ010359157.aspx