MS Access Course Program

Date:  May 24th, 2008, Saturday

Time: 9am – 4 pm

Course Contents:

1^st Period (9am- 10am):

·         Create and modify calculated fields and aggregate functions

·         Modify form layout

·         Modify report layout and page setup

2^nd Period(10am-11am)

·         Format datasheets

·         Sort records

·         Filter records

3rd Period(11am-12pm):

·         Lab Practice

·         Each student work on assigned project and instructor work with them individually

LUNCH BREAK(12pm-1pm)

4th Period(1pm-2pm):

·         Identify object dependencies

·         View objects and object data in other views

·         Print database objects and data

·         Export data from Access

5th Period(2pm-3pm):

·         Back up a database

·         Compact and repair databases

6th Period(3pm-4pm):

·         Lab Practice

·         Each student work on assigned project and instructor work with them individually