Access Form SQL -

i had question requires theoretical ideas/solutions rather exact execution plans.

i`m trying design ms access form (i have experience access it's been while , not enough practice), can compare 2 tables (table 1 , table 2) , gather list of names against other.

now know how , query results. problem arises when have multiple other tables want compare table 1 , of them have different columns.

this ongoing testing process , new changes introduced monthly/annually, want automated form can use button (or less time consuming using queries everytime). primary key have been useful since don't exist, full names best option.

another question related is, if excel tables stored in local server folders, there way retrieve files our database without manual imports? pass-through queries?

i don't mean throw work @ other people because of laziness, want overview of approach can take. advice appreciated!

thank you.

i want automated form can use button...

this macros for... automate manual tasks have perform. if can manually access interface, find macro task you.

if want fancy try hand @ vba coding automate of manual work. dao library allows view database metadata allow write code reflection qualities (vba doesn't support reflection scripting language , not oop). if metadata changing constantly, writing code easier said done... assuming foreign keys labeled properly, use tabledef object search tables corresponding name , dynamically build sql query based on discovery.

another question related is, if excel tables stored in local server folders, there way retrieve files our database without manual imports?

as long maintain same format of excel files , keep standard naming convention, quite automate process (again using macros) pulls in known file specific folder.

if things subject change can again use vba automate own streamlined import process. microsoft has exposed lot in access can quite tap window's common file dialog (open , save pop-up windows) using filedialog library customize user interaction.

keep in mind though create streamlines work going have spend man-hours coding... have weigh cost/benefit of work you'd put in automate manual processes.