MS Office Certification Access Beginning Access Intermediate Access Advanced I Access Advanced II  

4. Creating and Modifying Queries Queries: Add all fields to queries, 143 Query: Find Duplicates, 147 Queries: Based on more than one table, 37 Queries: Determine which table, 58 Query: Find Unmatched, 142 Query: MAKE TABLE, 141 Query: APPEND, 140 Query: DELETE, 149 Query: Subquery, 56 Filters: Save queries as filters, 55 Query design: Add a second copy of a table, 148 Query design: Criteria, 39 Query: Hard-coded criteria, 56 Query parameters, 41 Query joins: INNER, 146 Query joins: LEFT, 20 Query joins: RIGHT, 146 Query design: Use arithmetic, 59 Microsoft Access 2007 Study Guide Microsoft Certified Application Specialist (MCAS):  Microsoft Access 2007 Exam 77-605 Guide topics	5.  Presenting and Sharing Data Sort data within tables, 80 Sort data within reports, 80 Filter data within queries, 37 Filter data within queries, 101 Filter data within forms, 52 Charts: Create charts, 85 Charts: Format charts, 86 Charts: Change chart types, 86 Export data from tables, 150 Export data from queries, 151 Export data: Save and run export specifications, 151 Print database objects, 126   Print all, 127   Print selections, 129	6.  Maintaining Databases Back up databases, 108 Object dependencies, 126