WEEK 7 MICROSOFT ACCESS DATABASE HOMEWORK

All field name should be in Leyszinski notation. (-5)

tblContacts:

Captions and data are not fully displayed. (-1)

You should have the customer information (address fields) in the tblCustomer. If a contact should leave then you have no records of the Customer. (-5)

When testing the zip code and entering 3060 I get an error message as the value is not within your validation rule. You do not want a validation rule. Having the Data Type as Number, Field size as Long Integer and the Format as 00000 is enough. Get rid of the Validation rule. (-2)

Populate the Title field.

tblCustomer:

Captions and data not fully displayed. (-1)

As per one of the instructions it was a hint that the Sales Rep should be in this table. (-2)

As per one of the instructions the Active status should be moved to this table from the tblContacts.

You need a Territory Value list in this table. (-6)

tblProducts:

Data not fully displayed. (-1)

tblSalesRep:

You should have just 8 records (there are only 8 sales reps). Get rid of all duplicates. (-10)

Captions and data not fully displayed. (-1)

When clicking on the + to see the subdatasheet I am prompted for a field name before a blank subdatasheet is displayed. (-2)

The relationship between tblSalesRep.Customer Name & tblContacts.Customer Name is an indeterminate relationship which Access doesn’t recognize. You need a primary field in tblSalesRep (Sales Rep ID) (-3)

You need a field for the Territory and then create a relationship with the tblTerritory. (-2)

 Sales Rep hire date should not be so specific. You should use the Date() function. (-2)

tblTerriories:

Data not fully displayed. (-1)

You need a primary field. (-2)

You need to create relationships between tblTerritory and the tblSalesRep as well as with tblContacts. (-2)