Participants will learn database basics, how to build and modify tables, modify table data, work with forms, and create and modify select queries. Participants will also learn how to work with reports by using AutoReport and Report Wizard. Participants will learn how to enhance their Access databases and tables by defining field and table validation rules, using input masks, managing database files, enhancing forms and queries, building and enhancing forms and reports, controlling data integrity, working with select queries and creating macros. Participants should have Windows skills and Access skills. Participants will have the opportunity to test the code they are learning with suggested programming problems.
Courses start once a month, run for six weeks and consist of twelve lessons.
The lessons are supplemented by interactive quizzes, assignments, tutorials, and online discussion areas available via the World Wide Web. All you need to get started is Internet access, an e-mail account and a web browser. Additional requirements, if any, will be listed with the course description.