The coder will create an access database with one table and a module. The database can be created in any version of Access but the code must be compatible with Access 2000-2010. Use simple VBA. When IsExcluded is first called, the ExcludedFields table should be cached in memory. The detail of the project is below. The coder will also create a simple test form to test all methods below.
Table:
Name: ExcludedFields
Columns: TableName, FieldName both string 100
modExcludedFields
Please create the following methods:
'Returns true if the field is excluded
'If the table name is "All" "" or null match only by the field name
'This is a case insensitive matching
public function IsExcluded(tableName as string, fieldName as string) as boolean
'Delete all excluded fields in memory
public sub ClearExcludedCache()
'Delete all records in the ExcludedFields table
public sub ClearExcludedTable()