Tag Results For: Query

tableaccount.jpg

MS Access 2010 DATE Functions

Access encompass variety of powerful tools, that facilitates user to use dates and date ranges to be specified in a certain criteria. To get by with the complex logic in your database that contains dates, then DATE functions could be very useful for you. This post will elaborate how to use simple DATE functions. (more…)

Students.jpg

MS Access 2010: Create Simple Crosstab Query

Queries are very important tool for pulling out, searching and grabbing data from tables. It performs different actions or operations on the database and carry out results according to the needs. Microsoft Access Crosstab Query enables user to summarize information in a compact format which is similar to spreadsheet. This post elaborates why to use [...] (more…)

clip_image001.jpg

MS Access 2010 Relationship & Query Interconnect

Access 2010 is very useful tool for designing database and provides intermediate-level data mining. It has done and continues to do wonders especially when it comes to managing, creating and most importantly making use of Relational Database up to its acme. This post will cover how relationships and queries interconnect to make database more dynamic. (more…)

addictivetipstable.jpg

MS Access 2010: Query With IFF Function

In MS Access, the IIF function returns one value if a specified condition evaluates to TRUE, or another value if it evaluates to FALSE. IIF function returns one of two arguments depending on the evaluation of an expression just like as we use logic in IF-ELSE structure. It evaluates both true part and false part, [...] (more…)