In access an expert can set up relationships which will cause them to be automatically joined when a less expert user adds both tables to a query. Some knowled

In access an expert can set up relationships which will cause them to be automatically joined when a less expert user adds both tables to a query. Some knowledge is usually required to make sense of the results though but I'd say a non-expert still has more chance with access than any other tool.