Access 2007 – Intermediate
Class Date & Time: Wednesday, November 4, 2009, 9:00 a.m. – 11:10 a.m.
Data Base Management System – The focus of this course is to introduce different methods of database search criteria and queries, retrieve specific records using comparison and logical operators. Learn to use wildcard characters, the expression builder and query filters. Find records with high and low values in specific fields. Create expressions that calculate new field values. Use functions to select records by groups. Run a query with different criteria each time. Combine two or more fields into one field. Create a new table consisting of data from other tables and queries. Copy records from one table to another. Apply criteria to select and delete groups of records at one time. Hands–on exercises cover all topics introduced in this course.