Microsoft Access 2003: Level 1

22 March 2010
19 April 2010
17 May 2010
21 June 2010
19 July 2010
16 August 2010
20 September 2010
18 October 2010
22 November 2010
20 December 2010

Duration: 1 Day

Course Content

Lesson 1: An Overview of Access 2003

• Understand Relational Databases
• Examine the Access Environment
• Open the Database Environment
• Examine an Access Table

Lesson 2: Managing Data

• Examine an Access Form
• Add and Delete Records
• Sort Records

Read more »

Microsoft Access 2003: Level 2

23 March 2010
20 April 2010
18 May 2010
22 June 2010
20 July 2010
17 August 2010
21 September 2010
19 October 2010
23 November 2010
21 December 2010

Duration: 1 Day

Course  Content

Lesson 1: Planning a Database

• Design a Relational Database
• Identify Database Purpose
• Review Existing Data
• Determine Fields
• Group Fields into Tables
• Normalize the Data
• Designate Primary and Foreign Keys

Read more »

Microsoft Access 2003: Level 3

24 March 2010
21 April 2010
19 May 2010
23 June 2010
21 July 2010
18 August 2010
22 September 2010
20 October 2010
24 November 2010
22 December 2010

Duration: 2 Days

Course Content

Lesson 1: Structuring Existing Data

• Import Data
• Analyze Tables
• Create a Junction Table
• Improve Table Structure

Read more »