Загрузка страницы

When to Use a Stored Value Instead of a Calculated Value in Microsoft Access

In this video, we will discuss when you should use a stored vs. a calculated value in your Microsoft Access tables. I'll show you how to apply a customer discount based on the time the person has been a customer (number of years) but also allow for you to manually edit the discount amount. I'll show you how to display what the discount should be on the customer form and we'll make a button to apply it. We'll also apply it if the current discount rate is empty. We'll use conditional formatting to highlight the calculated value in red if it's different from the stored one.

Bryce from Washington DC (a Platinum Member) asks: I give my customers a percentage discount based on the time they've been a customer. For example, after a year it's 5%. After two years, it's 7%. And so on. I need the ability to manually change it, however. I give some customers a higher discount if they’ve made a lot of purchases. Others get none. It depends on many factors, and one of those factors is that it's completely up to me. LOL. How do I track this in Access?

BONUS FOR MEMBERS:
Silver Members and up get access to an Extended Cut of this video. Members will learn how to make a much more complex function to determine the discount rate based on multiple factors include table lookups. We'll put this public function in a global module. We will then use an Update Query to assign values to any customers who do not have one.

MEMBERS VIDEO:
https://youtu.be/YjZ310NICcI

BECOME A MEMBER:
YouTube: https://youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join
or My Site: https://599cd.com/THMember

LINKS:
Calculated Fields: https://599cd.com/Calculated
Switch Function: https://599cd.com/Switch
Intro to VBA: https://599cd.com/IntroVBA
OnCurrent Event: https://599cd.com/OnCurrent
Conditional Formatting: https://599cd.com/Conditional

COURSES:
FREE Access Beginner Level 1: https://599cd.com/Free1
$1 Access Level 2: https://599cd.com/1Dollar

FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: https://599cd.com/THFree
Blank Template: https://599cd.com/Blank
Contact Management: https://599cd.com/Contacts
Order Entry & Invoicing: https://599cd.com/Invoicing
More Access Templates: https://599cd.com/AccessTemplates

ADDITIONAL RESOURCES:
Get on my Mailing List: https://599cd.com/YTML
Contact Me: https://599cd.com/Contact
TechHelp: https://599cd.com/TechHelp
Consulting Help: https://599cd.com/Consulting
Twitter: https://twitter.com/LearningAccess
https://en.wikipedia.org/wiki/Microsoft_Access
https://products.office.com/en-us/access
https://microsoft.com/en-us/microsoft-365/blog/access/

KEYWORDS:
microsoft access, ms access, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #instruction, #learn, #lesson, #training, #database, why you should not store calculated information in tables, is it better to store, computed, calculating, calculate discount rate, calculated query fields

QUESTIONS:
Please feel free to post your questions or comments below. Thanks.

Видео When to Use a Stored Value Instead of a Calculated Value in Microsoft Access канала Computer Learning Zone
Показать
Комментарии отсутствуют
Введите заголовок:

Введите адрес ссылки:

Введите адрес видео с YouTube:

Зарегистрируйтесь или войдите с
Информация о видео
4 марта 2021 г. 6:41:44
00:30:05
Другие видео канала
Continuous Forms in Microsoft Access. Product Inventory List Form. Click to Open Specific Product.Continuous Forms in Microsoft Access. Product Inventory List Form. Click to Open Specific Product.Don't Delete! Marking Records Inactive. When and When NOT to Hard Delete Data in Microsoft AccessDon't Delete! Marking Records Inactive. When and When NOT to Hard Delete Data in Microsoft AccessImport New and Changed Records in Microsoft Access. Update Pricing from Vendor Excel SpreadsheetImport New and Changed Records in Microsoft Access. Update Pricing from Vendor Excel SpreadsheetMicrosoft Access v Microsoft Excel: Which is Better? When to Use Each. Data Management or Analysis?Microsoft Access v Microsoft Excel: Which is Better? When to Use Each. Data Management or Analysis?How to Compare Month-Over-Month (Previous Month and Same Month Last Year) Sales in Microsoft AccessHow to Compare Month-Over-Month (Previous Month and Same Month Last Year) Sales in Microsoft AccessCalculated Fields in Microsoft Access - How to Perform Calculations in Queries & Form Footer TotalsCalculated Fields in Microsoft Access - How to Perform Calculations in Queries & Form Footer TotalsMicrosoft Access 2016 Tutorial: Linking the Tables and Defining the RelationshipsMicrosoft Access 2016 Tutorial: Linking the Tables and Defining the RelationshipsOrder Entry System with Invoice Report Template for Microsoft Access. Print Receipts, Bills, More.Order Entry System with Invoice Report Template for Microsoft Access. Print Receipts, Bills, More.Hide Inactive Customers from Combo Boxes in your Microsoft Access Forms - Hiding Inactive RecordsHide Inactive Customers from Combo Boxes in your Microsoft Access Forms - Hiding Inactive RecordsCalculating Age in AccessCalculating Age in AccessTimesheets in Microsoft Access: Calculating Total Hours Worked for Employees or Customer BillingTimesheets in Microsoft Access: Calculating Total Hours Worked for Employees or Customer BillingHow and Why to Split Your Microsoft Access Database - Linked Table, Front End, Back End, BenefitsHow and Why to Split Your Microsoft Access Database - Linked Table, Front End, Back End, BenefitsCreate a Search Button on your Form in Microsoft Access. Find Button. Filter, FilterOn PropertiesCreate a Search Button on your Form in Microsoft Access. Find Button. Filter, FilterOn PropertiesAutomatic Numbering of Records. Renumber Counter on Add, Delete. Row Numbers in Microsoft Access.Automatic Numbering of Records. Renumber Counter on Add, Delete. Row Numbers in Microsoft Access.Microsoft Access A to Z: Designing Table RelationshipsMicrosoft Access A to Z: Designing Table RelationshipsMicrosoft Access Equivalent of an Excel VLOOKUP Function with Approximate Match using DLookup, DMaxMicrosoft Access Equivalent of an Excel VLOOKUP Function with Approximate Match using DLookup, DMaxMicrosoft Access - Calculate Value from Fields in Multiple TablesMicrosoft Access - Calculate Value from Fields in Multiple TablesCustomer-Specific Product Pricing for your Microsoft Access Order Entry Invoicing SystemCustomer-Specific Product Pricing for your Microsoft Access Order Entry Invoicing SystemMicrosoft Access 2016 Tutorial: Calculated Fields in a Query in Access DatabasesMicrosoft Access 2016 Tutorial: Calculated Fields in a Query in Access DatabasesDistributing Your Database with the Free Microsoft Access Runtime Edition Developer ExtensionsDistributing Your Database with the Free Microsoft Access Runtime Edition Developer Extensions
Яндекс.Метрика