From the course: Microsoft Access Essential Training (Office 2021/LTSC)

Unlock the full course today

Join today to access over 24,700 courses taught by industry experts.

The Simple Query Wizard

The Simple Query Wizard

From the course: Microsoft Access Essential Training (Office 2021/LTSC)

Start my 1-month free trial Buy for my team

The Simple Query Wizard

“

- [trainer] I've gone ahead and imported a number of additional data tables into access, to build out the Red30Tech database. We now have lots of information about employees products and customer orders that we can use to explore how access works, and all of this new data will make exploring the role of queries a little bit more interesting. As with many of the objects in access, the easiest way to get started with queries, is to have a wizard, walk us through the steps in the creation process. Before we get started, let's have a goal in mind. Let's first take a look at these new data tables and one way that I like to get the big picture on what's going on in a database is by going back to the relationships diagram. If you remember, you can get there by going to the Database Tools ribbons, and you'll find the Relationships button here. So here is the new diagram for all of the new tables. The customer's table that we've been…

Contents