From the course: Office 365: Access Essential Training
Unlock the full course today
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Building expressions - Microsoft Access Tutorial
From the course: Office 365: Access Essential Training
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…
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
-
-
-
-
-
-
-
(Locked)
Searching and replacing values3m 10s
-
(Locked)
Creating queries with the Simple Query Wizard3m 58s
-
Building queries in Design view9m 23s
-
(Locked)
Establishing constraints with criteria5m 28s
-
(Locked)
Specifying criteria with wildcards4m 16s
-
(Locked)
Leveraging multiple criteria with AND and OR statements6m 7s
-
(Locked)
Filtering with mathematical comparisons3m 41s
-
(Locked)
Creating flexible queries with parameter requests5m 7s
-
(Locked)
Building expressions7m 26s
-
Obtaining summary statistics7m 3s
-
(Locked)
Challenge: Creating queries42s
-
(Locked)
Solution: Creating queries4m 38s
-
(Locked)
-
-
-
-
-
-
-
-