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

Unlock the full course today

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

Build expressions

Build expressions

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

Start my 1-month free trial

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…

Contents