Mail us
Home » Posts tagged "microsoft access queries" (Page 2)

Tag Archives: microsoft access queries

Microsoft Access VBA vs MACRO

Microsoft access

A common question often asked: Would it be a good idea for me to use Microsoft access macros or would it be advisable to use Microsoft Access VBA code instead? You should base your choice to use either Microsoft access macros or MS access VBA code with two initial concerns: Security Usefulness that you require. Macros are considered to be easier to learn than VBA and in most cases it’s probably faster  to create a macro than it is to write VBA […]

Tags: , , , , , , ,

Time-saving tips when MS Access database

MS access database

Timing is very important in everything we do in life, in this post you will find out tricks to easily optimize your speed when working with MS Access database, this tips will also help you manage the time while creating access database. Each table should have primary keys: when creating access database in MS access make sure, each and every table in your access database should have primary keys. This allows the system to quickly locate and connect records with […]

Tags: , , , , , , , , ,

Microsoft Access Queries and How Important They Are in Your Database

Microsoft Access Database

The heart of any MS Access database system resides with the queries and I’m often asked to give new users a quick overview of this powerful application – here’s an example… A Microsoft Access Database is a desktop application which stores large amounts of data and is able to recognize relationships between those data. It consists of data and tools that enable users to manipulate that data.  One of these tools are the queries. Microsoft Access Queries are used specifically […]

Tags: , , , ,

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 […]

Tags: , , , ,

Microsoft Access Database Tutorial – Selecting Unique And Distinct Values In A Query

Microsoft Access

There are many different types and ways to run queries that your Microsoft Access database application provides and one useful ms access query is where you can create a distinct or unique value list from duplicate or repeating values from other records. Check out this 4 minute video tutorial which clearly explains two ways to create a unique value query report. As the video shows, you can use either the property sheet to select unique value or the SQL statement approach […]

Tags: , , , ,

Microsoft Access Queries: Difference Between The Where Clause And the Having Clause

Ms Access

Within the framework of using Ms Access queries, the HAVING clause can only be used with the GROUP BY type SQL statement which is also referred as the Groups and Totals query. The HAVING keyword when not used with the GROUP BY statement acts as a standard WHERE clause. The HAVING clause specifies a condition that is similar to the purpose of a WHERE clause when  applying criteria but the two clauses are not interchangeable. The key difference between these two keywords is […]

Tags: , , , ,

← Older posts Newer posts →