From the course: Access 2019 Essential Training

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

The Simple Query Wizard

The Simple Query Wizard

From the course: Access 2019 Essential Training

Start my 1-month free trial

The Simple Query Wizard

“

- [Instructor] 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 can get started, let's have a goal in mind. Let's first take a look at the existing data tables. And one way that we can get the big picture on what's going on in the database is by going back to the relationship screen. If you remember, we can get to it by going to the Database Tools tab and finding the button here. Now our Guest table is set up with a relationship to the RoomAssignments table which can be found here. This is where we're storing information about the each guests visit to the Landon Hotel. In the RoomAssignments table we can see their check in date, the room id for the room that they were assigned to, the foreign key, the reference here to the guest that was assigned to the room, the day of the week that was assigned on, and the rate code. Whether it was a weekend rate or a weekday rate for…

Contents