Given Microsoft Access's continuing use in small (and occasionally large) businesses, there are many resources out their providing "best practices" and hints for the novice and experienced developer. 

A quick discussion on options for small businesses needing a database solution ... discussing cloud, desktop and hybrid approaches to data management, including Microsoft Access, Excel, SQL Server and custom.

More on EAV and Dynamic Data with SQL and ASP.NET

• How to flatten out EAV - http://stackoverflow.com/questions/14740758/how-make-this-eav-query-to-make-horizontal-result
• Dynamic Data Tutorial - http://www.4guysfromrolla.com/articles/091008-1.aspx

The first link outlines some of the problems with the EAV model ... querying and reporting. 

Read some interesting posts this weekend ... EAV (pros and cons), and other DB models: 

Extensible Data Modeling -  http://www.slideshare.net/billkarwin/extensible-data-modeling Dave's Guide to the EAV -  http://weblogs.sqlteam.com/davidm/articles/12117.aspx Custom Fields in a Database - http://social.msdn.microsoft.com/Forums/sqlserver/en-US/a87e55c9-0760-4071-b222-354272d8541b/custom-fields-in-database EAV (Wikipedia entry) - http://en.wikipedia.org/wiki/Entity%E2%80%93attribute%E2%80%93value_model I'm looking for different solutions for an old client of mine ... he tends to want to change things a lot, thus my interest in EAV ... which would work, since it is a smaller DB, and won't ever grow to a million plus rows.  Still thinking ...

...