From the course: Access Basics for Excel Users
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Create calculated fields - Microsoft Access Tutorial
From the course: Access Basics for Excel Users
Create calculated fields
- [Instructor] Sometimes when working with databases there are views that don't explicitly come with the source data, but ones that we can easily creating using a calculation. Let's take a look at how. I suggest you open up 03 02 Calculated and follow along with me. Let's say that you've already built an Access query, you'll be able to see it here on the left under the All Access Objects window. Double-clicking on it will rerun the query and open the result in the data sheet view. What you're looking at here is a summary of employment data for California grouped by month and Area Category, which is essentially an aggregation of small, medium, and large geographical areas. However, looking at large numbers such as this can make it a little bit difficult to understand exactly what's going on. So how about we go ahead and create the unemployment rate using the data that's already in this query. To do this let's go and…
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.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.