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

Index Advanced Microsoft Access 2007 Exam 77-605 Guide
Attachments: Attach files to records, 92 Attachments: Attach multiple files, 92 Attachments: Detach files, 92 Attachments: Export files, 92 Attachments: Navigate, 91 Back up databases, 108 Charts: Change chart types, 86 Charts: Create charts, 85 Charts: Format charts, 86 Create blank databases, 159 Create relationships, 123 Create relationships: One to many, 124 Create tables by copying the structure of other tables, 134 Data:  Find using criteria, 139 Define / print table relationships, 122 Export data from queries, 151 Export data from tables, 150 Export data: Save and run export specifications, 151 Fields and field properties, 45 Fields: Attachment field design, 90 Fields: Attachment fields (multiple), 91 Fields: Attachment fields, 89 Fields: Memo, 7 Fields: Yes/No, 135	Filter data within forms, 52 Filter data within queries, 101 Filter data within queries, 37 Filters: Save queries as filters, 55 Forms: Datasheet View, 22 Forms: Pivot Table, 85 Forms: Subforms, 44 Import CSV data, 162 Import data: Save and run import specifications, 161 Import Microsoft Excel data, 160 Link or import data from external sources, 113 Link to Excel spreadsheets, 163	Modify properties: Allow zero length, 77 Modify properties: Set Memo field as append. only, 136 Modify relationships, 48 Modify table properties, 136 Multi-value fields, 137 Multivalued fields: possible issues, 137 Object dependencies, 126 Print database objects, 126   Print all, 127   Print selections, 129 Print table relationships, 125