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

Unlock this course with a free trial

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

The Simple Query Wizard

The Simple Query Wizard - Microsoft Access Tutorial

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

Start my 1-month free trial Buy for my team

The Simple Query Wizard

“

- [Instructor] I've gone ahead and imported a number of additional data tables into Access to build out the Two Trees Olive Oil company database. I've also updated the data in the PhoneNumbers table so that every customer has a single number now. Feel free to open this Exercise File to continue on, or you'll find the raw Excel workbooks with all of this data inside of the Exercise Files folder if you'd prefer to import the data into the database that you've been working with. 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 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. I first want to to take a look at these new data tables, and one way that we can get the big…

Contents