Microsoft Access 2003 Level 3

The course uses a combination of lecture, hands-on practice, and independent exercises to continue to familiarize students with queries important to development in Microsoft Access. The course
emphasizes the use of Access through commands, not Wizards.
The focus of this course is to learn how to use Access more efficiently and productively through commands and a greater awareness of multiple table database design. It is intended to not only show the student the wide range of problem solving that is available in Access, but to allow them to gain techniques that master database processes.
Students define permanent relationships between tables. You will build queries based on other queries. You will create action queries
including update, delete, append, and make tables. Students also learn how to perform data analysis using both a PivotTable and a PivotChart. Designing and building totals and crosstab queries are also covered.

see less