User Martin F

4 votes

5 answers

3k views

How can I allow part of a key to be null and enforce uniqueness of records with nulls?

asked Jun 14, 2016 at 21:53

2 votes

1 answer

571 views

Should I maintain relationships diagrams in the back-end and the front-end?

asked Aug 21, 2015 at 19:11

0 votes

1 answer

2k views

How to prevent #Error values derived from Nulls in an outer join

asked Jun 10, 2015 at 1:21

0 votes

1 answer

1k views

How to subtract records from a table based on their existence in another

asked May 28, 2015 at 1:56

3 votes

1 answer

17k views

How to get the equivalent of array or string GROUP BY aggregate functions in Access?

asked Apr 16, 2015 at 22:01

2 votes

3 answers

307 views

What is the term for a “wide”, non-normalized view/query?

asked Apr 7, 2015 at 19:39

1 vote

1 answer

1k views

How to manage many-to-many relationships when there is also a hierarchy among the many?

asked Apr 6, 2015 at 19:24

0 votes

1 answer

406 views

How to save the design of an Access database -- not the content -- as text?

asked Feb 24, 2015 at 19:54

0 votes

1 answer

252 views

Convert an interaction matrix into a ternary relation

asked Feb 5, 2015 at 19:25

Stack Exchange Network

9 Questions

How can I allow part of a key to be null and enforce uniqueness of records with nulls?

Should I maintain relationships diagrams in the back-end and the front-end?

How to prevent #Error values derived from Nulls in an outer join

How to subtract records from a table based on their existence in another

How to get the equivalent of array or string GROUP BY aggregate functions in Access?

What is the term for a “wide”, non-normalized view/query?

How to manage many-to-many relationships when there is also a hierarchy among the many?

How to save the design of an Access database -- not the content -- as text?

Convert an interaction matrix into a ternary relation