How to Create a Calendar Using Microsoft Access

People well aware of how the MS Access application works, might find it a very useful tool that does not only enable them to create their own databases, but just like the other MS Office applications, also offers a variety of other uses. The database management software program created by MS Office is often used for managing corporate and consumer data. However, its other uses may involve anything from importing and linking to data to creating budgets that assist in planning out your daily routine.

Initial users may complain about MS Access not being a user friendly application, but it’s only professionals or large Corporate offices who have understood its true worth. Although it may not be applicable for all, however, the benefits of the sensitively developed tools are some things that simply cannot be ignored. One of such applications is the regular use of the Calendar facility the benefit of which can not only be applied to schedule important meetings, but can also be used in doing important daily chores. One such feature is the Calendar that is created by the robust date and time tools of the interface application.

Instructions to create a Calendar using MS Access

Calendar is a feature that is found both in MS Access and MS Excel; however the steps to follow to create a calendar are different in both scenarios. What is about to follow are the steps for creating a calendar using MS Access.

Step 1: Launch the Microsoft Access application software after accessing the MS Office program.

Step 2: Click on the ‘File’ menu and select ‘Open’; then look for the Access form or report that you want to open. Then select ‘Open’ after clicking on them and the report or form will be displayed by the application in Access Design view.

Step 3: Click on the ‘More Controls’ tool button; it resembles a hammer and wrench. After you select it, a tools menu would come up on the screen.

Step 4: In the menu, look for ‘Calendar Control 11.0’ and select it when it is found.

Step 5: Click any point in the Access report or form where you want to create a calendar. The MS Access application would generate a calendar and would insert it into your Access page at the particular point you had earlier chosen in this step.

Step 6: To open the property sheet, press the F4 key on your keyboard. Through this sheet, you can modify and edit your calendar’s times and dates.

Step 7: You now need to connect your calendar with specific data in your database, like, for example, employees’ joining dates. On the top of the Access window, click on the ‘Data’ tab and click the ControlSource property for editing the specific information to which the calendar is tied.

Close the Access window and it would automatically save any changes made to its database. The next time you open the report or database, it will display your calendar.

3 Comments

  1. Steven

    Not sure what version of Access you’re using, but I am unable to locate any “More Controls” button. Closest I can get is “Compact Database,” which is utterly unrelated of course. Nice try, though.

  2. Ted Rubin

    I had tried creating a calendar in Microsoft Excel and it was sort of easy. When I tried the same with Microsoft Access I was not able to. There’s a difference in creating calendars on the two applications and I needed guidance to create one on Access. I wanted to learn and my extensive search brought me to this technical blog where I was able to find my answers.

  3. Brett

    I am a beginner here and don’t know too many things about using this application. I chanced upon your site and I must say that it is pretty handy! Reading through this post has helped me to create a calendar in just a few steps and I am also reading other posts that you’ve posted here. Good going.

  4. I wanted to create a calendar using Microsoft Access but was unable to do so. This application is not user friendly at all and I found it tough to create the calendar. Kept searching for steps on how to do so, I landed up here and found my answers. Thanks a lot.

Leave a Reply

Your email address will not be published. Required fields are marked *