Microsoft Access Queries: Some Pointers To Building Those Reports
Database developers have admired Microsoft Access because it’s scalable and user friendly (for a development application that is) and provides a good ‘one-stop‘ shop balance for database management meeting small and medium sized company needs.
I have always harked on about the key to a good database is in the query and just in case you are not yet familiar with Microsoft Access queries, here is just a little bit of information.
What are Access Queries?
Well the simple answer is…
"Access, I have a question for you!"
…It then goes off and finds the answer.
In other words, a query is simply an instruction or request for a report or some other form of output of information.
The language it uses to communicate and ask that question of your data is known as SQL (Structured Query Language) and it uses this SQL query syntax to provide answers very quickly indeed.
The advantage with Microsoft Access database queries however, is that there is no requirement to learn the language at all as it Continue reading “Microsoft Access Queries: Some Pointers To Building Those Reports”