Denormalize For Performance: One Way to Speed Up your Microsoft Access Database

In this Microsoft Access tutorial I'm going to teach you one way to speed up your database that actually goes against proper normalization techniques. We're going to the denormalize our database by adding redundant data in an effort to improve the efficiency of our queries and reports.
LEARN MORE:
599cd.com/Denormalize
BECOME A MEMBER:
RUclips: / @599cd
or My Site: 599cd.com/THMember
PRE-REQUISITES:
Intro to VBA: 599cd.com/IntroVBA
Update Queries: 599cd.com/UpdateQ
DLookup: 599cd.com/DLookup
SQL with Access: 599cd.com/SQLwithAccess
LINKS:
Normalizing Data: 599cd.com/Normalizing
Requery in Place: 599cd.com/RequeryInPlace
Modal & Popup: 599cd.com/ModalPopup
RECOMMENDED COURSES:
Access Expert 13: 599cd.com/ACX13 - Update Queries
Access Developer 1: 599cd.com/ACD1 - VBA
Access SQL Seminars: 599cd.com/SQL
FREE TEMPLATE DOWNLOADS:
TechHelp Free Templates: 599cd.com/THFree
Blank Template: 599cd.com/Blank
Contact Management: 599cd.com/Contacts
Order Entry & Invoicing: 599cd.com/Invoicing
More Access Templates: 599cd.com/AccessTemplates
ADDITIONAL RESOURCES:
FREE Access Beginner Level 1: 599cd.com/Free1
$1 Access Level 2: 599cd.com/1Dollar
Donate to my Tip Jar: 599cd.com/TipJar
Get on my Mailing List: 599cd.com/YTML
Contact Me: 599cd.com/Contact
TechHelp: 599cd.com/TechHelp
Consulting Help: 599cd.com/DevNet
Twitter: / learningaccess
en.wikipedia.org/wiki/Microso...
products.office.com/en-us/access
microsoft.com/en-us/microsoft...
KEYWORDS:
access 2016, access 2019, access 2021, access 365, microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, denormalize, performance, query, database, tutorial, speed up, redundancy, join, test

[@adelabdelhamid8272]

Well Done
Very clear teaching without puzzles
Very much thanks from Egypt
Thanks a lot

[@Shadow.Dragon]

Great video Richard! Happy First Contact Day!

[@599CD]

Thanks!!!

[@GregSevior]

To achieve the same result. sorry missed the end on the
last message.

[@599CD]

K

[@afrinsir7479]

make video on edit log in ms acess

[@599CD]

599cd.com/TrackChanges