Access 2010 – Level 1

Learn to use Access, a widely used Database Management System, to create a database, create and add data to a table, create a form for easy data entry, a query to ask for specified information from the table, and a report to format the information for a professional printout.

514 CMPA1052-RWE: W, 9am-4pm, one day, 5/1, $139 + $10 capital fee, Riverwalk

Access 2010 – Level 2

Use Access to create a relational database which allows combining data from multiple tables into one report. You will learn to create relationships and to design advanced queries based on single and multiple tables. Customizing Forms and Reports using Design View is included, as well as creating calculated fields in a query.

515 CMPA1053-RWB: W, 9am-4pm, one day, 5/15, $139 + $10 capital fee, Riverwalk

Access 2010 – Level 3

Access features, including data validity, advanced querying using expressions, modifying forms and reports in design view, creating forms with relational sub-forms, drop down lists, linking tables from other databases and applications, indexes, Action Queries, and an introduction to Access SQL.

Instructor: Jay Partlan, has taught credit and non-credit courses at UNH, Granite State College, Northern Essex Community College, New Hampshire Community Technical College and Newbury College

214 CMPA1054-RWA: Tu, 9am-4pm, one day, 3/19, $139 + $10 capital fee, Riverwalk
520 CMPA1054-RWB: W, 9am-4pm, one day, 5/29, $139 + $10 capital fee, Riverwalk