Wednesday, May 26, 2010

Topics for the final Access test

Sharing Data
• import data from Excel (no field titles)
• import data from Excel (with field titles)
• export data to Excel
• export data to a Word table
• import data from / export data to a delimited text file

Data Validity
• input masks
• validation rules
• lookup fields

Data Access Pages
• create a data access page using the wizard
• change data or add a field in Internet Explorer using a DAP

Relational Databases
• import data from Excel
• create relationships among field in several tables
• create a report with data from several tables
Note: The test will NOT cover Ex. 4, Step 8 (Enforcing Referential Integrity, Cascade Update Related Fields, Cascade Deleted Related Fields).