Access Video Quiz X3.4
By Richard Rost
31 hours ago
How to Calculate Total Inventory Value in Forms? Which aggregate function returns the highest unit price? Welcome to another Microsoft Access Video Quiz. You will be asked five Expert-level questions about totals and calculations in Access forms, including form footers, Sum, Count, Max, and calculating total inventory value. Recommended CoursesWant More?KeywordsAccess Video Quiz, Access form footer totals, continuous form calculations, subform totals, Sum function, Count function, Max function, inventory value calculation, calculated controls, aggregate functions, price times quantity, form footer expressions
More InformationTranscript Welcome to another video quiz from Access Learning Zone.
This one's at the expert level with five questions about totals and calculations in Access forms.
You'll have three seconds to answer each question, so hit pause if you need more time and keep track of your score.
Let's follow the footprints and see where those totals lead.
Question 1.
You have a continuous form showing several products and their quantities.
Where should you place a calculated text box to display the total quantity at the bottom of the form below all the records?
In the detail section, the form footer section, the page header section, or the navigation buttons section.
That's the form footer section.
Question 2.
Which control source expression adds up all the values in a field named quantity on hand?
Is that Count, Average, Sum, or Total?
That is the Sum function.
Question 3.
A subform shows three product records with quantities of 4, 6, and 10.
What will =Count(*) display in its form footer?
3, 10, 20, or 4.
The correct answer is 3.
That's the Count function.
Question 4.
A continuous form displays a different unit price for each product. Which aggregate function would reliably return the highest unit price?
Sum, Max, Average, or Last.
That'll be the Max function.
And question 5.
You have a subform listing products with unit price and quantity on hand fields.
You want to calculate the total inventory value.
What's the correct approach?
Use Sum on unit price alone.
Use Count on quantity on hand.
Multiply unit price and quantity on hand together.
Multiply price by quantity for each record and then sum those calculated values.
That'll be D.
Multiply price by quantity for each record, then sum the results.
Alright, how'd you do?
Did you get 5 out of 5?
Are you a certified Sasquatch tracker?
Or did Bigfoot find you first?
Well, if you missed any, these topics and more are covered in Microsoft Access Expert Level 3 Lesson 4, where we explore form footer totals and useful aggregate calculations.
Thanks for playing.
Post your score in the comments and keep an eye out for unexplained footprints in your area.
Until next time, live long and prosper. Intro Which aggregate function returns the highest unit price? Welcome to another Microsoft Access Video Quiz. You will be asked five Expert-level questions about totals and calculations in Access forms, including form footers, Sum, Count, Max, and calculating total inventory value.
|