From the course: Access 2021: Queries

Do more with Access queries

From the course: Access 2021: Queries

Start my 1-month free trial Buy for my team

Do more with Access queries

“

- [Adam] Access databases can store lots of raw data. With queries, we can find out what that data actually means and use that information to help drive decision making. Hi, my name is Adam Wilbert and I've been working with Access for over a decade now. I like to say that a good database can give you more than what you put into it. Queries are where that magic happens, where raw data becomes useful information. By leveraging the power of access query objects, users can explore their data from any number of angles. To get the most out of the database, you need to have a solid understanding of how queries work so that you can ask the best questions of your data. In this course, we'll construct queries that sort through and find records that meet specific criteria. We'll use queries to process our data through built in functions and expressions to surface additional insights that would otherwise go unnoticed. And we'll build flexible query frameworks that leverage inputs from forms and refine how the data is presented, so that results are easy to understand. So let's dig in and see how we can get the most out of my favorite component of any database. Welcome to Access 2021 Queries.

Contents