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.

Build expressions

Build expressions

From the course: Access 2019 Essential Training

Start my 1-month free trial

Build expressions

“

- [Instructor] In all the queries that we've built so far, we've focused on starting with the data that's in our tables and then filtering it using a variety of techniques. Another very powerful capability of queries is to create new columns that are calculated from existing Data columns. The advantage of this is that we don't need to actually store this data in the database. We can simply calculate it when we need it and then get rid of it when we don't. In our database, we currently have our room rate stored. We can use this to calculate the various taxes that also need to be collected using some simple formulas. Let's start a new query in Design View and we'll take a look at that. Now, this query is gonna pull out some information from the Guest table, so we can get the first and last name. We also wanna see the Room Assignments table as well as the Room Rates table, which will get us that rate data. Let's go ahead and close the Show Table window and we'll pull down the first name…

Contents