Access Appointment Database for Scheduling

Build a database in Microsoft Access to track your appointments (calendar, tasks, to-do list items, etc.). We will build the needed table, queries, form, and a printable scehedule report. 

Gabriella from St. Petersburg, Florida (a Platinum Member) asks: I need a simple database to track my upcoming appointments. I've been using Outlook, but I'd like to use Access so I can eventually tie appointments to customers. Can you help me?

Silver Members & Up

I'll show you how to set the end time to one hour after the start time, add buttons for add an hour, 15 minutes, or whatever interval you like to the appointment. We'll make a combo box to select what data you'd like to see in the form and report (recent, future, or all appointments). Then we'll add the customer data to the system so you can assign an appointment to a client.

•  Extended Cut Video - Silver (40 Minutes)

Gold Members & Up

This is the first time I recorded an extra BONUS video for Gold and Platinum members! This video is based heavily in VBA coding and we'll do some really cool stuff. We'll build in conflict resolution, so the system will warn you if you try to add an appointment that overlaps another one. Then, we'll make the database tell you when the next available open appointment slot is! Really helpful!

•  Gold Member Bonus Video - Gold (50 Minutes)
•  Gold Member Template Download - Gold

Silver Members and up get access to view Extended Cut videos, when available. Gold Members can download the files from class plus get access to the Code Vault. If you're not a member, Join Today!

Links

After Update: https://599cd.com/AfterUpdate
Arrange Tabular: https://599cd.com/ArrangeTabular
Format Property: https://599cd.com/FormatProperty
Query Criteria: https://599cd.com/Criteria
Calendar Seminar: https://599cd.com/Calendar
Can Shrink in Reports: https://599cd.com/acb9
SQL Seminars: https://599cd.com/SQL
DateTime Seminar: https://599cd.com/DateTime
Developer 24: https://599cd.com/acd24
Intro to VBA: https://599cd.com/IntroVBA

Learn More FREE Access Beginner Level 1 FREE Access Quick Start in 30 Minutes Access Level 2 for just $1 Free Templates TechHelp Free Templates Blank Template Contact Management Order Entry & Invoicing More Access Templates

Resources Mailing List - Get emails when new videos released Consulting - Need help with your database Tip Jar - Your tips are graciously accepted Questions? Please feel free to post your questions or comments below or post them in the Forums.