From the course: Access Essential Training (Office 365/Microsoft)
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Simple Query Wizard
From the course: Access Essential Training (Office 365/Microsoft)
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…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
What are queries?3m 2s
-
(Locked)
Simple Query Wizard4m 19s
-
(Locked)
Build queries in Design view6m 18s
-
(Locked)
Establish constraints with criteria4m 30s
-
(Locked)
Specify criteria with wildcards3m 47s
-
(Locked)
Incorporate AND and OR statements6m 1s
-
(Locked)
Filter with mathematical comparisons3m 26s
-
(Locked)
Create flexible queries with parameters3m 53s
-
(Locked)
Build expressions5m 33s
-
(Locked)
Obtain summary statistics7m 29s
-
-
-
-
-