Access 2010: Queries in Depth

with Adam Wilbert
please wait ...
Access 2010: Queries in Depth
Video duration: 0s 3h 2m Intermediate

Viewers:

In this course, author Adam Wilbert illustrates how to create and leverage real-world queries and turn raw data into usable information. The course covers setting up queries, performing calculations, using the built-in Access functions to further refine query results, and identifying top performers or areas for improvement based on a range of criteria.

Topics include:
  • Naming conventions and best practices
  • Working with joins
  • Using comparison operators
  • Defining criteria for select queries
  • Creating parameter queries
  • Creating calculated fields
  • Working with dates and times
  • Using the Expression Builder
  • Creating conditional statements
  • Making, deleting and appending records
  • Building reports
Subject:
Business
Software:
Access Office
Author:

Welcome

Hello, and welcome to Access 2010 Queries in Depth. My name is Adam Wilbert and I am going to take you deep inside what I consider to be the most powerful object within an Access database. We will start out by taking a look at creating some simple select queries to pull relevant fields from our data tables and then we will combine those fields for multiple tables in this single data sheet. We will then apply selection criteria to our queries to limit the records that have returned to just to subset that best satisfies our question. We will also use calculated fields to get a new perspective on the trends hiding within your database.

We will see how to create flexible queries through the use of parameter requests, which will allow your end- users to further define what results you queries return, and by automating common decision-making routines through program flow functions and conditional statements, you will save time and increase the accuracy and consistency of the data in your database. Finally, we'll see how to hook our queries back in the forms and reports for added functionality and we will apply these lessons to the creation of a flexible reporting tool. All of this as so that you can get more out of your database than just the data you put into it.

So, let's dig into Access 2010 Queries in Depth.

There are currently no FAQs about Access 2010: Queries in Depth.

please wait ...