How to Quickly & Easily Change the Data Sources in a Microsoft Access Query

A quick tip for showing you an easy way to change the data sources (tables and queries) in a Microsoft Access query.

LEARN MORE:

RECOMMENDED COURSE:

BECOME A MEMBER:

FREE TEMPLATE DOWNLOADS:

ADDITIONAL RESOURCES:

KEYWORDS:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, change query data source, add table, table, query

[parc]

Liking all your short tips, I pick up on other techniques other than what your showing sometimes. I then head over to your website and dive into your courses on that specific subject if I can incorporate it. Your Lego analogy. Microphone is a winner. Clean strong sound no background noise, I use a headset.

[rogerstrate]

Great video Richard and yes the mike sounds great.

[stephenbeswick]

Hi Richard thank you for fast tip I am building a new database for a friend her will need this and I have been thinking of this because he will be using over network. Many thanks Steve b

[payfast]

another fast way is go into sql view copy all paste in note pad and find and replace with new query or table name and paste back. big query's is a must

[jimyeske]

Hi Richard,
All makes sense!
BTW… Mic seems a bit tinnier than your other videos I’ve listened to but I find tinnier audio easier to comprehend.

[-ProSystem]

Hello, I need help connecting the fingerprint scanner with Access VBA
Can you help me with this, and if it's paid, I don't mind

[saeedbaryal]

Hello, Dear sir
I hope you are fine and doing well.
I have a question, In navigation control, Filter using option group doesnt work. If you could please help me, it would be so kind of you.

[Shadow.Dragon]

"It's not all rocket science folks!" - R. Rost (2023) ROFL!!!