Learn that calculated fields allow you to perform calculations on the data in your query. Author Jen McBee demonstrates how to create a calculated field using the Zoom box and Expression Builder. She shows how to format the new field, focusing on the skil
- [Instructor] Another option that I'd like to explore…with you is how to create a calculated field in a query.…On the Access 2010 MOS exam, you may be asked…to create a calculated field that will perform…a simple function, such as taking the unit price…and multiplying it times the quantity to get…the total cost of the sale.…Or, we might need to calculate a pay raise…for a group of people.…We'll take their current salary and multiply it…times the anticipated raise,…and come up with their new salary.…
Lots of good ways that you can use calculated fields…in your queries.…The two tools that we'll talk about are...…After you've create your calculated field, you'll then need…to format the results.…You want to make sure that if it is currency information,…it's formatted with a dollar sign and decimal places.…We're going to use two tools to create our calculated fields.…We'll use the Zoom tool which allows you to zoom into…where you're creating your calculation,…and we'll also look at the Expression Builder.…
I have the 05_07 exercise file open, so let's get started.…
- Creating a new Access database
- Applying application parts
- Backing up a database
- Creating new tables and fields
- Sorting and filtering records
- Setting primary keys
- Importing data
- Creating basic forms
- Creating Access queries, including crosstab and multitable queries
- Creating Access reports
Skill Level Intermediate
1. Microsoft Office Specialist Exam Overview
Prepare for the exam2m 18s
2. Managing the Access Environment
3. Building Tables
4. Create Forms
5. Create and Manage Queries
6. Create Reports
7. Final Practice Exam
- Mark as unwatched
- Mark all as unwatched
Are you sure you want to mark all the videos in this course as unwatched?
This will not affect your course history, your reports, or your certificates of completion for this course.Cancel
Take notes with your new membership!
Type in the entry box, then click Enter to save your note.
1:30Press on any video thumbnail to jump immediately to the timecode shown.
Notes are saved with you account but can also be exported as plain text, MS Word, PDF, Google Doc, or Evernote.