Beginning This one day course introduces the Access relational database concepts, providing a foundation for successful database management. Students learn how to design and set-up a database and create and modify data tables.
Students learn to use queries to select and analyze information in a table.
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.