Channel: Computer Learning Zone

Category: Education

Tags: task management#tutorialtask management database#msaccessms accessto do listfree task management templatetodo list#microsoftaccess#howto#lessontask management database template#trainingmicrosoft accesstask management access database templatetask tracker#help#database#learnms access tutorialtask manager

Description: In this video, I'm going to teach you how to build your own task management database in Microsoft Access. We will add all of the standard fields: description, notes, date created, date due, date closed, priority, and what customer it's for. We'll make buttons to show all tasks vs. open tasks only. Walter from Amarillo, Texas (a Platinum Member) asks: I would love it if you could show us how to build a task management database. I have a million things on my "to do" list. I need help organizing them based on priority, due date, what customer they're for, and that kind of stuff. If you could show me how to make buttons to show just the open tasks or ALL the tasks, that would be great too. Oh, and a search box! Thanks. Silver Members and up get access to an Extended Cut of this video. Members will learn how to get rid of the queries and replace them with SQL directly in the button code. We'll also create buttons we can click on to sort by various fields: date due, priority, or description. We'll also make a search box that will look for keywords in the description or notes fields and filter the results accordingly. MEMBERS VIDEO: youtu.be/xtEAzBSZsFc BECOME A MEMBER: YouTube: youtube.com/channel/UCl7-jJie4ifOVK87FINIuDg/join or My Site: 599cd.com/THMember LEARN MORE: 599cd.com/Tasks SUGGESTED TEMPLATE: Access Task Management Template: 599cd.com/Task LINKS: Contact Management: 599cd.com/Contacts Relationships: 599cd.com/Relationships Default Value: 599cd.com/Default Form / Subform: 599cd.com/Subform Relational Combo Boxes: 599cd.com/Relational Intro to VBA: 599cd.com/VBA Conditional Formatting: 599cd.com/ConditionalFormatting Value From a Form: 599cd.com/FormName Tab Stop, Order: 599cd.com/TabOrder ISO Dates: 599cd.com/ISODatesA List Items Edit Form: 599cd.com/ListItemsEditForm Don't Delete: 599cd.com/DontDelete OTHER COURSES: FREE Access Beginner Level 1: 599cd.com/Free1 $1 Access Level 2: 599cd.com/1Dollar 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: 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: twitter.com/LearningAccess en.wikipedia.org/wiki/Microsoft_Access products.office.com/en-us/access microsoft.com/en-us/microsoft-365/blog/access KEYWORDS: microsoft access, ms access, ms access tutorial, #msaccess, #microsoftaccess, #help, #howto, #tutorial, #learn, #lesson, #training, #database, task manager, task management, free task management template, Task Management Access Database template, task management database, task management database template, task tracker, to do list, todo list QUESTIONS: Please feel free to post your questions or comments below. Thanks.