Assignment:

1. Create a test database and then create a table with a primary key using the following features: Format, Input Mask, Caption, Default Value, Validation Rule, Validation Text, Required, Indexed and Lookup. This work should be done in Design View. Enter data to test the features. Send me the test database.
2. Do something with a subdatasheet
3. Use the import wizard to import data into a table - take pictures of the screen to show the steps
4. Import an Excel spreadsheet into Access - if you have one you can use it, other wise create a simple spreadsheet for use in this problem