ITSW 2337.102 and

POFI 1341.102

Send files to skennedy10@sbcglobal.net

Files for Access 2003

Have been removed.

For information contact

skennedy10@sbcglobal.net

webmail.uth.tmc.edu

· Introduction to course; review college and instructor policies and expectations.

· Introduction to MS Access 2003 T1 Week 1 January 18

· Creating and maintaining a database T2 Week 2 January 25

· Querying a database T3 Week3 February 1

· Creating forms and reports T4 Week4 Review February 8

· Introduce semester projects: Definition and design. These equal 1 major test grade.

You will create a business-oriented project! This project counts as a 4^th test. Week5 February 15

· TEST 1 -- Sections 1 – 4 (All assignments for Chapters 1-4 must be in.) Week 6…… February 22

· Advanced queries T5 Week 7 March 1

· Custom forms T6 Week 8……and TEST 1 - shortened format to 50 questions……………actual March 22… March 15

· Custom reports T7 Week 9 ………… March 22

· Using Action queriesT9.1 Week 10 March 29

Semester projects checkup: implementing and testing Week 10 also March 29

· TEST 2—Sections 5, 6, 7 and 9.1 This test will be a lab practical test. Week 11 April 5

· Relational databases and database design: Relationships and Joining Tables T9.2 Week 12 April 12

· Automating tasks with Macros T10 Week 13 April 19

· Semester Projects Due Week 14 April 26

Publishing Access data to the Web T8 Week 14 also May 3

· Using and writing Visual BASIC for Applications code T11 (Depending on time available)

· Managing and Securing a Database T12 (Depending on time available)

· TEST 3—Sections 9-12 Week 15 May 10