Creating a Query in Microsoft Access

In this Microsoft Access 2021 training course for beginners, we discuss how to create a query and how queries work in an Access database.

💻 Watch more free popular training tutorials from Simon Sez IT:

🔥Check out our FREE 300+ hour training course playlist here ➡️

💬Stay in touch!

🔔 Subscribe to our channel:

If you enjoyed the video, please give a thumbs up 👍🏽 ;-)

[steventate]

Ok I fall into the: i don't know anything but its not an excuse for not going after it" category. while messing around with the practice test software I am reading the hints and it says things like drag whatever from the layout pane to the design pane( or something like that).you could probably get so many clicks by making a video titled something like " this is the Layout Pane" or one called This is the Design Pane" because there lots of people who really don't know the first thing and they want a quick answer. This was still sort of helpful.

[learngeography]

Hi how can i design a querry where i can leave it to user to select the criteria for the querry. for example i want it to ask the user, whether he want Active orders or Closed orders. he would select one of the option and then data will be generated according to it

[veritasaequitas]

SQL Server and MySQL you can hand write Stored Procedures in free form script.
Being a very experienced SQL coder / script writer I prefer this because it is highly versatile and a lot quicker than using wizards.
Is this possible in the latest version of MS Access?
I have the 2003 version and it's not available in that version.
All you have is the wizards. Which is why I don't use MS Access.
I am considering upgrading to the latest version.
Does the latest version allow free formal query scripting?