Learn to use Access, a widely used Database Management System, to creat 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.
573 CMPA1052-NAE: W, 9am-4pm, one day, 6/3, $102 + $19 materials fee + $10 capital fee, North Andover
574 CMPA1052-NAF: M, 9am-4pm, one day, 8/3, $102 + $19 materials fee + $10 capital fee, North Andover
1036 CMPA1052-NAH: F, 9am-4pm, one day, 10/9, $120 + $19 materials fee + $10 capital fee, North Andover
1037 CMPA1052-NAI: W, 9am-4pm, one day, 11/18, $120 + $19 materials fee + $10 capital fee, North Andover
1042 CMPA1052-NAJ: Th, 6-9pm, 2 wks, 11/5-11/12, $120 + $19 materials fee + $10 capital fee, North Andover
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.
575 CMPA1053-NAC: W, 9am-4pm, one day, 6/10, $102 + $19 materials fee + $10 capital fee, North Andover
1038 CMPA1053-NAE: F, 9am-4pm, one day, 10/30, $120 + $19 materials fee + $10 capital fee, North Andover
1040 CMPA1053-NAF: F, 9am-4pm, one day, 12/4, $120 + $19 materials fee + $10 capital fee, North Andover
Access 2007 - 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
576 CMPA1054-NAC: Th, 9am-4pm, one day, 7/16, $102 + $19 materials fee + $10 capital fee, North Andover
1041 CMPA1054-NAD: W, 9am-4pm, one day, 12/9, $120 + $19 materials fee + $10 capital fee, North Andover