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

Unlock the full course today

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

Simple Query Wizard

Simple Query Wizard

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

Start my 1-month free trial

Simple Query Wizard

- [Narrator] 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 of the creation process. Before we can get started, let's have a goal in mind though. 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 Access database is by going back to the relationships screen, which if you remember you can get to from database tools and then clicking on relationships. Now, I've added a bunch of new tables here, since the last time we took a look at the relationships screen. Specifically, I want to take a look at the relationship between the guest table and this table here called room assignments. We can see that they are linked together based off of the guest ID field. So, the guest ID and the room assignments table is the foreign key for that table. We also have fields for the check in date as well as the room ID that each guest was assigned to. We can…

Contents