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.
