The high point of this course is learning when and how to create multiple database tables and join them. Students will use the full potential of Access by joining up to three database tables and retrieving selected data. Forms and reports are generated from queries based on joined tables. Macros are introduced as a way to automate many of the daily database functions such as a menu creation. Access 2000's interactive HTML page creation feature is also discussed.
Tuition covers the course handbook and the use of a data disk for all hands-on exercises.
Introduction to MS Access - Office 2000 or extensive experience with Access. Classes will be held at Center for Employee Development. Map and directions will be included with receipt. MS Access Visual Basic code to the mix. The properties of the objects that make up a form and the events initiated by the user of the form are examined.