MS Access 2003

The course gives an introduction to database concepts and to MS Access database basics. During the classes students will gain knowledge on the use of tables and on the analyzis of different data types, field properties and also get an overlook on the key expressions in MS Access.

Course details

Level: Beginner
Max. no. of participants: 20
Computer Lab: #1
Duration: 5 days
Requirements for pass: minimum attendance - 4 days
When the course is offered: see the list of courses for the current semester and/or the InfoSys

Course outline

Day 1:

• Database concepts
• MS Access database basics
• Using and editing tables
• Data types, field properties

Day 2:

• Expressions in MS Access
• Validating data entry
• Keys and indexes

Day 3:

• Queries
• Tables and relations

Day 4:

• Basics of forms and reports

Day 5:

• The last day of the course is devoted to a simple excercise to be solved on your own as a pass/fail exam.

Useful online resources

Extensive MS Access 2003 FAQ site - http://www.business.com/directory/computers_and_software/microsoft_corporation/software/
office/access/weblistings.asp
Basics of MS Access - http://cnx.org/content/col10465/latest/
MS Access 2003 index site - http://office.microsoft.com/en-us/access/FX100487571033.aspx

NOTE: all links open in new windows.