This course is designed to enhance the acquired knowledge of Microsoft Access 8.0. The course uses a hands-on approach to learning. Each student will design and create a complex database application. This application will involve advanced database concepts such as input masks and complex forms. Emphasis is placed on creating a database for others, that is user friendly and mistake proof. This course assumes that the participant has a good working knowledge of Access and the relational database design concept. It allows the student to put the database design concepts into practice.

• Using Input masks and validation rules to minimize input mistakes
• Using OLE fields to store data acquired from other applications
• Using relationships to access data in other related tables
• Creating queries to exploit relationships between tables to make the query more useful
• Using Action queries to create new tables, delete large amounts of data, add large amounts of data, and update tables
• Creating advanced forms including various controls to aid in the inputing of data
• Creating forms incorporating multiple tables
• Creating advanced reports using the wizards

The duration of the course is 1 day. This day begins at 8:30 am and ends at 4:30 pm.