Office Certification Description Access Beginning Access Intermediate Access Advanced  

Index Intermediate Microsoft Access 2007 Exam 77-605 Guide
Control: Bind controls to fields, 43 Controls: Add fields form the Ribbon, 24 Controls: Add fields from a table, 19 Create relationships: One to many, 28 Create relationships: One to one, 27 Database Documenter, 128 Database properties, 77 Database properties: Custom, 78 Database properties: edit, 77 Define join type, 93 Enable error checking, 124 Encrypt databases with passwords, 127 Fields: Date/Time, 15 Forms: Datasheet View, 31 Forms: Design View, 16 Forms: Layout view, 75 Forms: Multiple Item, 39 Forms: Split Forms, 41 Forms: Subforms, 29 Navigation pane: show/hide, 73 Open databases: Exclusively, 126 Open databases: Shared access, 125	Queries: Add fields to queries, 22 Queries: With more than one table, 92 Query calculations: AVERAGE, 123 Query calculations: COUNT, 117 Query calculations: Min/Max, 123 Query calculations: SUM, 123 Query: Add fields to calculations, 99 Query design: calculated fields, 99 Query design: Use arithmetic, 101 Query joins: LEFT, 100 Query parameters, 107 Query: CROSSTAB, 120	Reports: Create aggregate fields, 47 Reports: Use the Report Wizard, 96 Reports: Print Layout, 97 Save as an XPS file, 80 Save objects as other file types, 80 Save as a previous version, 79 Sort data within forms, 104 Startup display form, 71 What data should be calculated?, 46