Free Microsoft Office Training and Tutorial Resources

Blog Roll:
Free Microsoft Office Training & Tutorials
Free Adobe & Macromedia Training & Tutorials
Free Web Development Training & Tutorials
Intelligentedu.com Blogs
- Free Technical Computer Training
- Free Computer Books & Ebooks

Top Links:
Free Training By Email
Free Computer Training from EdComp
Free Computer and I.T. Training

January 2, 2007

Microsoft Access Training Course Workbooks

Teach-ict.com is a great software teaching and learning site that provides free training content for Microsoft Office and other applications. This site was developed by teachers, its coursework materials are high quality and are targeted to both students and teachers. Here are their Microsoft Access Training Course Workbooks that cover the following Access topics: creating a database, using fields, records, data types, primary keys, importing data, validation rules, creating and using queries, creating forms from tables and queries, creating reports from tables and queries, reports with grouping, and formatting.

Microsoft Access Training Course Workbooks

Database Workbook 1 (.doc)

Learn how to create a new database using Access. The following skills are covered:

Creating a simple database
Creating & using tables
Using data fields, records, data types, field sizes, primary key
Importing data
Validation
Import file for Task 1 on page 9: Stock.txt
Import file for Task 2 on page 13: Players.txt

Database Workbook 2 (.doc)

Learn how to use queries and create forms. The following skills are covered:

Creating queries
Using queries
Creating forms from a table
Creating forms from a query

Database Workbook 3 (.doc)

Continuing on from the first two workbooks, this workbook teaches how to create reports and formatting. The following skills are covered:

Creating reports from tables
Creating reports from queries
Reports with grouping
Formatting
Import file to use: Holidays.txt

Database Workbook 4 (.doc)

This workbook goes through all of the skills taught in the first three workbooks and can be used as a learning session to bring all of these skills together.

Import file to use: Pstock.txt

Database Task 5 – Data Validation (.doc)

Here is Task 5, where you will get to practice creating data validation rules. Answers are given so you can see if you have created your validation rules acurrately.