Computer and Statistics Center

 



MS Access 2003 MS Word 97

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.

 

You can rate this course here:

 

go to top

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

go to top

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.

Join us on Facebook:
Join us

 

QR code

 

and on Yammer CEU.