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.
Build expressions
From the course: Access Essential Training (Office 365/Microsoft)
Build expressions
- [Instructor] In all of the queries we built so far, we focused on starting with the data that's in our tables and then filtering it using a variety of techniques. Another very powerful ability of queries is to create new columns that are calculated from existing data columns. The advantage to this is that we don't need to actually store this data in the database, we simply calculate it when we need it and then get rid of it when we don't need it. In our database, we currently have our room rates stored. We can use this to calculate the various taxes that also need to be collected using simple formulas. Let's create a new query in Design view and I'm gonna add in the Guests table, the RoomAssignments table and finally, the RoomRates table. Let's go ahead and close the Show Table window. From the Guests table, I'll add the FirstName and LastName to the query grid. The CheckinDate from the RoomAssignments table and finally, the Rate from the RoomRates table. If I take a look at the…
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
-
-
-
-
-