Access 2007-2016
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
 
Home   News   Tips   Glossary   Templates   Forums   Help   Logon   Order   Contact Us  
 
 
 

Microsoft Access Calendar Seminar
Use Access to Create Monthly Calendars

 
If you've ever wanted to print monthly calendars from your Access databases, then this seminar is perfect for you.

Access Calendar 

This seminar covers creating an appointment database in Microsoft Access. You will create a form that looks like an actual monthly calendar, that you can review your appointments on. Then, when you're ready to print, just pick a month, and the report is generated. Click here for a video showing what's covered in this seminar:


 

 
Seminars - Access Calendars
Description: Create monthly calendar forms and reports completely within Microsoft Access
Versions: I will use Access 2007, however the lessons are valid for all versions of Access back to AC2000. I will show any differences between 2007 and 2003. The seminar works fine with Access 2010 and 2013, however the Calendar Control object was removed from this version by Microsoft. This is not a problem, since there is now a built-in Date Picker. See notes in the comments section below.
Pre-Requisites: Access 101-104 basic knowledge of Access strongly recommended
Access 201-207 relational database concepts recommended
Access 301-313 helpful but not necessary
Running Time: 1 hour, 56 minutes  (1:56)
Cost: $59.99

 

This seminar has two main goals. You will learn how to:

1. Build a calendar form to edit appointments
2. Create a printable monthly calendar report
 

You will begin by creating a basic table to store our appointment data. We'll also make a simple form to edit and add new records.

 

Next we'll build an appointment list form, where we can see all of our appointments. Double-click on an appointment to open and edit it. We'll also make a checkbox to allow us to see open vs. closed appointments (close it when you're done with it). You'll also learn about triple-state checkboxes where you can see open, closed, and ALL records.

 

In the next lessons we'll build a form to pick a date using a built-in Microsoft Access ActiveX Calendar control. Using this date, we'll generate our own form that looks like a full-sized monthly calendar, complete with all of our appointments on it.

 

One of the things we're going to learn how to do is make the first day on our calendar form figure out what the first Sunday on or before the start of the month is, then build the rest of the calendar accordingly, greying out any days that are before or after the selected month. We'll tackle that with a little bit of VBA programming.

 

Of course, you'll be able to double-click on any appointment on the calendar to open up a popup form to edit that appointment.

 

Then, once the form is completed, we'll create the printable monthly calendar report. We'll actually make two versions - I'll show you how to lay it out portrait and landscape.


 

 

This seminar is perfect for anyone who wants to do any kind of scheduling in Microsoft Access. You can store your appointments, edit them easily, and print out professional-looking monthly calendar reports - all from within Access.

This seminar is long (almost two hours) but it's broken up into easily managed lessons of about 10 minutes each. You can sit down, watch a lesson, review the material, test the code out yourself, and experiment. Do a little bit each day. It's long, but it's comprehensive - you won't miss a single step as I've recorded everything from start to finish.

All of the sample database files are available on my Web site (instructions on where to download them are in the course videos). They are available in Access 2007 and 2000 formats.

This seminar is available to view online in the Amicron Theater. You can click here to watch the first two lessons absolutely free.

NEW: If you would like to download a copy of the database we build in this class so you can look it over and see if it will meet your needs, then click on one of these links:

- Access 2007
- Access 2010/2013

The sample databases are only available for Access 2007 and 2010/13, however we do cover Access 2000 and 2003 in the class.

Of course, if you have any questions about whether or not this seminar is for you, please contact me.
 

 

Access Calendar Seminar Outline

00. Intro (7:35)
Topics Covered
Pre-Requisites

01. Create Database (7:02)
Turn on Overlapping Windows
Create Database File
Create Calendar Table
Create Calendar Form

02. Appointment List 1 (13:56)
Form to List Appointments
ApptListF
Double-Click to Open Appt
OnDblClick Event
Show Closed Items Checkbox

03. Appointment List 2 (7:54)
Triple State Checkbox
Show Closed, Open, All Appts
Create Dynamic SQL Rowsource
Refresh Button
List.Requery
Change Form Caption in VBA

04. Monthly View Form 1 (11:39)
CalendarQ With Short Time
DatePickerF Enter a Date
Start Monthly Form

05. Monthly View Form 2 (10:23)
Day 2 of our Calendar Form
Text Boxes to Show Dates
Make 7 Boxes for the Week

06. Monthly View Form 3 (11:30)
Calendar Control
Calculate First Day of Month
First Sunday on or Before 1st

07. Monthly View Form 4 (10:51)
Grey Out Days of Diff Months
Forms!Form("FieldName") Notation
&HFFFFFF Color Notation

08. Monthly View Form 5 (10:26)
Shrink Text
Get Rid of Horizontal Scrollbars
DblClick Event to Open Appointments
Use Excel to Generate VBA Code

09. Calendar Report 1 (9:40)
Design Printable Monthly Report

10. Calendar Report 2 (12:14)
VBA Code Rewrite for Reports
Using the Detail Build Event

11. Review (3:39)

 


 

 
 

You may want to read these articles from the 599CD News:

 

Learn
 
Accessindex
Excelindex
Wordindex
Windowsindex
PowerPointindex
Photoshopindex
Visual Basicindex
ASPindex
Seminars
More...
Customers
 
Account Login
Online Theater
Downloads
Lost Password
Free Upgrades
Insider Circle
Student Databases
Change Email
Info
 
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Articles
Search Our Site
Waiting List
Production Schedule
Collapse Menus
Help
 
Live Chat
Customer Support
WalkThru Tutorials
Troubleshooting
FAQs
TechHelp
Consulting Services
About Us
 
Background
Testimonials
Jobs
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Order
 
Video Tutorials
Handbooks
MYOLP Memberships
Idiot's Guide to Excel
Volume Discounts
Payment Info
Shipping
Terms of Sale
Gift CDs
Contact
 
Live Chat
General Info
Support Policy
Contact Form
Email Us
Mailing Address
Phone Number
Fax Number
Course Survey
Facebook    Twitter

Google Plus    LinkedIn

Blog RSS Feed    YouTube Channel
Richard Rost Microsoft MVP