Participants learn how to create data forms for viewing and inputting data and reports to output data. Essential database maintenance procedures are also covered. Intermediate This one day course builds on knowledge acquired in the introductory course. Upon successful completion of this course, students should be able to normalize data, establish relationships between tables, customize table designs, design queries using multiple tables, add calculated fields, create forms that contain subforms, and customize report designs. In this one-day course, students learn to create macros and command buttons to enhance user interaction with the database and to automate repetitive tasks.
Participants learn to perform advanced outer join and crosstab query techniques.
Creating hypertext links and publishing MS Access databases as HTML documents on the World Wide Web are also covered. In this two day class, students learn how to develop an application and tie the objects together into a cohesive system by using macros and Visual Basic code. Learn how to design an application by defining objectives and requirements, using external data sources. Create and use custom toolbars and menus, and create a form to use as a splash screen on application startup by setting properties and writing Visual Basic Code. Securing an application by defining security and setting a database password are also covered.