fbpx
Logo
Mail us
ben@accessdatabasetutorial.com
Home » Posts tagged "microsoft access query criteria"

Tag Archives: microsoft access query criteria

Access Queries: Date Criteria May Not Always Work with MS Access Query


Learning about ms access query  is the key to a good database management system as it is the heart of any database application. There are many ways and questions to ask a database using queries and mastering the special conventions and criteria will pay dividend and avoid silly mistakes, illogical record set results and even errors. One of the more commonly used criteria and prone to errors (if misunderstood) is the date/time data type and it’s conventions. Take a look […]

Tags: , , , , , , , ,

Microsoft Access Queries: 7 Basic Things to Know About MS Access Queries


Ms Access query

As I have mentioned before, Ms Access query is considered the most important object in your database. It’s the heart of the system and if you bypass it, there’s simply no life to your application! Just to put words into pictures, have a look at this simple diagram below (taken from one of my eBooks) You can see the above ‘Middle’ tier is a query which sits comfortably in the middle servicing all other key ‘Access‘ objects. Now imagine there were […]

Tags: , , , , ,