From the course: Office 365: Access Essential Training

Unlock the full course today

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

Building expressions

Building expressions - Microsoft Access Tutorial

From the course: Office 365: Access Essential Training

Start my 1-month free trial

Building expressions

- In all of the queries that we've built so far, we've focused on starting with the data that's in our data tables and then filtering them 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 of this is that we don't need to actually store this data in the database at all. We could 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 and we can use this information to calculate the various taxes that need to be collected after a guest's stay. Let's go ahead and create a query that's going to do that for us. Once again, I'll go to the Create tab, and start with a Query in Design view. I'm going to add in the Guest table, the Room Assignments table, and the Room Rates table here. That will add those three tables to our design and we'll go ahead and close the Show Table window. From the Guest…

Contents