Import Excel Data and Add Query Calculations in Microsoft Access - Fitness 8

In this Microsoft Access tutorial I will show you how to add a manual save button to your form, import data from Excel into your tables, calculate a protein-to-calorie ratio using a query with the IIf function, add and format calculated fields on your form, set up a requery button, and fix inner and outer joins to make sure all your records are displayed. This is part 8. BECOME A MEMBER: YouTube:    / @599cd   or My Site: https://599cd.com/THMember LEARN MORE: Fitness 8: https://599cd.com/Fitness8 PREREQUISITES: Fitness, Part 7: https://599cd.com/Fitness7 LINKS: IIF Function: https://599cd.com/IIF Outer Joins: https://599cd.com/OuterJoin UP NEXT: Fitness, Part 9: https://599cd.com/Fitness9 RECOMMENDED COURSES: Access Developer Courses: https://599cd.com/Developer 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 DIAMOND SPONSORS: More info on our Sponsors: https://599cd.com/DiamondSponsors ADDITIONAL RESOURCES: FREE Access Beginner Level 1: https://599cd.com/Free1 How to Use Access in 30 Minutes: https://599cd.com/30Minutes $1 Access Level 2: https://599cd.com/1Dollar Donate to my Tip Jar: https://599cd.com/TipJar Merch Store! Get your swag here: https://599cd.com/Merch 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/DevNet Twitter:   / learningaccess   https://en.wikipedia.org/wiki/Microso... https://products.office.com/en-us/access https://microsoft.com/en-us/microsoft... KEYWORDS: TechHelp, Access 2016, Access 2019, Access 2021, Access 2024, Access 365, Microsoft Access, MS Access, MS Access Tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, fitness database, database save button, Me.Dirty False, copy paste Excel data, protein to calorie ratio, calculated query field, IIf function, category auto fill, requery button, outer join FoodT FoodGroupT, percent format query, delete button form QUESTIONS: Please feel free to post your questions or comments below. Thanks. Live long, and prosper.