From the course: Cert Prep: Access 2016 Microsoft Office Specialist (77-730)
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Add a calculated field
From the course: Cert Prep: Access 2016 Microsoft Office Specialist (77-730)
Add a calculated field
- [Narrator] You can use calculated fields in both reports and forms, and they're both created exactly the same way. When we create a calculated field it's usually based on one or more fields within your table. You insert a control such as a text box that has a label and a data field so that you can label your new calculated field and create the calculation in the data field. In our 06_04 calculated fields database we'll be working with a proposed rate increase report. We currently have the employee's name, number and their current hourly rate. Over on the right hand side of the hourly rate we're going to insert a calculated field that will calculate their current rate times 5 % so that we can see what the proposed rate increase will be. Let's go ahead and go into design view. On our design tab in the controls group, I'm going to insert a text box. Text boxes will give you a label and a data field. I'll come down onto the report, click in the detail area. Here is my unbound field…
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.