04 – Basic Queries

In this post we will be examining basic queries and introducing Structured Query Language. We will also be showing you how to make your queries smarter with criteria and how to work with multi-table queries.

List of topics covered:

  • Introduction to SQL
  • Access Query Designer
  • Adding and Removing Tables
  • Choosing Tables and Queries
  • Viewing Query Data
  • Simple Queries with Criteria
  • Like Operator
  • Hard-Coded Values
  • The Use of Asterisk *
  • The Use of the Question Mark ?
  • Parameter Queries
  • Expression Builder
  • Calculated Fields
  • Renaming Fields, Aliasing and the Label Operator “:”
  • Multi-Table Queries
  • Relating Tables

In order to view the rest of this content you will need to register for a premium account. Click here for your free trial.

As always, a site wouldn't be anything without its users so please feel free to comment! We welcome any comments you have on the material and any suggestions you may have for future content.

In our humble opinion, it is worth commenting just so you can play with Fun Captcha below!