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

1. Structuring a Database Multi-value fields, 137 Link or import data from external sources, 113 Define table relationships, 122 Create relationships, 123   One to many, 124 Modify relationships, 48 Print table relationships, 125 Split databases, 106   To overcome size restrictions, 119   For multi-user applications, 118 Microsoft Access 2007 Study Guide Microsoft Certified Application Specialist (MCAS):  Microsoft Access 2007 Exam 77-605 Guide topics	2.  Formatting Database Elements Create blank databases, 159 Create tables by copying the structure of other tables, 134 Modify table properties, 136 Tables: Delete, 112 Tables: Add a Total row, 39 Fields and field properties, 45 Fields: Yes/No, 135 Fields: Memo, 7 Field properties: Allow zero length, 77 Field properties: Set Memo field as append. only, 136 MultiValue fields: possible issues, 137 Fields: Attachment fields, 89 Fields: Attachment fields (multiple), 91 Fields: Attachment field design, 90 Forms: Datasheet View, 22 Forms: Subforms, 44 Forms: Pivot Table, 85 Reports: Use the Wizard, 74 Reports: Use Design View, 75 Reports: Define Group Headers, 76 Reports: Create aggregate fields, 99 Report Print Layout options, 82 Report  Print Layout- Keep Together, 82 Reports: Label Wizard, 93	3.  Entering and Modifying Data Data:  Find using criteria, 139 Attachments: Attach multiple files, 92 Attachments: Attach files to records, 92 Attachments: Detach files, 92 Attachments: Export files, 92 Attachments: Navigate, 91 Import Microsoft Excel data, 160 Import CSV data, 162 Link to Excel spreadsheets, 163 Import data: Save and run import specifications, 161