1 files changed, 31 insertions, 0 deletions
diff --git a/test/dialect/test_access.py b/test/dialect/test_access.py
new file mode 100644
index 000000000..0ea8d9a61
--- /dev/null
+++ b/test/dialect/test_access.py
@@ -0,0 +1,31 @@
+from sqlalchemy import *
+from sqlalchemy import sql
+from sqlalchemy.databases import access
+from sqlalchemy.test import *
+
+
+class CompileTest(TestBase, AssertsCompiledSQL):
+    __dialect__ = access.dialect()
+
+    def test_extract(self):
+        t = sql.table('t', sql.column('col1'))
+
+        mapping = {
+            'month': 'm',
+            'day': 'd',
+            'year': 'yyyy',
+            'second': 's',
+            'hour': 'h',
+            'doy': 'y',
+            'minute': 'n',
+            'quarter': 'q',
+            'dow': 'w',
+            'week': 'ww'
+            }
+
+        for field, subst in mapping.items():
+            self.assert_compile(
+                select([extract(field, t.c.col1)]),
+                'SELECT DATEPART("%s", t.col1) AS anon_1 FROM t' % subst)
+
+