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

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

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

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's database, and I've updated the data in the PhoneNumbers table so that every customer has a single number. Feel free to open up this Exercise File to continue on, or you'll find copies of the raw Excel workbooks in the Exercise Files folder if you'd prefer to import this 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 help 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, though, it's always a good idea to have a goal in mind. Let's first take a look at these new data tables, and one way that we can get…

Contents